PageRenderTime 11ms CodeModel.GetById 7ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out

#
text | 156 lines | 156 code | 0 blank | 0 comment | 0 complexity | 810cbbc88ba88bc3625796b17ca531b3 MD5 | raw file
  1PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@partition_test_partitioned
  6PREHOOK: query: insert overwrite table partition_test_partitioned partition(dt=100) select * from src1
  7PREHOOK: type: QUERY
  8PREHOOK: Input: default@src1
  9PREHOOK: Output: default@partition_test_partitioned@dt=100
 10POSTHOOK: query: insert overwrite table partition_test_partitioned partition(dt=100) select * from src1
 11POSTHOOK: type: QUERY
 12POSTHOOK: Input: default@src1
 13POSTHOOK: Output: default@partition_test_partitioned@dt=100
 14POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 15POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 16PREHOOK: query: alter table partition_test_partitioned set fileformat rcfile
 17PREHOOK: type: ALTERTABLE_FILEFORMAT
 18PREHOOK: Input: default@partition_test_partitioned
 19PREHOOK: Output: default@partition_test_partitioned
 20POSTHOOK: query: alter table partition_test_partitioned set fileformat rcfile
 21POSTHOOK: type: ALTERTABLE_FILEFORMAT
 22POSTHOOK: Input: default@partition_test_partitioned
 23POSTHOOK: Output: default@partition_test_partitioned
 24POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 25POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 26PREHOOK: query: insert overwrite table partition_test_partitioned partition(dt=101) select * from src1
 27PREHOOK: type: QUERY
 28PREHOOK: Input: default@src1
 29PREHOOK: Output: default@partition_test_partitioned@dt=101
 30POSTHOOK: query: insert overwrite table partition_test_partitioned partition(dt=101) select * from src1
 31POSTHOOK: type: QUERY
 32POSTHOOK: Input: default@src1
 33POSTHOOK: Output: default@partition_test_partitioned@dt=101
 34POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 35POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 36POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 37POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 38PREHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
 39PREHOOK: type: ALTERTABLE_FILEFORMAT
 40PREHOOK: Input: default@partition_test_partitioned
 41PREHOOK: Output: default@partition_test_partitioned
 42POSTHOOK: query: alter table partition_test_partitioned set fileformat Sequencefile
 43POSTHOOK: type: ALTERTABLE_FILEFORMAT
 44POSTHOOK: Input: default@partition_test_partitioned
 45POSTHOOK: Output: default@partition_test_partitioned
 46POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 47POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 48POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 49POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 50PREHOOK: query: insert overwrite table partition_test_partitioned partition(dt=102) select * from src1
 51PREHOOK: type: QUERY
 52PREHOOK: Input: default@src1
 53PREHOOK: Output: default@partition_test_partitioned@dt=102
 54POSTHOOK: query: insert overwrite table partition_test_partitioned partition(dt=102) select * from src1
 55POSTHOOK: type: QUERY
 56POSTHOOK: Input: default@src1
 57POSTHOOK: Output: default@partition_test_partitioned@dt=102
 58POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 59POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 60POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 61POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 62POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 63POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 64PREHOOK: query: select * from partition_test_partitioned where dt >=100 and dt <= 102
 65PREHOOK: type: QUERY
 66PREHOOK: Input: default@partition_test_partitioned@dt=100
 67PREHOOK: Input: default@partition_test_partitioned@dt=101
 68PREHOOK: Input: default@partition_test_partitioned@dt=102
 69PREHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-43_260_5442200232343655466/-mr-10000
 70POSTHOOK: query: select * from partition_test_partitioned where dt >=100 and dt <= 102
 71POSTHOOK: type: QUERY
 72POSTHOOK: Input: default@partition_test_partitioned@dt=100
 73POSTHOOK: Input: default@partition_test_partitioned@dt=101
 74POSTHOOK: Input: default@partition_test_partitioned@dt=102
 75POSTHOOK: Output: file:/tmp/njain/hive_2010-08-17_00-29-43_260_5442200232343655466/-mr-10000
 76POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 77POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=100).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 78POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 79POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=101).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 80POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ]
 81POSTHOOK: Lineage: partition_test_partitioned PARTITION(dt=102).value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
 82238	val_238	100
 83		100
 84311	val_311	100
 85	val_27	100
 86	val_165	100
 87	val_409	100
 88255	val_255	100
 89278	val_278	100
 9098	val_98	100
 91	val_484	100
 92	val_265	100
 93	val_193	100
 94401	val_401	100
 95150	val_150	100
 96273	val_273	100
 97224		100
 98369		100
 9966	val_66	100
100128		100
101213	val_213	100
102146	val_146	100
103406	val_406	100
104		100
105		100
106		100
107238	val_238	101
108		101
109311	val_311	101
110	val_27	101
111	val_165	101
112	val_409	101
113255	val_255	101
114278	val_278	101
11598	val_98	101
116	val_484	101
117	val_265	101
118	val_193	101
119401	val_401	101
120150	val_150	101
121273	val_273	101
122224		101
123369		101
12466	val_66	101
125128		101
126213	val_213	101
127146	val_146	101
128406	val_406	101
129		101
130		101
131		101
132238	val_238	102
133		102
134311	val_311	102
135	val_27	102
136	val_165	102
137	val_409	102
138255	val_255	102
139278	val_278	102
14098	val_98	102
141	val_484	102
142	val_265	102
143	val_193	102
144401	val_401	102
145150	val_150	102
146273	val_273	102
147224		102
148369		102
14966	val_66	102
150128		102
151213	val_213	102
152146	val_146	102
153406	val_406	102
154		102
155		102
156		102