You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2013/10/16 22:28:20 UTC
svn commit: r1532891 [5/6] - in /hive/branches/tez: ./
ant/src/org/apache/hadoop/hive/ant/ bin/ bin/ext/ common/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hadoop/hive/conf/
common/src/java/org/apache/hive/common/ co...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/filter_numeric.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/filter_numeric.q.out?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/filter_numeric.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/filter_numeric.q.out Wed Oct 16 20:28:16 2013
@@ -638,6 +638,1624 @@ POSTHOOK: Lineage: partint PARTITION(ds=
400 val_400 12
200 val_200 12
97 val_97 12
+PREHOOK: query: explain select key, value, hr from partint where hr between 11 and 12
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select key, value, hr from partint where hr between 11 and 12
+POSTHOOK: type: QUERY
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME partint))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL hr))) (TOK_WHERE (TOK_FUNCTION between KW_FALSE (TOK_TABLE_OR_COL hr) 11 12))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ partint
+ TableScan
+ alias: partint
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: select key, value, hr from partint where hr between 11 and 12
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partint
+PREHOOK: Input: default@partint@ds=2008-04-08/hr=11
+PREHOOK: Input: default@partint@ds=2008-04-08/hr=12
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value, hr from partint where hr between 11 and 12
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partint
+POSTHOOK: Input: default@partint@ds=2008-04-08/hr=11
+POSTHOOK: Input: default@partint@ds=2008-04-08/hr=12
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238 11
+86 val_86 11
+311 val_311 11
+27 val_27 11
+165 val_165 11
+409 val_409 11
+255 val_255 11
+278 val_278 11
+98 val_98 11
+484 val_484 11
+265 val_265 11
+193 val_193 11
+401 val_401 11
+150 val_150 11
+273 val_273 11
+224 val_224 11
+369 val_369 11
+66 val_66 11
+128 val_128 11
+213 val_213 11
+146 val_146 11
+406 val_406 11
+429 val_429 11
+374 val_374 11
+152 val_152 11
+469 val_469 11
+145 val_145 11
+495 val_495 11
+37 val_37 11
+327 val_327 11
+281 val_281 11
+277 val_277 11
+209 val_209 11
+15 val_15 11
+82 val_82 11
+403 val_403 11
+166 val_166 11
+417 val_417 11
+430 val_430 11
+252 val_252 11
+292 val_292 11
+219 val_219 11
+287 val_287 11
+153 val_153 11
+193 val_193 11
+338 val_338 11
+446 val_446 11
+459 val_459 11
+394 val_394 11
+237 val_237 11
+482 val_482 11
+174 val_174 11
+413 val_413 11
+494 val_494 11
+207 val_207 11
+199 val_199 11
+466 val_466 11
+208 val_208 11
+174 val_174 11
+399 val_399 11
+396 val_396 11
+247 val_247 11
+417 val_417 11
+489 val_489 11
+162 val_162 11
+377 val_377 11
+397 val_397 11
+309 val_309 11
+365 val_365 11
+266 val_266 11
+439 val_439 11
+342 val_342 11
+367 val_367 11
+325 val_325 11
+167 val_167 11
+195 val_195 11
+475 val_475 11
+17 val_17 11
+113 val_113 11
+155 val_155 11
+203 val_203 11
+339 val_339 11
+0 val_0 11
+455 val_455 11
+128 val_128 11
+311 val_311 11
+316 val_316 11
+57 val_57 11
+302 val_302 11
+205 val_205 11
+149 val_149 11
+438 val_438 11
+345 val_345 11
+129 val_129 11
+170 val_170 11
+20 val_20 11
+489 val_489 11
+157 val_157 11
+378 val_378 11
+221 val_221 11
+92 val_92 11
+111 val_111 11
+47 val_47 11
+72 val_72 11
+4 val_4 11
+280 val_280 11
+35 val_35 11
+427 val_427 11
+277 val_277 11
+208 val_208 11
+356 val_356 11
+399 val_399 11
+169 val_169 11
+382 val_382 11
+498 val_498 11
+125 val_125 11
+386 val_386 11
+437 val_437 11
+469 val_469 11
+192 val_192 11
+286 val_286 11
+187 val_187 11
+176 val_176 11
+54 val_54 11
+459 val_459 11
+51 val_51 11
+138 val_138 11
+103 val_103 11
+239 val_239 11
+213 val_213 11
+216 val_216 11
+430 val_430 11
+278 val_278 11
+176 val_176 11
+289 val_289 11
+221 val_221 11
+65 val_65 11
+318 val_318 11
+332 val_332 11
+311 val_311 11
+275 val_275 11
+137 val_137 11
+241 val_241 11
+83 val_83 11
+333 val_333 11
+180 val_180 11
+284 val_284 11
+12 val_12 11
+230 val_230 11
+181 val_181 11
+67 val_67 11
+260 val_260 11
+404 val_404 11
+384 val_384 11
+489 val_489 11
+353 val_353 11
+373 val_373 11
+272 val_272 11
+138 val_138 11
+217 val_217 11
+84 val_84 11
+348 val_348 11
+466 val_466 11
+58 val_58 11
+8 val_8 11
+411 val_411 11
+230 val_230 11
+208 val_208 11
+348 val_348 11
+24 val_24 11
+463 val_463 11
+431 val_431 11
+179 val_179 11
+172 val_172 11
+42 val_42 11
+129 val_129 11
+158 val_158 11
+119 val_119 11
+496 val_496 11
+0 val_0 11
+322 val_322 11
+197 val_197 11
+468 val_468 11
+393 val_393 11
+454 val_454 11
+100 val_100 11
+298 val_298 11
+199 val_199 11
+191 val_191 11
+418 val_418 11
+96 val_96 11
+26 val_26 11
+165 val_165 11
+327 val_327 11
+230 val_230 11
+205 val_205 11
+120 val_120 11
+131 val_131 11
+51 val_51 11
+404 val_404 11
+43 val_43 11
+436 val_436 11
+156 val_156 11
+469 val_469 11
+468 val_468 11
+308 val_308 11
+95 val_95 11
+196 val_196 11
+288 val_288 11
+481 val_481 11
+457 val_457 11
+98 val_98 11
+282 val_282 11
+197 val_197 11
+187 val_187 11
+318 val_318 11
+318 val_318 11
+409 val_409 11
+470 val_470 11
+137 val_137 11
+369 val_369 11
+316 val_316 11
+169 val_169 11
+413 val_413 11
+85 val_85 11
+77 val_77 11
+0 val_0 11
+490 val_490 11
+87 val_87 11
+364 val_364 11
+179 val_179 11
+118 val_118 11
+134 val_134 11
+395 val_395 11
+282 val_282 11
+138 val_138 11
+238 val_238 11
+419 val_419 11
+15 val_15 11
+118 val_118 11
+72 val_72 11
+90 val_90 11
+307 val_307 11
+19 val_19 11
+435 val_435 11
+10 val_10 11
+277 val_277 11
+273 val_273 11
+306 val_306 11
+224 val_224 11
+309 val_309 11
+389 val_389 11
+327 val_327 11
+242 val_242 11
+369 val_369 11
+392 val_392 11
+272 val_272 11
+331 val_331 11
+401 val_401 11
+242 val_242 11
+452 val_452 11
+177 val_177 11
+226 val_226 11
+5 val_5 11
+497 val_497 11
+402 val_402 11
+396 val_396 11
+317 val_317 11
+395 val_395 11
+58 val_58 11
+35 val_35 11
+336 val_336 11
+95 val_95 11
+11 val_11 11
+168 val_168 11
+34 val_34 11
+229 val_229 11
+233 val_233 11
+143 val_143 11
+472 val_472 11
+322 val_322 11
+498 val_498 11
+160 val_160 11
+195 val_195 11
+42 val_42 11
+321 val_321 11
+430 val_430 11
+119 val_119 11
+489 val_489 11
+458 val_458 11
+78 val_78 11
+76 val_76 11
+41 val_41 11
+223 val_223 11
+492 val_492 11
+149 val_149 11
+449 val_449 11
+218 val_218 11
+228 val_228 11
+138 val_138 11
+453 val_453 11
+30 val_30 11
+209 val_209 11
+64 val_64 11
+468 val_468 11
+76 val_76 11
+74 val_74 11
+342 val_342 11
+69 val_69 11
+230 val_230 11
+33 val_33 11
+368 val_368 11
+103 val_103 11
+296 val_296 11
+113 val_113 11
+216 val_216 11
+367 val_367 11
+344 val_344 11
+167 val_167 11
+274 val_274 11
+219 val_219 11
+239 val_239 11
+485 val_485 11
+116 val_116 11
+223 val_223 11
+256 val_256 11
+263 val_263 11
+70 val_70 11
+487 val_487 11
+480 val_480 11
+401 val_401 11
+288 val_288 11
+191 val_191 11
+5 val_5 11
+244 val_244 11
+438 val_438 11
+128 val_128 11
+467 val_467 11
+432 val_432 11
+202 val_202 11
+316 val_316 11
+229 val_229 11
+469 val_469 11
+463 val_463 11
+280 val_280 11
+2 val_2 11
+35 val_35 11
+283 val_283 11
+331 val_331 11
+235 val_235 11
+80 val_80 11
+44 val_44 11
+193 val_193 11
+321 val_321 11
+335 val_335 11
+104 val_104 11
+466 val_466 11
+366 val_366 11
+175 val_175 11
+403 val_403 11
+483 val_483 11
+53 val_53 11
+105 val_105 11
+257 val_257 11
+406 val_406 11
+409 val_409 11
+190 val_190 11
+406 val_406 11
+401 val_401 11
+114 val_114 11
+258 val_258 11
+90 val_90 11
+203 val_203 11
+262 val_262 11
+348 val_348 11
+424 val_424 11
+12 val_12 11
+396 val_396 11
+201 val_201 11
+217 val_217 11
+164 val_164 11
+431 val_431 11
+454 val_454 11
+478 val_478 11
+298 val_298 11
+125 val_125 11
+431 val_431 11
+164 val_164 11
+424 val_424 11
+187 val_187 11
+382 val_382 11
+5 val_5 11
+70 val_70 11
+397 val_397 11
+480 val_480 11
+291 val_291 11
+24 val_24 11
+351 val_351 11
+255 val_255 11
+104 val_104 11
+70 val_70 11
+163 val_163 11
+438 val_438 11
+119 val_119 11
+414 val_414 11
+200 val_200 11
+491 val_491 11
+237 val_237 11
+439 val_439 11
+360 val_360 11
+248 val_248 11
+479 val_479 11
+305 val_305 11
+417 val_417 11
+199 val_199 11
+444 val_444 11
+120 val_120 11
+429 val_429 11
+169 val_169 11
+443 val_443 11
+323 val_323 11
+325 val_325 11
+277 val_277 11
+230 val_230 11
+478 val_478 11
+178 val_178 11
+468 val_468 11
+310 val_310 11
+317 val_317 11
+333 val_333 11
+493 val_493 11
+460 val_460 11
+207 val_207 11
+249 val_249 11
+265 val_265 11
+480 val_480 11
+83 val_83 11
+136 val_136 11
+353 val_353 11
+172 val_172 11
+214 val_214 11
+462 val_462 11
+233 val_233 11
+406 val_406 11
+133 val_133 11
+175 val_175 11
+189 val_189 11
+454 val_454 11
+375 val_375 11
+401 val_401 11
+421 val_421 11
+407 val_407 11
+384 val_384 11
+256 val_256 11
+26 val_26 11
+134 val_134 11
+67 val_67 11
+384 val_384 11
+379 val_379 11
+18 val_18 11
+462 val_462 11
+492 val_492 11
+100 val_100 11
+298 val_298 11
+9 val_9 11
+341 val_341 11
+498 val_498 11
+146 val_146 11
+458 val_458 11
+362 val_362 11
+186 val_186 11
+285 val_285 11
+348 val_348 11
+167 val_167 11
+18 val_18 11
+273 val_273 11
+183 val_183 11
+281 val_281 11
+344 val_344 11
+97 val_97 11
+469 val_469 11
+315 val_315 11
+84 val_84 11
+28 val_28 11
+37 val_37 11
+448 val_448 11
+152 val_152 11
+348 val_348 11
+307 val_307 11
+194 val_194 11
+414 val_414 11
+477 val_477 11
+222 val_222 11
+126 val_126 11
+90 val_90 11
+169 val_169 11
+403 val_403 11
+400 val_400 11
+200 val_200 11
+97 val_97 11
+238 val_238 12
+86 val_86 12
+311 val_311 12
+27 val_27 12
+165 val_165 12
+409 val_409 12
+255 val_255 12
+278 val_278 12
+98 val_98 12
+484 val_484 12
+265 val_265 12
+193 val_193 12
+401 val_401 12
+150 val_150 12
+273 val_273 12
+224 val_224 12
+369 val_369 12
+66 val_66 12
+128 val_128 12
+213 val_213 12
+146 val_146 12
+406 val_406 12
+429 val_429 12
+374 val_374 12
+152 val_152 12
+469 val_469 12
+145 val_145 12
+495 val_495 12
+37 val_37 12
+327 val_327 12
+281 val_281 12
+277 val_277 12
+209 val_209 12
+15 val_15 12
+82 val_82 12
+403 val_403 12
+166 val_166 12
+417 val_417 12
+430 val_430 12
+252 val_252 12
+292 val_292 12
+219 val_219 12
+287 val_287 12
+153 val_153 12
+193 val_193 12
+338 val_338 12
+446 val_446 12
+459 val_459 12
+394 val_394 12
+237 val_237 12
+482 val_482 12
+174 val_174 12
+413 val_413 12
+494 val_494 12
+207 val_207 12
+199 val_199 12
+466 val_466 12
+208 val_208 12
+174 val_174 12
+399 val_399 12
+396 val_396 12
+247 val_247 12
+417 val_417 12
+489 val_489 12
+162 val_162 12
+377 val_377 12
+397 val_397 12
+309 val_309 12
+365 val_365 12
+266 val_266 12
+439 val_439 12
+342 val_342 12
+367 val_367 12
+325 val_325 12
+167 val_167 12
+195 val_195 12
+475 val_475 12
+17 val_17 12
+113 val_113 12
+155 val_155 12
+203 val_203 12
+339 val_339 12
+0 val_0 12
+455 val_455 12
+128 val_128 12
+311 val_311 12
+316 val_316 12
+57 val_57 12
+302 val_302 12
+205 val_205 12
+149 val_149 12
+438 val_438 12
+345 val_345 12
+129 val_129 12
+170 val_170 12
+20 val_20 12
+489 val_489 12
+157 val_157 12
+378 val_378 12
+221 val_221 12
+92 val_92 12
+111 val_111 12
+47 val_47 12
+72 val_72 12
+4 val_4 12
+280 val_280 12
+35 val_35 12
+427 val_427 12
+277 val_277 12
+208 val_208 12
+356 val_356 12
+399 val_399 12
+169 val_169 12
+382 val_382 12
+498 val_498 12
+125 val_125 12
+386 val_386 12
+437 val_437 12
+469 val_469 12
+192 val_192 12
+286 val_286 12
+187 val_187 12
+176 val_176 12
+54 val_54 12
+459 val_459 12
+51 val_51 12
+138 val_138 12
+103 val_103 12
+239 val_239 12
+213 val_213 12
+216 val_216 12
+430 val_430 12
+278 val_278 12
+176 val_176 12
+289 val_289 12
+221 val_221 12
+65 val_65 12
+318 val_318 12
+332 val_332 12
+311 val_311 12
+275 val_275 12
+137 val_137 12
+241 val_241 12
+83 val_83 12
+333 val_333 12
+180 val_180 12
+284 val_284 12
+12 val_12 12
+230 val_230 12
+181 val_181 12
+67 val_67 12
+260 val_260 12
+404 val_404 12
+384 val_384 12
+489 val_489 12
+353 val_353 12
+373 val_373 12
+272 val_272 12
+138 val_138 12
+217 val_217 12
+84 val_84 12
+348 val_348 12
+466 val_466 12
+58 val_58 12
+8 val_8 12
+411 val_411 12
+230 val_230 12
+208 val_208 12
+348 val_348 12
+24 val_24 12
+463 val_463 12
+431 val_431 12
+179 val_179 12
+172 val_172 12
+42 val_42 12
+129 val_129 12
+158 val_158 12
+119 val_119 12
+496 val_496 12
+0 val_0 12
+322 val_322 12
+197 val_197 12
+468 val_468 12
+393 val_393 12
+454 val_454 12
+100 val_100 12
+298 val_298 12
+199 val_199 12
+191 val_191 12
+418 val_418 12
+96 val_96 12
+26 val_26 12
+165 val_165 12
+327 val_327 12
+230 val_230 12
+205 val_205 12
+120 val_120 12
+131 val_131 12
+51 val_51 12
+404 val_404 12
+43 val_43 12
+436 val_436 12
+156 val_156 12
+469 val_469 12
+468 val_468 12
+308 val_308 12
+95 val_95 12
+196 val_196 12
+288 val_288 12
+481 val_481 12
+457 val_457 12
+98 val_98 12
+282 val_282 12
+197 val_197 12
+187 val_187 12
+318 val_318 12
+318 val_318 12
+409 val_409 12
+470 val_470 12
+137 val_137 12
+369 val_369 12
+316 val_316 12
+169 val_169 12
+413 val_413 12
+85 val_85 12
+77 val_77 12
+0 val_0 12
+490 val_490 12
+87 val_87 12
+364 val_364 12
+179 val_179 12
+118 val_118 12
+134 val_134 12
+395 val_395 12
+282 val_282 12
+138 val_138 12
+238 val_238 12
+419 val_419 12
+15 val_15 12
+118 val_118 12
+72 val_72 12
+90 val_90 12
+307 val_307 12
+19 val_19 12
+435 val_435 12
+10 val_10 12
+277 val_277 12
+273 val_273 12
+306 val_306 12
+224 val_224 12
+309 val_309 12
+389 val_389 12
+327 val_327 12
+242 val_242 12
+369 val_369 12
+392 val_392 12
+272 val_272 12
+331 val_331 12
+401 val_401 12
+242 val_242 12
+452 val_452 12
+177 val_177 12
+226 val_226 12
+5 val_5 12
+497 val_497 12
+402 val_402 12
+396 val_396 12
+317 val_317 12
+395 val_395 12
+58 val_58 12
+35 val_35 12
+336 val_336 12
+95 val_95 12
+11 val_11 12
+168 val_168 12
+34 val_34 12
+229 val_229 12
+233 val_233 12
+143 val_143 12
+472 val_472 12
+322 val_322 12
+498 val_498 12
+160 val_160 12
+195 val_195 12
+42 val_42 12
+321 val_321 12
+430 val_430 12
+119 val_119 12
+489 val_489 12
+458 val_458 12
+78 val_78 12
+76 val_76 12
+41 val_41 12
+223 val_223 12
+492 val_492 12
+149 val_149 12
+449 val_449 12
+218 val_218 12
+228 val_228 12
+138 val_138 12
+453 val_453 12
+30 val_30 12
+209 val_209 12
+64 val_64 12
+468 val_468 12
+76 val_76 12
+74 val_74 12
+342 val_342 12
+69 val_69 12
+230 val_230 12
+33 val_33 12
+368 val_368 12
+103 val_103 12
+296 val_296 12
+113 val_113 12
+216 val_216 12
+367 val_367 12
+344 val_344 12
+167 val_167 12
+274 val_274 12
+219 val_219 12
+239 val_239 12
+485 val_485 12
+116 val_116 12
+223 val_223 12
+256 val_256 12
+263 val_263 12
+70 val_70 12
+487 val_487 12
+480 val_480 12
+401 val_401 12
+288 val_288 12
+191 val_191 12
+5 val_5 12
+244 val_244 12
+438 val_438 12
+128 val_128 12
+467 val_467 12
+432 val_432 12
+202 val_202 12
+316 val_316 12
+229 val_229 12
+469 val_469 12
+463 val_463 12
+280 val_280 12
+2 val_2 12
+35 val_35 12
+283 val_283 12
+331 val_331 12
+235 val_235 12
+80 val_80 12
+44 val_44 12
+193 val_193 12
+321 val_321 12
+335 val_335 12
+104 val_104 12
+466 val_466 12
+366 val_366 12
+175 val_175 12
+403 val_403 12
+483 val_483 12
+53 val_53 12
+105 val_105 12
+257 val_257 12
+406 val_406 12
+409 val_409 12
+190 val_190 12
+406 val_406 12
+401 val_401 12
+114 val_114 12
+258 val_258 12
+90 val_90 12
+203 val_203 12
+262 val_262 12
+348 val_348 12
+424 val_424 12
+12 val_12 12
+396 val_396 12
+201 val_201 12
+217 val_217 12
+164 val_164 12
+431 val_431 12
+454 val_454 12
+478 val_478 12
+298 val_298 12
+125 val_125 12
+431 val_431 12
+164 val_164 12
+424 val_424 12
+187 val_187 12
+382 val_382 12
+5 val_5 12
+70 val_70 12
+397 val_397 12
+480 val_480 12
+291 val_291 12
+24 val_24 12
+351 val_351 12
+255 val_255 12
+104 val_104 12
+70 val_70 12
+163 val_163 12
+438 val_438 12
+119 val_119 12
+414 val_414 12
+200 val_200 12
+491 val_491 12
+237 val_237 12
+439 val_439 12
+360 val_360 12
+248 val_248 12
+479 val_479 12
+305 val_305 12
+417 val_417 12
+199 val_199 12
+444 val_444 12
+120 val_120 12
+429 val_429 12
+169 val_169 12
+443 val_443 12
+323 val_323 12
+325 val_325 12
+277 val_277 12
+230 val_230 12
+478 val_478 12
+178 val_178 12
+468 val_468 12
+310 val_310 12
+317 val_317 12
+333 val_333 12
+493 val_493 12
+460 val_460 12
+207 val_207 12
+249 val_249 12
+265 val_265 12
+480 val_480 12
+83 val_83 12
+136 val_136 12
+353 val_353 12
+172 val_172 12
+214 val_214 12
+462 val_462 12
+233 val_233 12
+406 val_406 12
+133 val_133 12
+175 val_175 12
+189 val_189 12
+454 val_454 12
+375 val_375 12
+401 val_401 12
+421 val_421 12
+407 val_407 12
+384 val_384 12
+256 val_256 12
+26 val_26 12
+134 val_134 12
+67 val_67 12
+384 val_384 12
+379 val_379 12
+18 val_18 12
+462 val_462 12
+492 val_492 12
+100 val_100 12
+298 val_298 12
+9 val_9 12
+341 val_341 12
+498 val_498 12
+146 val_146 12
+458 val_458 12
+362 val_362 12
+186 val_186 12
+285 val_285 12
+348 val_348 12
+167 val_167 12
+18 val_18 12
+273 val_273 12
+183 val_183 12
+281 val_281 12
+344 val_344 12
+97 val_97 12
+469 val_469 12
+315 val_315 12
+84 val_84 12
+28 val_28 12
+37 val_37 12
+448 val_448 12
+152 val_152 12
+348 val_348 12
+307 val_307 12
+194 val_194 12
+414 val_414 12
+477 val_477 12
+222 val_222 12
+126 val_126 12
+90 val_90 12
+169 val_169 12
+403 val_403 12
+400 val_400 12
+200 val_200 12
+97 val_97 12
+PREHOOK: query: explain select key, value, hr from partint where hr not between 12 and 14
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select key, value, hr from partint where hr not between 12 and 14
+POSTHOOK: type: QUERY
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+ABSTRACT SYNTAX TREE:
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME partint))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL key)) (TOK_SELEXPR (TOK_TABLE_OR_COL value)) (TOK_SELEXPR (TOK_TABLE_OR_COL hr))) (TOK_WHERE (TOK_FUNCTION between KW_TRUE (TOK_TABLE_OR_COL hr) 12 14))))
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 is a root stage
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Alias -> Map Operator Tree:
+ partint
+ TableScan
+ alias: partint
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: hr
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+
+
+PREHOOK: query: select key, value, hr from partint where hr not between 12 and 14
+PREHOOK: type: QUERY
+PREHOOK: Input: default@partint
+PREHOOK: Input: default@partint@ds=2008-04-08/hr=11
+#### A masked pattern was here ####
+POSTHOOK: query: select key, value, hr from partint where hr not between 12 and 14
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@partint
+POSTHOOK: Input: default@partint@ds=2008-04-08/hr=11
+#### A masked pattern was here ####
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=11).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
+POSTHOOK: Lineage: partint PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
+238 val_238 11
+86 val_86 11
+311 val_311 11
+27 val_27 11
+165 val_165 11
+409 val_409 11
+255 val_255 11
+278 val_278 11
+98 val_98 11
+484 val_484 11
+265 val_265 11
+193 val_193 11
+401 val_401 11
+150 val_150 11
+273 val_273 11
+224 val_224 11
+369 val_369 11
+66 val_66 11
+128 val_128 11
+213 val_213 11
+146 val_146 11
+406 val_406 11
+429 val_429 11
+374 val_374 11
+152 val_152 11
+469 val_469 11
+145 val_145 11
+495 val_495 11
+37 val_37 11
+327 val_327 11
+281 val_281 11
+277 val_277 11
+209 val_209 11
+15 val_15 11
+82 val_82 11
+403 val_403 11
+166 val_166 11
+417 val_417 11
+430 val_430 11
+252 val_252 11
+292 val_292 11
+219 val_219 11
+287 val_287 11
+153 val_153 11
+193 val_193 11
+338 val_338 11
+446 val_446 11
+459 val_459 11
+394 val_394 11
+237 val_237 11
+482 val_482 11
+174 val_174 11
+413 val_413 11
+494 val_494 11
+207 val_207 11
+199 val_199 11
+466 val_466 11
+208 val_208 11
+174 val_174 11
+399 val_399 11
+396 val_396 11
+247 val_247 11
+417 val_417 11
+489 val_489 11
+162 val_162 11
+377 val_377 11
+397 val_397 11
+309 val_309 11
+365 val_365 11
+266 val_266 11
+439 val_439 11
+342 val_342 11
+367 val_367 11
+325 val_325 11
+167 val_167 11
+195 val_195 11
+475 val_475 11
+17 val_17 11
+113 val_113 11
+155 val_155 11
+203 val_203 11
+339 val_339 11
+0 val_0 11
+455 val_455 11
+128 val_128 11
+311 val_311 11
+316 val_316 11
+57 val_57 11
+302 val_302 11
+205 val_205 11
+149 val_149 11
+438 val_438 11
+345 val_345 11
+129 val_129 11
+170 val_170 11
+20 val_20 11
+489 val_489 11
+157 val_157 11
+378 val_378 11
+221 val_221 11
+92 val_92 11
+111 val_111 11
+47 val_47 11
+72 val_72 11
+4 val_4 11
+280 val_280 11
+35 val_35 11
+427 val_427 11
+277 val_277 11
+208 val_208 11
+356 val_356 11
+399 val_399 11
+169 val_169 11
+382 val_382 11
+498 val_498 11
+125 val_125 11
+386 val_386 11
+437 val_437 11
+469 val_469 11
+192 val_192 11
+286 val_286 11
+187 val_187 11
+176 val_176 11
+54 val_54 11
+459 val_459 11
+51 val_51 11
+138 val_138 11
+103 val_103 11
+239 val_239 11
+213 val_213 11
+216 val_216 11
+430 val_430 11
+278 val_278 11
+176 val_176 11
+289 val_289 11
+221 val_221 11
+65 val_65 11
+318 val_318 11
+332 val_332 11
+311 val_311 11
+275 val_275 11
+137 val_137 11
+241 val_241 11
+83 val_83 11
+333 val_333 11
+180 val_180 11
+284 val_284 11
+12 val_12 11
+230 val_230 11
+181 val_181 11
+67 val_67 11
+260 val_260 11
+404 val_404 11
+384 val_384 11
+489 val_489 11
+353 val_353 11
+373 val_373 11
+272 val_272 11
+138 val_138 11
+217 val_217 11
+84 val_84 11
+348 val_348 11
+466 val_466 11
+58 val_58 11
+8 val_8 11
+411 val_411 11
+230 val_230 11
+208 val_208 11
+348 val_348 11
+24 val_24 11
+463 val_463 11
+431 val_431 11
+179 val_179 11
+172 val_172 11
+42 val_42 11
+129 val_129 11
+158 val_158 11
+119 val_119 11
+496 val_496 11
+0 val_0 11
+322 val_322 11
+197 val_197 11
+468 val_468 11
+393 val_393 11
+454 val_454 11
+100 val_100 11
+298 val_298 11
+199 val_199 11
+191 val_191 11
+418 val_418 11
+96 val_96 11
+26 val_26 11
+165 val_165 11
+327 val_327 11
+230 val_230 11
+205 val_205 11
+120 val_120 11
+131 val_131 11
+51 val_51 11
+404 val_404 11
+43 val_43 11
+436 val_436 11
+156 val_156 11
+469 val_469 11
+468 val_468 11
+308 val_308 11
+95 val_95 11
+196 val_196 11
+288 val_288 11
+481 val_481 11
+457 val_457 11
+98 val_98 11
+282 val_282 11
+197 val_197 11
+187 val_187 11
+318 val_318 11
+318 val_318 11
+409 val_409 11
+470 val_470 11
+137 val_137 11
+369 val_369 11
+316 val_316 11
+169 val_169 11
+413 val_413 11
+85 val_85 11
+77 val_77 11
+0 val_0 11
+490 val_490 11
+87 val_87 11
+364 val_364 11
+179 val_179 11
+118 val_118 11
+134 val_134 11
+395 val_395 11
+282 val_282 11
+138 val_138 11
+238 val_238 11
+419 val_419 11
+15 val_15 11
+118 val_118 11
+72 val_72 11
+90 val_90 11
+307 val_307 11
+19 val_19 11
+435 val_435 11
+10 val_10 11
+277 val_277 11
+273 val_273 11
+306 val_306 11
+224 val_224 11
+309 val_309 11
+389 val_389 11
+327 val_327 11
+242 val_242 11
+369 val_369 11
+392 val_392 11
+272 val_272 11
+331 val_331 11
+401 val_401 11
+242 val_242 11
+452 val_452 11
+177 val_177 11
+226 val_226 11
+5 val_5 11
+497 val_497 11
+402 val_402 11
+396 val_396 11
+317 val_317 11
+395 val_395 11
+58 val_58 11
+35 val_35 11
+336 val_336 11
+95 val_95 11
+11 val_11 11
+168 val_168 11
+34 val_34 11
+229 val_229 11
+233 val_233 11
+143 val_143 11
+472 val_472 11
+322 val_322 11
+498 val_498 11
+160 val_160 11
+195 val_195 11
+42 val_42 11
+321 val_321 11
+430 val_430 11
+119 val_119 11
+489 val_489 11
+458 val_458 11
+78 val_78 11
+76 val_76 11
+41 val_41 11
+223 val_223 11
+492 val_492 11
+149 val_149 11
+449 val_449 11
+218 val_218 11
+228 val_228 11
+138 val_138 11
+453 val_453 11
+30 val_30 11
+209 val_209 11
+64 val_64 11
+468 val_468 11
+76 val_76 11
+74 val_74 11
+342 val_342 11
+69 val_69 11
+230 val_230 11
+33 val_33 11
+368 val_368 11
+103 val_103 11
+296 val_296 11
+113 val_113 11
+216 val_216 11
+367 val_367 11
+344 val_344 11
+167 val_167 11
+274 val_274 11
+219 val_219 11
+239 val_239 11
+485 val_485 11
+116 val_116 11
+223 val_223 11
+256 val_256 11
+263 val_263 11
+70 val_70 11
+487 val_487 11
+480 val_480 11
+401 val_401 11
+288 val_288 11
+191 val_191 11
+5 val_5 11
+244 val_244 11
+438 val_438 11
+128 val_128 11
+467 val_467 11
+432 val_432 11
+202 val_202 11
+316 val_316 11
+229 val_229 11
+469 val_469 11
+463 val_463 11
+280 val_280 11
+2 val_2 11
+35 val_35 11
+283 val_283 11
+331 val_331 11
+235 val_235 11
+80 val_80 11
+44 val_44 11
+193 val_193 11
+321 val_321 11
+335 val_335 11
+104 val_104 11
+466 val_466 11
+366 val_366 11
+175 val_175 11
+403 val_403 11
+483 val_483 11
+53 val_53 11
+105 val_105 11
+257 val_257 11
+406 val_406 11
+409 val_409 11
+190 val_190 11
+406 val_406 11
+401 val_401 11
+114 val_114 11
+258 val_258 11
+90 val_90 11
+203 val_203 11
+262 val_262 11
+348 val_348 11
+424 val_424 11
+12 val_12 11
+396 val_396 11
+201 val_201 11
+217 val_217 11
+164 val_164 11
+431 val_431 11
+454 val_454 11
+478 val_478 11
+298 val_298 11
+125 val_125 11
+431 val_431 11
+164 val_164 11
+424 val_424 11
+187 val_187 11
+382 val_382 11
+5 val_5 11
+70 val_70 11
+397 val_397 11
+480 val_480 11
+291 val_291 11
+24 val_24 11
+351 val_351 11
+255 val_255 11
+104 val_104 11
+70 val_70 11
+163 val_163 11
+438 val_438 11
+119 val_119 11
+414 val_414 11
+200 val_200 11
+491 val_491 11
+237 val_237 11
+439 val_439 11
+360 val_360 11
+248 val_248 11
+479 val_479 11
+305 val_305 11
+417 val_417 11
+199 val_199 11
+444 val_444 11
+120 val_120 11
+429 val_429 11
+169 val_169 11
+443 val_443 11
+323 val_323 11
+325 val_325 11
+277 val_277 11
+230 val_230 11
+478 val_478 11
+178 val_178 11
+468 val_468 11
+310 val_310 11
+317 val_317 11
+333 val_333 11
+493 val_493 11
+460 val_460 11
+207 val_207 11
+249 val_249 11
+265 val_265 11
+480 val_480 11
+83 val_83 11
+136 val_136 11
+353 val_353 11
+172 val_172 11
+214 val_214 11
+462 val_462 11
+233 val_233 11
+406 val_406 11
+133 val_133 11
+175 val_175 11
+189 val_189 11
+454 val_454 11
+375 val_375 11
+401 val_401 11
+421 val_421 11
+407 val_407 11
+384 val_384 11
+256 val_256 11
+26 val_26 11
+134 val_134 11
+67 val_67 11
+384 val_384 11
+379 val_379 11
+18 val_18 11
+462 val_462 11
+492 val_492 11
+100 val_100 11
+298 val_298 11
+9 val_9 11
+341 val_341 11
+498 val_498 11
+146 val_146 11
+458 val_458 11
+362 val_362 11
+186 val_186 11
+285 val_285 11
+348 val_348 11
+167 val_167 11
+18 val_18 11
+273 val_273 11
+183 val_183 11
+281 val_281 11
+344 val_344 11
+97 val_97 11
+469 val_469 11
+315 val_315 11
+84 val_84 11
+28 val_28 11
+37 val_37 11
+448 val_448 11
+152 val_152 11
+348 val_348 11
+307 val_307 11
+194 val_194 11
+414 val_414 11
+477 val_477 11
+222 val_222 11
+126 val_126 11
+90 val_90 11
+169 val_169 11
+403 val_403 11
+400 val_400 11
+200 val_200 11
+97 val_97 11
PREHOOK: query: explain select key, value, hr from partint where hr < 13
PREHOOK: type: QUERY
POSTHOOK: query: explain select key, value, hr from partint where hr < 13
Modified: hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_alter.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_alter.q.out?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_alter.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_alter.q.out Wed Oct 16 20:28:16 2013
@@ -15,9 +15,9 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE EXTERNAL TABLE tmp_showcrt1(
- key smallint,
- value float)
+CREATE EXTERNAL TABLE `tmp_showcrt1`(
+ `key` smallint,
+ `value` float)
CLUSTERED BY (
key)
SORTED BY (
@@ -49,9 +49,9 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE TABLE tmp_showcrt1(
- key smallint,
- value float)
+CREATE TABLE `tmp_showcrt1`(
+ `key` smallint,
+ `value` float)
COMMENT 'temporary table'
CLUSTERED BY (
key)
@@ -85,9 +85,9 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE EXTERNAL TABLE tmp_showcrt1(
- key smallint,
- value float)
+CREATE EXTERNAL TABLE `tmp_showcrt1`(
+ `key` smallint,
+ `value` float)
COMMENT 'changed comment'
CLUSTERED BY (
key)
@@ -120,9 +120,9 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE EXTERNAL TABLE tmp_showcrt1(
- key smallint,
- value float)
+CREATE EXTERNAL TABLE `tmp_showcrt1`(
+ `key` smallint,
+ `value` float)
COMMENT 'changed comment'
CLUSTERED BY (
key)
@@ -155,9 +155,9 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE EXTERNAL TABLE tmp_showcrt1(
- key smallint,
- value float)
+CREATE EXTERNAL TABLE `tmp_showcrt1`(
+ `key` smallint,
+ `value` float)
COMMENT 'changed comment'
CLUSTERED BY (
key)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_db_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_db_table.q.out?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_db_table.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_db_table.q.out Wed Oct 16 20:28:16 2013
@@ -27,9 +27,9 @@ PREHOOK: Input: tmp_feng@tmp_showcrt
POSTHOOK: query: SHOW CREATE TABLE tmp_feng.tmp_showcrt
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: tmp_feng@tmp_showcrt
-CREATE TABLE tmp_feng.tmp_showcrt(
- key string,
- value int)
+CREATE TABLE `tmp_feng.tmp_showcrt`(
+ `key` string,
+ `value` int)
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
STORED AS INPUTFORMAT
Modified: hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_delimited.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_delimited.q.out?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_delimited.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_delimited.q.out Wed Oct 16 20:28:16 2013
@@ -19,10 +19,10 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE TABLE tmp_showcrt1(
- key int,
- value string,
- newvalue bigint)
+CREATE TABLE `tmp_showcrt1`(
+ `key` int,
+ `value` string,
+ `newvalue` bigint)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
COLLECTION ITEMS TERMINATED BY '|'
Modified: hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_partitioned.q.out?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_partitioned.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_partitioned.q.out Wed Oct 16 20:28:16 2013
@@ -17,12 +17,12 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE EXTERNAL TABLE tmp_showcrt1(
- key string,
- newvalue boolean COMMENT 'a new value')
+CREATE EXTERNAL TABLE `tmp_showcrt1`(
+ `key` string,
+ `newvalue` boolean COMMENT 'a new value')
COMMENT 'temporary table'
PARTITIONED BY (
- value bigint COMMENT 'some value')
+ `value` bigint COMMENT 'some value')
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'
STORED AS INPUTFORMAT
Modified: hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_serde.q.out?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_serde.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_serde.q.out Wed Oct 16 20:28:16 2013
@@ -23,10 +23,10 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE TABLE tmp_showcrt1(
- key int,
- value string,
- newvalue bigint)
+CREATE TABLE `tmp_showcrt1`(
+ `key` int,
+ `value` string,
+ `newvalue` bigint)
COMMENT 'temporary table'
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
@@ -65,9 +65,9 @@ PREHOOK: Input: default@tmp_showcrt1
POSTHOOK: query: SHOW CREATE TABLE tmp_showcrt1
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_showcrt1
-CREATE EXTERNAL TABLE tmp_showcrt1(
- key string,
- value boolean)
+CREATE EXTERNAL TABLE `tmp_showcrt1`(
+ `key` string,
+ `value` boolean)
ROW FORMAT SERDE
'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
STORED BY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_view.q.out?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_view.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/show_create_table_view.q.out Wed Oct 16 20:28:16 2013
@@ -13,7 +13,7 @@ PREHOOK: Input: default@tmp_copy_src
POSTHOOK: query: SHOW CREATE TABLE tmp_copy_src
POSTHOOK: type: SHOW_CREATETABLE
POSTHOOK: Input: default@tmp_copy_src
-CREATE VIEW tmp_copy_src AS SELECT `src`.`key`, `src`.`value` FROM `default`.`src`
+CREATE VIEW `tmp_copy_src` AS SELECT `src`.`key`, `src`.`value` FROM `default`.`src`
PREHOOK: query: DROP VIEW tmp_copy_src
PREHOOK: type: DROPVIEW
PREHOOK: Input: default@tmp_copy_src
Modified: hive/branches/tez/ql/src/test/results/clientpositive/show_functions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/show_functions.q.out?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/show_functions.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/show_functions.q.out Wed Oct 16 20:28:16 2013
@@ -128,6 +128,7 @@ percentile
percentile_approx
pi
pmod
+posexplode
positive
pow
power
@@ -242,6 +243,7 @@ negative
ntile
parse_url_tuple
percentile
+posexplode
positive
regexp_replace
reverse
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vectorization_short_regress.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vectorization_short_regress.q.out?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vectorization_short_regress.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vectorization_short_regress.q.out Wed Oct 16 20:28:16 2013
@@ -363,7 +363,7 @@ POSTHOOK: Input: default@alltypesorc
PREHOOK: query: -- TargetTypeClasses: Long, Bool, Double, String, Timestamp
-- Functions: Max, VarP, StDevP, Avg, Min, StDev, Var
-- ArithmeticOps: Divide, Multiply, Remainder, Subtract
--- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like
+-- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like, RLike
-- GroupBy: NoGroupByProjectAggs
EXPLAIN SELECT MAX(cint),
(MAX(cint) / -3728),
@@ -394,14 +394,14 @@ WHERE (((cbigint <= 197)
OR ((cdouble >= -26.28)
AND (csmallint > cdouble))
OR ((ctinyint > cfloat)
- AND (cstring1 LIKE '%ss%'))
+ AND (cstring1 RLIKE '.*ss.*'))
OR ((cfloat > 79.553)
AND (cstring2 LIKE '10%')))
PREHOOK: type: QUERY
POSTHOOK: query: -- TargetTypeClasses: Long, Bool, Double, String, Timestamp
-- Functions: Max, VarP, StDevP, Avg, Min, StDev, Var
-- ArithmeticOps: Divide, Multiply, Remainder, Subtract
--- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like
+-- FilterOps: LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual, Like, RLike
-- GroupBy: NoGroupByProjectAggs
EXPLAIN SELECT MAX(cint),
(MAX(cint) / -3728),
@@ -432,12 +432,12 @@ WHERE (((cbigint <= 197)
OR ((cdouble >= -26.28)
AND (csmallint > cdouble))
OR ((ctinyint > cfloat)
- AND (cstring1 LIKE '%ss%'))
+ AND (cstring1 RLIKE '.*ss.*'))
OR ((cfloat > 79.553)
AND (cstring2 LIKE '10%')))
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (/ (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmalli
nt)) 10.175)) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)) 10.175))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (% (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)) (- 26.28))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (% (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_WHERE (OR (OR (OR (AND (<= (TOK_TAB
LE_OR_COL cbigint) 197) (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint))) (AND (>= (TOK_TABLE_OR_COL cdouble) (- 26.28)) (> (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL cdouble)))) (AND (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cfloat)) (LIKE (TOK_TABLE_OR_COL cstring1) '%ss%'))) (AND (> (TOK_TABLE_OR_COL cfloat) 79.553) (LIKE (TOK_TABLE_OR_COL cstring2) '10%'))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (/ (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmalli
nt)) 10.175)) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint)) 10.175))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (% (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cdouble)) (- 26.28))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (% (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))) (% (- 563) (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728))))) (TOK_SELEXPR (- (/ (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (- (* (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cint)) (- 3728)))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_WHERE (OR (OR (OR (AND (<= (TOK_TAB
LE_OR_COL cbigint) 197) (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint))) (AND (>= (TOK_TABLE_OR_COL cdouble) (- 26.28)) (> (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL cdouble)))) (AND (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cfloat)) (RLIKE (TOK_TABLE_OR_COL cstring1) '.*ss.*'))) (AND (> (TOK_TABLE_OR_COL cfloat) 79.553) (LIKE (TOK_TABLE_OR_COL cstring2) '10%'))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -452,7 +452,7 @@ STAGE PLANS:
alias: alltypesorc
Filter Operator
predicate:
- expr: (((((cbigint <= 197) and (cint < cbigint)) or ((cdouble >= (- 26.28)) and (csmallint > cdouble))) or ((ctinyint > cfloat) and (cstring1 like '%ss%'))) or ((cfloat > 79.553) and (cstring2 like '10%')))
+ expr: (((((cbigint <= 197) and (cint < cbigint)) or ((cdouble >= (- 26.28)) and (csmallint > cdouble))) or ((ctinyint > cfloat) and (cstring1 rlike '.*ss.*'))) or ((cfloat > 79.553) and (cstring2 like '10%')))
type: boolean
Vectorized execution: true
Select Operator
@@ -612,7 +612,7 @@ WHERE (((cbigint <= 197)
OR ((cdouble >= -26.28)
AND (csmallint > cdouble))
OR ((ctinyint > cfloat)
- AND (cstring1 LIKE '%ss%'))
+ AND (cstring1 RLIKE '.*ss.*'))
OR ((cfloat > 79.553)
AND (cstring2 LIKE '10%')))
PREHOOK: type: QUERY
@@ -647,7 +647,7 @@ WHERE (((cbigint <= 197)
OR ((cdouble >= -26.28)
AND (csmallint > cdouble))
OR ((ctinyint > cfloat)
- AND (cstring1 LIKE '%ss%'))
+ AND (cstring1 RLIKE '.*ss.*'))
OR ((cfloat > 79.553)
AND (cstring2 LIKE '10%')))
POSTHOOK: type: QUERY
@@ -1161,7 +1161,7 @@ POSTHOOK: Input: default@alltypesorc
PREHOOK: query: -- TargetTypeClasses: Timestamp, String, Long, Double, Bool
-- Functions: Max, Avg, Min, Var, StDev, Count, StDevP, Sum
-- ArithmeticOps: Multiply, Subtract, Add, Divide
--- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan
+-- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan, RLike
-- GroupBy: NoGroupByProjectColumns
EXPLAIN SELECT cint,
cdouble,
@@ -1187,7 +1187,7 @@ EXPLAIN SELECT cint,
(-(ctinyint)),
(79.553 / ctinyint)
FROM alltypesorc
-WHERE (((cstring1 LIKE 'a%')
+WHERE (((cstring1 RLIKE 'a.*')
AND (cstring2 LIKE '%ss%'))
OR ((1 != cboolean2)
AND ((csmallint < 79.553)
@@ -1200,7 +1200,7 @@ PREHOOK: type: QUERY
POSTHOOK: query: -- TargetTypeClasses: Timestamp, String, Long, Double, Bool
-- Functions: Max, Avg, Min, Var, StDev, Count, StDevP, Sum
-- ArithmeticOps: Multiply, Subtract, Add, Divide
--- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan
+-- FilterOps: Like, NotEqual, LessThan, GreaterThanOrEqual, GreaterThan, RLike
-- GroupBy: NoGroupByProjectColumns
EXPLAIN SELECT cint,
cdouble,
@@ -1226,7 +1226,7 @@ EXPLAIN SELECT cint,
(-(ctinyint)),
(79.553 / ctinyint)
FROM alltypesorc
-WHERE (((cstring1 LIKE 'a%')
+WHERE (((cstring1 RLIKE 'a.*')
AND (cstring2 LIKE '%ss%'))
OR ((1 != cboolean2)
AND ((csmallint < 79.553)
@@ -1237,7 +1237,7 @@ WHERE (((cstring1 LIKE 'a%')
AND (ctinyint > cbigint)))
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cdouble)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp2)) (TOK_SELEXPR (TOK_TABLE_OR_COL cstring1)) (TOK_SELEXPR (TOK_TABLE_OR_COL cboolean2)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cfloat)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp1)) (TOK_SELEXPR (TOK_TABLE_OR_COL csmallint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cbigint)) (TOK_SELEXPR (* (- 3728) (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (- 863.257) (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (+ (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint))) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_C
OL cint))) (TOK_SELEXPR (- (- (- 863.257) (TOK_TABLE_OR_COL cint)) (- 26.28))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (TOK_TABLE_OR_COL cdouble) (- 89010))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL ctinyint) 988888)) (TOK_SELEXPR (- (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (/ 79.553 (TOK_TABLE_OR_COL ctinyint)))) (TOK_WHERE (OR (OR (OR (AND (LIKE (TOK_TABLE_OR_COL cstring1) 'a%') (LIKE (TOK_TABLE_OR_COL cstring2) '%ss%')) (AND (!= 1 (TOK_TABLE_OR_COL cboolean2)) (AND (< (TOK_TABLE_OR_COL csmallint) 79.553) (!= (- 257) (TOK_TABLE_OR_COL ctinyint))))) (AND (> (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL ctinyint)) (>= (TOK_TABLE_OR_COL cfloat) (TOK_TABLE_OR_COL cint)))) (AND (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint)) (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cbigint)))))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cdouble)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp2)) (TOK_SELEXPR (TOK_TABLE_OR_COL cstring1)) (TOK_SELEXPR (TOK_TABLE_OR_COL cboolean2)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctinyint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cfloat)) (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp1)) (TOK_SELEXPR (TOK_TABLE_OR_COL csmallint)) (TOK_SELEXPR (TOK_TABLE_OR_COL cbigint)) (TOK_SELEXPR (* (- 3728) (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (- 863.257) (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (+ (- (TOK_TABLE_OR_COL csmallint) (- (TOK_TABLE_OR_COL csmallint))) (- (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_C
OL cint))) (TOK_SELEXPR (- (- (- 863.257) (TOK_TABLE_OR_COL cint)) (- 26.28))) (TOK_SELEXPR (- (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (TOK_TABLE_OR_COL cdouble) (- 89010))) (TOK_SELEXPR (/ (TOK_TABLE_OR_COL ctinyint) 988888)) (TOK_SELEXPR (- (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (/ 79.553 (TOK_TABLE_OR_COL ctinyint)))) (TOK_WHERE (OR (OR (OR (AND (RLIKE (TOK_TABLE_OR_COL cstring1) 'a.*') (LIKE (TOK_TABLE_OR_COL cstring2) '%ss%')) (AND (!= 1 (TOK_TABLE_OR_COL cboolean2)) (AND (< (TOK_TABLE_OR_COL csmallint) 79.553) (!= (- 257) (TOK_TABLE_OR_COL ctinyint))))) (AND (> (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL ctinyint)) (>= (TOK_TABLE_OR_COL cfloat) (TOK_TABLE_OR_COL cint)))) (AND (< (TOK_TABLE_OR_COL cint) (TOK_TABLE_OR_COL cbigint)) (> (TOK_TABLE_OR_COL ctinyint) (TOK_TABLE_OR_COL cbigint)))))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -1252,7 +1252,7 @@ STAGE PLANS:
alias: alltypesorc
Filter Operator
predicate:
- expr: (((((cstring1 like 'a%') and (cstring2 like '%ss%')) or ((1 <> cboolean2) and ((csmallint < 79.553) and ((- 257) <> ctinyint)))) or ((cdouble > ctinyint) and (cfloat >= cint))) or ((cint < cbigint) and (ctinyint > cbigint)))
+ expr: (((((cstring1 rlike 'a.*') and (cstring2 like '%ss%')) or ((1 <> cboolean2) and ((csmallint < 79.553) and ((- 257) <> ctinyint)))) or ((cdouble > ctinyint) and (cfloat >= cint))) or ((cint < cbigint) and (ctinyint > cbigint)))
type: boolean
Vectorized execution: true
Select Operator
@@ -1343,7 +1343,7 @@ PREHOOK: query: SELECT cint,
(-(ctinyint)),
(79.553 / ctinyint)
FROM alltypesorc
-WHERE (((cstring1 LIKE 'a%')
+WHERE (((cstring1 RLIKE 'a.*')
AND (cstring2 LIKE '%ss%'))
OR ((1 != cboolean2)
AND ((csmallint < 79.553)
@@ -1379,7 +1379,7 @@ POSTHOOK: query: SELECT cint,
(-(ctinyint)),
(79.553 / ctinyint)
FROM alltypesorc
-WHERE (((cstring1 LIKE 'a%')
+WHERE (((cstring1 RLIKE 'a.*')
AND (cstring2 LIKE '%ss%'))
OR ((1 != cboolean2)
AND ((csmallint < 79.553)
@@ -8252,7 +8252,7 @@ POSTHOOK: Input: default@alltypesorc
PREHOOK: query: -- TargetTypeClasses: Bool, Timestamp, String, Double, Long
-- Functions: StDevP, Avg, Count, Min, Var, VarP, Sum
-- ArithmeticOps: Multiply, Subtract, Add, Divide, Remainder
--- FilterOps: NotEqual, LessThan, Like, Equal
+-- FilterOps: NotEqual, LessThan, Like, Equal, RLike
-- GroupBy: GroupBy
EXPLAIN SELECT ctimestamp1,
cstring1,
@@ -8297,7 +8297,7 @@ FROM alltypesorc
WHERE (((ctimestamp1 != 0))
AND ((((-257 != ctinyint)
AND (cboolean2 IS NOT NULL))
- AND ((cstring1 LIKE '%ss')
+ AND ((cstring1 RLIKE '.*ss')
AND (-10669 < ctimestamp1)))
OR (ctimestamp2 = -10669)
OR ((ctimestamp1 < 0)
@@ -8310,7 +8310,7 @@ PREHOOK: type: QUERY
POSTHOOK: query: -- TargetTypeClasses: Bool, Timestamp, String, Double, Long
-- Functions: StDevP, Avg, Count, Min, Var, VarP, Sum
-- ArithmeticOps: Multiply, Subtract, Add, Divide, Remainder
--- FilterOps: NotEqual, LessThan, Like, Equal
+-- FilterOps: NotEqual, LessThan, Like, Equal, RLike
-- GroupBy: GroupBy
EXPLAIN SELECT ctimestamp1,
cstring1,
@@ -8355,7 +8355,7 @@ FROM alltypesorc
WHERE (((ctimestamp1 != 0))
AND ((((-257 != ctinyint)
AND (cboolean2 IS NOT NULL))
- AND ((cstring1 LIKE '%ss')
+ AND ((cstring1 RLIKE '.*ss')
AND (-10669 < ctimestamp1)))
OR (ctimestamp2 = -10669)
OR ((ctimestamp1 < 0)
@@ -8366,7 +8366,7 @@ WHERE (((ctimestamp1 != 0))
GROUP BY ctimestamp1, cstring1
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp1)) (TOK_SELEXPR (TOK_TABLE_OR_COL cstring1)) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175)) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (- (TOK_FUNCTIONSTAR COUNT))) (TOK_SELEXPR (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (T
OK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_SELEXPR (- (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT))))) (TOK_SELEXPR (- (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))))) (TOK_SELEXPR (/ (- (TOK_FUNCTIONSTAR COUNT)) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (/ 10.175 (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (- (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (T
OK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT))))) (TOK_SELEXPR (- (- (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (- (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) 10.175)) (TOK_SELEXPR (% 10.175 (/ 10.175 (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint))))) (TOK_SELEXPR (- (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_O
R_COL cdouble))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))))) (TOK_SELEXPR (% (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (/ (- 26.28) (- (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint))))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (/ (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (- (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (% (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.2
8) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (- 26.28)))) (TOK_WHERE (AND (!= (TOK_TABLE_OR_COL ctimestamp1) 0) (OR (OR (OR (OR (AND (AND (!= (- 257) (TOK_TABLE_OR_COL ctinyint)) (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cboolean2))) (AND (LIKE (TOK_TABLE_OR_COL cstring1) '%ss') (< (- 10669) (TOK_TABLE_OR_COL ctimestamp1)))) (= (TOK_TABLE_OR_COL ctimestamp2) (- 10669))) (AND (< (TOK_TABLE_OR_COL ctimestamp1) 0) (LIKE (TOK_TABLE_OR_COL cstring2) '%b%'))) (= (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL cint))) (AND (TOK_FUNCTION TOK_ISNULL (TOK_TABLE_OR_COL cboolean1)) (< (TOK_TABLE_OR_COL cfloat) (TOK_TABLE_OR_COL cint)))))) (TOK_GROUPBY (TOK_TABLE_OR_COL ctimestamp1) (TOK_TABLE_OR_COL cstring1))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL ctimestamp1)) (TOK_SELEXPR (TOK_TABLE_OR_COL cstring1)) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175)) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (- (TOK_FUNCTIONSTAR COUNT))) (TOK_SELEXPR (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (T
OK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_SELEXPR (- (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT))))) (TOK_SELEXPR (- (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))))) (TOK_SELEXPR (/ (- (TOK_FUNCTIONSTAR COUNT)) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (/ 10.175 (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (- (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (T
OK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT))))) (TOK_SELEXPR (- (- (* (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)) 10.175)))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (* (- (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) 10.175)) (TOK_SELEXPR (% 10.175 (/ 10.175 (TOK_FUNCTION AVG (TOK_TABLE_OR_COL csmallint))))) (TOK_SELEXPR (- (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_O
R_COL cdouble))) (TOK_SELEXPR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))))) (TOK_SELEXPR (% (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (/ (- 26.28) (- (TOK_FUNCTION MIN (TOK_TABLE_OR_COL ctinyint))))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (/ (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.28) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (- (- (TOK_FUNCTIONSTAR COUNT)))) (TOK_SELEXPR (TOK_FUNCTIONSTAR COUNT)) (TOK_SELEXPR (% (+ (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL csmallint)) (* (* (- (- 26.2
8) (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint))) (- (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL cint)))) (- (TOK_FUNCTIONSTAR COUNT)))) (- 26.28)))) (TOK_WHERE (AND (!= (TOK_TABLE_OR_COL ctimestamp1) 0) (OR (OR (OR (OR (AND (AND (!= (- 257) (TOK_TABLE_OR_COL ctinyint)) (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cboolean2))) (AND (RLIKE (TOK_TABLE_OR_COL cstring1) '.*ss') (< (- 10669) (TOK_TABLE_OR_COL ctimestamp1)))) (= (TOK_TABLE_OR_COL ctimestamp2) (- 10669))) (AND (< (TOK_TABLE_OR_COL ctimestamp1) 0) (LIKE (TOK_TABLE_OR_COL cstring2) '%b%'))) (= (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL cint))) (AND (TOK_FUNCTION TOK_ISNULL (TOK_TABLE_OR_COL cboolean1)) (< (TOK_TABLE_OR_COL cfloat) (TOK_TABLE_OR_COL cint)))))) (TOK_GROUPBY (TOK_TABLE_OR_COL ctimestamp1) (TOK_TABLE_OR_COL cstring1))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -8381,7 +8381,7 @@ STAGE PLANS:
alias: alltypesorc
Filter Operator
predicate:
- expr: ((ctimestamp1 <> 0) and ((((((((- 257) <> ctinyint) and cboolean2 is not null) and ((cstring1 like '%ss') and ((- 10669) < ctimestamp1))) or (ctimestamp2 = (- 10669))) or ((ctimestamp1 < 0) and (cstring2 like '%b%'))) or (cdouble = cint)) or (cboolean1 is null and (cfloat < cint))))
+ expr: ((ctimestamp1 <> 0) and ((((((((- 257) <> ctinyint) and cboolean2 is not null) and ((cstring1 rlike '.*ss') and ((- 10669) < ctimestamp1))) or (ctimestamp2 = (- 10669))) or ((ctimestamp1 < 0) and (cstring2 like '%b%'))) or (cdouble = cint)) or (cboolean1 is null and (cfloat < cint))))
type: boolean
Vectorized execution: true
Select Operator
@@ -8627,7 +8627,7 @@ FROM alltypesorc
WHERE (((ctimestamp1 != 0))
AND ((((-257 != ctinyint)
AND (cboolean2 IS NOT NULL))
- AND ((cstring1 LIKE '%ss')
+ AND ((cstring1 RLIKE '.*ss')
AND (-10669 < ctimestamp1)))
OR (ctimestamp2 = -10669)
OR ((ctimestamp1 < 0)
@@ -8682,7 +8682,7 @@ FROM alltypesorc
WHERE (((ctimestamp1 != 0))
AND ((((-257 != ctinyint)
AND (cboolean2 IS NOT NULL))
- AND ((cstring1 LIKE '%ss')
+ AND ((cstring1 RLIKE '.*ss')
AND (-10669 < ctimestamp1)))
OR (ctimestamp2 = -10669)
OR ((ctimestamp1 < 0)
@@ -8936,7 +8936,7 @@ WARNING: Comparing a bigint and a double
PREHOOK: query: -- TargetTypeClasses: Double, Long, String, Timestamp, Bool
-- Functions: Max, Sum, Var, Avg, Min, VarP, StDev, StDevP
-- ArithmeticOps: Divide, Subtract, Remainder, Add, Multiply
--- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like
+-- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like, RLike
-- GroupBy: GroupBy
EXPLAIN SELECT cboolean1,
MAX(cfloat),
@@ -8972,7 +8972,7 @@ WHERE (((cboolean1 IS NOT NULL))
OR ((cint >= -257)
AND ((cstring1 IS NOT NULL)
AND (cboolean1 >= 1)))
- OR (cstring2 LIKE 'b')
+ OR (cstring2 RLIKE 'b')
OR ((csmallint >= ctinyint)
AND (ctimestamp2 IS NULL))))
GROUP BY cboolean1
@@ -8981,7 +8981,7 @@ PREHOOK: type: QUERY
POSTHOOK: query: -- TargetTypeClasses: Double, Long, String, Timestamp, Bool
-- Functions: Max, Sum, Var, Avg, Min, VarP, StDev, StDevP
-- ArithmeticOps: Divide, Subtract, Remainder, Add, Multiply
--- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like
+-- FilterOps: GreaterThan, LessThanOrEqual, Equal, LessThan, GreaterThanOrEqual, NotEqual, Like, RLike
-- GroupBy: GroupBy
EXPLAIN SELECT cboolean1,
MAX(cfloat),
@@ -9017,14 +9017,14 @@ WHERE (((cboolean1 IS NOT NULL))
OR ((cint >= -257)
AND ((cstring1 IS NOT NULL)
AND (cboolean1 >= 1)))
- OR (cstring2 LIKE 'b')
+ OR (cstring2 RLIKE 'b')
OR ((csmallint >= ctinyint)
AND (ctimestamp2 IS NULL))))
GROUP BY cboolean1
ORDER BY cboolean1
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cboolean1)) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (/ (- 26.28) (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint)) 10.175)) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat))))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (+ (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint)) 10.175) (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint))) (TOK_SELEX
PR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))))) (TOK_SELEXPR (/ 79.553 (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (% (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)) (/ 79.553 (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (- (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint)) (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint)) (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint)))))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR
(- (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (* (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cboolean1)) (OR (OR (OR (AND (< (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL csmallint)) (AND (= (TOK_TABLE_OR_COL cboolean2) (TOK_TABLE_OR_COL cboolean1)) (<= (TOK_TABLE_OR_COL cbigint) (- 863.257)))) (AND (>= (TOK_TABLE_OR_COL cint) (- 257)) (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cstring1)) (>= (TOK_TABLE_OR_COL cboolean1) 1)))) (LIKE (TOK_TABLE_OR_COL cstring2) 'b')) (AND (>= (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL ctinyint)) (TOK_FUNCTION TOK_ISNULL (TOK_TABLE_OR_COL ctimestamp2)))))) (TOK_GROUPBY (TOK_TABLE_OR_COL cboolean1)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL cboolean1)))))
+ (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME alltypesorc))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TABLE_OR_COL cboolean1)) (TOK_SELEXPR (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat))) (TOK_SELEXPR (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (/ (- 26.28) (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint)) 10.175)) (TOK_SELEXPR (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (% (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))) (TOK_SELEXPR (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat))))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cdouble))) (TOK_SELEXPR (+ (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cbigint)) 10.175) (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint))) (TOK_SELEX
PR (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))) (TOK_SELEXPR (- (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))))) (TOK_SELEXPR (/ 79.553 (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (% (TOK_FUNCTION VAR_SAMP (TOK_TABLE_OR_COL cint)) (/ 79.553 (TOK_FUNCTION VAR_POP (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (- (+ 10.175 (- (TOK_FUNCTION MAX (TOK_TABLE_OR_COL cfloat)))))) (TOK_SELEXPR (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_SAMP (TOK_TABLE_OR_COL ctinyint))) (TOK_SELEXPR (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint)))) (TOK_SELEXPR (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint)) (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint))))) (TOK_SELEXPR (TOK_FUNCTION STDDEV_POP (TOK_TABLE_OR_COL csmallint))) (TOK_SELEXPR (- (- (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint)) (* (- 1.389) (TOK_FUNCTION MIN (TOK_TABLE_OR_COL cbigint)))))) (TOK_SELEXPR (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint))) (TOK_SELEXPR
(- (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)))) (TOK_SELEXPR (* (TOK_FUNCTION AVG (TOK_TABLE_OR_COL cint)) (TOK_FUNCTION SUM (TOK_TABLE_OR_COL cint))))) (TOK_WHERE (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cboolean1)) (OR (OR (OR (AND (< (TOK_TABLE_OR_COL cdouble) (TOK_TABLE_OR_COL csmallint)) (AND (= (TOK_TABLE_OR_COL cboolean2) (TOK_TABLE_OR_COL cboolean1)) (<= (TOK_TABLE_OR_COL cbigint) (- 863.257)))) (AND (>= (TOK_TABLE_OR_COL cint) (- 257)) (AND (TOK_FUNCTION TOK_ISNOTNULL (TOK_TABLE_OR_COL cstring1)) (>= (TOK_TABLE_OR_COL cboolean1) 1)))) (RLIKE (TOK_TABLE_OR_COL cstring2) 'b')) (AND (>= (TOK_TABLE_OR_COL csmallint) (TOK_TABLE_OR_COL ctinyint)) (TOK_FUNCTION TOK_ISNULL (TOK_TABLE_OR_COL ctimestamp2)))))) (TOK_GROUPBY (TOK_TABLE_OR_COL cboolean1)) (TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL cboolean1)))))
STAGE DEPENDENCIES:
Stage-1 is a root stage
@@ -9040,7 +9040,7 @@ STAGE PLANS:
alias: alltypesorc
Filter Operator
predicate:
- expr: (cboolean1 is not null and (((((cdouble < csmallint) and ((cboolean2 = cboolean1) and (cbigint <= (- 863.257)))) or ((cint >= (- 257)) and (cstring1 is not null and (cboolean1 >= 1)))) or (cstring2 like 'b')) or ((csmallint >= ctinyint) and ctimestamp2 is null)))
+ expr: (cboolean1 is not null and (((((cdouble < csmallint) and ((cboolean2 = cboolean1) and (cbigint <= (- 863.257)))) or ((cint >= (- 257)) and (cstring1 is not null and (cboolean1 >= 1)))) or (cstring2 rlike 'b')) or ((csmallint >= ctinyint) and ctimestamp2 is null)))
type: boolean
Vectorized execution: true
Select Operator
@@ -9306,7 +9306,7 @@ WHERE (((cboolean1 IS NOT NULL))
OR ((cint >= -257)
AND ((cstring1 IS NOT NULL)
AND (cboolean1 >= 1)))
- OR (cstring2 LIKE 'b')
+ OR (cstring2 RLIKE 'b')
OR ((csmallint >= ctinyint)
AND (ctimestamp2 IS NULL))))
GROUP BY cboolean1
@@ -9348,7 +9348,7 @@ WHERE (((cboolean1 IS NOT NULL))
OR ((cint >= -257)
AND ((cstring1 IS NOT NULL)
AND (cboolean1 >= 1)))
- OR (cstring2 LIKE 'b')
+ OR (cstring2 RLIKE 'b')
OR ((csmallint >= ctinyint)
AND (ctimestamp2 IS NULL))))
GROUP BY cboolean1
Modified: hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/RegexSerDe.java
URL: http://svn.apache.org/viewvc/hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/RegexSerDe.java?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/RegexSerDe.java (original)
+++ hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/RegexSerDe.java Wed Oct 16 20:28:16 2013
@@ -126,7 +126,7 @@ public class RegexSerDe extends Abstract
TypeInfo typeInfo = columnTypes.get(c);
if (typeInfo instanceof PrimitiveTypeInfo) {
PrimitiveTypeInfo pti = (PrimitiveTypeInfo) columnTypes.get(c);
- AbstractPrimitiveJavaObjectInspector oi =
+ AbstractPrimitiveJavaObjectInspector oi =
PrimitiveObjectInspectorFactory.getPrimitiveJavaObjectInspector(pti);
columnOIs.add(oi);
} else {
@@ -232,8 +232,7 @@ public class RegexSerDe extends Abstract
d = Date.valueOf(t);
row.set(c, d);
} else if (typeName.equals(serdeConstants.DECIMAL_TYPE_NAME)) {
- HiveDecimal bd;
- bd = new HiveDecimal(t);
+ HiveDecimal bd = HiveDecimal.create(t);
row.set(c, bd);
} else if (typeInfo instanceof VarcharTypeInfo) {
HiveVarchar hv = new HiveVarchar(t, ((VarcharTypeInfo)typeInfo).getLength());
Modified: hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java
URL: http://svn.apache.org/viewvc/hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java (original)
+++ hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/binarysortable/BinarySortableSerDe.java Wed Oct 16 20:28:16 2013
@@ -405,7 +405,7 @@ public class BinarySortableSerDe extends
String digits = new String(decimalBuffer, 0, length, decimalCharSet);
BigInteger bi = new BigInteger(digits);
- HiveDecimal bd = new HiveDecimal(bi).scaleByPowerOfTen(factor-length);
+ HiveDecimal bd = HiveDecimal.create(bi).scaleByPowerOfTen(factor-length);
if (!positive) {
bd = bd.negate();
Modified: hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/io/HiveDecimalWritable.java
URL: http://svn.apache.org/viewvc/hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/io/HiveDecimalWritable.java?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/io/HiveDecimalWritable.java (original)
+++ hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/io/HiveDecimalWritable.java Wed Oct 16 20:28:16 2013
@@ -81,7 +81,7 @@ public class HiveDecimalWritable impleme
}
public HiveDecimal getHiveDecimal() {
- return new HiveDecimal(new BigInteger(internalStorage), scale);
+ return HiveDecimal.create(new BigInteger(internalStorage), scale);
}
@Override
Modified: hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyHiveDecimal.java
URL: http://svn.apache.org/viewvc/hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyHiveDecimal.java?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyHiveDecimal.java (original)
+++ hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/lazy/LazyHiveDecimal.java Wed Oct 16 20:28:16 2013
@@ -52,15 +52,20 @@ public class LazyHiveDecimal extends Laz
String byteData = null;
try {
byteData = Text.decode(bytes.getData(), start, length);
- data.set(new HiveDecimal(byteData));
- isNull = false;
- } catch (NumberFormatException e) {
- isNull = true;
- LOG.debug("Data not in the HiveDecimal data type range so converted to null. Given data is :"
- + byteData, e);
} catch (CharacterCodingException e) {
isNull = true;
LOG.debug("Data not in the HiveDecimal data type range so converted to null.", e);
+ return;
+ }
+
+ HiveDecimal dec = HiveDecimal.create(byteData);
+ if (dec != null) {
+ data.set(dec);
+ isNull = false;
+ } else {
+ LOG.debug("Data not in the HiveDecimal data type range so converted to null. Given data is :"
+ + byteData);
+ isNull = true;
}
}
Modified: hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/SettableUnionObjectInspector.java
URL: http://svn.apache.org/viewvc/hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/SettableUnionObjectInspector.java?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/SettableUnionObjectInspector.java (original)
+++ hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/SettableUnionObjectInspector.java Wed Oct 16 20:28:16 2013
@@ -1,3 +1,21 @@
+/**
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements. See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership. The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License. You may obtain a copy of the License at
+ *
+ * http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
package org.apache.hadoop.hive.serde2.objectinspector;
Modified: hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/JavaHiveDecimalObjectInspector.java
URL: http://svn.apache.org/viewvc/hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/JavaHiveDecimalObjectInspector.java?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/JavaHiveDecimalObjectInspector.java (original)
+++ hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/JavaHiveDecimalObjectInspector.java Wed Oct 16 20:28:16 2013
@@ -38,12 +38,12 @@ public class JavaHiveDecimalObjectInspec
}
if (o instanceof String) {
- try {
- o = new HiveDecimal((String)o);
- } catch(NumberFormatException e) {
+ o = HiveDecimal.create((String)o);
+ if (o == null) {
return null;
}
}
+
return new HiveDecimalWritable((HiveDecimal) o);
}
@@ -54,7 +54,7 @@ public class JavaHiveDecimalObjectInspec
@Override
public Object set(Object o, byte[] bytes, int scale) {
- return new HiveDecimal(new BigInteger(bytes), scale);
+ return HiveDecimal.create(new BigInteger(bytes), scale);
}
@Override
@@ -69,20 +69,16 @@ public class JavaHiveDecimalObjectInspec
@Override
public Object create(byte[] bytes, int scale) {
- try {
- return new HiveDecimal(new BigInteger(bytes), scale);
- } catch (NumberFormatException e) {
- return null;
- }
+ return HiveDecimal.create(new BigInteger(bytes), scale);
}
@Override
public Object create(HiveDecimal t) {
- try {
- return t == null ? null : new HiveDecimal(t.unscaledValue(), t.scale());
- } catch(NumberFormatException e) {
+ if (t == null) {
return null;
}
+
+ return HiveDecimal.create(t.unscaledValue(), t.scale());
}
}
Modified: hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorConverter.java
URL: http://svn.apache.org/viewvc/hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorConverter.java?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorConverter.java (original)
+++ hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorConverter.java Wed Oct 16 20:28:16 2013
@@ -301,12 +301,7 @@ public class PrimitiveObjectInspectorCon
return null;
}
- try {
- return outputOI.set(r, PrimitiveObjectInspectorUtils.getHiveDecimal(input,
- inputOI));
- } catch (NumberFormatException e) {
- return null;
- }
+ return outputOI.set(r, PrimitiveObjectInspectorUtils.getHiveDecimal(input, inputOI));
}
}
Modified: hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorUtils.java
URL: http://svn.apache.org/viewvc/hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorUtils.java?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorUtils.java (original)
+++ hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/PrimitiveObjectInspectorUtils.java Wed Oct 16 20:28:16 2013
@@ -882,35 +882,35 @@ public final class PrimitiveObjectInspec
HiveDecimal.ONE : HiveDecimal.ZERO;
break;
case BYTE:
- result = new HiveDecimal(((ByteObjectInspector) oi).get(o));
+ result = HiveDecimal.create(((ByteObjectInspector) oi).get(o));
break;
case SHORT:
- result = new HiveDecimal(((ShortObjectInspector) oi).get(o));
+ result = HiveDecimal.create(((ShortObjectInspector) oi).get(o));
break;
case INT:
- result = new HiveDecimal(((IntObjectInspector) oi).get(o));
+ result = HiveDecimal.create(((IntObjectInspector) oi).get(o));
break;
case LONG:
- result = new HiveDecimal(((LongObjectInspector) oi).get(o));
+ result = HiveDecimal.create(((LongObjectInspector) oi).get(o));
break;
case FLOAT:
Float f = ((FloatObjectInspector) oi).get(o);
- result = new HiveDecimal(f.toString());
+ result = HiveDecimal.create(f.toString());
break;
case DOUBLE:
Double d = ((DoubleObjectInspector) oi).get(o);
- result = new HiveDecimal(d.toString());
+ result = HiveDecimal.create(d.toString());
break;
case STRING:
- result = new HiveDecimal(((StringObjectInspector) oi).getPrimitiveJavaObject(o));
+ result = HiveDecimal.create(((StringObjectInspector) oi).getPrimitiveJavaObject(o));
break;
case VARCHAR:
- result = new HiveDecimal(getString(o, oi));
+ result = HiveDecimal.create(getString(o, oi));
break;
case TIMESTAMP:
Double ts = ((TimestampObjectInspector) oi).getPrimitiveWritableObject(o)
.getDouble();
- result = new HiveDecimal(ts.toString());
+ result = HiveDecimal.create(ts.toString());
break;
case DECIMAL:
result = ((HiveDecimalObjectInspector) oi).getPrimitiveJavaObject(o);
Modified: hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableHiveDecimalObjectInspector.java
URL: http://svn.apache.org/viewvc/hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableHiveDecimalObjectInspector.java?rev=1532891&r1=1532890&r2=1532891&view=diff
==============================================================================
--- hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableHiveDecimalObjectInspector.java (original)
+++ hive/branches/tez/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/primitive/WritableHiveDecimalObjectInspector.java Wed Oct 16 20:28:16 2013
@@ -53,12 +53,20 @@ public class WritableHiveDecimalObjectIn
@Override
public Object set(Object o, HiveDecimal t) {
+ if (t == null) {
+ return null;
+ }
+
((HiveDecimalWritable) o).set(t);
return o;
}
@Override
public Object set(Object o, HiveDecimalWritable t) {
+ if (t == null) {
+ return null;
+ }
+
((HiveDecimalWritable) o).set(t);
return o;
}
@@ -70,6 +78,10 @@ public class WritableHiveDecimalObjectIn
@Override
public Object create(HiveDecimal t) {
+ if (t == null) {
+ return null;
+ }
+
return new HiveDecimalWritable(t);
}