diff --git ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrExprProcFactory.java ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrExprProcFactory.java index 2924124..7ec1f21 100644 --- ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrExprProcFactory.java +++ ql/src/java/org/apache/hadoop/hive/ql/optimizer/pcr/PcrExprProcFactory.java @@ -125,7 +125,7 @@ public final class PcrExprProcFactory { } static Boolean opAnd(Boolean op1, Boolean op2) { - if (op1 != null && op1.equals(Boolean.FALSE) || op2 != null && op2.equals(Boolean.FALSE)) { + if (op1.equals(Boolean.FALSE) || op2.equals(Boolean.FALSE)) { return Boolean.FALSE; } if (op1 == null || op2 == null) { @@ -135,7 +135,7 @@ public final class PcrExprProcFactory { } static Boolean opOr(Boolean op1, Boolean op2) { - if (op1 != null && op1.equals(Boolean.TRUE) || op2 != null && op2.equals(Boolean.TRUE)) { + if (op1.equals(Boolean.TRUE) || op2.equals(Boolean.TRUE)) { return Boolean.TRUE; } if (op1 == null || op2 == null) { @@ -145,13 +145,11 @@ public final class PcrExprProcFactory { } static Boolean opNot(Boolean op) { - if (op != null) { - if (op.equals(Boolean.TRUE)) { - return Boolean.FALSE; - } - if (op.equals(Boolean.FALSE)) { - return Boolean.TRUE; - } + if (op.equals(Boolean.TRUE)) { + return Boolean.FALSE; + } + if (op.equals(Boolean.FALSE)) { + return Boolean.TRUE; } return null; } diff --git ql/src/test/queries/clientpositive/select_unquote_and.q ql/src/test/queries/clientpositive/select_unquote_and.q deleted file mode 100644 index 554fdef..0000000 --- ql/src/test/queries/clientpositive/select_unquote_and.q +++ /dev/null @@ -1,15 +0,0 @@ -CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING); - -INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11') -SELECT src.key, src.value FROM src WHERE key < '200'; - -INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12') -SELECT src.key, src.value FROM src WHERE key > '200'; - -SELECT * FROM npe_test; - -EXPLAIN SELECT * FROM npe_test WHERE ds > 2012-11-31 AND ds < 2012-12-15; - -SELECT * FROM npe_test WHERE ds > 2012-11-31 AND ds < 2012-12-15; - -DROP TABLE npe_test; diff --git ql/src/test/queries/clientpositive/select_unquote_not.q ql/src/test/queries/clientpositive/select_unquote_not.q deleted file mode 100644 index 33d1d2a..0000000 --- ql/src/test/queries/clientpositive/select_unquote_not.q +++ /dev/null @@ -1,15 +0,0 @@ -CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING); - -INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11') -SELECT src.key, src.value FROM src WHERE key < '200'; - -INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12') -SELECT src.key, src.value FROM src WHERE key > '200'; - -SELECT * FROM npe_test; - -EXPLAIN SELECT * FROM npe_test WHERE NOT ds < 2012-11-31; - -SELECT * FROM npe_test WHERE NOT ds < 2012-11-31; - -DROP TABLE npe_test; diff --git ql/src/test/queries/clientpositive/select_unquote_or.q ql/src/test/queries/clientpositive/select_unquote_or.q deleted file mode 100644 index d0982db..0000000 --- ql/src/test/queries/clientpositive/select_unquote_or.q +++ /dev/null @@ -1,15 +0,0 @@ -CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING); - -INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11') -SELECT src.key, src.value FROM src WHERE key < '200'; - -INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12') -SELECT src.key, src.value FROM src WHERE key > '200'; - -SELECT * FROM npe_test; - -EXPLAIN SELECT * FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15; - -SELECT * FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15; - -DROP TABLE npe_test; diff --git ql/src/test/results/clientpositive/select_unquote_and.q.out ql/src/test/results/clientpositive/select_unquote_and.q.out deleted file mode 100644 index d875647..0000000 --- ql/src/test/results/clientpositive/select_unquote_and.q.out +++ /dev/null @@ -1,616 +0,0 @@ -PREHOOK: query: CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING) -PREHOOK: type: CREATETABLE -POSTHOOK: query: CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: default@npe_test -PREHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11') -SELECT src.key, src.value FROM src WHERE key < '200' -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@npe_test@ds=2012-12-11 -POSTHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11') -SELECT src.key, src.value FROM src WHERE key < '200' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@npe_test@ds=2012-12-11 -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12') -SELECT src.key, src.value FROM src WHERE key > '200' -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@npe_test@ds=2012-12-12 -POSTHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12') -SELECT src.key, src.value FROM src WHERE key > '200' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@npe_test@ds=2012-12-12 -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT * FROM npe_test -PREHOOK: type: QUERY -PREHOOK: Input: default@npe_test@ds=2012-12-11 -PREHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM npe_test -POSTHOOK: type: QUERY -POSTHOOK: Input: default@npe_test@ds=2012-12-11 -POSTHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -165 val_165 2012-12-11 -193 val_193 2012-12-11 -150 val_150 2012-12-11 -128 val_128 2012-12-11 -146 val_146 2012-12-11 -152 val_152 2012-12-11 -145 val_145 2012-12-11 -15 val_15 2012-12-11 -166 val_166 2012-12-11 -153 val_153 2012-12-11 -193 val_193 2012-12-11 -174 val_174 2012-12-11 -199 val_199 2012-12-11 -174 val_174 2012-12-11 -162 val_162 2012-12-11 -167 val_167 2012-12-11 -195 val_195 2012-12-11 -17 val_17 2012-12-11 -113 val_113 2012-12-11 -155 val_155 2012-12-11 -0 val_0 2012-12-11 -128 val_128 2012-12-11 -149 val_149 2012-12-11 -129 val_129 2012-12-11 -170 val_170 2012-12-11 -20 val_20 2012-12-11 -157 val_157 2012-12-11 -111 val_111 2012-12-11 -169 val_169 2012-12-11 -125 val_125 2012-12-11 -192 val_192 2012-12-11 -187 val_187 2012-12-11 -176 val_176 2012-12-11 -138 val_138 2012-12-11 -103 val_103 2012-12-11 -176 val_176 2012-12-11 -137 val_137 2012-12-11 -180 val_180 2012-12-11 -12 val_12 2012-12-11 -181 val_181 2012-12-11 -138 val_138 2012-12-11 -179 val_179 2012-12-11 -172 val_172 2012-12-11 -129 val_129 2012-12-11 -158 val_158 2012-12-11 -119 val_119 2012-12-11 -0 val_0 2012-12-11 -197 val_197 2012-12-11 -100 val_100 2012-12-11 -199 val_199 2012-12-11 -191 val_191 2012-12-11 -165 val_165 2012-12-11 -120 val_120 2012-12-11 -131 val_131 2012-12-11 -156 val_156 2012-12-11 -196 val_196 2012-12-11 -197 val_197 2012-12-11 -187 val_187 2012-12-11 -137 val_137 2012-12-11 -169 val_169 2012-12-11 -0 val_0 2012-12-11 -179 val_179 2012-12-11 -118 val_118 2012-12-11 -134 val_134 2012-12-11 -138 val_138 2012-12-11 -15 val_15 2012-12-11 -118 val_118 2012-12-11 -19 val_19 2012-12-11 -10 val_10 2012-12-11 -177 val_177 2012-12-11 -11 val_11 2012-12-11 -168 val_168 2012-12-11 -143 val_143 2012-12-11 -160 val_160 2012-12-11 -195 val_195 2012-12-11 -119 val_119 2012-12-11 -149 val_149 2012-12-11 -138 val_138 2012-12-11 -103 val_103 2012-12-11 -113 val_113 2012-12-11 -167 val_167 2012-12-11 -116 val_116 2012-12-11 -191 val_191 2012-12-11 -128 val_128 2012-12-11 -2 val_2 2012-12-11 -193 val_193 2012-12-11 -104 val_104 2012-12-11 -175 val_175 2012-12-11 -105 val_105 2012-12-11 -190 val_190 2012-12-11 -114 val_114 2012-12-11 -12 val_12 2012-12-11 -164 val_164 2012-12-11 -125 val_125 2012-12-11 -164 val_164 2012-12-11 -187 val_187 2012-12-11 -104 val_104 2012-12-11 -163 val_163 2012-12-11 -119 val_119 2012-12-11 -199 val_199 2012-12-11 -120 val_120 2012-12-11 -169 val_169 2012-12-11 -178 val_178 2012-12-11 -136 val_136 2012-12-11 -172 val_172 2012-12-11 -133 val_133 2012-12-11 -175 val_175 2012-12-11 -189 val_189 2012-12-11 -134 val_134 2012-12-11 -18 val_18 2012-12-11 -100 val_100 2012-12-11 -146 val_146 2012-12-11 -186 val_186 2012-12-11 -167 val_167 2012-12-11 -18 val_18 2012-12-11 -183 val_183 2012-12-11 -152 val_152 2012-12-11 -194 val_194 2012-12-11 -126 val_126 2012-12-11 -169 val_169 2012-12-11 -238 val_238 2012-12-12 -86 val_86 2012-12-12 -311 val_311 2012-12-12 -27 val_27 2012-12-12 -409 val_409 2012-12-12 -255 val_255 2012-12-12 -278 val_278 2012-12-12 -98 val_98 2012-12-12 -484 val_484 2012-12-12 -265 val_265 2012-12-12 -401 val_401 2012-12-12 -273 val_273 2012-12-12 -224 val_224 2012-12-12 -369 val_369 2012-12-12 -66 val_66 2012-12-12 -213 val_213 2012-12-12 -406 val_406 2012-12-12 -429 val_429 2012-12-12 -374 val_374 2012-12-12 -469 val_469 2012-12-12 -495 val_495 2012-12-12 -37 val_37 2012-12-12 -327 val_327 2012-12-12 -281 val_281 2012-12-12 -277 val_277 2012-12-12 -209 val_209 2012-12-12 -82 val_82 2012-12-12 -403 val_403 2012-12-12 -417 val_417 2012-12-12 -430 val_430 2012-12-12 -252 val_252 2012-12-12 -292 val_292 2012-12-12 -219 val_219 2012-12-12 -287 val_287 2012-12-12 -338 val_338 2012-12-12 -446 val_446 2012-12-12 -459 val_459 2012-12-12 -394 val_394 2012-12-12 -237 val_237 2012-12-12 -482 val_482 2012-12-12 -413 val_413 2012-12-12 -494 val_494 2012-12-12 -207 val_207 2012-12-12 -466 val_466 2012-12-12 -208 val_208 2012-12-12 -399 val_399 2012-12-12 -396 val_396 2012-12-12 -247 val_247 2012-12-12 -417 val_417 2012-12-12 -489 val_489 2012-12-12 -377 val_377 2012-12-12 -397 val_397 2012-12-12 -309 val_309 2012-12-12 -365 val_365 2012-12-12 -266 val_266 2012-12-12 -439 val_439 2012-12-12 -342 val_342 2012-12-12 -367 val_367 2012-12-12 -325 val_325 2012-12-12 -475 val_475 2012-12-12 -203 val_203 2012-12-12 -339 val_339 2012-12-12 -455 val_455 2012-12-12 -311 val_311 2012-12-12 -316 val_316 2012-12-12 -57 val_57 2012-12-12 -302 val_302 2012-12-12 -205 val_205 2012-12-12 -438 val_438 2012-12-12 -345 val_345 2012-12-12 -489 val_489 2012-12-12 -378 val_378 2012-12-12 -221 val_221 2012-12-12 -92 val_92 2012-12-12 -47 val_47 2012-12-12 -72 val_72 2012-12-12 -4 val_4 2012-12-12 -280 val_280 2012-12-12 -35 val_35 2012-12-12 -427 val_427 2012-12-12 -277 val_277 2012-12-12 -208 val_208 2012-12-12 -356 val_356 2012-12-12 -399 val_399 2012-12-12 -382 val_382 2012-12-12 -498 val_498 2012-12-12 -386 val_386 2012-12-12 -437 val_437 2012-12-12 -469 val_469 2012-12-12 -286 val_286 2012-12-12 -54 val_54 2012-12-12 -459 val_459 2012-12-12 -51 val_51 2012-12-12 -239 val_239 2012-12-12 -213 val_213 2012-12-12 -216 val_216 2012-12-12 -430 val_430 2012-12-12 -278 val_278 2012-12-12 -289 val_289 2012-12-12 -221 val_221 2012-12-12 -65 val_65 2012-12-12 -318 val_318 2012-12-12 -332 val_332 2012-12-12 -311 val_311 2012-12-12 -275 val_275 2012-12-12 -241 val_241 2012-12-12 -83 val_83 2012-12-12 -333 val_333 2012-12-12 -284 val_284 2012-12-12 -230 val_230 2012-12-12 -67 val_67 2012-12-12 -260 val_260 2012-12-12 -404 val_404 2012-12-12 -384 val_384 2012-12-12 -489 val_489 2012-12-12 -353 val_353 2012-12-12 -373 val_373 2012-12-12 -272 val_272 2012-12-12 -217 val_217 2012-12-12 -84 val_84 2012-12-12 -348 val_348 2012-12-12 -466 val_466 2012-12-12 -58 val_58 2012-12-12 -8 val_8 2012-12-12 -411 val_411 2012-12-12 -230 val_230 2012-12-12 -208 val_208 2012-12-12 -348 val_348 2012-12-12 -24 val_24 2012-12-12 -463 val_463 2012-12-12 -431 val_431 2012-12-12 -42 val_42 2012-12-12 -496 val_496 2012-12-12 -322 val_322 2012-12-12 -468 val_468 2012-12-12 -393 val_393 2012-12-12 -454 val_454 2012-12-12 -298 val_298 2012-12-12 -418 val_418 2012-12-12 -96 val_96 2012-12-12 -26 val_26 2012-12-12 -327 val_327 2012-12-12 -230 val_230 2012-12-12 -205 val_205 2012-12-12 -51 val_51 2012-12-12 -404 val_404 2012-12-12 -43 val_43 2012-12-12 -436 val_436 2012-12-12 -469 val_469 2012-12-12 -468 val_468 2012-12-12 -308 val_308 2012-12-12 -95 val_95 2012-12-12 -288 val_288 2012-12-12 -481 val_481 2012-12-12 -457 val_457 2012-12-12 -98 val_98 2012-12-12 -282 val_282 2012-12-12 -318 val_318 2012-12-12 -318 val_318 2012-12-12 -409 val_409 2012-12-12 -470 val_470 2012-12-12 -369 val_369 2012-12-12 -316 val_316 2012-12-12 -413 val_413 2012-12-12 -85 val_85 2012-12-12 -77 val_77 2012-12-12 -490 val_490 2012-12-12 -87 val_87 2012-12-12 -364 val_364 2012-12-12 -395 val_395 2012-12-12 -282 val_282 2012-12-12 -238 val_238 2012-12-12 -419 val_419 2012-12-12 -72 val_72 2012-12-12 -90 val_90 2012-12-12 -307 val_307 2012-12-12 -435 val_435 2012-12-12 -277 val_277 2012-12-12 -273 val_273 2012-12-12 -306 val_306 2012-12-12 -224 val_224 2012-12-12 -309 val_309 2012-12-12 -389 val_389 2012-12-12 -327 val_327 2012-12-12 -242 val_242 2012-12-12 -369 val_369 2012-12-12 -392 val_392 2012-12-12 -272 val_272 2012-12-12 -331 val_331 2012-12-12 -401 val_401 2012-12-12 -242 val_242 2012-12-12 -452 val_452 2012-12-12 -226 val_226 2012-12-12 -5 val_5 2012-12-12 -497 val_497 2012-12-12 -402 val_402 2012-12-12 -396 val_396 2012-12-12 -317 val_317 2012-12-12 -395 val_395 2012-12-12 -58 val_58 2012-12-12 -35 val_35 2012-12-12 -336 val_336 2012-12-12 -95 val_95 2012-12-12 -34 val_34 2012-12-12 -229 val_229 2012-12-12 -233 val_233 2012-12-12 -472 val_472 2012-12-12 -322 val_322 2012-12-12 -498 val_498 2012-12-12 -42 val_42 2012-12-12 -321 val_321 2012-12-12 -430 val_430 2012-12-12 -489 val_489 2012-12-12 -458 val_458 2012-12-12 -78 val_78 2012-12-12 -76 val_76 2012-12-12 -41 val_41 2012-12-12 -223 val_223 2012-12-12 -492 val_492 2012-12-12 -449 val_449 2012-12-12 -218 val_218 2012-12-12 -228 val_228 2012-12-12 -453 val_453 2012-12-12 -30 val_30 2012-12-12 -209 val_209 2012-12-12 -64 val_64 2012-12-12 -468 val_468 2012-12-12 -76 val_76 2012-12-12 -74 val_74 2012-12-12 -342 val_342 2012-12-12 -69 val_69 2012-12-12 -230 val_230 2012-12-12 -33 val_33 2012-12-12 -368 val_368 2012-12-12 -296 val_296 2012-12-12 -216 val_216 2012-12-12 -367 val_367 2012-12-12 -344 val_344 2012-12-12 -274 val_274 2012-12-12 -219 val_219 2012-12-12 -239 val_239 2012-12-12 -485 val_485 2012-12-12 -223 val_223 2012-12-12 -256 val_256 2012-12-12 -263 val_263 2012-12-12 -70 val_70 2012-12-12 -487 val_487 2012-12-12 -480 val_480 2012-12-12 -401 val_401 2012-12-12 -288 val_288 2012-12-12 -5 val_5 2012-12-12 -244 val_244 2012-12-12 -438 val_438 2012-12-12 -467 val_467 2012-12-12 -432 val_432 2012-12-12 -202 val_202 2012-12-12 -316 val_316 2012-12-12 -229 val_229 2012-12-12 -469 val_469 2012-12-12 -463 val_463 2012-12-12 -280 val_280 2012-12-12 -35 val_35 2012-12-12 -283 val_283 2012-12-12 -331 val_331 2012-12-12 -235 val_235 2012-12-12 -80 val_80 2012-12-12 -44 val_44 2012-12-12 -321 val_321 2012-12-12 -335 val_335 2012-12-12 -466 val_466 2012-12-12 -366 val_366 2012-12-12 -403 val_403 2012-12-12 -483 val_483 2012-12-12 -53 val_53 2012-12-12 -257 val_257 2012-12-12 -406 val_406 2012-12-12 -409 val_409 2012-12-12 -406 val_406 2012-12-12 -401 val_401 2012-12-12 -258 val_258 2012-12-12 -90 val_90 2012-12-12 -203 val_203 2012-12-12 -262 val_262 2012-12-12 -348 val_348 2012-12-12 -424 val_424 2012-12-12 -396 val_396 2012-12-12 -201 val_201 2012-12-12 -217 val_217 2012-12-12 -431 val_431 2012-12-12 -454 val_454 2012-12-12 -478 val_478 2012-12-12 -298 val_298 2012-12-12 -431 val_431 2012-12-12 -424 val_424 2012-12-12 -382 val_382 2012-12-12 -5 val_5 2012-12-12 -70 val_70 2012-12-12 -397 val_397 2012-12-12 -480 val_480 2012-12-12 -291 val_291 2012-12-12 -24 val_24 2012-12-12 -351 val_351 2012-12-12 -255 val_255 2012-12-12 -70 val_70 2012-12-12 -438 val_438 2012-12-12 -414 val_414 2012-12-12 -491 val_491 2012-12-12 -237 val_237 2012-12-12 -439 val_439 2012-12-12 -360 val_360 2012-12-12 -248 val_248 2012-12-12 -479 val_479 2012-12-12 -305 val_305 2012-12-12 -417 val_417 2012-12-12 -444 val_444 2012-12-12 -429 val_429 2012-12-12 -443 val_443 2012-12-12 -323 val_323 2012-12-12 -325 val_325 2012-12-12 -277 val_277 2012-12-12 -230 val_230 2012-12-12 -478 val_478 2012-12-12 -468 val_468 2012-12-12 -310 val_310 2012-12-12 -317 val_317 2012-12-12 -333 val_333 2012-12-12 -493 val_493 2012-12-12 -460 val_460 2012-12-12 -207 val_207 2012-12-12 -249 val_249 2012-12-12 -265 val_265 2012-12-12 -480 val_480 2012-12-12 -83 val_83 2012-12-12 -353 val_353 2012-12-12 -214 val_214 2012-12-12 -462 val_462 2012-12-12 -233 val_233 2012-12-12 -406 val_406 2012-12-12 -454 val_454 2012-12-12 -375 val_375 2012-12-12 -401 val_401 2012-12-12 -421 val_421 2012-12-12 -407 val_407 2012-12-12 -384 val_384 2012-12-12 -256 val_256 2012-12-12 -26 val_26 2012-12-12 -67 val_67 2012-12-12 -384 val_384 2012-12-12 -379 val_379 2012-12-12 -462 val_462 2012-12-12 -492 val_492 2012-12-12 -298 val_298 2012-12-12 -9 val_9 2012-12-12 -341 val_341 2012-12-12 -498 val_498 2012-12-12 -458 val_458 2012-12-12 -362 val_362 2012-12-12 -285 val_285 2012-12-12 -348 val_348 2012-12-12 -273 val_273 2012-12-12 -281 val_281 2012-12-12 -344 val_344 2012-12-12 -97 val_97 2012-12-12 -469 val_469 2012-12-12 -315 val_315 2012-12-12 -84 val_84 2012-12-12 -28 val_28 2012-12-12 -37 val_37 2012-12-12 -448 val_448 2012-12-12 -348 val_348 2012-12-12 -307 val_307 2012-12-12 -414 val_414 2012-12-12 -477 val_477 2012-12-12 -222 val_222 2012-12-12 -90 val_90 2012-12-12 -403 val_403 2012-12-12 -400 val_400 2012-12-12 -97 val_97 2012-12-12 -PREHOOK: query: EXPLAIN SELECT * FROM npe_test WHERE ds > 2012-11-31 AND ds < 2012-12-15 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT * FROM npe_test WHERE ds > 2012-11-31 AND ds < 2012-12-15 -POSTHOOK: type: QUERY -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -ABSTRACT SYNTAX TREE: - (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME npe_test))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (AND (> (TOK_TABLE_OR_COL ds) (- (- 2012 11) 31)) (< (TOK_TABLE_OR_COL ds) (- (- 2012 12) 15)))))) - -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: - npe_test - TableScan - alias: npe_test - Filter Operator - predicate: - expr: ((ds > ((2012 - 11) - 31)) and (ds < ((2012 - 12) - 15))) - type: boolean - Select Operator - expressions: - expr: key - type: string - expr: value - type: string - expr: ds - 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 - - Stage: Stage-0 - Fetch Operator - limit: -1 - - -PREHOOK: query: SELECT * FROM npe_test WHERE ds > 2012-11-31 AND ds < 2012-12-15 -PREHOOK: type: QUERY -PREHOOK: Input: default@npe_test@ds=2012-12-11 -PREHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM npe_test WHERE ds > 2012-11-31 AND ds < 2012-12-15 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@npe_test@ds=2012-12-11 -POSTHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: DROP TABLE npe_test -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@npe_test -PREHOOK: Output: default@npe_test -POSTHOOK: query: DROP TABLE npe_test -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@npe_test -POSTHOOK: Output: default@npe_test -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] diff --git ql/src/test/results/clientpositive/select_unquote_not.q.out ql/src/test/results/clientpositive/select_unquote_not.q.out deleted file mode 100644 index 4076172..0000000 --- ql/src/test/results/clientpositive/select_unquote_not.q.out +++ /dev/null @@ -1,616 +0,0 @@ -PREHOOK: query: CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING) -PREHOOK: type: CREATETABLE -POSTHOOK: query: CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: default@npe_test -PREHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11') -SELECT src.key, src.value FROM src WHERE key < '200' -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@npe_test@ds=2012-12-11 -POSTHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11') -SELECT src.key, src.value FROM src WHERE key < '200' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@npe_test@ds=2012-12-11 -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12') -SELECT src.key, src.value FROM src WHERE key > '200' -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@npe_test@ds=2012-12-12 -POSTHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12') -SELECT src.key, src.value FROM src WHERE key > '200' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@npe_test@ds=2012-12-12 -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT * FROM npe_test -PREHOOK: type: QUERY -PREHOOK: Input: default@npe_test@ds=2012-12-11 -PREHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM npe_test -POSTHOOK: type: QUERY -POSTHOOK: Input: default@npe_test@ds=2012-12-11 -POSTHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -165 val_165 2012-12-11 -193 val_193 2012-12-11 -150 val_150 2012-12-11 -128 val_128 2012-12-11 -146 val_146 2012-12-11 -152 val_152 2012-12-11 -145 val_145 2012-12-11 -15 val_15 2012-12-11 -166 val_166 2012-12-11 -153 val_153 2012-12-11 -193 val_193 2012-12-11 -174 val_174 2012-12-11 -199 val_199 2012-12-11 -174 val_174 2012-12-11 -162 val_162 2012-12-11 -167 val_167 2012-12-11 -195 val_195 2012-12-11 -17 val_17 2012-12-11 -113 val_113 2012-12-11 -155 val_155 2012-12-11 -0 val_0 2012-12-11 -128 val_128 2012-12-11 -149 val_149 2012-12-11 -129 val_129 2012-12-11 -170 val_170 2012-12-11 -20 val_20 2012-12-11 -157 val_157 2012-12-11 -111 val_111 2012-12-11 -169 val_169 2012-12-11 -125 val_125 2012-12-11 -192 val_192 2012-12-11 -187 val_187 2012-12-11 -176 val_176 2012-12-11 -138 val_138 2012-12-11 -103 val_103 2012-12-11 -176 val_176 2012-12-11 -137 val_137 2012-12-11 -180 val_180 2012-12-11 -12 val_12 2012-12-11 -181 val_181 2012-12-11 -138 val_138 2012-12-11 -179 val_179 2012-12-11 -172 val_172 2012-12-11 -129 val_129 2012-12-11 -158 val_158 2012-12-11 -119 val_119 2012-12-11 -0 val_0 2012-12-11 -197 val_197 2012-12-11 -100 val_100 2012-12-11 -199 val_199 2012-12-11 -191 val_191 2012-12-11 -165 val_165 2012-12-11 -120 val_120 2012-12-11 -131 val_131 2012-12-11 -156 val_156 2012-12-11 -196 val_196 2012-12-11 -197 val_197 2012-12-11 -187 val_187 2012-12-11 -137 val_137 2012-12-11 -169 val_169 2012-12-11 -0 val_0 2012-12-11 -179 val_179 2012-12-11 -118 val_118 2012-12-11 -134 val_134 2012-12-11 -138 val_138 2012-12-11 -15 val_15 2012-12-11 -118 val_118 2012-12-11 -19 val_19 2012-12-11 -10 val_10 2012-12-11 -177 val_177 2012-12-11 -11 val_11 2012-12-11 -168 val_168 2012-12-11 -143 val_143 2012-12-11 -160 val_160 2012-12-11 -195 val_195 2012-12-11 -119 val_119 2012-12-11 -149 val_149 2012-12-11 -138 val_138 2012-12-11 -103 val_103 2012-12-11 -113 val_113 2012-12-11 -167 val_167 2012-12-11 -116 val_116 2012-12-11 -191 val_191 2012-12-11 -128 val_128 2012-12-11 -2 val_2 2012-12-11 -193 val_193 2012-12-11 -104 val_104 2012-12-11 -175 val_175 2012-12-11 -105 val_105 2012-12-11 -190 val_190 2012-12-11 -114 val_114 2012-12-11 -12 val_12 2012-12-11 -164 val_164 2012-12-11 -125 val_125 2012-12-11 -164 val_164 2012-12-11 -187 val_187 2012-12-11 -104 val_104 2012-12-11 -163 val_163 2012-12-11 -119 val_119 2012-12-11 -199 val_199 2012-12-11 -120 val_120 2012-12-11 -169 val_169 2012-12-11 -178 val_178 2012-12-11 -136 val_136 2012-12-11 -172 val_172 2012-12-11 -133 val_133 2012-12-11 -175 val_175 2012-12-11 -189 val_189 2012-12-11 -134 val_134 2012-12-11 -18 val_18 2012-12-11 -100 val_100 2012-12-11 -146 val_146 2012-12-11 -186 val_186 2012-12-11 -167 val_167 2012-12-11 -18 val_18 2012-12-11 -183 val_183 2012-12-11 -152 val_152 2012-12-11 -194 val_194 2012-12-11 -126 val_126 2012-12-11 -169 val_169 2012-12-11 -238 val_238 2012-12-12 -86 val_86 2012-12-12 -311 val_311 2012-12-12 -27 val_27 2012-12-12 -409 val_409 2012-12-12 -255 val_255 2012-12-12 -278 val_278 2012-12-12 -98 val_98 2012-12-12 -484 val_484 2012-12-12 -265 val_265 2012-12-12 -401 val_401 2012-12-12 -273 val_273 2012-12-12 -224 val_224 2012-12-12 -369 val_369 2012-12-12 -66 val_66 2012-12-12 -213 val_213 2012-12-12 -406 val_406 2012-12-12 -429 val_429 2012-12-12 -374 val_374 2012-12-12 -469 val_469 2012-12-12 -495 val_495 2012-12-12 -37 val_37 2012-12-12 -327 val_327 2012-12-12 -281 val_281 2012-12-12 -277 val_277 2012-12-12 -209 val_209 2012-12-12 -82 val_82 2012-12-12 -403 val_403 2012-12-12 -417 val_417 2012-12-12 -430 val_430 2012-12-12 -252 val_252 2012-12-12 -292 val_292 2012-12-12 -219 val_219 2012-12-12 -287 val_287 2012-12-12 -338 val_338 2012-12-12 -446 val_446 2012-12-12 -459 val_459 2012-12-12 -394 val_394 2012-12-12 -237 val_237 2012-12-12 -482 val_482 2012-12-12 -413 val_413 2012-12-12 -494 val_494 2012-12-12 -207 val_207 2012-12-12 -466 val_466 2012-12-12 -208 val_208 2012-12-12 -399 val_399 2012-12-12 -396 val_396 2012-12-12 -247 val_247 2012-12-12 -417 val_417 2012-12-12 -489 val_489 2012-12-12 -377 val_377 2012-12-12 -397 val_397 2012-12-12 -309 val_309 2012-12-12 -365 val_365 2012-12-12 -266 val_266 2012-12-12 -439 val_439 2012-12-12 -342 val_342 2012-12-12 -367 val_367 2012-12-12 -325 val_325 2012-12-12 -475 val_475 2012-12-12 -203 val_203 2012-12-12 -339 val_339 2012-12-12 -455 val_455 2012-12-12 -311 val_311 2012-12-12 -316 val_316 2012-12-12 -57 val_57 2012-12-12 -302 val_302 2012-12-12 -205 val_205 2012-12-12 -438 val_438 2012-12-12 -345 val_345 2012-12-12 -489 val_489 2012-12-12 -378 val_378 2012-12-12 -221 val_221 2012-12-12 -92 val_92 2012-12-12 -47 val_47 2012-12-12 -72 val_72 2012-12-12 -4 val_4 2012-12-12 -280 val_280 2012-12-12 -35 val_35 2012-12-12 -427 val_427 2012-12-12 -277 val_277 2012-12-12 -208 val_208 2012-12-12 -356 val_356 2012-12-12 -399 val_399 2012-12-12 -382 val_382 2012-12-12 -498 val_498 2012-12-12 -386 val_386 2012-12-12 -437 val_437 2012-12-12 -469 val_469 2012-12-12 -286 val_286 2012-12-12 -54 val_54 2012-12-12 -459 val_459 2012-12-12 -51 val_51 2012-12-12 -239 val_239 2012-12-12 -213 val_213 2012-12-12 -216 val_216 2012-12-12 -430 val_430 2012-12-12 -278 val_278 2012-12-12 -289 val_289 2012-12-12 -221 val_221 2012-12-12 -65 val_65 2012-12-12 -318 val_318 2012-12-12 -332 val_332 2012-12-12 -311 val_311 2012-12-12 -275 val_275 2012-12-12 -241 val_241 2012-12-12 -83 val_83 2012-12-12 -333 val_333 2012-12-12 -284 val_284 2012-12-12 -230 val_230 2012-12-12 -67 val_67 2012-12-12 -260 val_260 2012-12-12 -404 val_404 2012-12-12 -384 val_384 2012-12-12 -489 val_489 2012-12-12 -353 val_353 2012-12-12 -373 val_373 2012-12-12 -272 val_272 2012-12-12 -217 val_217 2012-12-12 -84 val_84 2012-12-12 -348 val_348 2012-12-12 -466 val_466 2012-12-12 -58 val_58 2012-12-12 -8 val_8 2012-12-12 -411 val_411 2012-12-12 -230 val_230 2012-12-12 -208 val_208 2012-12-12 -348 val_348 2012-12-12 -24 val_24 2012-12-12 -463 val_463 2012-12-12 -431 val_431 2012-12-12 -42 val_42 2012-12-12 -496 val_496 2012-12-12 -322 val_322 2012-12-12 -468 val_468 2012-12-12 -393 val_393 2012-12-12 -454 val_454 2012-12-12 -298 val_298 2012-12-12 -418 val_418 2012-12-12 -96 val_96 2012-12-12 -26 val_26 2012-12-12 -327 val_327 2012-12-12 -230 val_230 2012-12-12 -205 val_205 2012-12-12 -51 val_51 2012-12-12 -404 val_404 2012-12-12 -43 val_43 2012-12-12 -436 val_436 2012-12-12 -469 val_469 2012-12-12 -468 val_468 2012-12-12 -308 val_308 2012-12-12 -95 val_95 2012-12-12 -288 val_288 2012-12-12 -481 val_481 2012-12-12 -457 val_457 2012-12-12 -98 val_98 2012-12-12 -282 val_282 2012-12-12 -318 val_318 2012-12-12 -318 val_318 2012-12-12 -409 val_409 2012-12-12 -470 val_470 2012-12-12 -369 val_369 2012-12-12 -316 val_316 2012-12-12 -413 val_413 2012-12-12 -85 val_85 2012-12-12 -77 val_77 2012-12-12 -490 val_490 2012-12-12 -87 val_87 2012-12-12 -364 val_364 2012-12-12 -395 val_395 2012-12-12 -282 val_282 2012-12-12 -238 val_238 2012-12-12 -419 val_419 2012-12-12 -72 val_72 2012-12-12 -90 val_90 2012-12-12 -307 val_307 2012-12-12 -435 val_435 2012-12-12 -277 val_277 2012-12-12 -273 val_273 2012-12-12 -306 val_306 2012-12-12 -224 val_224 2012-12-12 -309 val_309 2012-12-12 -389 val_389 2012-12-12 -327 val_327 2012-12-12 -242 val_242 2012-12-12 -369 val_369 2012-12-12 -392 val_392 2012-12-12 -272 val_272 2012-12-12 -331 val_331 2012-12-12 -401 val_401 2012-12-12 -242 val_242 2012-12-12 -452 val_452 2012-12-12 -226 val_226 2012-12-12 -5 val_5 2012-12-12 -497 val_497 2012-12-12 -402 val_402 2012-12-12 -396 val_396 2012-12-12 -317 val_317 2012-12-12 -395 val_395 2012-12-12 -58 val_58 2012-12-12 -35 val_35 2012-12-12 -336 val_336 2012-12-12 -95 val_95 2012-12-12 -34 val_34 2012-12-12 -229 val_229 2012-12-12 -233 val_233 2012-12-12 -472 val_472 2012-12-12 -322 val_322 2012-12-12 -498 val_498 2012-12-12 -42 val_42 2012-12-12 -321 val_321 2012-12-12 -430 val_430 2012-12-12 -489 val_489 2012-12-12 -458 val_458 2012-12-12 -78 val_78 2012-12-12 -76 val_76 2012-12-12 -41 val_41 2012-12-12 -223 val_223 2012-12-12 -492 val_492 2012-12-12 -449 val_449 2012-12-12 -218 val_218 2012-12-12 -228 val_228 2012-12-12 -453 val_453 2012-12-12 -30 val_30 2012-12-12 -209 val_209 2012-12-12 -64 val_64 2012-12-12 -468 val_468 2012-12-12 -76 val_76 2012-12-12 -74 val_74 2012-12-12 -342 val_342 2012-12-12 -69 val_69 2012-12-12 -230 val_230 2012-12-12 -33 val_33 2012-12-12 -368 val_368 2012-12-12 -296 val_296 2012-12-12 -216 val_216 2012-12-12 -367 val_367 2012-12-12 -344 val_344 2012-12-12 -274 val_274 2012-12-12 -219 val_219 2012-12-12 -239 val_239 2012-12-12 -485 val_485 2012-12-12 -223 val_223 2012-12-12 -256 val_256 2012-12-12 -263 val_263 2012-12-12 -70 val_70 2012-12-12 -487 val_487 2012-12-12 -480 val_480 2012-12-12 -401 val_401 2012-12-12 -288 val_288 2012-12-12 -5 val_5 2012-12-12 -244 val_244 2012-12-12 -438 val_438 2012-12-12 -467 val_467 2012-12-12 -432 val_432 2012-12-12 -202 val_202 2012-12-12 -316 val_316 2012-12-12 -229 val_229 2012-12-12 -469 val_469 2012-12-12 -463 val_463 2012-12-12 -280 val_280 2012-12-12 -35 val_35 2012-12-12 -283 val_283 2012-12-12 -331 val_331 2012-12-12 -235 val_235 2012-12-12 -80 val_80 2012-12-12 -44 val_44 2012-12-12 -321 val_321 2012-12-12 -335 val_335 2012-12-12 -466 val_466 2012-12-12 -366 val_366 2012-12-12 -403 val_403 2012-12-12 -483 val_483 2012-12-12 -53 val_53 2012-12-12 -257 val_257 2012-12-12 -406 val_406 2012-12-12 -409 val_409 2012-12-12 -406 val_406 2012-12-12 -401 val_401 2012-12-12 -258 val_258 2012-12-12 -90 val_90 2012-12-12 -203 val_203 2012-12-12 -262 val_262 2012-12-12 -348 val_348 2012-12-12 -424 val_424 2012-12-12 -396 val_396 2012-12-12 -201 val_201 2012-12-12 -217 val_217 2012-12-12 -431 val_431 2012-12-12 -454 val_454 2012-12-12 -478 val_478 2012-12-12 -298 val_298 2012-12-12 -431 val_431 2012-12-12 -424 val_424 2012-12-12 -382 val_382 2012-12-12 -5 val_5 2012-12-12 -70 val_70 2012-12-12 -397 val_397 2012-12-12 -480 val_480 2012-12-12 -291 val_291 2012-12-12 -24 val_24 2012-12-12 -351 val_351 2012-12-12 -255 val_255 2012-12-12 -70 val_70 2012-12-12 -438 val_438 2012-12-12 -414 val_414 2012-12-12 -491 val_491 2012-12-12 -237 val_237 2012-12-12 -439 val_439 2012-12-12 -360 val_360 2012-12-12 -248 val_248 2012-12-12 -479 val_479 2012-12-12 -305 val_305 2012-12-12 -417 val_417 2012-12-12 -444 val_444 2012-12-12 -429 val_429 2012-12-12 -443 val_443 2012-12-12 -323 val_323 2012-12-12 -325 val_325 2012-12-12 -277 val_277 2012-12-12 -230 val_230 2012-12-12 -478 val_478 2012-12-12 -468 val_468 2012-12-12 -310 val_310 2012-12-12 -317 val_317 2012-12-12 -333 val_333 2012-12-12 -493 val_493 2012-12-12 -460 val_460 2012-12-12 -207 val_207 2012-12-12 -249 val_249 2012-12-12 -265 val_265 2012-12-12 -480 val_480 2012-12-12 -83 val_83 2012-12-12 -353 val_353 2012-12-12 -214 val_214 2012-12-12 -462 val_462 2012-12-12 -233 val_233 2012-12-12 -406 val_406 2012-12-12 -454 val_454 2012-12-12 -375 val_375 2012-12-12 -401 val_401 2012-12-12 -421 val_421 2012-12-12 -407 val_407 2012-12-12 -384 val_384 2012-12-12 -256 val_256 2012-12-12 -26 val_26 2012-12-12 -67 val_67 2012-12-12 -384 val_384 2012-12-12 -379 val_379 2012-12-12 -462 val_462 2012-12-12 -492 val_492 2012-12-12 -298 val_298 2012-12-12 -9 val_9 2012-12-12 -341 val_341 2012-12-12 -498 val_498 2012-12-12 -458 val_458 2012-12-12 -362 val_362 2012-12-12 -285 val_285 2012-12-12 -348 val_348 2012-12-12 -273 val_273 2012-12-12 -281 val_281 2012-12-12 -344 val_344 2012-12-12 -97 val_97 2012-12-12 -469 val_469 2012-12-12 -315 val_315 2012-12-12 -84 val_84 2012-12-12 -28 val_28 2012-12-12 -37 val_37 2012-12-12 -448 val_448 2012-12-12 -348 val_348 2012-12-12 -307 val_307 2012-12-12 -414 val_414 2012-12-12 -477 val_477 2012-12-12 -222 val_222 2012-12-12 -90 val_90 2012-12-12 -403 val_403 2012-12-12 -400 val_400 2012-12-12 -97 val_97 2012-12-12 -PREHOOK: query: EXPLAIN SELECT * FROM npe_test WHERE NOT ds < 2012-11-31 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT * FROM npe_test WHERE NOT ds < 2012-11-31 -POSTHOOK: type: QUERY -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -ABSTRACT SYNTAX TREE: - (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME npe_test))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (NOT (< (TOK_TABLE_OR_COL ds) (- (- 2012 11) 31)))))) - -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: - npe_test - TableScan - alias: npe_test - Filter Operator - predicate: - expr: (not (ds < ((2012 - 11) - 31))) - type: boolean - Select Operator - expressions: - expr: key - type: string - expr: value - type: string - expr: ds - 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 - - Stage: Stage-0 - Fetch Operator - limit: -1 - - -PREHOOK: query: SELECT * FROM npe_test WHERE NOT ds < 2012-11-31 -PREHOOK: type: QUERY -PREHOOK: Input: default@npe_test@ds=2012-12-11 -PREHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM npe_test WHERE NOT ds < 2012-11-31 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@npe_test@ds=2012-12-11 -POSTHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: DROP TABLE npe_test -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@npe_test -PREHOOK: Output: default@npe_test -POSTHOOK: query: DROP TABLE npe_test -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@npe_test -POSTHOOK: Output: default@npe_test -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] diff --git ql/src/test/results/clientpositive/select_unquote_or.q.out ql/src/test/results/clientpositive/select_unquote_or.q.out deleted file mode 100644 index 46b68d1..0000000 --- ql/src/test/results/clientpositive/select_unquote_or.q.out +++ /dev/null @@ -1,616 +0,0 @@ -PREHOOK: query: CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING) -PREHOOK: type: CREATETABLE -POSTHOOK: query: CREATE TABLE npe_test (key STRING, value STRING) PARTITIONED BY (ds STRING) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: default@npe_test -PREHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11') -SELECT src.key, src.value FROM src WHERE key < '200' -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@npe_test@ds=2012-12-11 -POSTHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-11') -SELECT src.key, src.value FROM src WHERE key < '200' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@npe_test@ds=2012-12-11 -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12') -SELECT src.key, src.value FROM src WHERE key > '200' -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@npe_test@ds=2012-12-12 -POSTHOOK: query: INSERT OVERWRITE TABLE npe_test PARTITION(ds='2012-12-12') -SELECT src.key, src.value FROM src WHERE key > '200' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@npe_test@ds=2012-12-12 -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT * FROM npe_test -PREHOOK: type: QUERY -PREHOOK: Input: default@npe_test@ds=2012-12-11 -PREHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM npe_test -POSTHOOK: type: QUERY -POSTHOOK: Input: default@npe_test@ds=2012-12-11 -POSTHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -165 val_165 2012-12-11 -193 val_193 2012-12-11 -150 val_150 2012-12-11 -128 val_128 2012-12-11 -146 val_146 2012-12-11 -152 val_152 2012-12-11 -145 val_145 2012-12-11 -15 val_15 2012-12-11 -166 val_166 2012-12-11 -153 val_153 2012-12-11 -193 val_193 2012-12-11 -174 val_174 2012-12-11 -199 val_199 2012-12-11 -174 val_174 2012-12-11 -162 val_162 2012-12-11 -167 val_167 2012-12-11 -195 val_195 2012-12-11 -17 val_17 2012-12-11 -113 val_113 2012-12-11 -155 val_155 2012-12-11 -0 val_0 2012-12-11 -128 val_128 2012-12-11 -149 val_149 2012-12-11 -129 val_129 2012-12-11 -170 val_170 2012-12-11 -20 val_20 2012-12-11 -157 val_157 2012-12-11 -111 val_111 2012-12-11 -169 val_169 2012-12-11 -125 val_125 2012-12-11 -192 val_192 2012-12-11 -187 val_187 2012-12-11 -176 val_176 2012-12-11 -138 val_138 2012-12-11 -103 val_103 2012-12-11 -176 val_176 2012-12-11 -137 val_137 2012-12-11 -180 val_180 2012-12-11 -12 val_12 2012-12-11 -181 val_181 2012-12-11 -138 val_138 2012-12-11 -179 val_179 2012-12-11 -172 val_172 2012-12-11 -129 val_129 2012-12-11 -158 val_158 2012-12-11 -119 val_119 2012-12-11 -0 val_0 2012-12-11 -197 val_197 2012-12-11 -100 val_100 2012-12-11 -199 val_199 2012-12-11 -191 val_191 2012-12-11 -165 val_165 2012-12-11 -120 val_120 2012-12-11 -131 val_131 2012-12-11 -156 val_156 2012-12-11 -196 val_196 2012-12-11 -197 val_197 2012-12-11 -187 val_187 2012-12-11 -137 val_137 2012-12-11 -169 val_169 2012-12-11 -0 val_0 2012-12-11 -179 val_179 2012-12-11 -118 val_118 2012-12-11 -134 val_134 2012-12-11 -138 val_138 2012-12-11 -15 val_15 2012-12-11 -118 val_118 2012-12-11 -19 val_19 2012-12-11 -10 val_10 2012-12-11 -177 val_177 2012-12-11 -11 val_11 2012-12-11 -168 val_168 2012-12-11 -143 val_143 2012-12-11 -160 val_160 2012-12-11 -195 val_195 2012-12-11 -119 val_119 2012-12-11 -149 val_149 2012-12-11 -138 val_138 2012-12-11 -103 val_103 2012-12-11 -113 val_113 2012-12-11 -167 val_167 2012-12-11 -116 val_116 2012-12-11 -191 val_191 2012-12-11 -128 val_128 2012-12-11 -2 val_2 2012-12-11 -193 val_193 2012-12-11 -104 val_104 2012-12-11 -175 val_175 2012-12-11 -105 val_105 2012-12-11 -190 val_190 2012-12-11 -114 val_114 2012-12-11 -12 val_12 2012-12-11 -164 val_164 2012-12-11 -125 val_125 2012-12-11 -164 val_164 2012-12-11 -187 val_187 2012-12-11 -104 val_104 2012-12-11 -163 val_163 2012-12-11 -119 val_119 2012-12-11 -199 val_199 2012-12-11 -120 val_120 2012-12-11 -169 val_169 2012-12-11 -178 val_178 2012-12-11 -136 val_136 2012-12-11 -172 val_172 2012-12-11 -133 val_133 2012-12-11 -175 val_175 2012-12-11 -189 val_189 2012-12-11 -134 val_134 2012-12-11 -18 val_18 2012-12-11 -100 val_100 2012-12-11 -146 val_146 2012-12-11 -186 val_186 2012-12-11 -167 val_167 2012-12-11 -18 val_18 2012-12-11 -183 val_183 2012-12-11 -152 val_152 2012-12-11 -194 val_194 2012-12-11 -126 val_126 2012-12-11 -169 val_169 2012-12-11 -238 val_238 2012-12-12 -86 val_86 2012-12-12 -311 val_311 2012-12-12 -27 val_27 2012-12-12 -409 val_409 2012-12-12 -255 val_255 2012-12-12 -278 val_278 2012-12-12 -98 val_98 2012-12-12 -484 val_484 2012-12-12 -265 val_265 2012-12-12 -401 val_401 2012-12-12 -273 val_273 2012-12-12 -224 val_224 2012-12-12 -369 val_369 2012-12-12 -66 val_66 2012-12-12 -213 val_213 2012-12-12 -406 val_406 2012-12-12 -429 val_429 2012-12-12 -374 val_374 2012-12-12 -469 val_469 2012-12-12 -495 val_495 2012-12-12 -37 val_37 2012-12-12 -327 val_327 2012-12-12 -281 val_281 2012-12-12 -277 val_277 2012-12-12 -209 val_209 2012-12-12 -82 val_82 2012-12-12 -403 val_403 2012-12-12 -417 val_417 2012-12-12 -430 val_430 2012-12-12 -252 val_252 2012-12-12 -292 val_292 2012-12-12 -219 val_219 2012-12-12 -287 val_287 2012-12-12 -338 val_338 2012-12-12 -446 val_446 2012-12-12 -459 val_459 2012-12-12 -394 val_394 2012-12-12 -237 val_237 2012-12-12 -482 val_482 2012-12-12 -413 val_413 2012-12-12 -494 val_494 2012-12-12 -207 val_207 2012-12-12 -466 val_466 2012-12-12 -208 val_208 2012-12-12 -399 val_399 2012-12-12 -396 val_396 2012-12-12 -247 val_247 2012-12-12 -417 val_417 2012-12-12 -489 val_489 2012-12-12 -377 val_377 2012-12-12 -397 val_397 2012-12-12 -309 val_309 2012-12-12 -365 val_365 2012-12-12 -266 val_266 2012-12-12 -439 val_439 2012-12-12 -342 val_342 2012-12-12 -367 val_367 2012-12-12 -325 val_325 2012-12-12 -475 val_475 2012-12-12 -203 val_203 2012-12-12 -339 val_339 2012-12-12 -455 val_455 2012-12-12 -311 val_311 2012-12-12 -316 val_316 2012-12-12 -57 val_57 2012-12-12 -302 val_302 2012-12-12 -205 val_205 2012-12-12 -438 val_438 2012-12-12 -345 val_345 2012-12-12 -489 val_489 2012-12-12 -378 val_378 2012-12-12 -221 val_221 2012-12-12 -92 val_92 2012-12-12 -47 val_47 2012-12-12 -72 val_72 2012-12-12 -4 val_4 2012-12-12 -280 val_280 2012-12-12 -35 val_35 2012-12-12 -427 val_427 2012-12-12 -277 val_277 2012-12-12 -208 val_208 2012-12-12 -356 val_356 2012-12-12 -399 val_399 2012-12-12 -382 val_382 2012-12-12 -498 val_498 2012-12-12 -386 val_386 2012-12-12 -437 val_437 2012-12-12 -469 val_469 2012-12-12 -286 val_286 2012-12-12 -54 val_54 2012-12-12 -459 val_459 2012-12-12 -51 val_51 2012-12-12 -239 val_239 2012-12-12 -213 val_213 2012-12-12 -216 val_216 2012-12-12 -430 val_430 2012-12-12 -278 val_278 2012-12-12 -289 val_289 2012-12-12 -221 val_221 2012-12-12 -65 val_65 2012-12-12 -318 val_318 2012-12-12 -332 val_332 2012-12-12 -311 val_311 2012-12-12 -275 val_275 2012-12-12 -241 val_241 2012-12-12 -83 val_83 2012-12-12 -333 val_333 2012-12-12 -284 val_284 2012-12-12 -230 val_230 2012-12-12 -67 val_67 2012-12-12 -260 val_260 2012-12-12 -404 val_404 2012-12-12 -384 val_384 2012-12-12 -489 val_489 2012-12-12 -353 val_353 2012-12-12 -373 val_373 2012-12-12 -272 val_272 2012-12-12 -217 val_217 2012-12-12 -84 val_84 2012-12-12 -348 val_348 2012-12-12 -466 val_466 2012-12-12 -58 val_58 2012-12-12 -8 val_8 2012-12-12 -411 val_411 2012-12-12 -230 val_230 2012-12-12 -208 val_208 2012-12-12 -348 val_348 2012-12-12 -24 val_24 2012-12-12 -463 val_463 2012-12-12 -431 val_431 2012-12-12 -42 val_42 2012-12-12 -496 val_496 2012-12-12 -322 val_322 2012-12-12 -468 val_468 2012-12-12 -393 val_393 2012-12-12 -454 val_454 2012-12-12 -298 val_298 2012-12-12 -418 val_418 2012-12-12 -96 val_96 2012-12-12 -26 val_26 2012-12-12 -327 val_327 2012-12-12 -230 val_230 2012-12-12 -205 val_205 2012-12-12 -51 val_51 2012-12-12 -404 val_404 2012-12-12 -43 val_43 2012-12-12 -436 val_436 2012-12-12 -469 val_469 2012-12-12 -468 val_468 2012-12-12 -308 val_308 2012-12-12 -95 val_95 2012-12-12 -288 val_288 2012-12-12 -481 val_481 2012-12-12 -457 val_457 2012-12-12 -98 val_98 2012-12-12 -282 val_282 2012-12-12 -318 val_318 2012-12-12 -318 val_318 2012-12-12 -409 val_409 2012-12-12 -470 val_470 2012-12-12 -369 val_369 2012-12-12 -316 val_316 2012-12-12 -413 val_413 2012-12-12 -85 val_85 2012-12-12 -77 val_77 2012-12-12 -490 val_490 2012-12-12 -87 val_87 2012-12-12 -364 val_364 2012-12-12 -395 val_395 2012-12-12 -282 val_282 2012-12-12 -238 val_238 2012-12-12 -419 val_419 2012-12-12 -72 val_72 2012-12-12 -90 val_90 2012-12-12 -307 val_307 2012-12-12 -435 val_435 2012-12-12 -277 val_277 2012-12-12 -273 val_273 2012-12-12 -306 val_306 2012-12-12 -224 val_224 2012-12-12 -309 val_309 2012-12-12 -389 val_389 2012-12-12 -327 val_327 2012-12-12 -242 val_242 2012-12-12 -369 val_369 2012-12-12 -392 val_392 2012-12-12 -272 val_272 2012-12-12 -331 val_331 2012-12-12 -401 val_401 2012-12-12 -242 val_242 2012-12-12 -452 val_452 2012-12-12 -226 val_226 2012-12-12 -5 val_5 2012-12-12 -497 val_497 2012-12-12 -402 val_402 2012-12-12 -396 val_396 2012-12-12 -317 val_317 2012-12-12 -395 val_395 2012-12-12 -58 val_58 2012-12-12 -35 val_35 2012-12-12 -336 val_336 2012-12-12 -95 val_95 2012-12-12 -34 val_34 2012-12-12 -229 val_229 2012-12-12 -233 val_233 2012-12-12 -472 val_472 2012-12-12 -322 val_322 2012-12-12 -498 val_498 2012-12-12 -42 val_42 2012-12-12 -321 val_321 2012-12-12 -430 val_430 2012-12-12 -489 val_489 2012-12-12 -458 val_458 2012-12-12 -78 val_78 2012-12-12 -76 val_76 2012-12-12 -41 val_41 2012-12-12 -223 val_223 2012-12-12 -492 val_492 2012-12-12 -449 val_449 2012-12-12 -218 val_218 2012-12-12 -228 val_228 2012-12-12 -453 val_453 2012-12-12 -30 val_30 2012-12-12 -209 val_209 2012-12-12 -64 val_64 2012-12-12 -468 val_468 2012-12-12 -76 val_76 2012-12-12 -74 val_74 2012-12-12 -342 val_342 2012-12-12 -69 val_69 2012-12-12 -230 val_230 2012-12-12 -33 val_33 2012-12-12 -368 val_368 2012-12-12 -296 val_296 2012-12-12 -216 val_216 2012-12-12 -367 val_367 2012-12-12 -344 val_344 2012-12-12 -274 val_274 2012-12-12 -219 val_219 2012-12-12 -239 val_239 2012-12-12 -485 val_485 2012-12-12 -223 val_223 2012-12-12 -256 val_256 2012-12-12 -263 val_263 2012-12-12 -70 val_70 2012-12-12 -487 val_487 2012-12-12 -480 val_480 2012-12-12 -401 val_401 2012-12-12 -288 val_288 2012-12-12 -5 val_5 2012-12-12 -244 val_244 2012-12-12 -438 val_438 2012-12-12 -467 val_467 2012-12-12 -432 val_432 2012-12-12 -202 val_202 2012-12-12 -316 val_316 2012-12-12 -229 val_229 2012-12-12 -469 val_469 2012-12-12 -463 val_463 2012-12-12 -280 val_280 2012-12-12 -35 val_35 2012-12-12 -283 val_283 2012-12-12 -331 val_331 2012-12-12 -235 val_235 2012-12-12 -80 val_80 2012-12-12 -44 val_44 2012-12-12 -321 val_321 2012-12-12 -335 val_335 2012-12-12 -466 val_466 2012-12-12 -366 val_366 2012-12-12 -403 val_403 2012-12-12 -483 val_483 2012-12-12 -53 val_53 2012-12-12 -257 val_257 2012-12-12 -406 val_406 2012-12-12 -409 val_409 2012-12-12 -406 val_406 2012-12-12 -401 val_401 2012-12-12 -258 val_258 2012-12-12 -90 val_90 2012-12-12 -203 val_203 2012-12-12 -262 val_262 2012-12-12 -348 val_348 2012-12-12 -424 val_424 2012-12-12 -396 val_396 2012-12-12 -201 val_201 2012-12-12 -217 val_217 2012-12-12 -431 val_431 2012-12-12 -454 val_454 2012-12-12 -478 val_478 2012-12-12 -298 val_298 2012-12-12 -431 val_431 2012-12-12 -424 val_424 2012-12-12 -382 val_382 2012-12-12 -5 val_5 2012-12-12 -70 val_70 2012-12-12 -397 val_397 2012-12-12 -480 val_480 2012-12-12 -291 val_291 2012-12-12 -24 val_24 2012-12-12 -351 val_351 2012-12-12 -255 val_255 2012-12-12 -70 val_70 2012-12-12 -438 val_438 2012-12-12 -414 val_414 2012-12-12 -491 val_491 2012-12-12 -237 val_237 2012-12-12 -439 val_439 2012-12-12 -360 val_360 2012-12-12 -248 val_248 2012-12-12 -479 val_479 2012-12-12 -305 val_305 2012-12-12 -417 val_417 2012-12-12 -444 val_444 2012-12-12 -429 val_429 2012-12-12 -443 val_443 2012-12-12 -323 val_323 2012-12-12 -325 val_325 2012-12-12 -277 val_277 2012-12-12 -230 val_230 2012-12-12 -478 val_478 2012-12-12 -468 val_468 2012-12-12 -310 val_310 2012-12-12 -317 val_317 2012-12-12 -333 val_333 2012-12-12 -493 val_493 2012-12-12 -460 val_460 2012-12-12 -207 val_207 2012-12-12 -249 val_249 2012-12-12 -265 val_265 2012-12-12 -480 val_480 2012-12-12 -83 val_83 2012-12-12 -353 val_353 2012-12-12 -214 val_214 2012-12-12 -462 val_462 2012-12-12 -233 val_233 2012-12-12 -406 val_406 2012-12-12 -454 val_454 2012-12-12 -375 val_375 2012-12-12 -401 val_401 2012-12-12 -421 val_421 2012-12-12 -407 val_407 2012-12-12 -384 val_384 2012-12-12 -256 val_256 2012-12-12 -26 val_26 2012-12-12 -67 val_67 2012-12-12 -384 val_384 2012-12-12 -379 val_379 2012-12-12 -462 val_462 2012-12-12 -492 val_492 2012-12-12 -298 val_298 2012-12-12 -9 val_9 2012-12-12 -341 val_341 2012-12-12 -498 val_498 2012-12-12 -458 val_458 2012-12-12 -362 val_362 2012-12-12 -285 val_285 2012-12-12 -348 val_348 2012-12-12 -273 val_273 2012-12-12 -281 val_281 2012-12-12 -344 val_344 2012-12-12 -97 val_97 2012-12-12 -469 val_469 2012-12-12 -315 val_315 2012-12-12 -84 val_84 2012-12-12 -28 val_28 2012-12-12 -37 val_37 2012-12-12 -448 val_448 2012-12-12 -348 val_348 2012-12-12 -307 val_307 2012-12-12 -414 val_414 2012-12-12 -477 val_477 2012-12-12 -222 val_222 2012-12-12 -90 val_90 2012-12-12 -403 val_403 2012-12-12 -400 val_400 2012-12-12 -97 val_97 2012-12-12 -PREHOOK: query: EXPLAIN SELECT * FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT * FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15 -POSTHOOK: type: QUERY -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -ABSTRACT SYNTAX TREE: - (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME npe_test))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_WHERE (OR (> (TOK_TABLE_OR_COL ds) (- (- 2012 11) 31)) (< (TOK_TABLE_OR_COL ds) (- (- 2012 12) 15)))))) - -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: - npe_test - TableScan - alias: npe_test - Filter Operator - predicate: - expr: ((ds > ((2012 - 11) - 31)) or (ds < ((2012 - 12) - 15))) - type: boolean - Select Operator - expressions: - expr: key - type: string - expr: value - type: string - expr: ds - 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 - - Stage: Stage-0 - Fetch Operator - limit: -1 - - -PREHOOK: query: SELECT * FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15 -PREHOOK: type: QUERY -PREHOOK: Input: default@npe_test@ds=2012-12-11 -PREHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM npe_test WHERE ds > 2012-11-31 OR ds < 2012-12-15 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@npe_test@ds=2012-12-11 -POSTHOOK: Input: default@npe_test@ds=2012-12-12 -#### A masked pattern was here #### -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: DROP TABLE npe_test -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@npe_test -PREHOOK: Output: default@npe_test -POSTHOOK: query: DROP TABLE npe_test -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@npe_test -POSTHOOK: Output: default@npe_test -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-11).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: npe_test PARTITION(ds=2012-12-12).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]