You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by zs...@apache.org on 2008/09/20 01:56:35 UTC
svn commit: r697291 [16/31] - in /hadoop/core/trunk: ./
src/contrib/hive/cli/src/java/org/apache/hadoop/hive/cli/
src/contrib/hive/metastore/if/
src/contrib/hive/metastore/src/gen-javabean/org/apache/hadoop/hive/metastore/api/
src/contrib/hive/metastor...
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input12.q.out Fri Sep 19 16:56:30 2008
@@ -1,584 +1,588 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (TOK_COLREF src key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (and (>= (TOK_COLREF src key) 100) (< (TOK_COLREF src key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest3 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key))) (TOK_WHERE (>= (TOK_COLREF src key) 200))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- Filter Operator
- predicate:
- expr: (key < 100)
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Filter Operator
- predicate:
- expr: ((key >= 100) and (key < 200))
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- name: dest2
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Filter Operator
- predicate:
- expr: (key >= 200)
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- File Output Operator
- table:
- name: dest3
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- table:
- name: dest2
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- table:
- name: dest3
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- partition:
- ds 2008-04-08
- hr 12
- replace:
-
-86 val_86
-27 val_27
-98 val_98
-66 val_66
-37 val_37
-15 val_15
-82 val_82
-17 val_17
-0 val_0
-57 val_57
-20 val_20
-92 val_92
-47 val_47
-72 val_72
-4 val_4
-35 val_35
-54 val_54
-51 val_51
-65 val_65
-83 val_83
-12 val_12
-67 val_67
-84 val_84
-58 val_58
-8 val_8
-24 val_24
-42 val_42
-0 val_0
-96 val_96
-26 val_26
-51 val_51
-43 val_43
-95 val_95
-98 val_98
-85 val_85
-77 val_77
-0 val_0
-87 val_87
-15 val_15
-72 val_72
-90 val_90
-19 val_19
-10 val_10
-5 val_5
-58 val_58
-35 val_35
-95 val_95
-11 val_11
-34 val_34
-42 val_42
-78 val_78
-76 val_76
-41 val_41
-30 val_30
-64 val_64
-76 val_76
-74 val_74
-69 val_69
-33 val_33
-70 val_70
-5 val_5
-2 val_2
-35 val_35
-80 val_80
-44 val_44
-53 val_53
-90 val_90
-12 val_12
-5 val_5
-70 val_70
-24 val_24
-70 val_70
-83 val_83
-26 val_26
-67 val_67
-18 val_18
-9 val_9
-18 val_18
-97 val_97
-84 val_84
-28 val_28
-37 val_37
-90 val_90
-97 val_97
-165 val_165
-193 val_193
-150 val_150
-128 val_128
-146 val_146
-152 val_152
-145 val_145
-166 val_166
-153 val_153
-193 val_193
-174 val_174
-199 val_199
-174 val_174
-162 val_162
-167 val_167
-195 val_195
-113 val_113
-155 val_155
-128 val_128
-149 val_149
-129 val_129
-170 val_170
-157 val_157
-111 val_111
-169 val_169
-125 val_125
-192 val_192
-187 val_187
-176 val_176
-138 val_138
-103 val_103
-176 val_176
-137 val_137
-180 val_180
-181 val_181
-138 val_138
-179 val_179
-172 val_172
-129 val_129
-158 val_158
-119 val_119
-197 val_197
-100 val_100
-199 val_199
-191 val_191
-165 val_165
-120 val_120
-131 val_131
-156 val_156
-196 val_196
-197 val_197
-187 val_187
-137 val_137
-169 val_169
-179 val_179
-118 val_118
-134 val_134
-138 val_138
-118 val_118
-177 val_177
-168 val_168
-143 val_143
-160 val_160
-195 val_195
-119 val_119
-149 val_149
-138 val_138
-103 val_103
-113 val_113
-167 val_167
-116 val_116
-191 val_191
-128 val_128
-193 val_193
-104 val_104
-175 val_175
-105 val_105
-190 val_190
-114 val_114
-164 val_164
-125 val_125
-164 val_164
-187 val_187
-104 val_104
-163 val_163
-119 val_119
-199 val_199
-120 val_120
-169 val_169
-178 val_178
-136 val_136
-172 val_172
-133 val_133
-175 val_175
-189 val_189
-134 val_134
-100 val_100
-146 val_146
-186 val_186
-167 val_167
-183 val_183
-152 val_152
-194 val_194
-126 val_126
-169 val_169
-238 NULL 2008-04-08 12
-311 NULL 2008-04-08 12
-409 NULL 2008-04-08 12
-255 NULL 2008-04-08 12
-278 NULL 2008-04-08 12
-484 NULL 2008-04-08 12
-265 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-224 NULL 2008-04-08 12
-369 NULL 2008-04-08 12
-213 NULL 2008-04-08 12
-406 NULL 2008-04-08 12
-429 NULL 2008-04-08 12
-374 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-495 NULL 2008-04-08 12
-327 NULL 2008-04-08 12
-281 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-209 NULL 2008-04-08 12
-403 NULL 2008-04-08 12
-417 NULL 2008-04-08 12
-430 NULL 2008-04-08 12
-252 NULL 2008-04-08 12
-292 NULL 2008-04-08 12
-219 NULL 2008-04-08 12
-287 NULL 2008-04-08 12
-338 NULL 2008-04-08 12
-446 NULL 2008-04-08 12
-459 NULL 2008-04-08 12
-394 NULL 2008-04-08 12
-237 NULL 2008-04-08 12
-482 NULL 2008-04-08 12
-413 NULL 2008-04-08 12
-494 NULL 2008-04-08 12
-207 NULL 2008-04-08 12
-466 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-399 NULL 2008-04-08 12
-396 NULL 2008-04-08 12
-247 NULL 2008-04-08 12
-417 NULL 2008-04-08 12
-489 NULL 2008-04-08 12
-377 NULL 2008-04-08 12
-397 NULL 2008-04-08 12
-309 NULL 2008-04-08 12
-365 NULL 2008-04-08 12
-266 NULL 2008-04-08 12
-439 NULL 2008-04-08 12
-342 NULL 2008-04-08 12
-367 NULL 2008-04-08 12
-325 NULL 2008-04-08 12
-475 NULL 2008-04-08 12
-203 NULL 2008-04-08 12
-339 NULL 2008-04-08 12
-455 NULL 2008-04-08 12
-311 NULL 2008-04-08 12
-316 NULL 2008-04-08 12
-302 NULL 2008-04-08 12
-205 NULL 2008-04-08 12
-438 NULL 2008-04-08 12
-345 NULL 2008-04-08 12
-489 NULL 2008-04-08 12
-378 NULL 2008-04-08 12
-221 NULL 2008-04-08 12
-280 NULL 2008-04-08 12
-427 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-356 NULL 2008-04-08 12
-399 NULL 2008-04-08 12
-382 NULL 2008-04-08 12
-498 NULL 2008-04-08 12
-386 NULL 2008-04-08 12
-437 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-286 NULL 2008-04-08 12
-459 NULL 2008-04-08 12
-239 NULL 2008-04-08 12
-213 NULL 2008-04-08 12
-216 NULL 2008-04-08 12
-430 NULL 2008-04-08 12
-278 NULL 2008-04-08 12
-289 NULL 2008-04-08 12
-221 NULL 2008-04-08 12
-318 NULL 2008-04-08 12
-332 NULL 2008-04-08 12
-311 NULL 2008-04-08 12
-275 NULL 2008-04-08 12
-241 NULL 2008-04-08 12
-333 NULL 2008-04-08 12
-284 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-260 NULL 2008-04-08 12
-404 NULL 2008-04-08 12
-384 NULL 2008-04-08 12
-489 NULL 2008-04-08 12
-353 NULL 2008-04-08 12
-373 NULL 2008-04-08 12
-272 NULL 2008-04-08 12
-217 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-466 NULL 2008-04-08 12
-411 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-463 NULL 2008-04-08 12
-431 NULL 2008-04-08 12
-496 NULL 2008-04-08 12
-322 NULL 2008-04-08 12
-468 NULL 2008-04-08 12
-393 NULL 2008-04-08 12
-454 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-418 NULL 2008-04-08 12
-327 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-205 NULL 2008-04-08 12
-404 NULL 2008-04-08 12
-436 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-468 NULL 2008-04-08 12
-308 NULL 2008-04-08 12
-288 NULL 2008-04-08 12
-481 NULL 2008-04-08 12
-457 NULL 2008-04-08 12
-282 NULL 2008-04-08 12
-318 NULL 2008-04-08 12
-318 NULL 2008-04-08 12
-409 NULL 2008-04-08 12
-470 NULL 2008-04-08 12
-369 NULL 2008-04-08 12
-316 NULL 2008-04-08 12
-413 NULL 2008-04-08 12
-490 NULL 2008-04-08 12
-364 NULL 2008-04-08 12
-395 NULL 2008-04-08 12
-282 NULL 2008-04-08 12
-238 NULL 2008-04-08 12
-419 NULL 2008-04-08 12
-307 NULL 2008-04-08 12
-435 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-306 NULL 2008-04-08 12
-224 NULL 2008-04-08 12
-309 NULL 2008-04-08 12
-389 NULL 2008-04-08 12
-327 NULL 2008-04-08 12
-242 NULL 2008-04-08 12
-369 NULL 2008-04-08 12
-392 NULL 2008-04-08 12
-272 NULL 2008-04-08 12
-331 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-242 NULL 2008-04-08 12
-452 NULL 2008-04-08 12
-226 NULL 2008-04-08 12
-497 NULL 2008-04-08 12
-402 NULL 2008-04-08 12
-396 NULL 2008-04-08 12
-317 NULL 2008-04-08 12
-395 NULL 2008-04-08 12
-336 NULL 2008-04-08 12
-229 NULL 2008-04-08 12
-233 NULL 2008-04-08 12
-472 NULL 2008-04-08 12
-322 NULL 2008-04-08 12
-498 NULL 2008-04-08 12
-321 NULL 2008-04-08 12
-430 NULL 2008-04-08 12
-489 NULL 2008-04-08 12
-458 NULL 2008-04-08 12
-223 NULL 2008-04-08 12
-492 NULL 2008-04-08 12
-449 NULL 2008-04-08 12
-218 NULL 2008-04-08 12
-228 NULL 2008-04-08 12
-453 NULL 2008-04-08 12
-209 NULL 2008-04-08 12
-468 NULL 2008-04-08 12
-342 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-368 NULL 2008-04-08 12
-296 NULL 2008-04-08 12
-216 NULL 2008-04-08 12
-367 NULL 2008-04-08 12
-344 NULL 2008-04-08 12
-274 NULL 2008-04-08 12
-219 NULL 2008-04-08 12
-239 NULL 2008-04-08 12
-485 NULL 2008-04-08 12
-223 NULL 2008-04-08 12
-256 NULL 2008-04-08 12
-263 NULL 2008-04-08 12
-487 NULL 2008-04-08 12
-480 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-288 NULL 2008-04-08 12
-244 NULL 2008-04-08 12
-438 NULL 2008-04-08 12
-467 NULL 2008-04-08 12
-432 NULL 2008-04-08 12
-202 NULL 2008-04-08 12
-316 NULL 2008-04-08 12
-229 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-463 NULL 2008-04-08 12
-280 NULL 2008-04-08 12
-283 NULL 2008-04-08 12
-331 NULL 2008-04-08 12
-235 NULL 2008-04-08 12
-321 NULL 2008-04-08 12
-335 NULL 2008-04-08 12
-466 NULL 2008-04-08 12
-366 NULL 2008-04-08 12
-403 NULL 2008-04-08 12
-483 NULL 2008-04-08 12
-257 NULL 2008-04-08 12
-406 NULL 2008-04-08 12
-409 NULL 2008-04-08 12
-406 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-258 NULL 2008-04-08 12
-203 NULL 2008-04-08 12
-262 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-424 NULL 2008-04-08 12
-396 NULL 2008-04-08 12
-201 NULL 2008-04-08 12
-217 NULL 2008-04-08 12
-431 NULL 2008-04-08 12
-454 NULL 2008-04-08 12
-478 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-431 NULL 2008-04-08 12
-424 NULL 2008-04-08 12
-382 NULL 2008-04-08 12
-397 NULL 2008-04-08 12
-480 NULL 2008-04-08 12
-291 NULL 2008-04-08 12
-351 NULL 2008-04-08 12
-255 NULL 2008-04-08 12
-438 NULL 2008-04-08 12
-414 NULL 2008-04-08 12
-200 NULL 2008-04-08 12
-491 NULL 2008-04-08 12
-237 NULL 2008-04-08 12
-439 NULL 2008-04-08 12
-360 NULL 2008-04-08 12
-248 NULL 2008-04-08 12
-479 NULL 2008-04-08 12
-305 NULL 2008-04-08 12
-417 NULL 2008-04-08 12
-444 NULL 2008-04-08 12
-429 NULL 2008-04-08 12
-443 NULL 2008-04-08 12
-323 NULL 2008-04-08 12
-325 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-478 NULL 2008-04-08 12
-468 NULL 2008-04-08 12
-310 NULL 2008-04-08 12
-317 NULL 2008-04-08 12
-333 NULL 2008-04-08 12
-493 NULL 2008-04-08 12
-460 NULL 2008-04-08 12
-207 NULL 2008-04-08 12
-249 NULL 2008-04-08 12
-265 NULL 2008-04-08 12
-480 NULL 2008-04-08 12
-353 NULL 2008-04-08 12
-214 NULL 2008-04-08 12
-462 NULL 2008-04-08 12
-233 NULL 2008-04-08 12
-406 NULL 2008-04-08 12
-454 NULL 2008-04-08 12
-375 NULL 2008-04-08 12
-401 NULL 2008-04-08 12
-421 NULL 2008-04-08 12
-407 NULL 2008-04-08 12
-384 NULL 2008-04-08 12
-256 NULL 2008-04-08 12
-384 NULL 2008-04-08 12
-379 NULL 2008-04-08 12
-462 NULL 2008-04-08 12
-492 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-341 NULL 2008-04-08 12
-498 NULL 2008-04-08 12
-458 NULL 2008-04-08 12
-362 NULL 2008-04-08 12
-285 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-281 NULL 2008-04-08 12
-344 NULL 2008-04-08 12
-469 NULL 2008-04-08 12
-315 NULL 2008-04-08 12
-448 NULL 2008-04-08 12
-348 NULL 2008-04-08 12
-307 NULL 2008-04-08 12
-414 NULL 2008-04-08 12
-477 NULL 2008-04-08 12
-222 NULL 2008-04-08 12
-403 NULL 2008-04-08 12
-400 NULL 2008-04-08 12
-200 NULL 2008-04-08 12
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (TOK_COLREF src key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (and (>= (TOK_COLREF src key) 100) (< (TOK_COLREF src key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest3 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key))) (TOK_WHERE (>= (TOK_COLREF src key) 200))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ Filter Operator
+ predicate:
+ expr: (key < 100)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: ((key >= 100) and (key < 200))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ name: dest2
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: (key >= 200)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ File Output Operator
+ table:
+ name: dest3
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ table:
+ name: dest2
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ table:
+ name: dest3
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ partition:
+ ds 2008-04-08
+ hr 12
+ replace:
+
+
+86 val_86
+27 val_27
+98 val_98
+66 val_66
+37 val_37
+15 val_15
+82 val_82
+17 val_17
+0 val_0
+57 val_57
+20 val_20
+92 val_92
+47 val_47
+72 val_72
+4 val_4
+35 val_35
+54 val_54
+51 val_51
+65 val_65
+83 val_83
+12 val_12
+67 val_67
+84 val_84
+58 val_58
+8 val_8
+24 val_24
+42 val_42
+0 val_0
+96 val_96
+26 val_26
+51 val_51
+43 val_43
+95 val_95
+98 val_98
+85 val_85
+77 val_77
+0 val_0
+87 val_87
+15 val_15
+72 val_72
+90 val_90
+19 val_19
+10 val_10
+5 val_5
+58 val_58
+35 val_35
+95 val_95
+11 val_11
+34 val_34
+42 val_42
+78 val_78
+76 val_76
+41 val_41
+30 val_30
+64 val_64
+76 val_76
+74 val_74
+69 val_69
+33 val_33
+70 val_70
+5 val_5
+2 val_2
+35 val_35
+80 val_80
+44 val_44
+53 val_53
+90 val_90
+12 val_12
+5 val_5
+70 val_70
+24 val_24
+70 val_70
+83 val_83
+26 val_26
+67 val_67
+18 val_18
+9 val_9
+18 val_18
+97 val_97
+84 val_84
+28 val_28
+37 val_37
+90 val_90
+97 val_97
+
+165 val_165
+193 val_193
+150 val_150
+128 val_128
+146 val_146
+152 val_152
+145 val_145
+166 val_166
+153 val_153
+193 val_193
+174 val_174
+199 val_199
+174 val_174
+162 val_162
+167 val_167
+195 val_195
+113 val_113
+155 val_155
+128 val_128
+149 val_149
+129 val_129
+170 val_170
+157 val_157
+111 val_111
+169 val_169
+125 val_125
+192 val_192
+187 val_187
+176 val_176
+138 val_138
+103 val_103
+176 val_176
+137 val_137
+180 val_180
+181 val_181
+138 val_138
+179 val_179
+172 val_172
+129 val_129
+158 val_158
+119 val_119
+197 val_197
+100 val_100
+199 val_199
+191 val_191
+165 val_165
+120 val_120
+131 val_131
+156 val_156
+196 val_196
+197 val_197
+187 val_187
+137 val_137
+169 val_169
+179 val_179
+118 val_118
+134 val_134
+138 val_138
+118 val_118
+177 val_177
+168 val_168
+143 val_143
+160 val_160
+195 val_195
+119 val_119
+149 val_149
+138 val_138
+103 val_103
+113 val_113
+167 val_167
+116 val_116
+191 val_191
+128 val_128
+193 val_193
+104 val_104
+175 val_175
+105 val_105
+190 val_190
+114 val_114
+164 val_164
+125 val_125
+164 val_164
+187 val_187
+104 val_104
+163 val_163
+119 val_119
+199 val_199
+120 val_120
+169 val_169
+178 val_178
+136 val_136
+172 val_172
+133 val_133
+175 val_175
+189 val_189
+134 val_134
+100 val_100
+146 val_146
+186 val_186
+167 val_167
+183 val_183
+152 val_152
+194 val_194
+126 val_126
+169 val_169
+
+238 NULL 2008-04-08 12
+311 NULL 2008-04-08 12
+409 NULL 2008-04-08 12
+255 NULL 2008-04-08 12
+278 NULL 2008-04-08 12
+484 NULL 2008-04-08 12
+265 NULL 2008-04-08 12
+401 NULL 2008-04-08 12
+273 NULL 2008-04-08 12
+224 NULL 2008-04-08 12
+369 NULL 2008-04-08 12
+213 NULL 2008-04-08 12
+406 NULL 2008-04-08 12
+429 NULL 2008-04-08 12
+374 NULL 2008-04-08 12
+469 NULL 2008-04-08 12
+495 NULL 2008-04-08 12
+327 NULL 2008-04-08 12
+281 NULL 2008-04-08 12
+277 NULL 2008-04-08 12
+209 NULL 2008-04-08 12
+403 NULL 2008-04-08 12
+417 NULL 2008-04-08 12
+430 NULL 2008-04-08 12
+252 NULL 2008-04-08 12
+292 NULL 2008-04-08 12
+219 NULL 2008-04-08 12
+287 NULL 2008-04-08 12
+338 NULL 2008-04-08 12
+446 NULL 2008-04-08 12
+459 NULL 2008-04-08 12
+394 NULL 2008-04-08 12
+237 NULL 2008-04-08 12
+482 NULL 2008-04-08 12
+413 NULL 2008-04-08 12
+494 NULL 2008-04-08 12
+207 NULL 2008-04-08 12
+466 NULL 2008-04-08 12
+208 NULL 2008-04-08 12
+399 NULL 2008-04-08 12
+396 NULL 2008-04-08 12
+247 NULL 2008-04-08 12
+417 NULL 2008-04-08 12
+489 NULL 2008-04-08 12
+377 NULL 2008-04-08 12
+397 NULL 2008-04-08 12
+309 NULL 2008-04-08 12
+365 NULL 2008-04-08 12
+266 NULL 2008-04-08 12
+439 NULL 2008-04-08 12
+342 NULL 2008-04-08 12
+367 NULL 2008-04-08 12
+325 NULL 2008-04-08 12
+475 NULL 2008-04-08 12
+203 NULL 2008-04-08 12
+339 NULL 2008-04-08 12
+455 NULL 2008-04-08 12
+311 NULL 2008-04-08 12
+316 NULL 2008-04-08 12
+302 NULL 2008-04-08 12
+205 NULL 2008-04-08 12
+438 NULL 2008-04-08 12
+345 NULL 2008-04-08 12
+489 NULL 2008-04-08 12
+378 NULL 2008-04-08 12
+221 NULL 2008-04-08 12
+280 NULL 2008-04-08 12
+427 NULL 2008-04-08 12
+277 NULL 2008-04-08 12
+208 NULL 2008-04-08 12
+356 NULL 2008-04-08 12
+399 NULL 2008-04-08 12
+382 NULL 2008-04-08 12
+498 NULL 2008-04-08 12
+386 NULL 2008-04-08 12
+437 NULL 2008-04-08 12
+469 NULL 2008-04-08 12
+286 NULL 2008-04-08 12
+459 NULL 2008-04-08 12
+239 NULL 2008-04-08 12
+213 NULL 2008-04-08 12
+216 NULL 2008-04-08 12
+430 NULL 2008-04-08 12
+278 NULL 2008-04-08 12
+289 NULL 2008-04-08 12
+221 NULL 2008-04-08 12
+318 NULL 2008-04-08 12
+332 NULL 2008-04-08 12
+311 NULL 2008-04-08 12
+275 NULL 2008-04-08 12
+241 NULL 2008-04-08 12
+333 NULL 2008-04-08 12
+284 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+260 NULL 2008-04-08 12
+404 NULL 2008-04-08 12
+384 NULL 2008-04-08 12
+489 NULL 2008-04-08 12
+353 NULL 2008-04-08 12
+373 NULL 2008-04-08 12
+272 NULL 2008-04-08 12
+217 NULL 2008-04-08 12
+348 NULL 2008-04-08 12
+466 NULL 2008-04-08 12
+411 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+208 NULL 2008-04-08 12
+348 NULL 2008-04-08 12
+463 NULL 2008-04-08 12
+431 NULL 2008-04-08 12
+496 NULL 2008-04-08 12
+322 NULL 2008-04-08 12
+468 NULL 2008-04-08 12
+393 NULL 2008-04-08 12
+454 NULL 2008-04-08 12
+298 NULL 2008-04-08 12
+418 NULL 2008-04-08 12
+327 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+205 NULL 2008-04-08 12
+404 NULL 2008-04-08 12
+436 NULL 2008-04-08 12
+469 NULL 2008-04-08 12
+468 NULL 2008-04-08 12
+308 NULL 2008-04-08 12
+288 NULL 2008-04-08 12
+481 NULL 2008-04-08 12
+457 NULL 2008-04-08 12
+282 NULL 2008-04-08 12
+318 NULL 2008-04-08 12
+318 NULL 2008-04-08 12
+409 NULL 2008-04-08 12
+470 NULL 2008-04-08 12
+369 NULL 2008-04-08 12
+316 NULL 2008-04-08 12
+413 NULL 2008-04-08 12
+490 NULL 2008-04-08 12
+364 NULL 2008-04-08 12
+395 NULL 2008-04-08 12
+282 NULL 2008-04-08 12
+238 NULL 2008-04-08 12
+419 NULL 2008-04-08 12
+307 NULL 2008-04-08 12
+435 NULL 2008-04-08 12
+277 NULL 2008-04-08 12
+273 NULL 2008-04-08 12
+306 NULL 2008-04-08 12
+224 NULL 2008-04-08 12
+309 NULL 2008-04-08 12
+389 NULL 2008-04-08 12
+327 NULL 2008-04-08 12
+242 NULL 2008-04-08 12
+369 NULL 2008-04-08 12
+392 NULL 2008-04-08 12
+272 NULL 2008-04-08 12
+331 NULL 2008-04-08 12
+401 NULL 2008-04-08 12
+242 NULL 2008-04-08 12
+452 NULL 2008-04-08 12
+226 NULL 2008-04-08 12
+497 NULL 2008-04-08 12
+402 NULL 2008-04-08 12
+396 NULL 2008-04-08 12
+317 NULL 2008-04-08 12
+395 NULL 2008-04-08 12
+336 NULL 2008-04-08 12
+229 NULL 2008-04-08 12
+233 NULL 2008-04-08 12
+472 NULL 2008-04-08 12
+322 NULL 2008-04-08 12
+498 NULL 2008-04-08 12
+321 NULL 2008-04-08 12
+430 NULL 2008-04-08 12
+489 NULL 2008-04-08 12
+458 NULL 2008-04-08 12
+223 NULL 2008-04-08 12
+492 NULL 2008-04-08 12
+449 NULL 2008-04-08 12
+218 NULL 2008-04-08 12
+228 NULL 2008-04-08 12
+453 NULL 2008-04-08 12
+209 NULL 2008-04-08 12
+468 NULL 2008-04-08 12
+342 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+368 NULL 2008-04-08 12
+296 NULL 2008-04-08 12
+216 NULL 2008-04-08 12
+367 NULL 2008-04-08 12
+344 NULL 2008-04-08 12
+274 NULL 2008-04-08 12
+219 NULL 2008-04-08 12
+239 NULL 2008-04-08 12
+485 NULL 2008-04-08 12
+223 NULL 2008-04-08 12
+256 NULL 2008-04-08 12
+263 NULL 2008-04-08 12
+487 NULL 2008-04-08 12
+480 NULL 2008-04-08 12
+401 NULL 2008-04-08 12
+288 NULL 2008-04-08 12
+244 NULL 2008-04-08 12
+438 NULL 2008-04-08 12
+467 NULL 2008-04-08 12
+432 NULL 2008-04-08 12
+202 NULL 2008-04-08 12
+316 NULL 2008-04-08 12
+229 NULL 2008-04-08 12
+469 NULL 2008-04-08 12
+463 NULL 2008-04-08 12
+280 NULL 2008-04-08 12
+283 NULL 2008-04-08 12
+331 NULL 2008-04-08 12
+235 NULL 2008-04-08 12
+321 NULL 2008-04-08 12
+335 NULL 2008-04-08 12
+466 NULL 2008-04-08 12
+366 NULL 2008-04-08 12
+403 NULL 2008-04-08 12
+483 NULL 2008-04-08 12
+257 NULL 2008-04-08 12
+406 NULL 2008-04-08 12
+409 NULL 2008-04-08 12
+406 NULL 2008-04-08 12
+401 NULL 2008-04-08 12
+258 NULL 2008-04-08 12
+203 NULL 2008-04-08 12
+262 NULL 2008-04-08 12
+348 NULL 2008-04-08 12
+424 NULL 2008-04-08 12
+396 NULL 2008-04-08 12
+201 NULL 2008-04-08 12
+217 NULL 2008-04-08 12
+431 NULL 2008-04-08 12
+454 NULL 2008-04-08 12
+478 NULL 2008-04-08 12
+298 NULL 2008-04-08 12
+431 NULL 2008-04-08 12
+424 NULL 2008-04-08 12
+382 NULL 2008-04-08 12
+397 NULL 2008-04-08 12
+480 NULL 2008-04-08 12
+291 NULL 2008-04-08 12
+351 NULL 2008-04-08 12
+255 NULL 2008-04-08 12
+438 NULL 2008-04-08 12
+414 NULL 2008-04-08 12
+200 NULL 2008-04-08 12
+491 NULL 2008-04-08 12
+237 NULL 2008-04-08 12
+439 NULL 2008-04-08 12
+360 NULL 2008-04-08 12
+248 NULL 2008-04-08 12
+479 NULL 2008-04-08 12
+305 NULL 2008-04-08 12
+417 NULL 2008-04-08 12
+444 NULL 2008-04-08 12
+429 NULL 2008-04-08 12
+443 NULL 2008-04-08 12
+323 NULL 2008-04-08 12
+325 NULL 2008-04-08 12
+277 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+478 NULL 2008-04-08 12
+468 NULL 2008-04-08 12
+310 NULL 2008-04-08 12
+317 NULL 2008-04-08 12
+333 NULL 2008-04-08 12
+493 NULL 2008-04-08 12
+460 NULL 2008-04-08 12
+207 NULL 2008-04-08 12
+249 NULL 2008-04-08 12
+265 NULL 2008-04-08 12
+480 NULL 2008-04-08 12
+353 NULL 2008-04-08 12
+214 NULL 2008-04-08 12
+462 NULL 2008-04-08 12
+233 NULL 2008-04-08 12
+406 NULL 2008-04-08 12
+454 NULL 2008-04-08 12
+375 NULL 2008-04-08 12
+401 NULL 2008-04-08 12
+421 NULL 2008-04-08 12
+407 NULL 2008-04-08 12
+384 NULL 2008-04-08 12
+256 NULL 2008-04-08 12
+384 NULL 2008-04-08 12
+379 NULL 2008-04-08 12
+462 NULL 2008-04-08 12
+492 NULL 2008-04-08 12
+298 NULL 2008-04-08 12
+341 NULL 2008-04-08 12
+498 NULL 2008-04-08 12
+458 NULL 2008-04-08 12
+362 NULL 2008-04-08 12
+285 NULL 2008-04-08 12
+348 NULL 2008-04-08 12
+273 NULL 2008-04-08 12
+281 NULL 2008-04-08 12
+344 NULL 2008-04-08 12
+469 NULL 2008-04-08 12
+315 NULL 2008-04-08 12
+448 NULL 2008-04-08 12
+348 NULL 2008-04-08 12
+307 NULL 2008-04-08 12
+414 NULL 2008-04-08 12
+477 NULL 2008-04-08 12
+222 NULL 2008-04-08 12
+403 NULL 2008-04-08 12
+400 NULL 2008-04-08 12
+200 NULL 2008-04-08 12
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input13.q.out Fri Sep 19 16:56:30 2008
@@ -1,394 +1,398 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (TOK_COLREF src key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (and (>= (TOK_COLREF src key) 100) (< (TOK_COLREF src key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest3 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key))) (TOK_WHERE (and (>= (TOK_COLREF src key) 200) (< (TOK_COLREF src key) 300)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out')) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (>= (TOK_COLREF src key) 300))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src
- Filter Operator
- predicate:
- expr: (key < 100)
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Filter Operator
- predicate:
- expr: ((key >= 100) and (key < 200))
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- name: dest2
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Filter Operator
- predicate:
- expr: ((key >= 200) and (key < 300))
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- File Output Operator
- table:
- name: dest3
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Filter Operator
- predicate:
- expr: (key >= 300)
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- table:
- name: dest2
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
- table:
- name: dest3
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- partition:
- ds 2008-04-08
- hr 12
- replace:
- files:
- destination: ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out
- hdfs directory:
-
-86 val_86
-27 val_27
-98 val_98
-66 val_66
-37 val_37
-15 val_15
-82 val_82
-17 val_17
-0 val_0
-57 val_57
-20 val_20
-92 val_92
-47 val_47
-72 val_72
-4 val_4
-35 val_35
-54 val_54
-51 val_51
-65 val_65
-83 val_83
-12 val_12
-67 val_67
-84 val_84
-58 val_58
-8 val_8
-24 val_24
-42 val_42
-0 val_0
-96 val_96
-26 val_26
-51 val_51
-43 val_43
-95 val_95
-98 val_98
-85 val_85
-77 val_77
-0 val_0
-87 val_87
-15 val_15
-72 val_72
-90 val_90
-19 val_19
-10 val_10
-5 val_5
-58 val_58
-35 val_35
-95 val_95
-11 val_11
-34 val_34
-42 val_42
-78 val_78
-76 val_76
-41 val_41
-30 val_30
-64 val_64
-76 val_76
-74 val_74
-69 val_69
-33 val_33
-70 val_70
-5 val_5
-2 val_2
-35 val_35
-80 val_80
-44 val_44
-53 val_53
-90 val_90
-12 val_12
-5 val_5
-70 val_70
-24 val_24
-70 val_70
-83 val_83
-26 val_26
-67 val_67
-18 val_18
-9 val_9
-18 val_18
-97 val_97
-84 val_84
-28 val_28
-37 val_37
-90 val_90
-97 val_97
-165 val_165
-193 val_193
-150 val_150
-128 val_128
-146 val_146
-152 val_152
-145 val_145
-166 val_166
-153 val_153
-193 val_193
-174 val_174
-199 val_199
-174 val_174
-162 val_162
-167 val_167
-195 val_195
-113 val_113
-155 val_155
-128 val_128
-149 val_149
-129 val_129
-170 val_170
-157 val_157
-111 val_111
-169 val_169
-125 val_125
-192 val_192
-187 val_187
-176 val_176
-138 val_138
-103 val_103
-176 val_176
-137 val_137
-180 val_180
-181 val_181
-138 val_138
-179 val_179
-172 val_172
-129 val_129
-158 val_158
-119 val_119
-197 val_197
-100 val_100
-199 val_199
-191 val_191
-165 val_165
-120 val_120
-131 val_131
-156 val_156
-196 val_196
-197 val_197
-187 val_187
-137 val_137
-169 val_169
-179 val_179
-118 val_118
-134 val_134
-138 val_138
-118 val_118
-177 val_177
-168 val_168
-143 val_143
-160 val_160
-195 val_195
-119 val_119
-149 val_149
-138 val_138
-103 val_103
-113 val_113
-167 val_167
-116 val_116
-191 val_191
-128 val_128
-193 val_193
-104 val_104
-175 val_175
-105 val_105
-190 val_190
-114 val_114
-164 val_164
-125 val_125
-164 val_164
-187 val_187
-104 val_104
-163 val_163
-119 val_119
-199 val_199
-120 val_120
-169 val_169
-178 val_178
-136 val_136
-172 val_172
-133 val_133
-175 val_175
-189 val_189
-134 val_134
-100 val_100
-146 val_146
-186 val_186
-167 val_167
-183 val_183
-152 val_152
-194 val_194
-126 val_126
-169 val_169
-238 NULL 2008-04-08 12
-255 NULL 2008-04-08 12
-278 NULL 2008-04-08 12
-265 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-224 NULL 2008-04-08 12
-213 NULL 2008-04-08 12
-281 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-209 NULL 2008-04-08 12
-252 NULL 2008-04-08 12
-292 NULL 2008-04-08 12
-219 NULL 2008-04-08 12
-287 NULL 2008-04-08 12
-237 NULL 2008-04-08 12
-207 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-247 NULL 2008-04-08 12
-266 NULL 2008-04-08 12
-203 NULL 2008-04-08 12
-205 NULL 2008-04-08 12
-221 NULL 2008-04-08 12
-280 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-286 NULL 2008-04-08 12
-239 NULL 2008-04-08 12
-213 NULL 2008-04-08 12
-216 NULL 2008-04-08 12
-278 NULL 2008-04-08 12
-289 NULL 2008-04-08 12
-221 NULL 2008-04-08 12
-275 NULL 2008-04-08 12
-241 NULL 2008-04-08 12
-284 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-260 NULL 2008-04-08 12
-272 NULL 2008-04-08 12
-217 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-208 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-205 NULL 2008-04-08 12
-288 NULL 2008-04-08 12
-282 NULL 2008-04-08 12
-282 NULL 2008-04-08 12
-238 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-224 NULL 2008-04-08 12
-242 NULL 2008-04-08 12
-272 NULL 2008-04-08 12
-242 NULL 2008-04-08 12
-226 NULL 2008-04-08 12
-229 NULL 2008-04-08 12
-233 NULL 2008-04-08 12
-223 NULL 2008-04-08 12
-218 NULL 2008-04-08 12
-228 NULL 2008-04-08 12
-209 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-296 NULL 2008-04-08 12
-216 NULL 2008-04-08 12
-274 NULL 2008-04-08 12
-219 NULL 2008-04-08 12
-239 NULL 2008-04-08 12
-223 NULL 2008-04-08 12
-256 NULL 2008-04-08 12
-263 NULL 2008-04-08 12
-288 NULL 2008-04-08 12
-244 NULL 2008-04-08 12
-202 NULL 2008-04-08 12
-229 NULL 2008-04-08 12
-280 NULL 2008-04-08 12
-283 NULL 2008-04-08 12
-235 NULL 2008-04-08 12
-257 NULL 2008-04-08 12
-258 NULL 2008-04-08 12
-203 NULL 2008-04-08 12
-262 NULL 2008-04-08 12
-201 NULL 2008-04-08 12
-217 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-291 NULL 2008-04-08 12
-255 NULL 2008-04-08 12
-200 NULL 2008-04-08 12
-237 NULL 2008-04-08 12
-248 NULL 2008-04-08 12
-277 NULL 2008-04-08 12
-230 NULL 2008-04-08 12
-207 NULL 2008-04-08 12
-249 NULL 2008-04-08 12
-265 NULL 2008-04-08 12
-214 NULL 2008-04-08 12
-233 NULL 2008-04-08 12
-256 NULL 2008-04-08 12
-298 NULL 2008-04-08 12
-285 NULL 2008-04-08 12
-273 NULL 2008-04-08 12
-281 NULL 2008-04-08 12
-222 NULL 2008-04-08 12
-200 NULL 2008-04-08 12
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (TOK_COLREF src key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key)) (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (and (>= (TOK_COLREF src key) 100) (< (TOK_COLREF src key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest3 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src key))) (TOK_WHERE (and (>= (TOK_COLREF src key) 200) (< (TOK_COLREF src key) 300)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out')) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src value))) (TOK_WHERE (>= (TOK_COLREF src key) 300))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src
+ Filter Operator
+ predicate:
+ expr: (key < 100)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: ((key >= 100) and (key < 200))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ name: dest2
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: ((key >= 200) and (key < 300))
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ File Output Operator
+ table:
+ name: dest3
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: (key >= 300)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ table:
+ name: dest2
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+ table:
+ name: dest3
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ partition:
+ ds 2008-04-08
+ hr 12
+ replace:
+ files:
+ destination: ../../../../build/contrib/hive/ql/test/data/warehouse/dest4.out
+ hdfs directory:
+
+
+86 val_86
+27 val_27
+98 val_98
+66 val_66
+37 val_37
+15 val_15
+82 val_82
+17 val_17
+0 val_0
+57 val_57
+20 val_20
+92 val_92
+47 val_47
+72 val_72
+4 val_4
+35 val_35
+54 val_54
+51 val_51
+65 val_65
+83 val_83
+12 val_12
+67 val_67
+84 val_84
+58 val_58
+8 val_8
+24 val_24
+42 val_42
+0 val_0
+96 val_96
+26 val_26
+51 val_51
+43 val_43
+95 val_95
+98 val_98
+85 val_85
+77 val_77
+0 val_0
+87 val_87
+15 val_15
+72 val_72
+90 val_90
+19 val_19
+10 val_10
+5 val_5
+58 val_58
+35 val_35
+95 val_95
+11 val_11
+34 val_34
+42 val_42
+78 val_78
+76 val_76
+41 val_41
+30 val_30
+64 val_64
+76 val_76
+74 val_74
+69 val_69
+33 val_33
+70 val_70
+5 val_5
+2 val_2
+35 val_35
+80 val_80
+44 val_44
+53 val_53
+90 val_90
+12 val_12
+5 val_5
+70 val_70
+24 val_24
+70 val_70
+83 val_83
+26 val_26
+67 val_67
+18 val_18
+9 val_9
+18 val_18
+97 val_97
+84 val_84
+28 val_28
+37 val_37
+90 val_90
+97 val_97
+
+165 val_165
+193 val_193
+150 val_150
+128 val_128
+146 val_146
+152 val_152
+145 val_145
+166 val_166
+153 val_153
+193 val_193
+174 val_174
+199 val_199
+174 val_174
+162 val_162
+167 val_167
+195 val_195
+113 val_113
+155 val_155
+128 val_128
+149 val_149
+129 val_129
+170 val_170
+157 val_157
+111 val_111
+169 val_169
+125 val_125
+192 val_192
+187 val_187
+176 val_176
+138 val_138
+103 val_103
+176 val_176
+137 val_137
+180 val_180
+181 val_181
+138 val_138
+179 val_179
+172 val_172
+129 val_129
+158 val_158
+119 val_119
+197 val_197
+100 val_100
+199 val_199
+191 val_191
+165 val_165
+120 val_120
+131 val_131
+156 val_156
+196 val_196
+197 val_197
+187 val_187
+137 val_137
+169 val_169
+179 val_179
+118 val_118
+134 val_134
+138 val_138
+118 val_118
+177 val_177
+168 val_168
+143 val_143
+160 val_160
+195 val_195
+119 val_119
+149 val_149
+138 val_138
+103 val_103
+113 val_113
+167 val_167
+116 val_116
+191 val_191
+128 val_128
+193 val_193
+104 val_104
+175 val_175
+105 val_105
+190 val_190
+114 val_114
+164 val_164
+125 val_125
+164 val_164
+187 val_187
+104 val_104
+163 val_163
+119 val_119
+199 val_199
+120 val_120
+169 val_169
+178 val_178
+136 val_136
+172 val_172
+133 val_133
+175 val_175
+189 val_189
+134 val_134
+100 val_100
+146 val_146
+186 val_186
+167 val_167
+183 val_183
+152 val_152
+194 val_194
+126 val_126
+169 val_169
+
+238 NULL 2008-04-08 12
+255 NULL 2008-04-08 12
+278 NULL 2008-04-08 12
+265 NULL 2008-04-08 12
+273 NULL 2008-04-08 12
+224 NULL 2008-04-08 12
+213 NULL 2008-04-08 12
+281 NULL 2008-04-08 12
+277 NULL 2008-04-08 12
+209 NULL 2008-04-08 12
+252 NULL 2008-04-08 12
+292 NULL 2008-04-08 12
+219 NULL 2008-04-08 12
+287 NULL 2008-04-08 12
+237 NULL 2008-04-08 12
+207 NULL 2008-04-08 12
+208 NULL 2008-04-08 12
+247 NULL 2008-04-08 12
+266 NULL 2008-04-08 12
+203 NULL 2008-04-08 12
+205 NULL 2008-04-08 12
+221 NULL 2008-04-08 12
+280 NULL 2008-04-08 12
+277 NULL 2008-04-08 12
+208 NULL 2008-04-08 12
+286 NULL 2008-04-08 12
+239 NULL 2008-04-08 12
+213 NULL 2008-04-08 12
+216 NULL 2008-04-08 12
+278 NULL 2008-04-08 12
+289 NULL 2008-04-08 12
+221 NULL 2008-04-08 12
+275 NULL 2008-04-08 12
+241 NULL 2008-04-08 12
+284 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+260 NULL 2008-04-08 12
+272 NULL 2008-04-08 12
+217 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+208 NULL 2008-04-08 12
+298 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+205 NULL 2008-04-08 12
+288 NULL 2008-04-08 12
+282 NULL 2008-04-08 12
+282 NULL 2008-04-08 12
+238 NULL 2008-04-08 12
+277 NULL 2008-04-08 12
+273 NULL 2008-04-08 12
+224 NULL 2008-04-08 12
+242 NULL 2008-04-08 12
+272 NULL 2008-04-08 12
+242 NULL 2008-04-08 12
+226 NULL 2008-04-08 12
+229 NULL 2008-04-08 12
+233 NULL 2008-04-08 12
+223 NULL 2008-04-08 12
+218 NULL 2008-04-08 12
+228 NULL 2008-04-08 12
+209 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+296 NULL 2008-04-08 12
+216 NULL 2008-04-08 12
+274 NULL 2008-04-08 12
+219 NULL 2008-04-08 12
+239 NULL 2008-04-08 12
+223 NULL 2008-04-08 12
+256 NULL 2008-04-08 12
+263 NULL 2008-04-08 12
+288 NULL 2008-04-08 12
+244 NULL 2008-04-08 12
+202 NULL 2008-04-08 12
+229 NULL 2008-04-08 12
+280 NULL 2008-04-08 12
+283 NULL 2008-04-08 12
+235 NULL 2008-04-08 12
+257 NULL 2008-04-08 12
+258 NULL 2008-04-08 12
+203 NULL 2008-04-08 12
+262 NULL 2008-04-08 12
+201 NULL 2008-04-08 12
+217 NULL 2008-04-08 12
+298 NULL 2008-04-08 12
+291 NULL 2008-04-08 12
+255 NULL 2008-04-08 12
+200 NULL 2008-04-08 12
+237 NULL 2008-04-08 12
+248 NULL 2008-04-08 12
+277 NULL 2008-04-08 12
+230 NULL 2008-04-08 12
+207 NULL 2008-04-08 12
+249 NULL 2008-04-08 12
+265 NULL 2008-04-08 12
+214 NULL 2008-04-08 12
+233 NULL 2008-04-08 12
+256 NULL 2008-04-08 12
+298 NULL 2008-04-08 12
+285 NULL 2008-04-08 12
+273 NULL 2008-04-08 12
+281 NULL 2008-04-08 12
+222 NULL 2008-04-08 12
+200 NULL 2008-04-08 12
+
val_311
val_409
val_484
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input14.q.out Fri Sep 19 16:56:30 2008
@@ -1,147 +1,149 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src key) (TOK_COLREF src value)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Reduce Operator Tree:
- Extract
- Filter Operator
- predicate:
- expr: (0 < 100)
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: 0
- type: class java.lang.String
- expr: 1
- type: class java.lang.String
- File Output Operator
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Alias -> Map Operator Tree:
- tmap:src
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- Transform Operator
- command: /bin/cat
- output info:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Reduce Output Operator
- tag: -1
- key expressions:
- expr: tkey
- type: class java.lang.String
- value expressions:
- expr: tkey
- type: class java.lang.String
- expr: tvalue
- type: class java.lang.String
- # partition fields: 1
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
-
-0 val_0
-0 val_0
-0 val_0
-10 val_10
-11 val_11
-12 val_12
-12 val_12
-15 val_15
-15 val_15
-17 val_17
-18 val_18
-18 val_18
-19 val_19
-2 val_2
-20 val_20
-24 val_24
-24 val_24
-26 val_26
-26 val_26
-27 val_27
-28 val_28
-30 val_30
-33 val_33
-34 val_34
-35 val_35
-35 val_35
-35 val_35
-37 val_37
-37 val_37
-4 val_4
-41 val_41
-42 val_42
-42 val_42
-43 val_43
-44 val_44
-47 val_47
-5 val_5
-5 val_5
-5 val_5
-51 val_51
-51 val_51
-53 val_53
-54 val_54
-57 val_57
-58 val_58
-58 val_58
-64 val_64
-65 val_65
-66 val_66
-67 val_67
-67 val_67
-69 val_69
-70 val_70
-70 val_70
-70 val_70
-72 val_72
-72 val_72
-74 val_74
-76 val_76
-76 val_76
-77 val_77
-78 val_78
-8 val_8
-80 val_80
-82 val_82
-83 val_83
-83 val_83
-84 val_84
-84 val_84
-85 val_85
-86 val_86
-87 val_87
-9 val_9
-90 val_90
-90 val_90
-90 val_90
-92 val_92
-95 val_95
-95 val_95
-96 val_96
-97 val_97
-97 val_97
-98 val_98
-98 val_98
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src key) (TOK_COLREF src value)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue))) (TOK_WHERE (< (TOK_COLREF tmap tkey) 100))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Reduce Operator Tree:
+ Extract
+ Filter Operator
+ predicate:
+ expr: (0 < 100)
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ tmap:src
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Transform Operator
+ command: /bin/cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Reduce Output Operator
+ tag: -1
+ key expressions:
+ expr: tkey
+ type: string
+ value expressions:
+ expr: tkey
+ type: string
+ expr: tvalue
+ type: string
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+
+
+0 val_0
+0 val_0
+0 val_0
+10 val_10
+11 val_11
+12 val_12
+12 val_12
+15 val_15
+15 val_15
+17 val_17
+18 val_18
+18 val_18
+19 val_19
+2 val_2
+20 val_20
+24 val_24
+24 val_24
+26 val_26
+26 val_26
+27 val_27
+28 val_28
+30 val_30
+33 val_33
+34 val_34
+35 val_35
+35 val_35
+35 val_35
+37 val_37
+37 val_37
+4 val_4
+41 val_41
+42 val_42
+42 val_42
+43 val_43
+44 val_44
+47 val_47
+5 val_5
+5 val_5
+5 val_5
+51 val_51
+51 val_51
+53 val_53
+54 val_54
+57 val_57
+58 val_58
+58 val_58
+64 val_64
+65 val_65
+66 val_66
+67 val_67
+67 val_67
+69 val_69
+70 val_70
+70 val_70
+70 val_70
+72 val_72
+72 val_72
+74 val_74
+76 val_76
+76 val_76
+77 val_77
+78 val_78
+8 val_8
+80 val_80
+82 val_82
+83 val_83
+83 val_83
+84 val_84
+84 val_84
+85 val_85
+86 val_86
+87 val_87
+9 val_9
+90 val_90
+90 val_90
+90 val_90
+92 val_92
+95 val_95
+95 val_95
+96 val_96
+97 val_97
+97 val_97
+98 val_98
+98 val_98
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input15.q.out Fri Sep 19 16:56:30 2008
@@ -1,18 +1,20 @@
-ABSTRACT SYNTAX TREE:
- (TOK_CREATETABLE TEST15 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEROWFORMAT (TOK_TABLEROWFORMATFIELD '\t')))
-
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
- Create Table Operator:
- Create Table
- isExternal:
- name: TEST15
- field delimiter:
- isCompressed:
- # buckets: -1
- columns: key int, value string
-
-Table TEST15 does not exist
+ABSTRACT SYNTAX TREE:
+ (TOK_CREATETABLE TEST15 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEROWFORMAT (TOK_TABLEROWFORMATFIELD '\t')))
+
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Create Table Operator:
+ Create Table
+ isExternal:
+ name: TEST15
+ # buckets: -1
+ field delimiter:
+ isSequenceFile:
+ columns: key int, value string
+
+
+key int
+value string
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input2.q.out Fri Sep 19 16:56:30 2008
@@ -1,18 +1,19 @@
-a int
-b float
-a array<int>
-b float
-c map<float,int>
-src src1 src_sequencefile src_thrift srcbucket srcpart test2a test2b
-src src1 src_sequencefile src_thrift srcbucket srcpart test2b
-ABSTRACT SYNTAX TREE:
- TOK_SHOWTABLES
-
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
-
- Show Tables
-
+a int
+b float
+a array<int>
+b float
+c map<float,int>
+src src1 src_sequencefile src_thrift srcbucket srcpart test2a test2b
+src src1 src_sequencefile src_thrift srcbucket srcpart test2b
+ABSTRACT SYNTAX TREE:
+ TOK_SHOWTABLES
+
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Show Table Operator:
+ Show Tables
+
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input3.q.out Fri Sep 19 16:56:30 2008
@@ -1,43 +1,45 @@
-a int
-b float
-a array<int>
-b float
-c map<float,int>
-src src1 src_sequencefile src_thrift srcbucket srcpart test3a test3b
-ABSTRACT SYNTAX TREE:
- (TOK_ALTERTABLE_ADDCOLS TEST3b (TOK_TABCOLLIST (TOK_TABCOL X TOK_FLOAT)))
-
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
-
- Alter Table
- old name: TEST3b
- type: add columns
- new columns: a array<int>, b float, c map<float,int>, X float
-
-a array<int>
-b float
-c map<float,int>
-x float
-ABSTRACT SYNTAX TREE:
- (TOK_ALTERTABLE_RENAME TEST3b TEST3c)
-
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
-
-STAGE PLANS:
- Stage: Stage-0
-
- Alter Table
- old name: TEST3b
- new name: TEST3c
- type: rename
-
-a array<int>
-b float
-c map<float,int>
-x float
-src src1 src_sequencefile src_thrift srcbucket srcpart test3a test3c
+a int
+b float
+a array<int>
+b float
+c map<float,int>
+src src1 src_sequencefile src_thrift srcbucket srcpart test3a test3b
+ABSTRACT SYNTAX TREE:
+ (TOK_ALTERTABLE_ADDCOLS TEST3b (TOK_TABCOLLIST (TOK_TABCOL X TOK_FLOAT)))
+
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Alter Table Operator:
+ Alter Table
+ old name: TEST3b
+ type: add columns
+ new columns: a array<int>, b float, c map<float,int>, X float
+
+
+a array<int>
+b float
+c map<float,int>
+x float
+ABSTRACT SYNTAX TREE:
+ (TOK_ALTERTABLE_RENAME TEST3b TEST3c)
+
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-0
+ Alter Table Operator:
+ Alter Table
+ old name: TEST3b
+ new name: TEST3c
+ type: rename
+
+
+a array<int>
+b float
+c map<float,int>
+x float
+src src1 src_sequencefile src_thrift srcbucket srcpart test3a test3c
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input4.q.out Fri Sep 19 16:56:30 2008
@@ -1,523 +1,525 @@
-ABSTRACT SYNTAX TREE:
- (TOK_LOAD '../data/files/kv1.txt' (TOK_TAB INPUT4) LOCAL)
-
-STAGE DEPENDENCIES:
- Stage-0 is a root stage
- Stage-1 depends on stages: Stage-0
-
-STAGE PLANS:
- Stage: Stage-0
- Copy
- source: file:/home/athusoo/projects/hadoop/trunk/VENDOR/hadoop-0.17/src/contrib/hive/data/files/kv1.txt
- destination: file:/tmp/hive-athusoo/-494206631
-
- Stage: Stage-1
- Move Operator
- tables:
- table:
- name: input4
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
-
-val_238 238
-val_86 86
-val_311 311
-val_27 27
-val_165 165
-val_409 409
-val_255 255
-val_278 278
-val_98 98
-val_484 484
-val_265 265
-val_193 193
-val_401 401
-val_150 150
-val_273 273
-val_224 224
-val_369 369
-val_66 66
-val_128 128
-val_213 213
-val_146 146
-val_406 406
-val_429 429
-val_374 374
-val_152 152
-val_469 469
-val_145 145
-val_495 495
-val_37 37
-val_327 327
-val_281 281
-val_277 277
-val_209 209
-val_15 15
-val_82 82
-val_403 403
-val_166 166
-val_417 417
-val_430 430
-val_252 252
-val_292 292
-val_219 219
-val_287 287
-val_153 153
-val_193 193
-val_338 338
-val_446 446
-val_459 459
-val_394 394
-val_237 237
-val_482 482
-val_174 174
-val_413 413
-val_494 494
-val_207 207
-val_199 199
-val_466 466
-val_208 208
-val_174 174
-val_399 399
-val_396 396
-val_247 247
-val_417 417
-val_489 489
-val_162 162
-val_377 377
-val_397 397
-val_309 309
-val_365 365
-val_266 266
-val_439 439
-val_342 342
-val_367 367
-val_325 325
-val_167 167
-val_195 195
-val_475 475
-val_17 17
-val_113 113
-val_155 155
-val_203 203
-val_339 339
-val_0 0
-val_455 455
-val_128 128
-val_311 311
-val_316 316
-val_57 57
-val_302 302
-val_205 205
-val_149 149
-val_438 438
-val_345 345
-val_129 129
-val_170 170
-val_20 20
-val_489 489
-val_157 157
-val_378 378
-val_221 221
-val_92 92
-val_111 111
-val_47 47
-val_72 72
-val_4 4
-val_280 280
-val_35 35
-val_427 427
-val_277 277
-val_208 208
-val_356 356
-val_399 399
-val_169 169
-val_382 382
-val_498 498
-val_125 125
-val_386 386
-val_437 437
-val_469 469
-val_192 192
-val_286 286
-val_187 187
-val_176 176
-val_54 54
-val_459 459
-val_51 51
-val_138 138
-val_103 103
-val_239 239
-val_213 213
-val_216 216
-val_430 430
-val_278 278
-val_176 176
-val_289 289
-val_221 221
-val_65 65
-val_318 318
-val_332 332
-val_311 311
-val_275 275
-val_137 137
-val_241 241
-val_83 83
-val_333 333
-val_180 180
-val_284 284
-val_12 12
-val_230 230
-val_181 181
-val_67 67
-val_260 260
-val_404 404
-val_384 384
-val_489 489
-val_353 353
-val_373 373
-val_272 272
-val_138 138
-val_217 217
-val_84 84
-val_348 348
-val_466 466
-val_58 58
-val_8 8
-val_411 411
-val_230 230
-val_208 208
-val_348 348
-val_24 24
-val_463 463
-val_431 431
-val_179 179
-val_172 172
-val_42 42
-val_129 129
-val_158 158
-val_119 119
-val_496 496
-val_0 0
-val_322 322
-val_197 197
-val_468 468
-val_393 393
-val_454 454
-val_100 100
-val_298 298
-val_199 199
-val_191 191
-val_418 418
-val_96 96
-val_26 26
-val_165 165
-val_327 327
-val_230 230
-val_205 205
-val_120 120
-val_131 131
-val_51 51
-val_404 404
-val_43 43
-val_436 436
-val_156 156
-val_469 469
-val_468 468
-val_308 308
-val_95 95
-val_196 196
-val_288 288
-val_481 481
-val_457 457
-val_98 98
-val_282 282
-val_197 197
-val_187 187
-val_318 318
-val_318 318
-val_409 409
-val_470 470
-val_137 137
-val_369 369
-val_316 316
-val_169 169
-val_413 413
-val_85 85
-val_77 77
-val_0 0
-val_490 490
-val_87 87
-val_364 364
-val_179 179
-val_118 118
-val_134 134
-val_395 395
-val_282 282
-val_138 138
-val_238 238
-val_419 419
-val_15 15
-val_118 118
-val_72 72
-val_90 90
-val_307 307
-val_19 19
-val_435 435
-val_10 10
-val_277 277
-val_273 273
-val_306 306
-val_224 224
-val_309 309
-val_389 389
-val_327 327
-val_242 242
-val_369 369
-val_392 392
-val_272 272
-val_331 331
-val_401 401
-val_242 242
-val_452 452
-val_177 177
-val_226 226
-val_5 5
-val_497 497
-val_402 402
-val_396 396
-val_317 317
-val_395 395
-val_58 58
-val_35 35
-val_336 336
-val_95 95
-val_11 11
-val_168 168
-val_34 34
-val_229 229
-val_233 233
-val_143 143
-val_472 472
-val_322 322
-val_498 498
-val_160 160
-val_195 195
-val_42 42
-val_321 321
-val_430 430
-val_119 119
-val_489 489
-val_458 458
-val_78 78
-val_76 76
-val_41 41
-val_223 223
-val_492 492
-val_149 149
-val_449 449
-val_218 218
-val_228 228
-val_138 138
-val_453 453
-val_30 30
-val_209 209
-val_64 64
-val_468 468
-val_76 76
-val_74 74
-val_342 342
-val_69 69
-val_230 230
-val_33 33
-val_368 368
-val_103 103
-val_296 296
-val_113 113
-val_216 216
-val_367 367
-val_344 344
-val_167 167
-val_274 274
-val_219 219
-val_239 239
-val_485 485
-val_116 116
-val_223 223
-val_256 256
-val_263 263
-val_70 70
-val_487 487
-val_480 480
-val_401 401
-val_288 288
-val_191 191
-val_5 5
-val_244 244
-val_438 438
-val_128 128
-val_467 467
-val_432 432
-val_202 202
-val_316 316
-val_229 229
-val_469 469
-val_463 463
-val_280 280
-val_2 2
-val_35 35
-val_283 283
-val_331 331
-val_235 235
-val_80 80
-val_44 44
-val_193 193
-val_321 321
-val_335 335
-val_104 104
-val_466 466
-val_366 366
-val_175 175
-val_403 403
-val_483 483
-val_53 53
-val_105 105
-val_257 257
-val_406 406
-val_409 409
-val_190 190
-val_406 406
-val_401 401
-val_114 114
-val_258 258
-val_90 90
-val_203 203
-val_262 262
-val_348 348
-val_424 424
-val_12 12
-val_396 396
-val_201 201
-val_217 217
-val_164 164
-val_431 431
-val_454 454
-val_478 478
-val_298 298
-val_125 125
-val_431 431
-val_164 164
-val_424 424
-val_187 187
-val_382 382
-val_5 5
-val_70 70
-val_397 397
-val_480 480
-val_291 291
-val_24 24
-val_351 351
-val_255 255
-val_104 104
-val_70 70
-val_163 163
-val_438 438
-val_119 119
-val_414 414
-val_200 200
-val_491 491
-val_237 237
-val_439 439
-val_360 360
-val_248 248
-val_479 479
-val_305 305
-val_417 417
-val_199 199
-val_444 444
-val_120 120
-val_429 429
-val_169 169
-val_443 443
-val_323 323
-val_325 325
-val_277 277
-val_230 230
-val_478 478
-val_178 178
-val_468 468
-val_310 310
-val_317 317
-val_333 333
-val_493 493
-val_460 460
-val_207 207
-val_249 249
-val_265 265
-val_480 480
-val_83 83
-val_136 136
-val_353 353
-val_172 172
-val_214 214
-val_462 462
-val_233 233
-val_406 406
-val_133 133
-val_175 175
-val_189 189
-val_454 454
-val_375 375
-val_401 401
-val_421 421
-val_407 407
-val_384 384
-val_256 256
-val_26 26
-val_134 134
-val_67 67
-val_384 384
-val_379 379
-val_18 18
-val_462 462
-val_492 492
-val_100 100
-val_298 298
-val_9 9
-val_341 341
-val_498 498
-val_146 146
-val_458 458
-val_362 362
-val_186 186
-val_285 285
-val_348 348
-val_167 167
-val_18 18
-val_273 273
-val_183 183
-val_281 281
-val_344 344
-val_97 97
-val_469 469
-val_315 315
-val_84 84
-val_28 28
-val_37 37
-val_448 448
-val_152 152
-val_348 348
-val_307 307
-val_194 194
-val_414 414
-val_477 477
-val_222 222
-val_126 126
-val_90 90
-val_169 169
-val_403 403
-val_400 400
-val_200 200
-val_97 97
+ABSTRACT SYNTAX TREE:
+ (TOK_LOAD '../data/files/kv1.txt' (TOK_TAB INPUT4) LOCAL)
+
+STAGE DEPENDENCIES:
+ Stage-0 is a root stage
+ Stage-1 depends on stages: Stage-0
+
+STAGE PLANS:
+ Stage: Stage-0
+ Copy
+ source: file:/data/zshao/trunk/VENDOR/hadoop-0.17/src/contrib/hive/data/files/kv1.txt
+ destination: file:/tmp/hive-zshao/-1658380790
+
+ Stage: Stage-1
+ Move Operator
+ tables:
+ table:
+ name: input4
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+
+
+val_238 238
+val_86 86
+val_311 311
+val_27 27
+val_165 165
+val_409 409
+val_255 255
+val_278 278
+val_98 98
+val_484 484
+val_265 265
+val_193 193
+val_401 401
+val_150 150
+val_273 273
+val_224 224
+val_369 369
+val_66 66
+val_128 128
+val_213 213
+val_146 146
+val_406 406
+val_429 429
+val_374 374
+val_152 152
+val_469 469
+val_145 145
+val_495 495
+val_37 37
+val_327 327
+val_281 281
+val_277 277
+val_209 209
+val_15 15
+val_82 82
+val_403 403
+val_166 166
+val_417 417
+val_430 430
+val_252 252
+val_292 292
+val_219 219
+val_287 287
+val_153 153
+val_193 193
+val_338 338
+val_446 446
+val_459 459
+val_394 394
+val_237 237
+val_482 482
+val_174 174
+val_413 413
+val_494 494
+val_207 207
+val_199 199
+val_466 466
+val_208 208
+val_174 174
+val_399 399
+val_396 396
+val_247 247
+val_417 417
+val_489 489
+val_162 162
+val_377 377
+val_397 397
+val_309 309
+val_365 365
+val_266 266
+val_439 439
+val_342 342
+val_367 367
+val_325 325
+val_167 167
+val_195 195
+val_475 475
+val_17 17
+val_113 113
+val_155 155
+val_203 203
+val_339 339
+val_0 0
+val_455 455
+val_128 128
+val_311 311
+val_316 316
+val_57 57
+val_302 302
+val_205 205
+val_149 149
+val_438 438
+val_345 345
+val_129 129
+val_170 170
+val_20 20
+val_489 489
+val_157 157
+val_378 378
+val_221 221
+val_92 92
+val_111 111
+val_47 47
+val_72 72
+val_4 4
+val_280 280
+val_35 35
+val_427 427
+val_277 277
+val_208 208
+val_356 356
+val_399 399
+val_169 169
+val_382 382
+val_498 498
+val_125 125
+val_386 386
+val_437 437
+val_469 469
+val_192 192
+val_286 286
+val_187 187
+val_176 176
+val_54 54
+val_459 459
+val_51 51
+val_138 138
+val_103 103
+val_239 239
+val_213 213
+val_216 216
+val_430 430
+val_278 278
+val_176 176
+val_289 289
+val_221 221
+val_65 65
+val_318 318
+val_332 332
+val_311 311
+val_275 275
+val_137 137
+val_241 241
+val_83 83
+val_333 333
+val_180 180
+val_284 284
+val_12 12
+val_230 230
+val_181 181
+val_67 67
+val_260 260
+val_404 404
+val_384 384
+val_489 489
+val_353 353
+val_373 373
+val_272 272
+val_138 138
+val_217 217
+val_84 84
+val_348 348
+val_466 466
+val_58 58
+val_8 8
+val_411 411
+val_230 230
+val_208 208
+val_348 348
+val_24 24
+val_463 463
+val_431 431
+val_179 179
+val_172 172
+val_42 42
+val_129 129
+val_158 158
+val_119 119
+val_496 496
+val_0 0
+val_322 322
+val_197 197
+val_468 468
+val_393 393
+val_454 454
+val_100 100
+val_298 298
+val_199 199
+val_191 191
+val_418 418
+val_96 96
+val_26 26
+val_165 165
+val_327 327
+val_230 230
+val_205 205
+val_120 120
+val_131 131
+val_51 51
+val_404 404
+val_43 43
+val_436 436
+val_156 156
+val_469 469
+val_468 468
+val_308 308
+val_95 95
+val_196 196
+val_288 288
+val_481 481
+val_457 457
+val_98 98
+val_282 282
+val_197 197
+val_187 187
+val_318 318
+val_318 318
+val_409 409
+val_470 470
+val_137 137
+val_369 369
+val_316 316
+val_169 169
+val_413 413
+val_85 85
+val_77 77
+val_0 0
+val_490 490
+val_87 87
+val_364 364
+val_179 179
+val_118 118
+val_134 134
+val_395 395
+val_282 282
+val_138 138
+val_238 238
+val_419 419
+val_15 15
+val_118 118
+val_72 72
+val_90 90
+val_307 307
+val_19 19
+val_435 435
+val_10 10
+val_277 277
+val_273 273
+val_306 306
+val_224 224
+val_309 309
+val_389 389
+val_327 327
+val_242 242
+val_369 369
+val_392 392
+val_272 272
+val_331 331
+val_401 401
+val_242 242
+val_452 452
+val_177 177
+val_226 226
+val_5 5
+val_497 497
+val_402 402
+val_396 396
+val_317 317
+val_395 395
+val_58 58
+val_35 35
+val_336 336
+val_95 95
+val_11 11
+val_168 168
+val_34 34
+val_229 229
+val_233 233
+val_143 143
+val_472 472
+val_322 322
+val_498 498
+val_160 160
+val_195 195
+val_42 42
+val_321 321
+val_430 430
+val_119 119
+val_489 489
+val_458 458
+val_78 78
+val_76 76
+val_41 41
+val_223 223
+val_492 492
+val_149 149
+val_449 449
+val_218 218
+val_228 228
+val_138 138
+val_453 453
+val_30 30
+val_209 209
+val_64 64
+val_468 468
+val_76 76
+val_74 74
+val_342 342
+val_69 69
+val_230 230
+val_33 33
+val_368 368
+val_103 103
+val_296 296
+val_113 113
+val_216 216
+val_367 367
+val_344 344
+val_167 167
+val_274 274
+val_219 219
+val_239 239
+val_485 485
+val_116 116
+val_223 223
+val_256 256
+val_263 263
+val_70 70
+val_487 487
+val_480 480
+val_401 401
+val_288 288
+val_191 191
+val_5 5
+val_244 244
+val_438 438
+val_128 128
+val_467 467
+val_432 432
+val_202 202
+val_316 316
+val_229 229
+val_469 469
+val_463 463
+val_280 280
+val_2 2
+val_35 35
+val_283 283
+val_331 331
+val_235 235
+val_80 80
+val_44 44
+val_193 193
+val_321 321
+val_335 335
+val_104 104
+val_466 466
+val_366 366
+val_175 175
+val_403 403
+val_483 483
+val_53 53
+val_105 105
+val_257 257
+val_406 406
+val_409 409
+val_190 190
+val_406 406
+val_401 401
+val_114 114
+val_258 258
+val_90 90
+val_203 203
+val_262 262
+val_348 348
+val_424 424
+val_12 12
+val_396 396
+val_201 201
+val_217 217
+val_164 164
+val_431 431
+val_454 454
+val_478 478
+val_298 298
+val_125 125
+val_431 431
+val_164 164
+val_424 424
+val_187 187
+val_382 382
+val_5 5
+val_70 70
+val_397 397
+val_480 480
+val_291 291
+val_24 24
+val_351 351
+val_255 255
+val_104 104
+val_70 70
+val_163 163
+val_438 438
+val_119 119
+val_414 414
+val_200 200
+val_491 491
+val_237 237
+val_439 439
+val_360 360
+val_248 248
+val_479 479
+val_305 305
+val_417 417
+val_199 199
+val_444 444
+val_120 120
+val_429 429
+val_169 169
+val_443 443
+val_323 323
+val_325 325
+val_277 277
+val_230 230
+val_478 478
+val_178 178
+val_468 468
+val_310 310
+val_317 317
+val_333 333
+val_493 493
+val_460 460
+val_207 207
+val_249 249
+val_265 265
+val_480 480
+val_83 83
+val_136 136
+val_353 353
+val_172 172
+val_214 214
+val_462 462
+val_233 233
+val_406 406
+val_133 133
+val_175 175
+val_189 189
+val_454 454
+val_375 375
+val_401 401
+val_421 421
+val_407 407
+val_384 384
+val_256 256
+val_26 26
+val_134 134
+val_67 67
+val_384 384
+val_379 379
+val_18 18
+val_462 462
+val_492 492
+val_100 100
+val_298 298
+val_9 9
+val_341 341
+val_498 498
+val_146 146
+val_458 458
+val_362 362
+val_186 186
+val_285 285
+val_348 348
+val_167 167
+val_18 18
+val_273 273
+val_183 183
+val_281 281
+val_344 344
+val_97 97
+val_469 469
+val_315 315
+val_84 84
+val_28 28
+val_37 37
+val_448 448
+val_152 152
+val_348 348
+val_307 307
+val_194 194
+val_414 414
+val_477 477
+val_222 222
+val_126 126
+val_90 90
+val_169 169
+val_403 403
+val_400 400
+val_200 200
+val_97 97
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input5.q.out Fri Sep 19 16:56:30 2008
@@ -1,69 +1,71 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src_thrift lint) (TOK_COLREF src_thrift lintstring)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue)))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Reduce Operator Tree:
- Extract
- Select Operator
- expressions:
- expr: 0
- type: class java.lang.String
- expr: 1
- type: class java.lang.String
- File Output Operator
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Alias -> Map Operator Tree:
- tmap:src_thrift
- Select Operator
- expressions:
- expr: lint
- type: List<class java.lang.Integer>
- expr: lintstring
- type: List<Struct([class java.lang.Integer, class java.lang.String])>
- Transform Operator
- command: /bin/cat
- output info:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- Reduce Output Operator
- tag: -1
- key expressions:
- expr: tkey
- type: class java.lang.String
- value expressions:
- expr: tkey
- type: class java.lang.String
- expr: tvalue
- type: class java.lang.String
- # partition fields: 1
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
-
-[0,0,0] [{"1":{"i32":0},"2":{"str":"0"}}]
-[1,2,3] [{"1":{"i32":1},"2":{"str":"1"}}]
-[2,4,6] [{"1":{"i32":4},"2":{"str":"8"}}]
-[3,6,9] [{"1":{"i32":9},"2":{"str":"27"}}]
-[4,8,12] [{"1":{"i32":16},"2":{"str":"64"}}]
-[5,10,15] [{"1":{"i32":25},"2":{"str":"125"}}]
-[6,12,18] [{"1":{"i32":36},"2":{"str":"216"}}]
-[7,14,21] [{"1":{"i32":49},"2":{"str":"343"}}]
-[8,16,24] [{"1":{"i32":64},"2":{"str":"512"}}]
-[9,18,27] [{"1":{"i32":81},"2":{"str":"729"}}]
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_COLLIST (TOK_COLREF src_thrift lint) (TOK_COLREF src_thrift lintstring)) (TOK_ALIASLIST tkey tvalue) '/bin/cat'))) (TOK_CLUSTERBY tkey))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF tmap tkey)) (TOK_SELEXPR (TOK_COLREF tmap tvalue)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Reduce Operator Tree:
+ Extract
+ Select Operator
+ expressions:
+ expr: 0
+ type: string
+ expr: 1
+ type: string
+ File Output Operator
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Alias -> Map Operator Tree:
+ tmap:src_thrift
+ Select Operator
+ expressions:
+ expr: lint
+ type: array<int>
+ expr: lintstring
+ type: array<struct{myint:int,mystring:string}>
+ Transform Operator
+ command: /bin/cat
+ output info:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ Reduce Output Operator
+ tag: -1
+ key expressions:
+ expr: tkey
+ type: string
+ value expressions:
+ expr: tkey
+ type: string
+ expr: tvalue
+ type: string
+ # partition fields: 1
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+
+
+[0,0,0] [{"myint":0,"mystring":"0"}]
+[1,2,3] [{"myint":1,"mystring":"1"}]
+[2,4,6] [{"myint":4,"mystring":"8"}]
+[3,6,9] [{"myint":9,"mystring":"27"}]
+[4,8,12] [{"myint":16,"mystring":"64"}]
+[5,10,15] [{"myint":25,"mystring":"125"}]
+[6,12,18] [{"myint":36,"mystring":"216"}]
+[7,14,21] [{"myint":49,"mystring":"343"}]
+[8,16,24] [{"myint":64,"mystring":"512"}]
+[9,18,27] [{"myint":81,"mystring":"729"}]
+
Modified: hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out?rev=697291&r1=697290&r2=697291&view=diff
==============================================================================
--- hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hadoop/core/trunk/src/contrib/hive/ql/src/test/results/clientpositive/input6.q.out Fri Sep 19 16:56:30 2008
@@ -1,39 +1,40 @@
-ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key)) (TOK_SELEXPR (TOK_COLREF src1 value))) (TOK_WHERE (TOK_FUNCTION TOK_ISNULL (TOK_COLREF src1 key)))))
-
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Map Reduce
- Alias -> Map Operator Tree:
- src1
- Filter Operator
- predicate:
- expr: key is null
- type: class java.lang.Boolean
- Select Operator
- expressions:
- expr: key
- type: class java.lang.String
- expr: value
- type: class java.lang.String
- File Output Operator
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
-
- Stage: Stage-0
- Move Operator
- tables:
- table:
- name: dest1
- serde: org.apache.hadoop.hive.serde.simple_meta.MetadataTypedColumnsetSerDe
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- replace:
-
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_COLREF src1 key)) (TOK_SELEXPR (TOK_COLREF src1 value))) (TOK_WHERE (TOK_FUNCTION TOK_ISNULL (TOK_COLREF src1 key)))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ src1
+ Filter Operator
+ predicate:
+ expr: key is null
+ type: Boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ File Output Operator
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+
+ Stage: Stage-0
+ Move Operator
+ tables:
+ table:
+ name: dest1
+ serde: simple_meta
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
+ replace:
+
+