PageRenderTime 23ms CodeModel.GetById 14ms app.highlight 4ms RepoModel.GetById 1ms app.codeStats 1ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/partition_special_char.q.out

#
text | 109 lines | 109 code | 0 blank | 0 comment | 0 complexity | 6fe6a7698474ef1ae1b65472d23110c8 MD5 | raw file
  1PREHOOK: query: create table sc as select * 
  2from (select '2011-01-11', '2011-01-11+14:18:26' from src limit 1 
  3      union all 
  4      select '2011-01-11', '2011-01-11+15:18:26' from src limit 1 
  5      union all 
  6      select '2011-01-11', '2011-01-11+16:18:26' from src limit 1 ) s
  7PREHOOK: type: CREATETABLE_AS_SELECT
  8PREHOOK: Input: default@src
  9POSTHOOK: query: create table sc as select * 
 10from (select '2011-01-11', '2011-01-11+14:18:26' from src limit 1 
 11      union all 
 12      select '2011-01-11', '2011-01-11+15:18:26' from src limit 1 
 13      union all 
 14      select '2011-01-11', '2011-01-11+16:18:26' from src limit 1 ) s
 15POSTHOOK: type: CREATETABLE_AS_SELECT
 16POSTHOOK: Input: default@src
 17POSTHOOK: Output: default@sc
 18PREHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
 19PREHOOK: type: CREATETABLE
 20POSTHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
 21POSTHOOK: type: CREATETABLE
 22POSTHOOK: Output: default@sc_part
 23PREHOOK: query: insert overwrite table sc_part partition(ts) select * from sc
 24PREHOOK: type: QUERY
 25PREHOOK: Input: default@sc
 26PREHOOK: Output: default@sc_part
 27POSTHOOK: query: insert overwrite table sc_part partition(ts) select * from sc
 28POSTHOOK: type: QUERY
 29POSTHOOK: Input: default@sc
 30POSTHOOK: Output: default@sc_part@ts=2011-01-11+14%3A18%3A26
 31POSTHOOK: Output: default@sc_part@ts=2011-01-11+15%3A18%3A26
 32POSTHOOK: Output: default@sc_part@ts=2011-01-11+16%3A18%3A26
 33POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 34POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 35POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 36PREHOOK: query: show partitions sc_part
 37PREHOOK: type: SHOWPARTITIONS
 38POSTHOOK: query: show partitions sc_part
 39POSTHOOK: type: SHOWPARTITIONS
 40POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 41POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 42POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 43ts=2011-01-11+14%3A18%3A26
 44ts=2011-01-11+15%3A18%3A26
 45ts=2011-01-11+16%3A18%3A26
 46PREHOOK: query: select count(*) from sc_part where ts is not null
 47PREHOOK: type: QUERY
 48PREHOOK: Input: default@sc_part@ts=2011-01-11+14%3A18%3A26
 49PREHOOK: Input: default@sc_part@ts=2011-01-11+15%3A18%3A26
 50PREHOOK: Input: default@sc_part@ts=2011-01-11+16%3A18%3A26
 51PREHOOK: Output: file:/tmp/nzhang/hive_2011-01-13_11-13-08_667_3825187877309649250/-mr-10000
 52POSTHOOK: query: select count(*) from sc_part where ts is not null
 53POSTHOOK: type: QUERY
 54POSTHOOK: Input: default@sc_part@ts=2011-01-11+14%3A18%3A26
 55POSTHOOK: Input: default@sc_part@ts=2011-01-11+15%3A18%3A26
 56POSTHOOK: Input: default@sc_part@ts=2011-01-11+16%3A18%3A26
 57POSTHOOK: Output: file:/tmp/nzhang/hive_2011-01-13_11-13-08_667_3825187877309649250/-mr-10000
 58POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 59POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 60POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 613
 62PREHOOK: query: insert overwrite table sc_part partition(ts) select * from sc
 63PREHOOK: type: QUERY
 64PREHOOK: Input: default@sc
 65PREHOOK: Output: default@sc_part
 66POSTHOOK: query: insert overwrite table sc_part partition(ts) select * from sc
 67POSTHOOK: type: QUERY
 68POSTHOOK: Input: default@sc
 69POSTHOOK: Output: default@sc_part@ts=2011-01-11+14%3A18%3A26
 70POSTHOOK: Output: default@sc_part@ts=2011-01-11+15%3A18%3A26
 71POSTHOOK: Output: default@sc_part@ts=2011-01-11+16%3A18%3A26
 72POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 73POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 74POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 75POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 76POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 77POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 78PREHOOK: query: show partitions sc_part
 79PREHOOK: type: SHOWPARTITIONS
 80POSTHOOK: query: show partitions sc_part
 81POSTHOOK: type: SHOWPARTITIONS
 82POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 83POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 84POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 85POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 86POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 87POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
 88ts=2011-01-11+14%3A18%3A26
 89ts=2011-01-11+15%3A18%3A26
 90ts=2011-01-11+16%3A18%3A26
 91PREHOOK: query: select count(*) from sc_part where ts is not null
 92PREHOOK: type: QUERY
 93PREHOOK: Input: default@sc_part@ts=2011-01-11+14%3A18%3A26
 94PREHOOK: Input: default@sc_part@ts=2011-01-11+15%3A18%3A26
 95PREHOOK: Input: default@sc_part@ts=2011-01-11+16%3A18%3A26
 96PREHOOK: Output: file:/tmp/nzhang/hive_2011-01-13_11-13-17_403_2722288816258097447/-mr-10000
 97POSTHOOK: query: select count(*) from sc_part where ts is not null
 98POSTHOOK: type: QUERY
 99POSTHOOK: Input: default@sc_part@ts=2011-01-11+14%3A18%3A26
100POSTHOOK: Input: default@sc_part@ts=2011-01-11+15%3A18%3A26
101POSTHOOK: Input: default@sc_part@ts=2011-01-11+16%3A18%3A26
102POSTHOOK: Output: file:/tmp/nzhang/hive_2011-01-13_11-13-17_403_2722288816258097447/-mr-10000
103POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
104POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+14:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
105POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
106POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+15:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
107POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
108POSTHOOK: Lineage: sc_part PARTITION(ts=2011-01-11+16:18:26).key SIMPLE [(sc)sc.FieldSchema(name:_c0, type:string, comment:null), ]
1093