hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ser...@apache.org
Subject svn commit: r1669718 [18/29] - in /hive/branches/llap: ./ ant/src/org/apache/hadoop/hive/ant/ common/src/java/org/apache/hadoop/hive/common/ common/src/java/org/apache/hadoop/hive/common/type/ common/src/java/org/apache/hadoop/hive/conf/ common/src/jav...
Date Sat, 28 Mar 2015 00:22:27 GMT
Added: hive/branches/llap/ql/src/test/results/clientpositive/encrypted/encryption_unencrypted_nonhdfs_external_tables.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/encrypted/encryption_unencrypted_nonhdfs_external_tables.q.out?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/encrypted/encryption_unencrypted_nonhdfs_external_tables.q.out (added)
+++ hive/branches/llap/ql/src/test/results/clientpositive/encrypted/encryption_unencrypted_nonhdfs_external_tables.q.out Sat Mar 28 00:22:15 2015
@@ -0,0 +1,546 @@
+PREHOOK: query: -- This test does not test encrypted data, but it makes sure that external tables out of HDFS can
+-- be queried due to internal encryption functions;
+
+DROP TABLE mydata
+PREHOOK: type: DROPTABLE
+POSTHOOK: query: -- This test does not test encrypted data, but it makes sure that external tables out of HDFS can
+-- be queried due to internal encryption functions;
+
+DROP TABLE mydata
+POSTHOOK: type: DROPTABLE
+PREHOOK: query: CREATE EXTERNAL TABLE mydata (key STRING, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' '
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+#### A masked pattern was here ####
+PREHOOK: Output: database:default
+PREHOOK: Output: default@mydata
+POSTHOOK: query: CREATE EXTERNAL TABLE mydata (key STRING, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY ' '
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+#### A masked pattern was here ####
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@mydata
+PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' OVERWRITE INTO TABLE mydata
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@mydata
+POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' OVERWRITE INTO TABLE mydata
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@mydata
+PREHOOK: query: SELECT * from mydata
+PREHOOK: type: QUERY
+PREHOOK: Input: default@mydata
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * from mydata
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@mydata
+#### A masked pattern was here ####
+238val_238	NULL
+86val_86	NULL
+311val_311	NULL
+27val_27	NULL
+165val_165	NULL
+409val_409	NULL
+255val_255	NULL
+278val_278	NULL
+98val_98	NULL
+484val_484	NULL
+265val_265	NULL
+193val_193	NULL
+401val_401	NULL
+150val_150	NULL
+273val_273	NULL
+224val_224	NULL
+369val_369	NULL
+66val_66	NULL
+128val_128	NULL
+213val_213	NULL
+146val_146	NULL
+406val_406	NULL
+429val_429	NULL
+374val_374	NULL
+152val_152	NULL
+469val_469	NULL
+145val_145	NULL
+495val_495	NULL
+37val_37	NULL
+327val_327	NULL
+281val_281	NULL
+277val_277	NULL
+209val_209	NULL
+15val_15	NULL
+82val_82	NULL
+403val_403	NULL
+166val_166	NULL
+417val_417	NULL
+430val_430	NULL
+252val_252	NULL
+292val_292	NULL
+219val_219	NULL
+287val_287	NULL
+153val_153	NULL
+193val_193	NULL
+338val_338	NULL
+446val_446	NULL
+459val_459	NULL
+394val_394	NULL
+237val_237	NULL
+482val_482	NULL
+174val_174	NULL
+413val_413	NULL
+494val_494	NULL
+207val_207	NULL
+199val_199	NULL
+466val_466	NULL
+208val_208	NULL
+174val_174	NULL
+399val_399	NULL
+396val_396	NULL
+247val_247	NULL
+417val_417	NULL
+489val_489	NULL
+162val_162	NULL
+377val_377	NULL
+397val_397	NULL
+309val_309	NULL
+365val_365	NULL
+266val_266	NULL
+439val_439	NULL
+342val_342	NULL
+367val_367	NULL
+325val_325	NULL
+167val_167	NULL
+195val_195	NULL
+475val_475	NULL
+17val_17	NULL
+113val_113	NULL
+155val_155	NULL
+203val_203	NULL
+339val_339	NULL
+0val_0	NULL
+455val_455	NULL
+128val_128	NULL
+311val_311	NULL
+316val_316	NULL
+57val_57	NULL
+302val_302	NULL
+205val_205	NULL
+149val_149	NULL
+438val_438	NULL
+345val_345	NULL
+129val_129	NULL
+170val_170	NULL
+20val_20	NULL
+489val_489	NULL
+157val_157	NULL
+378val_378	NULL
+221val_221	NULL
+92val_92	NULL
+111val_111	NULL
+47val_47	NULL
+72val_72	NULL
+4val_4	NULL
+280val_280	NULL
+35val_35	NULL
+427val_427	NULL
+277val_277	NULL
+208val_208	NULL
+356val_356	NULL
+399val_399	NULL
+169val_169	NULL
+382val_382	NULL
+498val_498	NULL
+125val_125	NULL
+386val_386	NULL
+437val_437	NULL
+469val_469	NULL
+192val_192	NULL
+286val_286	NULL
+187val_187	NULL
+176val_176	NULL
+54val_54	NULL
+459val_459	NULL
+51val_51	NULL
+138val_138	NULL
+103val_103	NULL
+239val_239	NULL
+213val_213	NULL
+216val_216	NULL
+430val_430	NULL
+278val_278	NULL
+176val_176	NULL
+289val_289	NULL
+221val_221	NULL
+65val_65	NULL
+318val_318	NULL
+332val_332	NULL
+311val_311	NULL
+275val_275	NULL
+137val_137	NULL
+241val_241	NULL
+83val_83	NULL
+333val_333	NULL
+180val_180	NULL
+284val_284	NULL
+12val_12	NULL
+230val_230	NULL
+181val_181	NULL
+67val_67	NULL
+260val_260	NULL
+404val_404	NULL
+384val_384	NULL
+489val_489	NULL
+353val_353	NULL
+373val_373	NULL
+272val_272	NULL
+138val_138	NULL
+217val_217	NULL
+84val_84	NULL
+348val_348	NULL
+466val_466	NULL
+58val_58	NULL
+8val_8	NULL
+411val_411	NULL
+230val_230	NULL
+208val_208	NULL
+348val_348	NULL
+24val_24	NULL
+463val_463	NULL
+431val_431	NULL
+179val_179	NULL
+172val_172	NULL
+42val_42	NULL
+129val_129	NULL
+158val_158	NULL
+119val_119	NULL
+496val_496	NULL
+0val_0	NULL
+322val_322	NULL
+197val_197	NULL
+468val_468	NULL
+393val_393	NULL
+454val_454	NULL
+100val_100	NULL
+298val_298	NULL
+199val_199	NULL
+191val_191	NULL
+418val_418	NULL
+96val_96	NULL
+26val_26	NULL
+165val_165	NULL
+327val_327	NULL
+230val_230	NULL
+205val_205	NULL
+120val_120	NULL
+131val_131	NULL
+51val_51	NULL
+404val_404	NULL
+43val_43	NULL
+436val_436	NULL
+156val_156	NULL
+469val_469	NULL
+468val_468	NULL
+308val_308	NULL
+95val_95	NULL
+196val_196	NULL
+288val_288	NULL
+481val_481	NULL
+457val_457	NULL
+98val_98	NULL
+282val_282	NULL
+197val_197	NULL
+187val_187	NULL
+318val_318	NULL
+318val_318	NULL
+409val_409	NULL
+470val_470	NULL
+137val_137	NULL
+369val_369	NULL
+316val_316	NULL
+169val_169	NULL
+413val_413	NULL
+85val_85	NULL
+77val_77	NULL
+0val_0	NULL
+490val_490	NULL
+87val_87	NULL
+364val_364	NULL
+179val_179	NULL
+118val_118	NULL
+134val_134	NULL
+395val_395	NULL
+282val_282	NULL
+138val_138	NULL
+238val_238	NULL
+419val_419	NULL
+15val_15	NULL
+118val_118	NULL
+72val_72	NULL
+90val_90	NULL
+307val_307	NULL
+19val_19	NULL
+435val_435	NULL
+10val_10	NULL
+277val_277	NULL
+273val_273	NULL
+306val_306	NULL
+224val_224	NULL
+309val_309	NULL
+389val_389	NULL
+327val_327	NULL
+242val_242	NULL
+369val_369	NULL
+392val_392	NULL
+272val_272	NULL
+331val_331	NULL
+401val_401	NULL
+242val_242	NULL
+452val_452	NULL
+177val_177	NULL
+226val_226	NULL
+5val_5	NULL
+497val_497	NULL
+402val_402	NULL
+396val_396	NULL
+317val_317	NULL
+395val_395	NULL
+58val_58	NULL
+35val_35	NULL
+336val_336	NULL
+95val_95	NULL
+11val_11	NULL
+168val_168	NULL
+34val_34	NULL
+229val_229	NULL
+233val_233	NULL
+143val_143	NULL
+472val_472	NULL
+322val_322	NULL
+498val_498	NULL
+160val_160	NULL
+195val_195	NULL
+42val_42	NULL
+321val_321	NULL
+430val_430	NULL
+119val_119	NULL
+489val_489	NULL
+458val_458	NULL
+78val_78	NULL
+76val_76	NULL
+41val_41	NULL
+223val_223	NULL
+492val_492	NULL
+149val_149	NULL
+449val_449	NULL
+218val_218	NULL
+228val_228	NULL
+138val_138	NULL
+453val_453	NULL
+30val_30	NULL
+209val_209	NULL
+64val_64	NULL
+468val_468	NULL
+76val_76	NULL
+74val_74	NULL
+342val_342	NULL
+69val_69	NULL
+230val_230	NULL
+33val_33	NULL
+368val_368	NULL
+103val_103	NULL
+296val_296	NULL
+113val_113	NULL
+216val_216	NULL
+367val_367	NULL
+344val_344	NULL
+167val_167	NULL
+274val_274	NULL
+219val_219	NULL
+239val_239	NULL
+485val_485	NULL
+116val_116	NULL
+223val_223	NULL
+256val_256	NULL
+263val_263	NULL
+70val_70	NULL
+487val_487	NULL
+480val_480	NULL
+401val_401	NULL
+288val_288	NULL
+191val_191	NULL
+5val_5	NULL
+244val_244	NULL
+438val_438	NULL
+128val_128	NULL
+467val_467	NULL
+432val_432	NULL
+202val_202	NULL
+316val_316	NULL
+229val_229	NULL
+469val_469	NULL
+463val_463	NULL
+280val_280	NULL
+2val_2	NULL
+35val_35	NULL
+283val_283	NULL
+331val_331	NULL
+235val_235	NULL
+80val_80	NULL
+44val_44	NULL
+193val_193	NULL
+321val_321	NULL
+335val_335	NULL
+104val_104	NULL
+466val_466	NULL
+366val_366	NULL
+175val_175	NULL
+403val_403	NULL
+483val_483	NULL
+53val_53	NULL
+105val_105	NULL
+257val_257	NULL
+406val_406	NULL
+409val_409	NULL
+190val_190	NULL
+406val_406	NULL
+401val_401	NULL
+114val_114	NULL
+258val_258	NULL
+90val_90	NULL
+203val_203	NULL
+262val_262	NULL
+348val_348	NULL
+424val_424	NULL
+12val_12	NULL
+396val_396	NULL
+201val_201	NULL
+217val_217	NULL
+164val_164	NULL
+431val_431	NULL
+454val_454	NULL
+478val_478	NULL
+298val_298	NULL
+125val_125	NULL
+431val_431	NULL
+164val_164	NULL
+424val_424	NULL
+187val_187	NULL
+382val_382	NULL
+5val_5	NULL
+70val_70	NULL
+397val_397	NULL
+480val_480	NULL
+291val_291	NULL
+24val_24	NULL
+351val_351	NULL
+255val_255	NULL
+104val_104	NULL
+70val_70	NULL
+163val_163	NULL
+438val_438	NULL
+119val_119	NULL
+414val_414	NULL
+200val_200	NULL
+491val_491	NULL
+237val_237	NULL
+439val_439	NULL
+360val_360	NULL
+248val_248	NULL
+479val_479	NULL
+305val_305	NULL
+417val_417	NULL
+199val_199	NULL
+444val_444	NULL
+120val_120	NULL
+429val_429	NULL
+169val_169	NULL
+443val_443	NULL
+323val_323	NULL
+325val_325	NULL
+277val_277	NULL
+230val_230	NULL
+478val_478	NULL
+178val_178	NULL
+468val_468	NULL
+310val_310	NULL
+317val_317	NULL
+333val_333	NULL
+493val_493	NULL
+460val_460	NULL
+207val_207	NULL
+249val_249	NULL
+265val_265	NULL
+480val_480	NULL
+83val_83	NULL
+136val_136	NULL
+353val_353	NULL
+172val_172	NULL
+214val_214	NULL
+462val_462	NULL
+233val_233	NULL
+406val_406	NULL
+133val_133	NULL
+175val_175	NULL
+189val_189	NULL
+454val_454	NULL
+375val_375	NULL
+401val_401	NULL
+421val_421	NULL
+407val_407	NULL
+384val_384	NULL
+256val_256	NULL
+26val_26	NULL
+134val_134	NULL
+67val_67	NULL
+384val_384	NULL
+379val_379	NULL
+18val_18	NULL
+462val_462	NULL
+492val_492	NULL
+100val_100	NULL
+298val_298	NULL
+9val_9	NULL
+341val_341	NULL
+498val_498	NULL
+146val_146	NULL
+458val_458	NULL
+362val_362	NULL
+186val_186	NULL
+285val_285	NULL
+348val_348	NULL
+167val_167	NULL
+18val_18	NULL
+273val_273	NULL
+183val_183	NULL
+281val_281	NULL
+344val_344	NULL
+97val_97	NULL
+469val_469	NULL
+315val_315	NULL
+84val_84	NULL
+28val_28	NULL
+37val_37	NULL
+448val_448	NULL
+152val_152	NULL
+348val_348	NULL
+307val_307	NULL
+194val_194	NULL
+414val_414	NULL
+477val_477	NULL
+222val_222	NULL
+126val_126	NULL
+90val_90	NULL
+169val_169	NULL
+403val_403	NULL
+400val_400	NULL
+200val_200	NULL
+97val_97	NULL
+PREHOOK: query: DROP TABLE mydata
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@mydata
+PREHOOK: Output: default@mydata
+POSTHOOK: query: DROP TABLE mydata
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@mydata
+POSTHOOK: Output: default@mydata

Modified: hive/branches/llap/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out?rev=1669718&r1=1669717&r2=1669718&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/extrapolate_part_stats_full.q.out Sat Mar 28 00:22:15 2015
@@ -136,7 +136,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 362
+              totalSize 375
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -179,7 +179,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 382
+              totalSize 397
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -269,7 +269,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 362
+              totalSize 375
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -312,7 +312,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 382
+              totalSize 397
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -469,7 +469,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 277
+              totalSize 290
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -513,7 +513,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 279
+              totalSize 291
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -557,7 +557,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 261
+              totalSize 274
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -601,7 +601,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 261
+              totalSize 274
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -688,7 +688,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 277
+              totalSize 290
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -732,7 +732,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 279
+              totalSize 291
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -776,7 +776,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 261
+              totalSize 274
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -820,7 +820,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 261
+              totalSize 274
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           

Modified: hive/branches/llap/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out?rev=1669718&r1=1669717&r2=1669718&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/extrapolate_part_stats_partial.q.out Sat Mar 28 00:22:15 2015
@@ -153,7 +153,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 362
+              totalSize 375
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -196,7 +196,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 383
+              totalSize 398
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -239,7 +239,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 404
+              totalSize 418
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -282,7 +282,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 412
+              totalSize 427
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -372,7 +372,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 362
+              totalSize 375
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -415,7 +415,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 383
+              totalSize 398
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -458,7 +458,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 404
+              totalSize 418
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -501,7 +501,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 412
+              totalSize 427
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -604,7 +604,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 362
+              totalSize 375
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -647,7 +647,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 383
+              totalSize 398
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -690,7 +690,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 404
+              totalSize 418
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -733,7 +733,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 412
+              totalSize 427
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -819,7 +819,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 362
+              totalSize 375
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -862,7 +862,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 383
+              totalSize 398
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -905,7 +905,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 404
+              totalSize 418
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -948,7 +948,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_1d { string state, i32 locid, i32 zip}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 412
+              totalSize 427
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1106,7 +1106,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 281
+              totalSize 293
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1150,7 +1150,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 291
+              totalSize 303
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1194,7 +1194,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 298
+              totalSize 312
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1238,7 +1238,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 277
+              totalSize 290
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1282,7 +1282,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 272
+              totalSize 285
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1326,7 +1326,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 283
+              totalSize 295
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1370,7 +1370,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 292
+              totalSize 305
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1414,7 +1414,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 261
+              totalSize 274
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1458,7 +1458,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 261
+              totalSize 274
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1502,7 +1502,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 294
+              totalSize 306
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1546,7 +1546,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 291
+              totalSize 305
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1633,7 +1633,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 281
+              totalSize 293
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1677,7 +1677,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 291
+              totalSize 303
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1721,7 +1721,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 298
+              totalSize 312
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1765,7 +1765,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 277
+              totalSize 290
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1809,7 +1809,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 272
+              totalSize 285
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1853,7 +1853,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 283
+              totalSize 295
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1897,7 +1897,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 292
+              totalSize 305
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1941,7 +1941,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 261
+              totalSize 274
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -1985,7 +1985,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 261
+              totalSize 274
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -2029,7 +2029,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 294
+              totalSize 306
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           
@@ -2073,7 +2073,7 @@ STAGE PLANS:
               serialization.ddl struct loc_orc_2d { string state, i32 locid}
               serialization.format 1
               serialization.lib org.apache.hadoop.hive.ql.io.orc.OrcSerde
-              totalSize 291
+              totalSize 305
 #### A masked pattern was here ####
             serde: org.apache.hadoop.hive.ql.io.orc.OrcSerde
           

Modified: hive/branches/llap/ql/src/test/results/clientpositive/groupby_cube1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/groupby_cube1.q.out?rev=1669718&r1=1669717&r2=1669718&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/groupby_cube1.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/groupby_cube1.q.out Sat Mar 28 00:22:15 2015
@@ -206,11 +206,11 @@ STAGE PLANS:
             Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
             Select Operator
               expressions: key (type: string), val (type: string)
-              outputColumnNames: key, val
+              outputColumnNames: _col0, _col1
               Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
               Group By Operator
-                aggregations: count(DISTINCT val)
-                keys: key (type: string), '0' (type: string), val (type: string)
+                aggregations: count(DISTINCT _col1)
+                keys: _col0 (type: string), '0' (type: string), _col1 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -388,11 +388,11 @@ STAGE PLANS:
             Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
             Select Operator
               expressions: key (type: string), val (type: string)
-              outputColumnNames: key, val
+              outputColumnNames: _col0, _col1
               Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
               Group By Operator
-                aggregations: count(DISTINCT val)
-                keys: key (type: string), '0' (type: string), val (type: string)
+                aggregations: count(DISTINCT _col1)
+                keys: _col0 (type: string), '0' (type: string), _col1 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE

Modified: hive/branches/llap/ql/src/test/results/clientpositive/groupby_rollup1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/groupby_rollup1.q.out?rev=1669718&r1=1669717&r2=1669718&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/groupby_rollup1.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/groupby_rollup1.q.out Sat Mar 28 00:22:15 2015
@@ -116,11 +116,11 @@ STAGE PLANS:
             Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
             Select Operator
               expressions: key (type: string), val (type: string)
-              outputColumnNames: key, val
+              outputColumnNames: _col0, _col1
               Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
               Group By Operator
-                aggregations: count(DISTINCT val)
-                keys: key (type: string), '0' (type: string), val (type: string)
+                aggregations: count(DISTINCT _col1)
+                keys: _col0 (type: string), '0' (type: string), _col1 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -292,11 +292,11 @@ STAGE PLANS:
             Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
             Select Operator
               expressions: key (type: string), val (type: string)
-              outputColumnNames: key, val
+              outputColumnNames: _col0, _col1
               Statistics: Num rows: 0 Data size: 30 Basic stats: PARTIAL Column stats: NONE
               Group By Operator
-                aggregations: count(DISTINCT val)
-                keys: key (type: string), '0' (type: string), val (type: string)
+                aggregations: count(DISTINCT _col1)
+                keys: _col0 (type: string), '0' (type: string), _col1 (type: string)
                 mode: hash
                 outputColumnNames: _col0, _col1, _col2, _col3
                 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE

Added: hive/branches/llap/ql/src/test/results/clientpositive/interval_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/interval_1.q.out?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/interval_1.q.out (added)
+++ hive/branches/llap/ql/src/test/results/clientpositive/interval_1.q.out Sat Mar 28 00:22:15 2015
@@ -0,0 +1,116 @@
+PREHOOK: query: select
+  interval '10-11' year to month,
+  interval '10' year,
+  interval '11' month
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  interval '10-11' year to month,
+  interval '10' year,
+  interval '11' month
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+10-11	10-0	0-11
+PREHOOK: query: select
+  interval_year_month('10-11'),
+  interval_year_month(cast('10-11' as string)),
+  interval_year_month(cast('10-11' as varchar(10))),
+  interval_year_month(cast('10-11' as char(10))),
+  interval_year_month('10-11') = interval '10-11' year to month
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  interval_year_month('10-11'),
+  interval_year_month(cast('10-11' as string)),
+  interval_year_month(cast('10-11' as varchar(10))),
+  interval_year_month(cast('10-11' as char(10))),
+  interval_year_month('10-11') = interval '10-11' year to month
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+10-11	10-11	10-11	10-11	true
+PREHOOK: query: -- Test normalization of interval values
+select
+  interval '49' month
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- Test normalization of interval values
+select
+  interval '49' month
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+4-1
+PREHOOK: query: select
+  interval '10 9:8:7.987654321' day to second,
+  interval '10' day,
+  interval '11' hour,
+  interval '12' minute,
+  interval '13' second,
+  interval '13.123456789' second
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  interval '10 9:8:7.987654321' day to second,
+  interval '10' day,
+  interval '11' hour,
+  interval '12' minute,
+  interval '13' second,
+  interval '13.123456789' second
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+10 09:08:07.987654321	10 00:00:00.000000000	0 11:00:00.000000000	0 00:12:00.000000000	0 00:00:13.000000000	0 00:00:13.123456789
+PREHOOK: query: select
+  interval_day_time('2 1:2:3'),
+  interval_day_time(cast('2 1:2:3' as string)),
+  interval_day_time(cast('2 1:2:3' as varchar(10))),
+  interval_day_time(cast('2 1:2:3' as char(10))),
+  interval_day_time('2 1:2:3') = interval '2 1:2:3' day to second
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  interval_day_time('2 1:2:3'),
+  interval_day_time(cast('2 1:2:3' as string)),
+  interval_day_time(cast('2 1:2:3' as varchar(10))),
+  interval_day_time(cast('2 1:2:3' as char(10))),
+  interval_day_time('2 1:2:3') = interval '2 1:2:3' day to second
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+2 01:02:03.000000000	2 01:02:03.000000000	2 01:02:03.000000000	2 01:02:03.000000000	true
+PREHOOK: query: -- Test normalization of interval values
+select
+  interval '49' hour,
+  interval '1470' minute,
+  interval '90061.111111111' second
+from src limit 1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- Test normalization of interval values
+select
+  interval '49' hour,
+  interval '1470' minute,
+  interval '90061.111111111' second
+from src limit 1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+2 01:00:00.000000000	1 00:30:00.000000000	1 01:01:01.111111111

Added: hive/branches/llap/ql/src/test/results/clientpositive/interval_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/interval_2.q.out?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/interval_2.q.out (added)
+++ hive/branches/llap/ql/src/test/results/clientpositive/interval_2.q.out Sat Mar 28 00:22:15 2015
@@ -0,0 +1,231 @@
+PREHOOK: query: -- group-by/order-by/aggregation functions
+
+select
+  iym, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by iym 
+order by iym asc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- group-by/order-by/aggregation functions
+
+select
+  iym, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by iym 
+order by iym asc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+0-1	3	0	0	0-1	0-1	0 01:01:01.000000000	0 01:01:01.000000000
+2-1	1	2	2	2-1	2-1	2 01:01:01.000000000	2 01:01:01.000000000
+4-1	1	4	4	4-1	4-1	4 01:01:01.000000000	4 01:01:01.000000000
+5-1	3	5	5	5-1	5-1	5 01:01:01.000000000	5 01:01:01.000000000
+8-1	1	8	8	8-1	8-1	8 01:01:01.000000000	8 01:01:01.000000000
+PREHOOK: query: select
+  iym, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by iym 
+order by iym desc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  iym, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by iym 
+order by iym desc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+498-1	3	498	498	498-1	498-1	498 01:01:01.000000000	498 01:01:01.000000000
+497-1	1	497	497	497-1	497-1	497 01:01:01.000000000	497 01:01:01.000000000
+496-1	1	496	496	496-1	496-1	496 01:01:01.000000000	496 01:01:01.000000000
+495-1	1	495	495	495-1	495-1	495 01:01:01.000000000	495 01:01:01.000000000
+494-1	1	494	494	494-1	494-1	494 01:01:01.000000000	494 01:01:01.000000000
+PREHOOK: query: -- same query as previous, with having clause
+select
+  iym, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by iym 
+having max(idt) > interval '496 0:0:0' day to second
+order by iym desc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- same query as previous, with having clause
+select
+  iym, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by iym 
+having max(idt) > interval '496 0:0:0' day to second
+order by iym desc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+498-1	3	498	498	498-1	498-1	498 01:01:01.000000000	498 01:01:01.000000000
+497-1	1	497	497	497-1	497-1	497 01:01:01.000000000	497 01:01:01.000000000
+496-1	1	496	496	496-1	496-1	496 01:01:01.000000000	496 01:01:01.000000000
+PREHOOK: query: select
+  idt, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by idt 
+order by idt asc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  idt, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by idt 
+order by idt asc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+0 01:01:01.000000000	3	0	0	0-1	0-1	0 01:01:01.000000000	0 01:01:01.000000000
+2 01:01:01.000000000	1	2	2	2-1	2-1	2 01:01:01.000000000	2 01:01:01.000000000
+4 01:01:01.000000000	1	4	4	4-1	4-1	4 01:01:01.000000000	4 01:01:01.000000000
+5 01:01:01.000000000	3	5	5	5-1	5-1	5 01:01:01.000000000	5 01:01:01.000000000
+8 01:01:01.000000000	1	8	8	8-1	8-1	8 01:01:01.000000000	8 01:01:01.000000000
+PREHOOK: query: select
+  idt, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by idt 
+order by idt desc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  idt, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by idt 
+order by idt desc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+498 01:01:01.000000000	3	498	498	498-1	498-1	498 01:01:01.000000000	498 01:01:01.000000000
+497 01:01:01.000000000	1	497	497	497-1	497-1	497 01:01:01.000000000	497 01:01:01.000000000
+496 01:01:01.000000000	1	496	496	496-1	496-1	496 01:01:01.000000000	496 01:01:01.000000000
+495 01:01:01.000000000	1	495	495	495-1	495-1	495 01:01:01.000000000	495 01:01:01.000000000
+494 01:01:01.000000000	1	494	494	494-1	494-1	494 01:01:01.000000000	494 01:01:01.000000000
+PREHOOK: query: -- same query as previous, with having clause
+select
+  idt, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by idt 
+having max(iym) < interval '496-0' year to month
+order by idt desc
+limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- same query as previous, with having clause
+select
+  idt, count(*), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+group by idt 
+having max(iym) < interval '496-0' year to month
+order by idt desc
+limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+495 01:01:01.000000000	1	495	495	495-1	495-1	495 01:01:01.000000000	495 01:01:01.000000000
+494 01:01:01.000000000	1	494	494	494-1	494-1	494 01:01:01.000000000	494 01:01:01.000000000
+493 01:01:01.000000000	1	493	493	493-1	493-1	493 01:01:01.000000000	493 01:01:01.000000000
+492 01:01:01.000000000	2	492	492	492-1	492-1	492 01:01:01.000000000	492 01:01:01.000000000
+491 01:01:01.000000000	1	491	491	491-1	491-1	491 01:01:01.000000000	491 01:01:01.000000000
+PREHOOK: query: select
+  count(iym), count(idt), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  count(iym), count(idt), min(key), max(key), min(iym), max(iym), min(idt), max(idt)
+from (
+  select
+    key,
+    interval_year_month(concat(key, '-1')) as iym,
+    interval_day_time(concat(key, ' 1:1:1')) as idt
+  from src) q1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+500	500	0	98	0-1	498-1	0 01:01:01.000000000	498 01:01:01.000000000

Added: hive/branches/llap/ql/src/test/results/clientpositive/interval_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/interval_3.q.out?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/interval_3.q.out (added)
+++ hive/branches/llap/ql/src/test/results/clientpositive/interval_3.q.out Sat Mar 28 00:22:15 2015
@@ -0,0 +1,102 @@
+PREHOOK: query: -- where clause
+select
+  l_orderkey, l_shipdate, l_receiptdate
+from lineitem
+  where (cast(l_shipdate as date) - date '1992-01-01') < interval '365 0:0:0' day to second
+order by l_orderkey
+PREHOOK: type: QUERY
+PREHOOK: Input: default@lineitem
+#### A masked pattern was here ####
+POSTHOOK: query: -- where clause
+select
+  l_orderkey, l_shipdate, l_receiptdate
+from lineitem
+  where (cast(l_shipdate as date) - date '1992-01-01') < interval '365 0:0:0' day to second
+order by l_orderkey
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@lineitem
+#### A masked pattern was here ####
+6	1992-04-27	1992-05-02
+37	1992-07-10	1992-08-02
+37	1992-07-02	1992-07-28
+37	1992-07-21	1992-08-15
+PREHOOK: query: select
+  l_orderkey, l_shipdate, l_receiptdate
+from lineitem
+  where (cast(l_shipdate as date) + interval '1-0' year to month) <= date '1994-01-01'
+order by l_orderkey
+PREHOOK: type: QUERY
+PREHOOK: Input: default@lineitem
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  l_orderkey, l_shipdate, l_receiptdate
+from lineitem
+  where (cast(l_shipdate as date) + interval '1-0' year to month) <= date '1994-01-01'
+order by l_orderkey
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@lineitem
+#### A masked pattern was here ####
+6	1992-04-27	1992-05-02
+37	1992-07-10	1992-08-02
+37	1992-07-02	1992-07-28
+37	1992-07-21	1992-08-15
+PREHOOK: query: select
+  l_orderkey, l_shipdate, l_receiptdate
+from lineitem
+  where (cast(l_shipdate as date) + interval '1-0' year to month) <= date '1994-01-01'
+    and (cast(l_receiptdate as date) - cast(l_shipdate as date)) < interval '10' day
+order by l_orderkey
+PREHOOK: type: QUERY
+PREHOOK: Input: default@lineitem
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  l_orderkey, l_shipdate, l_receiptdate
+from lineitem
+  where (cast(l_shipdate as date) + interval '1-0' year to month) <= date '1994-01-01'
+    and (cast(l_receiptdate as date) - cast(l_shipdate as date)) < interval '10' day
+order by l_orderkey
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@lineitem
+#### A masked pattern was here ####
+6	1992-04-27	1992-05-02
+PREHOOK: query: -- joins
+select
+  a.l_orderkey, b.l_orderkey, a.interval1
+from
+  (
+    select
+      l_orderkey, l_shipdate, l_receiptdate, (cast(l_receiptdate as date) - cast(l_shipdate as date)) as interval1
+    from lineitem
+  ) a 
+  join
+  (
+    select
+      l_orderkey, l_shipdate, l_receiptdate, (cast(l_receiptdate as date) - date '1992-07-02') as interval2
+    from lineitem
+  ) b
+  on a.interval1 = b.interval2 and a.l_orderkey = b.l_orderkey
+order by a.l_orderkey
+PREHOOK: type: QUERY
+PREHOOK: Input: default@lineitem
+#### A masked pattern was here ####
+POSTHOOK: query: -- joins
+select
+  a.l_orderkey, b.l_orderkey, a.interval1
+from
+  (
+    select
+      l_orderkey, l_shipdate, l_receiptdate, (cast(l_receiptdate as date) - cast(l_shipdate as date)) as interval1
+    from lineitem
+  ) a 
+  join
+  (
+    select
+      l_orderkey, l_shipdate, l_receiptdate, (cast(l_receiptdate as date) - date '1992-07-02') as interval2
+    from lineitem
+  ) b
+  on a.interval1 = b.interval2 and a.l_orderkey = b.l_orderkey
+order by a.l_orderkey
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@lineitem
+#### A masked pattern was here ####
+37	37	26 00:00:00.000000000

Added: hive/branches/llap/ql/src/test/results/clientpositive/interval_arithmetic.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/interval_arithmetic.q.out?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/interval_arithmetic.q.out (added)
+++ hive/branches/llap/ql/src/test/results/clientpositive/interval_arithmetic.q.out Sat Mar 28 00:22:15 2015
@@ -0,0 +1,620 @@
+PREHOOK: query: create table interval_arithmetic_1 (dateval date, tsval timestamp)
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@interval_arithmetic_1
+POSTHOOK: query: create table interval_arithmetic_1 (dateval date, tsval timestamp)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@interval_arithmetic_1
+PREHOOK: query: insert overwrite table interval_arithmetic_1
+  select cast(ctimestamp1 as date), ctimestamp1 from alltypesorc
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@interval_arithmetic_1
+POSTHOOK: query: insert overwrite table interval_arithmetic_1
+  select cast(ctimestamp1 as date), ctimestamp1 from alltypesorc
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@interval_arithmetic_1
+POSTHOOK: Lineage: interval_arithmetic_1.dateval EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: interval_arithmetic_1.tsval SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
+PREHOOK: query: -- interval year-month arithmetic
+explain
+select
+  dateval,
+  dateval - interval '2-2' year to month,
+  dateval - interval '-2-2' year to month,
+  dateval + interval '2-2' year to month,
+  dateval + interval '-2-2' year to month,
+  - interval '2-2' year to month + dateval,
+  interval '2-2' year to month + dateval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: -- interval year-month arithmetic
+explain
+select
+  dateval,
+  dateval - interval '2-2' year to month,
+  dateval - interval '-2-2' year to month,
+  dateval + interval '2-2' year to month,
+  dateval + interval '-2-2' year to month,
+  - interval '2-2' year to month + dateval,
+  interval '2-2' year to month + dateval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            alias: interval_arithmetic_1
+            Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+            Select Operator
+              expressions: dateval (type: date), (dateval - 2-2) (type: date), (dateval - -2-2) (type: date), (dateval + 2-2) (type: date), (dateval + -2-2) (type: date), (-2-2 + dateval) (type: date), (2-2 + dateval) (type: date)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+              Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+              Limit
+                Number of rows: 2
+                Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                  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: 2
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: select
+  dateval,
+  dateval - interval '2-2' year to month,
+  dateval - interval '-2-2' year to month,
+  dateval + interval '2-2' year to month,
+  dateval + interval '-2-2' year to month,
+  - interval '2-2' year to month + dateval,
+  interval '2-2' year to month + dateval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  dateval,
+  dateval - interval '2-2' year to month,
+  dateval - interval '-2-2' year to month,
+  dateval + interval '2-2' year to month,
+  dateval + interval '-2-2' year to month,
+  - interval '2-2' year to month + dateval,
+  interval '2-2' year to month + dateval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+1970-01-01	1967-11-01	1972-03-01	1972-03-01	1967-11-01	1967-11-01	1972-03-01
+NULL	NULL	NULL	NULL	NULL	NULL	NULL
+PREHOOK: query: explain
+select
+  dateval,
+  dateval - date '1999-06-07',
+  date '1999-06-07' - dateval,
+  dateval - dateval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+  dateval,
+  dateval - date '1999-06-07',
+  date '1999-06-07' - dateval,
+  dateval - dateval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            alias: interval_arithmetic_1
+            Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+            Select Operator
+              expressions: dateval (type: date), (dateval - 1999-06-07) (type: interval_day_time), (1999-06-07 - dateval) (type: interval_day_time), (dateval - dateval) (type: interval_day_time)
+              outputColumnNames: _col0, _col1, _col2, _col3
+              Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+              Limit
+                Number of rows: 2
+                Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                  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: 2
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: select
+  dateval,
+  dateval - date '1999-06-07',
+  date '1999-06-07' - dateval,
+  dateval - dateval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  dateval,
+  dateval - date '1999-06-07',
+  date '1999-06-07' - dateval,
+  dateval - dateval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+1970-01-01	-10748 23:00:00.000000000	10748 23:00:00.000000000	0 00:00:00.000000000
+NULL	NULL	NULL	NULL
+PREHOOK: query: explain
+select
+  tsval,
+  tsval - interval '2-2' year to month,
+  tsval - interval '-2-2' year to month,
+  tsval + interval '2-2' year to month,
+  tsval + interval '-2-2' year to month,
+  - interval '2-2' year to month + tsval,
+  interval '2-2' year to month + tsval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+  tsval,
+  tsval - interval '2-2' year to month,
+  tsval - interval '-2-2' year to month,
+  tsval + interval '2-2' year to month,
+  tsval + interval '-2-2' year to month,
+  - interval '2-2' year to month + tsval,
+  interval '2-2' year to month + tsval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            alias: interval_arithmetic_1
+            Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+            Select Operator
+              expressions: tsval (type: timestamp), (tsval - 2-2) (type: timestamp), (tsval - -2-2) (type: timestamp), (tsval + 2-2) (type: timestamp), (tsval + -2-2) (type: timestamp), (-2-2 + tsval) (type: timestamp), (2-2 + tsval) (type: timestamp)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+              Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+              Limit
+                Number of rows: 2
+                Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                  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: 2
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: select
+  tsval,
+  tsval - interval '2-2' year to month,
+  tsval - interval '-2-2' year to month,
+  tsval + interval '2-2' year to month,
+  tsval + interval '-2-2' year to month,
+  - interval '2-2' year to month + tsval,
+  interval '2-2' year to month + tsval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  tsval,
+  tsval - interval '2-2' year to month,
+  tsval - interval '-2-2' year to month,
+  tsval + interval '2-2' year to month,
+  tsval + interval '-2-2' year to month,
+  - interval '2-2' year to month + tsval,
+  interval '2-2' year to month + tsval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+1969-12-31 15:59:46.674	1967-10-31 15:59:46.674	1972-02-29 15:59:46.674	1972-02-29 15:59:46.674	1967-10-31 15:59:46.674	1967-10-31 15:59:46.674	1972-02-29 15:59:46.674
+NULL	NULL	NULL	NULL	NULL	NULL	NULL
+PREHOOK: query: explain
+select
+  interval '2-2' year to month + interval '3-3' year to month,
+  interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+  interval '2-2' year to month + interval '3-3' year to month,
+  interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+    Fetch Operator
+      limit: 2
+      Processor Tree:
+        TableScan
+          alias: interval_arithmetic_1
+          Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: COMPLETE
+          Select Operator
+            expressions: 5-5 (type: interval_year_month), -1-1 (type: interval_year_month)
+            outputColumnNames: _col0, _col1
+            Statistics: Num rows: 12288 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+            Limit
+              Number of rows: 2
+              Statistics: Num rows: 2 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+              ListSink
+
+PREHOOK: query: select
+  interval '2-2' year to month + interval '3-3' year to month,
+  interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  interval '2-2' year to month + interval '3-3' year to month,
+  interval '2-2' year to month - interval '3-3' year to month
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+5-5	-1-1
+5-5	-1-1
+PREHOOK: query: -- interval day-time arithmetic
+explain
+select
+  dateval,
+  dateval - interval '99 11:22:33.123456789' day to second,
+  dateval - interval '-99 11:22:33.123456789' day to second,
+  dateval + interval '99 11:22:33.123456789' day to second,
+  dateval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + dateval,
+  interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: -- interval day-time arithmetic
+explain
+select
+  dateval,
+  dateval - interval '99 11:22:33.123456789' day to second,
+  dateval - interval '-99 11:22:33.123456789' day to second,
+  dateval + interval '99 11:22:33.123456789' day to second,
+  dateval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + dateval,
+  interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            alias: interval_arithmetic_1
+            Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+            Select Operator
+              expressions: dateval (type: date), (dateval - 99 11:22:33.123456789) (type: timestamp), (dateval - -99 11:22:33.123456789) (type: timestamp), (dateval + 99 11:22:33.123456789) (type: timestamp), (dateval + -99 11:22:33.123456789) (type: timestamp), (-99 11:22:33.123456789 + dateval) (type: timestamp), (99 11:22:33.123456789 + dateval) (type: timestamp)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+              Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+              Limit
+                Number of rows: 2
+                Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                  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: 2
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: select
+  dateval,
+  dateval - interval '99 11:22:33.123456789' day to second,
+  dateval - interval '-99 11:22:33.123456789' day to second,
+  dateval + interval '99 11:22:33.123456789' day to second,
+  dateval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + dateval,
+  interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  dateval,
+  dateval - interval '99 11:22:33.123456789' day to second,
+  dateval - interval '-99 11:22:33.123456789' day to second,
+  dateval + interval '99 11:22:33.123456789' day to second,
+  dateval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + dateval,
+  interval '99 11:22:33.123456789' day to second + dateval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+1970-01-01	1969-09-23 13:37:26.876543211	1970-04-10 11:22:33.123456789	1970-04-10 11:22:33.123456789	1969-09-23 13:37:26.876543211	1969-09-23 13:37:26.876543211	1970-04-10 11:22:33.123456789
+NULL	NULL	NULL	NULL	NULL	NULL	NULL
+PREHOOK: query: explain
+select
+  dateval,
+  tsval,
+  dateval - tsval,
+  tsval - dateval,
+  tsval - tsval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+  dateval,
+  tsval,
+  dateval - tsval,
+  tsval - dateval,
+  tsval - tsval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            alias: interval_arithmetic_1
+            Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+            Select Operator
+              expressions: dateval (type: date), tsval (type: timestamp), (dateval - tsval) (type: interval_day_time), (tsval - dateval) (type: interval_day_time), (tsval - tsval) (type: interval_day_time)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4
+              Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+              Limit
+                Number of rows: 2
+                Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                  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: 2
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: select
+  dateval,
+  tsval,
+  dateval - tsval,
+  tsval - dateval,
+  tsval - tsval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  dateval,
+  tsval,
+  dateval - tsval,
+  tsval - dateval,
+  tsval - tsval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+1970-01-01	1969-12-31 15:59:46.674	0 08:00:12.326000000	-0 08:00:12.326000000	0 00:00:00.000000000
+NULL	NULL	NULL	NULL	NULL
+PREHOOK: query: explain
+select
+  tsval,
+  tsval - interval '99 11:22:33.123456789' day to second,
+  tsval - interval '-99 11:22:33.123456789' day to second,
+  tsval + interval '99 11:22:33.123456789' day to second,
+  tsval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + tsval,
+  interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+  tsval,
+  tsval - interval '99 11:22:33.123456789' day to second,
+  tsval - interval '-99 11:22:33.123456789' day to second,
+  tsval + interval '99 11:22:33.123456789' day to second,
+  tsval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + tsval,
+  interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-1 is a root stage
+  Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+  Stage: Stage-1
+    Map Reduce
+      Map Operator Tree:
+          TableScan
+            alias: interval_arithmetic_1
+            Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+            Select Operator
+              expressions: tsval (type: timestamp), (tsval - 99 11:22:33.123456789) (type: timestamp), (tsval - -99 11:22:33.123456789) (type: timestamp), (tsval + 99 11:22:33.123456789) (type: timestamp), (tsval + -99 11:22:33.123456789) (type: timestamp), (-99 11:22:33.123456789 + tsval) (type: timestamp), (99 11:22:33.123456789 + tsval) (type: timestamp)
+              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6
+              Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: NONE
+              Limit
+                Number of rows: 2
+                Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                File Output Operator
+                  compressed: false
+                  Statistics: Num rows: 2 Data size: 52 Basic stats: COMPLETE Column stats: NONE
+                  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: 2
+      Processor Tree:
+        ListSink
+
+PREHOOK: query: select
+  tsval,
+  tsval - interval '99 11:22:33.123456789' day to second,
+  tsval - interval '-99 11:22:33.123456789' day to second,
+  tsval + interval '99 11:22:33.123456789' day to second,
+  tsval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + tsval,
+  interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  tsval,
+  tsval - interval '99 11:22:33.123456789' day to second,
+  tsval - interval '-99 11:22:33.123456789' day to second,
+  tsval + interval '99 11:22:33.123456789' day to second,
+  tsval + interval '-99 11:22:33.123456789' day to second,
+  -interval '99 11:22:33.123456789' day to second + tsval,
+  interval '99 11:22:33.123456789' day to second + tsval
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+1969-12-31 15:59:46.674	1969-09-23 05:37:13.550543211	1970-04-10 03:22:19.797456789	1970-04-10 03:22:19.797456789	1969-09-23 05:37:13.550543211	1969-09-23 05:37:13.550543211	1970-04-10 03:22:19.797456789
+NULL	NULL	NULL	NULL	NULL	NULL	NULL
+PREHOOK: query: explain
+select
+  interval '99 11:22:33.123456789' day to second + interval '10 9:8:7.123456789' day to second,
+  interval '99 11:22:33.123456789' day to second - interval '10 9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+POSTHOOK: query: explain
+select
+  interval '99 11:22:33.123456789' day to second + interval '10 9:8:7.123456789' day to second,
+  interval '99 11:22:33.123456789' day to second - interval '10 9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+  Stage-0 is a root stage
+
+STAGE PLANS:
+  Stage: Stage-0
+    Fetch Operator
+      limit: 2
+      Processor Tree:
+        TableScan
+          alias: interval_arithmetic_1
+          Statistics: Num rows: 12288 Data size: 326837 Basic stats: COMPLETE Column stats: COMPLETE
+          Select Operator
+            expressions: 109 20:30:40.246913578 (type: interval_day_time), 89 02:14:26.000000000 (type: interval_day_time)
+            outputColumnNames: _col0, _col1
+            Statistics: Num rows: 12288 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+            Limit
+              Number of rows: 2
+              Statistics: Num rows: 2 Data size: 0 Basic stats: PARTIAL Column stats: COMPLETE
+              ListSink
+
+PREHOOK: query: select
+  interval '99 11:22:33.123456789' day to second + interval '10 9:8:7.123456789' day to second,
+  interval '99 11:22:33.123456789' day to second - interval '10 9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2
+PREHOOK: type: QUERY
+PREHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+POSTHOOK: query: select
+  interval '99 11:22:33.123456789' day to second + interval '10 9:8:7.123456789' day to second,
+  interval '99 11:22:33.123456789' day to second - interval '10 9:8:7.123456789' day to second
+from interval_arithmetic_1
+limit 2
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@interval_arithmetic_1
+#### A masked pattern was here ####
+109 20:30:40.246913578	89 02:14:26.000000000
+109 20:30:40.246913578	89 02:14:26.000000000
+PREHOOK: query: drop table interval_arithmetic_1
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: default@interval_arithmetic_1
+PREHOOK: Output: default@interval_arithmetic_1
+POSTHOOK: query: drop table interval_arithmetic_1
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: default@interval_arithmetic_1
+POSTHOOK: Output: default@interval_arithmetic_1

Added: hive/branches/llap/ql/src/test/results/clientpositive/interval_comparison.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/interval_comparison.q.out?rev=1669718&view=auto
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/interval_comparison.q.out (added)
+++ hive/branches/llap/ql/src/test/results/clientpositive/interval_comparison.q.out Sat Mar 28 00:22:15 2015
@@ -0,0 +1,188 @@
+PREHOOK: query: -- should all be true
+select
+  i1 = i1,
+  i1 = i2,
+  i1 >= i2,
+  i1 <= i2,
+  i3 = i3,
+  i3 = i4,
+  i3 <= i4,
+  i3 >= i4,
+  i1 < i3,
+  i3 > i1,
+  i1 != i3
+from (
+  select
+    interval '2-0' year to month as i1,
+    interval '2' year as i2,
+    interval '2-1' year to month as i3,
+    interval '25' month as i4
+  from src limit 1
+) q1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- should all be true
+select
+  i1 = i1,
+  i1 = i2,
+  i1 >= i2,
+  i1 <= i2,
+  i3 = i3,
+  i3 = i4,
+  i3 <= i4,
+  i3 >= i4,
+  i1 < i3,
+  i3 > i1,
+  i1 != i3
+from (
+  select
+    interval '2-0' year to month as i1,
+    interval '2' year as i2,
+    interval '2-1' year to month as i3,
+    interval '25' month as i4
+  from src limit 1
+) q1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true	true	true	true	true	true	true	true	true	true	true
+PREHOOK: query: -- should all be false
+select
+  i1 != i1,
+  i1 != i2,
+  i1 < i2,
+  i1 > i2,
+  i1 = i3,
+  i1 > i3,
+  i1 >= i3,
+  i3 < i1,
+  i3 <= i1
+from (
+  select
+    interval '2-0' year to month as i1,
+    interval '2' year as i2,
+    interval '2-1' year to month as i3,
+    interval '25' month as i4
+  from src limit 1
+) q1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- should all be false
+select
+  i1 != i1,
+  i1 != i2,
+  i1 < i2,
+  i1 > i2,
+  i1 = i3,
+  i1 > i3,
+  i1 >= i3,
+  i3 < i1,
+  i3 <= i1
+from (
+  select
+    interval '2-0' year to month as i1,
+    interval '2' year as i2,
+    interval '2-1' year to month as i3,
+    interval '25' month as i4
+  from src limit 1
+) q1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+false	false	false	false	false	false	false	false	false
+PREHOOK: query: -- should all be true
+select
+  i1 = i1,
+  i1 = i2,
+  i1 >= i2,
+  i1 <= i2,
+  i3 = i3,
+  i3 = i4,
+  i3 <= i4,
+  i3 >= i4,
+  i1 < i3,
+  i3 > i1,
+  i1 != i3
+from (
+  select
+    interval '1 0:0:0' day to second as i1,
+    interval '24' hour as i2,
+    interval '1 0:0:1' day to second as i3,
+    interval '86401' second as i4
+  from src limit 1
+) q1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- should all be true
+select
+  i1 = i1,
+  i1 = i2,
+  i1 >= i2,
+  i1 <= i2,
+  i3 = i3,
+  i3 = i4,
+  i3 <= i4,
+  i3 >= i4,
+  i1 < i3,
+  i3 > i1,
+  i1 != i3
+from (
+  select
+    interval '1 0:0:0' day to second as i1,
+    interval '24' hour as i2,
+    interval '1 0:0:1' day to second as i3,
+    interval '86401' second as i4
+  from src limit 1
+) q1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+true	true	true	true	true	true	true	true	true	true	true
+PREHOOK: query: -- should all be false
+select
+  i1 != i1,
+  i1 != i2,
+  i1 < i2,
+  i1 > i2,
+  i1 = i3,
+  i1 > i3,
+  i1 >= i3,
+  i3 < i1,
+  i3 <= i1
+from (
+  select
+    interval '1 0:0:0' day to second as i1,
+    interval '24' hour as i2,
+    interval '1 0:0:1' day to second as i3,
+    interval '86401' second as i4
+  from src limit 1
+) q1
+PREHOOK: type: QUERY
+PREHOOK: Input: default@src
+#### A masked pattern was here ####
+POSTHOOK: query: -- should all be false
+select
+  i1 != i1,
+  i1 != i2,
+  i1 < i2,
+  i1 > i2,
+  i1 = i3,
+  i1 > i3,
+  i1 >= i3,
+  i3 < i1,
+  i3 <= i1
+from (
+  select
+    interval '1 0:0:0' day to second as i1,
+    interval '24' hour as i2,
+    interval '1 0:0:1' day to second as i3,
+    interval '86401' second as i4
+  from src limit 1
+) q1
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@src
+#### A masked pattern was here ####
+false	false	false	false	false	false	false	false	false



Mime
View raw message