HIVE-18797 : ExprConstNodeDesc's getExprString should put appropriate qualifier with...
[hive.git] / ql / src / test / results / clientpositive / spark / orc_merge6.q.out
1 PREHOOK: query: create table orc_merge5 (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc
2 PREHOOK: type: CREATETABLE
3 PREHOOK: Output: database:default
4 PREHOOK: Output: default@orc_merge5
5 POSTHOOK: query: create table orc_merge5 (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc
6 POSTHOOK: type: CREATETABLE
7 POSTHOOK: Output: database:default
8 POSTHOOK: Output: default@orc_merge5
9 PREHOOK: query: create table orc_merge5a (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) partitioned by (year string, hour int) stored as orc
10 PREHOOK: type: CREATETABLE
11 PREHOOK: Output: database:default
12 PREHOOK: Output: default@orc_merge5a
13 POSTHOOK: query: create table orc_merge5a (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) partitioned by (year string, hour int) stored as orc
14 POSTHOOK: type: CREATETABLE
15 POSTHOOK: Output: database:default
16 POSTHOOK: Output: default@orc_merge5a
17 PREHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_merge5
18 PREHOOK: type: LOAD
19 #### A masked pattern was here ####
20 PREHOOK: Output: default@orc_merge5
21 POSTHOOK: query: load data local inpath '../../data/files/orc_split_elim.orc' into table orc_merge5
22 POSTHOOK: type: LOAD
23 #### A masked pattern was here ####
24 POSTHOOK: Output: default@orc_merge5
25 PREHOOK: query: explain insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
26 PREHOOK: type: QUERY
27 POSTHOOK: query: explain insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
28 POSTHOOK: type: QUERY
29 STAGE DEPENDENCIES:
30   Stage-1 is a root stage
31   Stage-0 depends on stages: Stage-1
32   Stage-2 depends on stages: Stage-0
33
34 STAGE PLANS:
35   Stage: Stage-1
36     Spark
37 #### A masked pattern was here ####
38       Vertices:
39         Map 1 
40             Map Operator Tree:
41                 TableScan
42                   alias: orc_merge5
43                   filterExpr: (userid <= 13L) (type: boolean)
44                   Statistics: Num rows: 1 Data size: 2464020 Basic stats: COMPLETE Column stats: NONE
45                   Filter Operator
46                     predicate: (userid <= 13L) (type: boolean)
47                     Statistics: Num rows: 1 Data size: 2464020 Basic stats: COMPLETE Column stats: NONE
48                     Select Operator
49                       expressions: userid (type: bigint), string1 (type: string), subtype (type: double), decimal1 (type: decimal(10,0)), ts (type: timestamp)
50                       outputColumnNames: _col0, _col1, _col2, _col3, _col4
51                       Statistics: Num rows: 1 Data size: 2464020 Basic stats: COMPLETE Column stats: NONE
52                       File Output Operator
53                         compressed: false
54                         Statistics: Num rows: 1 Data size: 2464020 Basic stats: COMPLETE Column stats: NONE
55                         table:
56                             input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
57                             output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
58                             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
59                             name: default.orc_merge5a
60
61   Stage: Stage-0
62     Move Operator
63       tables:
64           partition:
65             hour 24
66             year 2000
67           replace: true
68           table:
69               input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
70               output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
71               serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
72               name: default.orc_merge5a
73
74   Stage: Stage-2
75     Stats Work
76       Basic Stats Work:
77
78 PREHOOK: query: insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
79 PREHOOK: type: QUERY
80 PREHOOK: Input: default@orc_merge5
81 PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
82 POSTHOOK: query: insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
83 POSTHOOK: type: QUERY
84 POSTHOOK: Input: default@orc_merge5
85 POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
86 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).decimal1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:decimal1, type:decimal(10,0), comment:null), ]
87 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).string1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:string1, type:string, comment:null), ]
88 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype, type:double, comment:null), ]
89 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp, comment:null), ]
90 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
91 PREHOOK: query: insert overwrite table orc_merge5a partition (year="2001",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
92 PREHOOK: type: QUERY
93 PREHOOK: Input: default@orc_merge5
94 PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
95 POSTHOOK: query: insert overwrite table orc_merge5a partition (year="2001",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
96 POSTHOOK: type: QUERY
97 POSTHOOK: Input: default@orc_merge5
98 POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
99 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).decimal1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:decimal1, type:decimal(10,0), comment:null), ]
100 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).string1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:string1, type:string, comment:null), ]
101 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype, type:double, comment:null), ]
102 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp, comment:null), ]
103 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
104 PREHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
105 PREHOOK: type: QUERY
106 PREHOOK: Input: default@orc_merge5a
107 PREHOOK: Output: default@orc_merge5a
108 PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
109 POSTHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
110 POSTHOOK: type: QUERY
111 POSTHOOK: Input: default@orc_merge5a
112 POSTHOOK: Output: default@orc_merge5a
113 POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
114 PREHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
115 PREHOOK: type: QUERY
116 PREHOOK: Input: default@orc_merge5a
117 PREHOOK: Output: default@orc_merge5a
118 PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
119 POSTHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
120 POSTHOOK: type: QUERY
121 POSTHOOK: Input: default@orc_merge5a
122 POSTHOOK: Output: default@orc_merge5a
123 POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
124 Found 3 items
125 -rw-r--r--   3 ### USER ### ### GROUP ###        649 ### HDFS DATE ### hdfs://### HDFS PATH ###
126 -rw-r--r--   3 ### USER ### ### GROUP ###          0 ### HDFS DATE ### hdfs://### HDFS PATH ###
127 -rw-r--r--   3 ### USER ### ### GROUP ###        601 ### HDFS DATE ### hdfs://### HDFS PATH ###
128 Found 3 items
129 -rw-r--r--   3 ### USER ### ### GROUP ###        649 ### HDFS DATE ### hdfs://### HDFS PATH ###
130 -rw-r--r--   3 ### USER ### ### GROUP ###          0 ### HDFS DATE ### hdfs://### HDFS PATH ###
131 -rw-r--r--   3 ### USER ### ### GROUP ###        601 ### HDFS DATE ### hdfs://### HDFS PATH ###
132 PREHOOK: query: show partitions orc_merge5a
133 PREHOOK: type: SHOWPARTITIONS
134 PREHOOK: Input: default@orc_merge5a
135 POSTHOOK: query: show partitions orc_merge5a
136 POSTHOOK: type: SHOWPARTITIONS
137 POSTHOOK: Input: default@orc_merge5a
138 year=2000/hour=24
139 year=2001/hour=24
140 PREHOOK: query: select * from orc_merge5a
141 PREHOOK: type: QUERY
142 PREHOOK: Input: default@orc_merge5a
143 PREHOOK: Input: default@orc_merge5a@year=2000/hour=24
144 PREHOOK: Input: default@orc_merge5a@year=2001/hour=24
145 PREHOOK: Output: hdfs://### HDFS PATH ###
146 POSTHOOK: query: select * from orc_merge5a
147 POSTHOOK: type: QUERY
148 POSTHOOK: Input: default@orc_merge5a
149 POSTHOOK: Input: default@orc_merge5a@year=2000/hour=24
150 POSTHOOK: Input: default@orc_merge5a@year=2001/hour=24
151 POSTHOOK: Output: hdfs://### HDFS PATH ###
152 13      bar     80.0    2       1969-12-31 16:00:05     2000    24
153 13      bar     80.0    2       1969-12-31 16:00:05     2001    24
154 2       foo     0.8     1       1969-12-31 16:00:00     2000    24
155 2       foo     0.8     1       1969-12-31 16:00:00     2001    24
156 5       eat     0.8     6       1969-12-31 16:00:20     2000    24
157 5       eat     0.8     6       1969-12-31 16:00:20     2001    24
158 PREHOOK: query: explain insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
159 PREHOOK: type: QUERY
160 POSTHOOK: query: explain insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
161 POSTHOOK: type: QUERY
162 STAGE DEPENDENCIES:
163   Stage-1 is a root stage
164   Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
165   Stage-4
166   Stage-0 depends on stages: Stage-4, Stage-3, Stage-6
167   Stage-2 depends on stages: Stage-0
168   Stage-3
169   Stage-5
170   Stage-6 depends on stages: Stage-5
171
172 STAGE PLANS:
173   Stage: Stage-1
174     Spark
175 #### A masked pattern was here ####
176       Vertices:
177         Map 1 
178             Map Operator Tree:
179                 TableScan
180                   alias: orc_merge5
181                   filterExpr: (userid <= 13L) (type: boolean)
182                   Statistics: Num rows: 1 Data size: 2464020 Basic stats: COMPLETE Column stats: NONE
183                   Filter Operator
184                     predicate: (userid <= 13L) (type: boolean)
185                     Statistics: Num rows: 1 Data size: 2464020 Basic stats: COMPLETE Column stats: NONE
186                     Select Operator
187                       expressions: userid (type: bigint), string1 (type: string), subtype (type: double), decimal1 (type: decimal(10,0)), ts (type: timestamp)
188                       outputColumnNames: _col0, _col1, _col2, _col3, _col4
189                       Statistics: Num rows: 1 Data size: 2464020 Basic stats: COMPLETE Column stats: NONE
190                       File Output Operator
191                         compressed: false
192                         Statistics: Num rows: 1 Data size: 2464020 Basic stats: COMPLETE Column stats: NONE
193                         table:
194                             input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
195                             output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
196                             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
197                             name: default.orc_merge5a
198
199   Stage: Stage-7
200     Conditional Operator
201
202   Stage: Stage-4
203     Move Operator
204       files:
205           hdfs directory: true
206           destination: hdfs://### HDFS PATH ###
207
208   Stage: Stage-0
209     Move Operator
210       tables:
211           partition:
212             hour 24
213             year 2000
214           replace: true
215           table:
216               input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
217               output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
218               serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
219               name: default.orc_merge5a
220
221   Stage: Stage-2
222     Stats Work
223       Basic Stats Work:
224
225   Stage: Stage-3
226     Spark
227 #### A masked pattern was here ####
228       Vertices:
229         Spark Merge File Work 
230           Merge File Operator
231             Map Operator Tree:
232                 ORC File Merge Operator
233             merge level: stripe
234             input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
235
236   Stage: Stage-5
237     Spark
238 #### A masked pattern was here ####
239       Vertices:
240         Spark Merge File Work 
241           Merge File Operator
242             Map Operator Tree:
243                 ORC File Merge Operator
244             merge level: stripe
245             input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
246
247   Stage: Stage-6
248     Move Operator
249       files:
250           hdfs directory: true
251           destination: hdfs://### HDFS PATH ###
252
253 PREHOOK: query: insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
254 PREHOOK: type: QUERY
255 PREHOOK: Input: default@orc_merge5
256 PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
257 POSTHOOK: query: insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
258 POSTHOOK: type: QUERY
259 POSTHOOK: Input: default@orc_merge5
260 POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
261 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).decimal1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:decimal1, type:decimal(10,0), comment:null), ]
262 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).string1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:string1, type:string, comment:null), ]
263 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype, type:double, comment:null), ]
264 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp, comment:null), ]
265 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
266 PREHOOK: query: insert overwrite table orc_merge5a partition (year="2001",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
267 PREHOOK: type: QUERY
268 PREHOOK: Input: default@orc_merge5
269 PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
270 POSTHOOK: query: insert overwrite table orc_merge5a partition (year="2001",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
271 POSTHOOK: type: QUERY
272 POSTHOOK: Input: default@orc_merge5
273 POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
274 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).decimal1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:decimal1, type:decimal(10,0), comment:null), ]
275 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).string1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:string1, type:string, comment:null), ]
276 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype, type:double, comment:null), ]
277 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp, comment:null), ]
278 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
279 PREHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
280 PREHOOK: type: QUERY
281 PREHOOK: Input: default@orc_merge5a
282 PREHOOK: Output: default@orc_merge5a
283 PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
284 POSTHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
285 POSTHOOK: type: QUERY
286 POSTHOOK: Input: default@orc_merge5a
287 POSTHOOK: Output: default@orc_merge5a
288 POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
289 PREHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
290 PREHOOK: type: QUERY
291 PREHOOK: Input: default@orc_merge5a
292 PREHOOK: Output: default@orc_merge5a
293 PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
294 POSTHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
295 POSTHOOK: type: QUERY
296 POSTHOOK: Input: default@orc_merge5a
297 POSTHOOK: Output: default@orc_merge5a
298 POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
299 Found 1 items
300 -rw-r--r--   3 ### USER ### ### GROUP ###       1022 ### HDFS DATE ### hdfs://### HDFS PATH ###
301 Found 1 items
302 -rw-r--r--   3 ### USER ### ### GROUP ###       1022 ### HDFS DATE ### hdfs://### HDFS PATH ###
303 PREHOOK: query: show partitions orc_merge5a
304 PREHOOK: type: SHOWPARTITIONS
305 PREHOOK: Input: default@orc_merge5a
306 POSTHOOK: query: show partitions orc_merge5a
307 POSTHOOK: type: SHOWPARTITIONS
308 POSTHOOK: Input: default@orc_merge5a
309 year=2000/hour=24
310 year=2001/hour=24
311 PREHOOK: query: select * from orc_merge5a
312 PREHOOK: type: QUERY
313 PREHOOK: Input: default@orc_merge5a
314 PREHOOK: Input: default@orc_merge5a@year=2000/hour=24
315 PREHOOK: Input: default@orc_merge5a@year=2001/hour=24
316 PREHOOK: Output: hdfs://### HDFS PATH ###
317 POSTHOOK: query: select * from orc_merge5a
318 POSTHOOK: type: QUERY
319 POSTHOOK: Input: default@orc_merge5a
320 POSTHOOK: Input: default@orc_merge5a@year=2000/hour=24
321 POSTHOOK: Input: default@orc_merge5a@year=2001/hour=24
322 POSTHOOK: Output: hdfs://### HDFS PATH ###
323 13      bar     80.0    2       1969-12-31 16:00:05     2000    24
324 13      bar     80.0    2       1969-12-31 16:00:05     2001    24
325 2       foo     0.8     1       1969-12-31 16:00:00     2000    24
326 2       foo     0.8     1       1969-12-31 16:00:00     2001    24
327 5       eat     0.8     6       1969-12-31 16:00:20     2000    24
328 5       eat     0.8     6       1969-12-31 16:00:20     2001    24
329 PREHOOK: query: insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
330 PREHOOK: type: QUERY
331 PREHOOK: Input: default@orc_merge5
332 PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
333 POSTHOOK: query: insert overwrite table orc_merge5a partition (year="2000",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
334 POSTHOOK: type: QUERY
335 POSTHOOK: Input: default@orc_merge5
336 POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
337 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).decimal1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:decimal1, type:decimal(10,0), comment:null), ]
338 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).string1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:string1, type:string, comment:null), ]
339 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype, type:double, comment:null), ]
340 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp, comment:null), ]
341 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2000,hour=24).userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
342 PREHOOK: query: insert overwrite table orc_merge5a partition (year="2001",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
343 PREHOOK: type: QUERY
344 PREHOOK: Input: default@orc_merge5
345 PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
346 POSTHOOK: query: insert overwrite table orc_merge5a partition (year="2001",hour=24) select userid,string1,subtype,decimal1,ts from orc_merge5 where userid<=13
347 POSTHOOK: type: QUERY
348 POSTHOOK: Input: default@orc_merge5
349 POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
350 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).decimal1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:decimal1, type:decimal(10,0), comment:null), ]
351 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).string1 SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:string1, type:string, comment:null), ]
352 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).subtype SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:subtype, type:double, comment:null), ]
353 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).ts SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:ts, type:timestamp, comment:null), ]
354 POSTHOOK: Lineage: orc_merge5a PARTITION(year=2001,hour=24).userid SIMPLE [(orc_merge5)orc_merge5.FieldSchema(name:userid, type:bigint, comment:null), ]
355 PREHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
356 PREHOOK: type: QUERY
357 PREHOOK: Input: default@orc_merge5a
358 PREHOOK: Output: default@orc_merge5a
359 PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
360 POSTHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
361 POSTHOOK: type: QUERY
362 POSTHOOK: Input: default@orc_merge5a
363 POSTHOOK: Output: default@orc_merge5a
364 POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
365 PREHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
366 PREHOOK: type: QUERY
367 PREHOOK: Input: default@orc_merge5a
368 PREHOOK: Output: default@orc_merge5a
369 PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
370 POSTHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
371 POSTHOOK: type: QUERY
372 POSTHOOK: Input: default@orc_merge5a
373 POSTHOOK: Output: default@orc_merge5a
374 POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
375 Found 3 items
376 -rw-r--r--   3 ### USER ### ### GROUP ###        649 ### HDFS DATE ### hdfs://### HDFS PATH ###
377 -rw-r--r--   3 ### USER ### ### GROUP ###          0 ### HDFS DATE ### hdfs://### HDFS PATH ###
378 -rw-r--r--   3 ### USER ### ### GROUP ###        601 ### HDFS DATE ### hdfs://### HDFS PATH ###
379 Found 3 items
380 -rw-r--r--   3 ### USER ### ### GROUP ###        649 ### HDFS DATE ### hdfs://### HDFS PATH ###
381 -rw-r--r--   3 ### USER ### ### GROUP ###          0 ### HDFS DATE ### hdfs://### HDFS PATH ###
382 -rw-r--r--   3 ### USER ### ### GROUP ###        601 ### HDFS DATE ### hdfs://### HDFS PATH ###
383 PREHOOK: query: show partitions orc_merge5a
384 PREHOOK: type: SHOWPARTITIONS
385 PREHOOK: Input: default@orc_merge5a
386 POSTHOOK: query: show partitions orc_merge5a
387 POSTHOOK: type: SHOWPARTITIONS
388 POSTHOOK: Input: default@orc_merge5a
389 year=2000/hour=24
390 year=2001/hour=24
391 PREHOOK: query: select * from orc_merge5a
392 PREHOOK: type: QUERY
393 PREHOOK: Input: default@orc_merge5a
394 PREHOOK: Input: default@orc_merge5a@year=2000/hour=24
395 PREHOOK: Input: default@orc_merge5a@year=2001/hour=24
396 PREHOOK: Output: hdfs://### HDFS PATH ###
397 POSTHOOK: query: select * from orc_merge5a
398 POSTHOOK: type: QUERY
399 POSTHOOK: Input: default@orc_merge5a
400 POSTHOOK: Input: default@orc_merge5a@year=2000/hour=24
401 POSTHOOK: Input: default@orc_merge5a@year=2001/hour=24
402 POSTHOOK: Output: hdfs://### HDFS PATH ###
403 13      bar     80.0    2       1969-12-31 16:00:05     2000    24
404 13      bar     80.0    2       1969-12-31 16:00:05     2001    24
405 2       foo     0.8     1       1969-12-31 16:00:00     2000    24
406 2       foo     0.8     1       1969-12-31 16:00:00     2001    24
407 5       eat     0.8     6       1969-12-31 16:00:20     2000    24
408 5       eat     0.8     6       1969-12-31 16:00:20     2001    24
409 PREHOOK: query: explain alter table orc_merge5a partition(year="2000",hour=24) concatenate
410 PREHOOK: type: ALTER_PARTITION_MERGE
411 POSTHOOK: query: explain alter table orc_merge5a partition(year="2000",hour=24) concatenate
412 POSTHOOK: type: ALTER_PARTITION_MERGE
413 STAGE DEPENDENCIES:
414   Stage-0 is a root stage
415   Stage-1 depends on stages: Stage-0
416   Stage-2 depends on stages: Stage-1
417
418 STAGE PLANS:
419   Stage: Stage-0
420
421   Stage: Stage-1
422     Move Operator
423       tables:
424           partition:
425             hour 24
426             year 2000
427           replace: true
428           table:
429               input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
430               output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
431               serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
432               name: default.orc_merge5a
433
434   Stage: Stage-2
435     Stats Work
436       Basic Stats Work:
437
438 PREHOOK: query: alter table orc_merge5a partition(year="2000",hour=24) concatenate
439 PREHOOK: type: ALTER_PARTITION_MERGE
440 PREHOOK: Input: default@orc_merge5a
441 PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
442 POSTHOOK: query: alter table orc_merge5a partition(year="2000",hour=24) concatenate
443 POSTHOOK: type: ALTER_PARTITION_MERGE
444 POSTHOOK: Input: default@orc_merge5a
445 POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
446 PREHOOK: query: alter table orc_merge5a partition(year="2001",hour=24) concatenate
447 PREHOOK: type: ALTER_PARTITION_MERGE
448 PREHOOK: Input: default@orc_merge5a
449 PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
450 POSTHOOK: query: alter table orc_merge5a partition(year="2001",hour=24) concatenate
451 POSTHOOK: type: ALTER_PARTITION_MERGE
452 POSTHOOK: Input: default@orc_merge5a
453 POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
454 PREHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
455 PREHOOK: type: QUERY
456 PREHOOK: Input: default@orc_merge5a
457 PREHOOK: Output: default@orc_merge5a
458 PREHOOK: Output: default@orc_merge5a@year=2000/hour=24
459 POSTHOOK: query: analyze table orc_merge5a partition(year="2000",hour=24) compute statistics noscan
460 POSTHOOK: type: QUERY
461 POSTHOOK: Input: default@orc_merge5a
462 POSTHOOK: Output: default@orc_merge5a
463 POSTHOOK: Output: default@orc_merge5a@year=2000/hour=24
464 PREHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
465 PREHOOK: type: QUERY
466 PREHOOK: Input: default@orc_merge5a
467 PREHOOK: Output: default@orc_merge5a
468 PREHOOK: Output: default@orc_merge5a@year=2001/hour=24
469 POSTHOOK: query: analyze table orc_merge5a partition(year="2001",hour=24) compute statistics noscan
470 POSTHOOK: type: QUERY
471 POSTHOOK: Input: default@orc_merge5a
472 POSTHOOK: Output: default@orc_merge5a
473 POSTHOOK: Output: default@orc_merge5a@year=2001/hour=24
474 Found 1 items
475 -rw-r--r--   3 ### USER ### ### GROUP ###       1022 ### HDFS DATE ### hdfs://### HDFS PATH ###
476 Found 1 items
477 -rw-r--r--   3 ### USER ### ### GROUP ###       1022 ### HDFS DATE ### hdfs://### HDFS PATH ###
478 PREHOOK: query: show partitions orc_merge5a
479 PREHOOK: type: SHOWPARTITIONS
480 PREHOOK: Input: default@orc_merge5a
481 POSTHOOK: query: show partitions orc_merge5a
482 POSTHOOK: type: SHOWPARTITIONS
483 POSTHOOK: Input: default@orc_merge5a
484 year=2000/hour=24
485 year=2001/hour=24
486 PREHOOK: query: select * from orc_merge5a
487 PREHOOK: type: QUERY
488 PREHOOK: Input: default@orc_merge5a
489 PREHOOK: Input: default@orc_merge5a@year=2000/hour=24
490 PREHOOK: Input: default@orc_merge5a@year=2001/hour=24
491 PREHOOK: Output: hdfs://### HDFS PATH ###
492 POSTHOOK: query: select * from orc_merge5a
493 POSTHOOK: type: QUERY
494 POSTHOOK: Input: default@orc_merge5a
495 POSTHOOK: Input: default@orc_merge5a@year=2000/hour=24
496 POSTHOOK: Input: default@orc_merge5a@year=2001/hour=24
497 POSTHOOK: Output: hdfs://### HDFS PATH ###
498 13      bar     80.0    2       1969-12-31 16:00:05     2000    24
499 13      bar     80.0    2       1969-12-31 16:00:05     2001    24
500 2       foo     0.8     1       1969-12-31 16:00:00     2000    24
501 2       foo     0.8     1       1969-12-31 16:00:00     2001    24
502 5       eat     0.8     6       1969-12-31 16:00:20     2000    24
503 5       eat     0.8     6       1969-12-31 16:00:20     2001    24