hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From gunt...@apache.org
Subject 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...
Date Wed, 16 Oct 2013 20:28:20 GMT
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);
   }
 



Mime
View raw message