hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From amareshw...@apache.org
Subject svn commit: r1468783 [15/16] - in /hive/branches/HIVE-4115: ./ beeline/src/java/org/apache/hive/beeline/ beeline/src/test/org/ beeline/src/test/org/apache/ beeline/src/test/org/apache/hive/ beeline/src/test/org/apache/hive/beeline/ beeline/src/test/org...
Date Wed, 17 Apr 2013 07:29:46 GMT
Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf_npath.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf_npath.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf_npath.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/ptf_npath.q.out Wed Apr 17 07:29:38 2013
@@ -37,7 +37,7 @@ from npath(on 
         sort by year, month, day_of_month  
       arg1('LATE.LATE+'), 
       arg2('LATE'), arg3(arr_delay > 15), 
-    arg4('origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath as tpath') 
+    arg4('origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath') 
    )
 PREHOOK: type: QUERY
 PREHOOK: Input: default@flights_tiny
@@ -50,27 +50,27 @@ from npath(on 
         sort by year, month, day_of_month  
       arg1('LATE.LATE+'), 
       arg2('LATE'), arg3(arr_delay > 15), 
-    arg4('origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath as tpath') 
+    arg4('origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath') 
    )
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@flights_tiny
 #### A masked pattern was here ####
-Baltimore	1142	2010	10	20	6	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":20,"arr_delay":23.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":105.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":54.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":25,"arr_delay":92.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":26,"arr_delay":123.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":49.0,"fl_num":"1142"}]
-Baltimore	1142	2010	10	21	5	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":105.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":54.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":25,"arr_delay":92.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":26,"arr_delay":123.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":49.0,"fl_num":"1142"}]
-Baltimore	1142	2010	10	22	4	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":54.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":25,"arr_delay":92.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":26,"arr_delay":123.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":49.0,"fl_num":"1142"}]
-Baltimore	1142	2010	10	25	3	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":25,"arr_delay":92.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":26,"arr_delay":123.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":49.0,"fl_num":"1142"}]
-Baltimore	1142	2010	10	26	2	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":26,"arr_delay":123.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":49.0,"fl_num":"1142"}]
-Chicago	1531	2010	10	21	2	[{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":53.0,"fl_num":"1531"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":16.0,"fl_num":"1531"}]
-Chicago	1531	2010	10	25	3	[{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":25,"arr_delay":43.0,"fl_num":"1531"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":26,"arr_delay":29.0,"fl_num":"1531"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":70.0,"fl_num":"1531"}]
-Chicago	1531	2010	10	26	2	[{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":26,"arr_delay":29.0,"fl_num":"1531"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":70.0,"fl_num":"1531"}]
-Baltimore	1599	2010	10	21	2	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":28.0,"fl_num":"1599"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":18.0,"fl_num":"1599"}]
-Baltimore	1599	2010	10	25	3	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":25,"arr_delay":106.0,"fl_num":"1599"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":26,"arr_delay":90.0,"fl_num":"1599"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":92.0,"fl_num":"1599"}]
-Baltimore	1599	2010	10	26	2	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":26,"arr_delay":90.0,"fl_num":"1599"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":92.0,"fl_num":"1599"}]
-Chicago	361	2010	10	20	2	[{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":20,"arr_delay":42.0,"fl_num":"361"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":142.0,"fl_num":"361"}]
-Washington	7291	2010	10	27	2	[{"origin_city_name":"Washington","dest_city_name":"New York","year":2010,"month":10,"day_of_month":27,"arr_delay":26.0,"fl_num":"7291"},{"origin_city_name":"Washington","dest_city_name":"New York","year":2010,"month":10,"day_of_month":28,"arr_delay":45.0,"fl_num":"7291"}]
-Chicago	897	2010	10	20	4	[{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":20,"arr_delay":24.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":77.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":24.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":24,"arr_delay":113.0,"fl_num":"897"}]
-Chicago	897	2010	10	21	3	[{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":77.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":24.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":24,"arr_delay":113.0,"fl_num":"897"}]
-Chicago	897	2010	10	22	2	[{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":24.0,"fl_num":"897"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":24,"arr_delay":113.0,"fl_num":"897"}]
+Baltimore	1142	2010	10	20	6	20
+Baltimore	1142	2010	10	21	5	21
+Baltimore	1142	2010	10	22	4	22
+Baltimore	1142	2010	10	25	3	25
+Baltimore	1142	2010	10	26	2	26
+Chicago	1531	2010	10	21	2	21
+Chicago	1531	2010	10	25	3	25
+Chicago	1531	2010	10	26	2	26
+Baltimore	1599	2010	10	21	2	21
+Baltimore	1599	2010	10	25	3	25
+Baltimore	1599	2010	10	26	2	26
+Chicago	361	2010	10	20	2	20
+Washington	7291	2010	10	27	2	27
+Chicago	897	2010	10	20	4	20
+Chicago	897	2010	10	21	3	21
+Chicago	897	2010	10	22	2	22
 PREHOOK: query: -- 2. Npath on 1 partition
 select origin_city_name, fl_num, year, month, day_of_month, sz, tpath 
 from npath(on 
@@ -78,7 +78,7 @@ from npath(on 
         sort by year, month, day_of_month  
       arg1('LATE.LATE+'), 
       arg2('LATE'), arg3(arr_delay > 15), 
-    arg4('origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath as tpath') 
+    arg4('origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath') 
    )
 where fl_num = 1142
 PREHOOK: type: QUERY
@@ -91,12 +91,12 @@ from npath(on 
         sort by year, month, day_of_month  
       arg1('LATE.LATE+'), 
       arg2('LATE'), arg3(arr_delay > 15), 
-    arg4('origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath as tpath') 
+    arg4('origin_city_name, fl_num, year, month, day_of_month, size(tpath) as sz, tpath[0].day_of_month as tpath') 
    )
 where fl_num = 1142
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@flights_tiny
 #### A masked pattern was here ####
-Baltimore	1142	2010	10	21	2	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":105.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":21,"arr_delay":28.0,"fl_num":"1599"}]
-Baltimore	1142	2010	10	22	2	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":54.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":22,"arr_delay":18.0,"fl_num":"1599"}]
-Baltimore	1142	2010	10	25	3	[{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":25,"arr_delay":92.0,"fl_num":"1142"},{"origin_city_name":"Baltimore","dest_city_name":"New York","year":2010,"month":10,"day_of_month":25,"arr_delay":106.0,"fl_num":"1599"},{"origin_city_name":"Chicago","dest_city_name":"New York","year":2010,"month":10,"day_of_month":25,"arr_delay":31.0,"fl_num":"361"}]
+Baltimore	1142	2010	10	21	2	21
+Baltimore	1142	2010	10	22	2	22
+Baltimore	1142	2010	10	25	3	25

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_bigdata.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_bigdata.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_bigdata.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_bigdata.q.out Wed Apr 17 07:29:38 2013
@@ -31,8 +31,6 @@ POSTHOOK: query: describe columnTable_Bi
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: columntable_bigdata.key SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: columntable_bigdata.value SCRIPT [(src)src.FieldSchema(name:key, type:string, comment:default), (src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 PREHOOK: query: select count(columnTable_Bigdata.key) from columnTable_Bigdata

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_columnar.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_columnar.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_columnar.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_columnar.q.out Wed Apr 17 07:29:38 2013
@@ -31,8 +31,6 @@ POSTHOOK: query: describe columnTable
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: columntable.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: columntable.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 PREHOOK: query: SELECT columnTable.* FROM columnTable ORDER BY key ASC, value ASC

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_default_format.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_default_format.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_default_format.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rcfile_default_format.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: DESCRIBE EXTENDED rcfile
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -23,8 +21,6 @@ PREHOOK: query: DESCRIBE EXTENDED rcfile
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_ctas
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -48,8 +44,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED rcfile_default_format_txtfile
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 	 	 
 #### A masked pattern was here ####
@@ -66,8 +60,6 @@ PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE EXTENDED textfile_default_format_ctas
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: rcfile_default_format_txtfile.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rename_column.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rename_column.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rename_column.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/rename_column.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	int                 	None                
 b                   	int                 	None                
 c                   	int                 	None                
@@ -24,8 +22,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	int                 	None                
 c                   	int                 	None                
@@ -41,8 +37,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a1                  	int                 	None                
 b                   	int                 	None                
 c                   	int                 	None                
@@ -58,8 +52,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a2                  	int                 	None                
 b                   	int                 	None                
 c                   	int                 	None                
@@ -75,8 +67,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 b                   	int                 	None                
 a                   	int                 	None                
 c                   	int                 	None                
@@ -92,8 +82,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 b                   	int                 	None                
 a1                  	int                 	test comment1       
 c                   	int                 	None                
@@ -109,8 +97,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a2                  	int                 	test comment2       
 b                   	int                 	None                
 c                   	int                 	None                
@@ -126,8 +112,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 b                   	int                 	None                
 a                   	int                 	test comment2       
 c                   	int                 	None                
@@ -170,8 +154,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	int                 	None                
 b                   	int                 	None                
 c                   	int                 	None                
@@ -187,8 +169,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	string              	None                
 b                   	int                 	None                
 c                   	int                 	None                
@@ -204,8 +184,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a1                  	int                 	None                
 b                   	int                 	None                
 c                   	int                 	None                
@@ -221,8 +199,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a2                  	int                 	None                
 b                   	int                 	None                
 c                   	int                 	None                
@@ -238,8 +214,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 b                   	int                 	None                
 a                   	int                 	None                
 c                   	int                 	None                
@@ -255,8 +229,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 b                   	int                 	None                
 a1                  	int                 	test comment1       
 c                   	int                 	None                
@@ -272,8 +244,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a2                  	int                 	test comment2       
 b                   	int                 	None                
 c                   	int                 	None                
@@ -289,8 +259,6 @@ PREHOOK: query: DESCRIBE kv_rename_test
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE kv_rename_test
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 b                   	int                 	None                
 a                   	int                 	test comment2       
 c                   	int                 	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/serde_regex.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/serde_regex.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/serde_regex.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/serde_regex.q.out Wed Apr 17 07:29:38 2013
@@ -194,16 +194,18 @@ PREHOOK: Output: default@serde_regex1
 POSTHOOK: query: LOAD DATA LOCAL INPATH "../data/files/kv7.txt" INTO TABLE serde_regex1
 POSTHOOK: type: LOAD
 POSTHOOK: Output: default@serde_regex1
-PREHOOK: query: SELECT key, value FROM serde_regex1 ORDER BY key
+PREHOOK: query: SELECT key, value FROM serde_regex1 ORDER BY key, value
 PREHOOK: type: QUERY
 PREHOOK: Input: default@serde_regex1
 #### A masked pattern was here ####
-POSTHOOK: query: SELECT key, value FROM serde_regex1 ORDER BY key
+POSTHOOK: query: SELECT key, value FROM serde_regex1 ORDER BY key, value
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@serde_regex1
 #### A masked pattern was here ####
+NULL	0
+NULL	0
 -1234567890.123456789	-1234567890
--4.4E+3	4400
+-4400	4400
 -1255.49	-1255
 -1.122	-11
 -1.12	-1
@@ -213,7 +215,6 @@ POSTHOOK: Input: default@serde_regex1
 -0.3	0
 0	0
 0	0
-1E-99	0
 0.01	0
 0.02	0
 0.1	0
@@ -232,14 +233,13 @@ POSTHOOK: Input: default@serde_regex1
 3.14	3
 3.14	3
 3.14	4
-1E+1	10
-2E+1	20
-1E+2	100
+10	10
+20	20
+100	100
 124	124
 125.2	125
-2E+2	200
+200	200
 1234567890.12345678	1234567890
-1E+99	0
 PREHOOK: query: DROP TABLE serde_regex1
 PREHOOK: type: DROPTABLE
 PREHOOK: Input: default@serde_regex1

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/serde_reported_schema.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/serde_reported_schema.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/serde_reported_schema.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/serde_reported_schema.q.out Wed Apr 17 07:29:38 2013
@@ -17,8 +17,6 @@ PREHOOK: query: describe int_string
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe int_string
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 myint               	int                 	from deserializer   
 mystring            	string              	from deserializer   
 underscore_int      	int                 	from deserializer   
@@ -39,8 +37,6 @@ PREHOOK: query: describe int_string part
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: describe int_string partition (b='part1')
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 myint               	int                 	from deserializer   
 mystring            	string              	from deserializer   
 underscore_int      	int                 	from deserializer   

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_columns.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_columns.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_columns.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_columns.q.out Wed Apr 17 07:29:38 2013
@@ -32,8 +32,6 @@ PREHOOK: Input: default@shcol_test
 POSTHOOK: query: SHOW COLUMNS from shcol_test
 POSTHOOK: type: SHOWCOLUMNS
 POSTHOOK: Input: default@shcol_test
-# col_name            
-
 key                 
 value               
 ds                  
@@ -64,8 +62,6 @@ PREHOOK: Input: test_db@foo
 POSTHOOK: query: SHOW COLUMNS from foo
 POSTHOOK: type: SHOWCOLUMNS
 POSTHOOK: Input: test_db@foo
-# col_name            
-
 a                   
 PREHOOK: query: SHOW COLUMNS in foo
 PREHOOK: type: SHOWCOLUMNS
@@ -73,8 +69,6 @@ PREHOOK: Input: test_db@foo
 POSTHOOK: query: SHOW COLUMNS in foo
 POSTHOOK: type: SHOWCOLUMNS
 POSTHOOK: Input: test_db@foo
-# col_name            
-
 a                   
 PREHOOK: query: -- SHOW COLUMNS from a database with a name that requires escaping
 CREATE DATABASE `database`
@@ -97,8 +91,6 @@ PREHOOK: Input: database@foo
 POSTHOOK: query: SHOW COLUMNS from foo
 POSTHOOK: type: SHOWCOLUMNS
 POSTHOOK: Input: database@foo
-# col_name            
-
 a                   
 PREHOOK: query: use default
 PREHOOK: type: SWITCHDATABASE
@@ -110,8 +102,6 @@ PREHOOK: Input: test_db@foo
 POSTHOOK: query: SHOW COLUMNS from test_db.foo
 POSTHOOK: type: SHOWCOLUMNS
 POSTHOOK: Input: test_db@foo
-# col_name            
-
 a                   
 PREHOOK: query: SHOW COLUMNS from foo from test_db
 PREHOOK: type: SHOWCOLUMNS
@@ -119,6 +109,4 @@ PREHOOK: Input: test_db@foo
 POSTHOOK: query: SHOW COLUMNS from foo from test_db
 POSTHOOK: type: SHOWCOLUMNS
 POSTHOOK: Input: test_db@foo
-# col_name            
-
 a                   

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_create_table_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_create_table_view.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_create_table_view.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/show_create_table_view.q.out Wed Apr 17 07:29:38 2013
@@ -2,13 +2,11 @@ PREHOOK: query: -- Test SHOW CREATE TABL
 
 CREATE VIEW tmp_copy_src AS SELECT * FROM src
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- Test SHOW CREATE TABLE on a view name.
 
 CREATE VIEW tmp_copy_src AS SELECT * FROM src
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@tmp_copy_src
-#### A masked pattern was here ####
 PREHOOK: query: SHOW CREATE TABLE tmp_copy_src
 PREHOOK: type: SHOW_CREATETABLE
 PREHOOK: Input: default@tmp_copy_src

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/stats0.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/stats0.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/stats0.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/stats0.q.out Wed Apr 17 07:29:38 2013
@@ -152,8 +152,6 @@ POSTHOOK: query: desc extended stats_non
 POSTHOOK: type: DESCTABLE
 POSTHOOK: Lineage: stats_non_partitioned.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_non_partitioned.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -1277,8 +1275,6 @@ POSTHOOK: Lineage: stats_non_partitioned
 POSTHOOK: Lineage: stats_non_partitioned.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 ds                  	string              	None                
@@ -1297,8 +1293,6 @@ POSTHOOK: Lineage: stats_non_partitioned
 POSTHOOK: Lineage: stats_non_partitioned.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 ds                  	string              	None                
@@ -1655,8 +1649,6 @@ POSTHOOK: Lineage: stats_non_partitioned
 POSTHOOK: Lineage: stats_non_partitioned.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -2854,8 +2846,6 @@ POSTHOOK: Lineage: stats_partitioned PAR
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 ds                  	string              	None                
@@ -2878,8 +2868,6 @@ POSTHOOK: Lineage: stats_partitioned PAR
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: stats_partitioned PARTITION(ds=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 ds                  	string              	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/tablename_with_select.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/tablename_with_select.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/tablename_with_select.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/tablename_with_select.q.out Wed Apr 17 07:29:38 2013
@@ -7,8 +7,6 @@ PREHOOK: query: DESCRIBE tmp_select
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: DESCRIBE tmp_select
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 a                   	int                 	None                
 b                   	string              	None                
 PREHOOK: query: INSERT OVERWRITE TABLE tmp_select SELECT key, value FROM src

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udf_percentile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udf_percentile.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udf_percentile.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udf_percentile.q.out Wed Apr 17 07:29:38 2013
@@ -306,56 +306,56 @@ GROUP BY CAST(key AS INT) DIV 10
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
-0	NULL	null
-1	NULL	null
-2	NULL	null
-3	NULL	null
-4	NULL	null
-5	NULL	null
-6	NULL	null
-7	NULL	null
-8	NULL	null
-9	NULL	null
-10	NULL	null
-11	NULL	null
-12	NULL	null
-13	NULL	null
-14	NULL	null
-15	NULL	null
-16	NULL	null
-17	NULL	null
-18	NULL	null
-19	NULL	null
-20	NULL	null
-21	NULL	null
-22	NULL	null
-23	NULL	null
-24	NULL	null
-25	NULL	null
-26	NULL	null
-27	NULL	null
-28	NULL	null
-29	NULL	null
-30	NULL	null
-31	NULL	null
-32	NULL	null
-33	NULL	null
-34	NULL	null
-35	NULL	null
-36	NULL	null
-37	NULL	null
-38	NULL	null
-39	NULL	null
-40	NULL	null
-41	NULL	null
-42	NULL	null
-43	NULL	null
-44	NULL	null
-45	NULL	null
-46	NULL	null
-47	NULL	null
-48	NULL	null
-49	NULL	null
+0	NULL	NULL
+1	NULL	NULL
+2	NULL	NULL
+3	NULL	NULL
+4	NULL	NULL
+5	NULL	NULL
+6	NULL	NULL
+7	NULL	NULL
+8	NULL	NULL
+9	NULL	NULL
+10	NULL	NULL
+11	NULL	NULL
+12	NULL	NULL
+13	NULL	NULL
+14	NULL	NULL
+15	NULL	NULL
+16	NULL	NULL
+17	NULL	NULL
+18	NULL	NULL
+19	NULL	NULL
+20	NULL	NULL
+21	NULL	NULL
+22	NULL	NULL
+23	NULL	NULL
+24	NULL	NULL
+25	NULL	NULL
+26	NULL	NULL
+27	NULL	NULL
+28	NULL	NULL
+29	NULL	NULL
+30	NULL	NULL
+31	NULL	NULL
+32	NULL	NULL
+33	NULL	NULL
+34	NULL	NULL
+35	NULL	NULL
+36	NULL	NULL
+37	NULL	NULL
+38	NULL	NULL
+39	NULL	NULL
+40	NULL	NULL
+41	NULL	NULL
+42	NULL	NULL
+43	NULL	NULL
+44	NULL	NULL
+45	NULL	NULL
+46	NULL	NULL
+47	NULL	NULL
+48	NULL	NULL
+49	NULL	NULL
 PREHOOK: query: -- test empty array handling
 SELECT CAST(key AS INT) DIV 10,
        percentile(IF(CAST(key AS INT) DIV 10 < 5, 1, NULL), 0.5),
@@ -379,51 +379,51 @@ POSTHOOK: Input: default@src
 2	1.0	[1.0,1.0,1.0,1.0]
 3	1.0	[1.0,1.0,1.0,1.0]
 4	1.0	[1.0,1.0,1.0,1.0]
-5	NULL	null
-6	NULL	null
-7	NULL	null
-8	NULL	null
-9	NULL	null
-10	NULL	null
-11	NULL	null
-12	NULL	null
-13	NULL	null
-14	NULL	null
-15	NULL	null
-16	NULL	null
-17	NULL	null
-18	NULL	null
-19	NULL	null
-20	NULL	null
-21	NULL	null
-22	NULL	null
-23	NULL	null
-24	NULL	null
-25	NULL	null
-26	NULL	null
-27	NULL	null
-28	NULL	null
-29	NULL	null
-30	NULL	null
-31	NULL	null
-32	NULL	null
-33	NULL	null
-34	NULL	null
-35	NULL	null
-36	NULL	null
-37	NULL	null
-38	NULL	null
-39	NULL	null
-40	NULL	null
-41	NULL	null
-42	NULL	null
-43	NULL	null
-44	NULL	null
-45	NULL	null
-46	NULL	null
-47	NULL	null
-48	NULL	null
-49	NULL	null
+5	NULL	NULL
+6	NULL	NULL
+7	NULL	NULL
+8	NULL	NULL
+9	NULL	NULL
+10	NULL	NULL
+11	NULL	NULL
+12	NULL	NULL
+13	NULL	NULL
+14	NULL	NULL
+15	NULL	NULL
+16	NULL	NULL
+17	NULL	NULL
+18	NULL	NULL
+19	NULL	NULL
+20	NULL	NULL
+21	NULL	NULL
+22	NULL	NULL
+23	NULL	NULL
+24	NULL	NULL
+25	NULL	NULL
+26	NULL	NULL
+27	NULL	NULL
+28	NULL	NULL
+29	NULL	NULL
+30	NULL	NULL
+31	NULL	NULL
+32	NULL	NULL
+33	NULL	NULL
+34	NULL	NULL
+35	NULL	NULL
+36	NULL	NULL
+37	NULL	NULL
+38	NULL	NULL
+39	NULL	NULL
+40	NULL	NULL
+41	NULL	NULL
+42	NULL	NULL
+43	NULL	NULL
+44	NULL	NULL
+45	NULL	NULL
+46	NULL	NULL
+47	NULL	NULL
+48	NULL	NULL
+49	NULL	NULL
 PREHOOK: query: select percentile(cast(key as bigint), 0.5) from src where false
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src
@@ -443,4 +443,4 @@ select percentile(cast(key as bigint), a
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
-null
+NULL

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udf_substr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udf_substr.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udf_substr.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udf_substr.q.out Wed Apr 17 07:29:38 2013
@@ -181,7 +181,7 @@ FROM (
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
-NULL	NULL	null	null	null	A	AB	ABC	ABC	A	AB	ABC	ABC	B	BC	BC	BC	C	C	C	C		C	C	C	C	B	BC	BC	BC	A	AB	ABC	ABC	
+NULL	NULL	NULL	NULL	NULL	A	AB	ABC	ABC	A	AB	ABC	ABC	B	BC	BC	BC	C	C	C	C		C	C	C	C	B	BC	BC	BC	A	AB	ABC	ABC	
 PREHOOK: query: -- test UTF-8 substr
 SELECT
   substr("玩", 1),

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_stack.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_stack.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_stack.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/udtf_stack.q.out Wed Apr 17 07:29:38 2013
@@ -156,7 +156,7 @@ POSTHOOK: type: QUERY
 POSTHOOK: Input: default@src
 #### A masked pattern was here ####
 x	[1]
-z	null
+z	NULL
 PREHOOK: query: SELECT x, y FROM src LATERAL VIEW STACK(2, 'x', array(1), 'z', array(4)) a AS x, y LIMIT 2
 PREHOOK: type: QUERY
 PREHOOK: Input: default@src

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/union_remove_10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/union_remove_10.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/union_remove_10.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/union_remove_10.q.out Wed Apr 17 07:29:38 2013
@@ -152,6 +152,25 @@ STAGE PLANS:
                       expr: _col1
                       type: bigint
                 outputColumnNames: _col0, _col1
+                File Output Operator
+                  compressed: false
+                  GlobalTableId: 1
+                  table:
+                      input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+                      output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+                      serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+                      name: default.outputtbl1
+        null-subquery2:b-subquery2-subquery2:a-subquery2:inputtbl1 
+          TableScan
+            alias: inputtbl1
+            Select Operator
+              expressions:
+                    expr: key
+                    type: string
+                    expr: UDFToLong(2)
+                    type: bigint
+              outputColumnNames: _col0, _col1
+              Union
                 Select Operator
                   expressions:
                         expr: _col0
@@ -167,46 +186,6 @@ STAGE PLANS:
                         output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
                         serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
                         name: default.outputtbl1
-        null-subquery2:b-subquery2-subquery2:a-subquery2:inputtbl1 
-          TableScan
-            alias: inputtbl1
-            Select Operator
-              expressions:
-                    expr: key
-                    type: string
-                    expr: 2
-                    type: int
-              outputColumnNames: _col0, _col1
-              Select Operator
-                expressions:
-                      expr: _col0
-                      type: string
-                      expr: UDFToLong(_col1)
-                      type: bigint
-                outputColumnNames: _col0, _col1
-                Union
-                  Select Operator
-                    expressions:
-                          expr: _col0
-                          type: string
-                          expr: _col1
-                          type: bigint
-                    outputColumnNames: _col0, _col1
-                    Select Operator
-                      expressions:
-                            expr: _col0
-                            type: string
-                            expr: _col1
-                            type: bigint
-                      outputColumnNames: _col0, _col1
-                      File Output Operator
-                        compressed: false
-                        GlobalTableId: 1
-                        table:
-                            input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
-                            output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
-                            serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
-                            name: default.outputtbl1
 
   Stage: Stage-7
     Conditional Operator
@@ -249,31 +228,17 @@ STAGE PLANS:
               expressions:
                     expr: key
                     type: string
-                    expr: 1
-                    type: int
+                    expr: UDFToLong(1)
+                    type: bigint
               outputColumnNames: _col0, _col1
-              Select Operator
-                expressions:
-                      expr: _col0
-                      type: string
-                      expr: UDFToLong(_col1)
-                      type: bigint
-                outputColumnNames: _col0, _col1
-                Select Operator
-                  expressions:
-                        expr: _col0
-                        type: string
-                        expr: _col1
-                        type: bigint
-                  outputColumnNames: _col0, _col1
-                  File Output Operator
-                    compressed: false
-                    GlobalTableId: 1
-                    table:
-                        input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
-                        output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
-                        serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
-                        name: default.outputtbl1
+              File Output Operator
+                compressed: false
+                GlobalTableId: 1
+                table:
+                    input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+                    output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+                    serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+                    name: default.outputtbl1
 
 
 PREHOOK: query: insert overwrite table outputTbl1

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/unset_table_view_property.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/unset_table_view_property.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/unset_table_view_property.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/unset_table_view_property.q.out Wed Apr 17 07:29:38 2013
@@ -159,12 +159,10 @@ a	1
 PREHOOK: query: -- UNSET VIEW PROPERTIES
 CREATE VIEW testView AS SELECT value FROM src WHERE key=86
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- UNSET VIEW PROPERTIES
 CREATE VIEW testView AS SELECT value FROM src WHERE key=86
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@testView
-#### A masked pattern was here ####
 PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
 PREHOOK: type: ALTERVIEW_PROPERTIES
 PREHOOK: Input: default@testview

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/updateAccessTime.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/updateAccessTime.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/updateAccessTime.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/updateAccessTime.q.out Wed Apr 17 07:29:38 2013
@@ -13,8 +13,6 @@ PREHOOK: query: desc extended tstsrc
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: desc extended tstsrc
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -32,8 +30,6 @@ PREHOOK: query: desc extended tstsrc
 PREHOOK: type: DESCTABLE
 POSTHOOK: query: desc extended tstsrc
 POSTHOOK: type: DESCTABLE
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	None                
 value               	string              	None                
 	 	 
@@ -94,8 +90,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -120,8 +114,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -146,8 +138,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -191,8 +181,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -217,8 +205,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                
@@ -243,8 +229,6 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=11).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
 POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-09,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-# col_name            	data_type           	comment             
-	 	 
 key                 	string              	default             
 value               	string              	default             
 ds                  	string              	None                

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/view.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/view.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/view.q.out Wed Apr 17 07:29:38 2013
@@ -39,75 +39,59 @@ POSTHOOK: Output: db1@table2
 PREHOOK: query: -- relative reference, no alias
 CREATE VIEW v1 AS SELECT * FROM table1
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- relative reference, no alias
 CREATE VIEW v1 AS SELECT * FROM table1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db1@v1
-#### A masked pattern was here ####
 PREHOOK: query: -- relative reference, aliased
 CREATE VIEW v2 AS SELECT t1.* FROM table1 t1
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- relative reference, aliased
 CREATE VIEW v2 AS SELECT t1.* FROM table1 t1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db1@v2
-#### A masked pattern was here ####
 PREHOOK: query: -- relative reference, multiple tables
 CREATE VIEW v3 AS SELECT t1.*, t2.key k FROM table1 t1 JOIN table2 t2 ON t1.key = t2.key
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- relative reference, multiple tables
 CREATE VIEW v3 AS SELECT t1.*, t2.key k FROM table1 t1 JOIN table2 t2 ON t1.key = t2.key
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db1@v3
-#### A masked pattern was here ####
 PREHOOK: query: -- absolute reference, no alias
 CREATE VIEW v4 AS SELECT * FROM db1.table1
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- absolute reference, no alias
 CREATE VIEW v4 AS SELECT * FROM db1.table1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db1@v4
-#### A masked pattern was here ####
 PREHOOK: query: -- absolute reference, aliased
 CREATE VIEW v5 AS SELECT t1.* FROM db1.table1 t1
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- absolute reference, aliased
 CREATE VIEW v5 AS SELECT t1.* FROM db1.table1 t1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db1@v5
-#### A masked pattern was here ####
 PREHOOK: query: -- absolute reference, multiple tables
 CREATE VIEW v6 AS SELECT t1.*, t2.key k FROM db1.table1 t1 JOIN db1.table2 t2 ON t1.key = t2.key
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- absolute reference, multiple tables
 CREATE VIEW v6 AS SELECT t1.*, t2.key k FROM db1.table1 t1 JOIN db1.table2 t2 ON t1.key = t2.key
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db1@v6
-#### A masked pattern was here ####
 PREHOOK: query: -- relative reference, explicit column
 CREATE VIEW v7 AS SELECT key from table1
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- relative reference, explicit column
 CREATE VIEW v7 AS SELECT key from table1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db1@v7
-#### A masked pattern was here ####
 PREHOOK: query: -- absolute reference, explicit column
 CREATE VIEW v8 AS SELECT key from db1.table1
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- absolute reference, explicit column
 CREATE VIEW v8 AS SELECT key from db1.table1
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: db1@v8
-#### A masked pattern was here ####
 PREHOOK: query: CREATE DATABASE db2
 PREHOOK: type: CREATEDATABASE
 POSTHOOK: query: CREATE DATABASE db2

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing.q.out Wed Apr 17 07:29:38 2013
@@ -692,32 +692,32 @@ window w1 as (distribute by p_mfgr sort 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	0.16666666666666666	0.0	2	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	0.16666666666666666	0.0	1	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1	0.16666666666666666	0.0	1	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1	0.16666666666666666	0.0	2	6	19.0	16.237815945091466	2	42	2
-Manufacturer#1	almond aquamarine burnished black steel	28	1	1	0.16666666666666666	0.0	3	6	19.0	16.237815945091466	2	42	34
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1	0.16666666666666666	0.0	3	6	19.0	16.237815945091466	2	42	6
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	0.2	0.0	1	5	19.8	12.560254774486067	4	18	14
-Manufacturer#2	almond antique violet turquoise frosted	40	1	1	0.2	0.0	1	5	19.8	12.560254774486067	4	18	14
-Manufacturer#2	almond aquamarine midnight light salmon	2	1	1	0.2	0.0	2	5	19.8	12.560254774486067	4	18	14
-Manufacturer#2	almond aquamarine rose maroon antique	25	1	1	0.2	0.0	2	5	19.8	12.560254774486067	4	18	40
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1	0.2	0.0	3	5	19.8	12.560254774486067	4	18	2
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	0.2	0.0	1	5	19.2	14.344336861632886	4	45	17
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	1	0.2	0.0	2	5	19.2	14.344336861632886	4	45	17
-Manufacturer#3	almond antique metallic orange dim	19	1	1	0.2	0.0	1	5	19.2	14.344336861632886	4	45	17
-Manufacturer#3	almond antique misty red olive	1	1	1	0.2	0.0	2	5	19.2	14.344336861632886	4	45	14
-Manufacturer#3	almond antique olive coral navajo	45	1	1	0.2	0.0	3	5	19.2	14.344336861632886	4	45	19
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	0.2	0.0	1	5	19.0	12.149074038789951	0	12	10
-Manufacturer#4	almond antique violet mint lemon	39	1	1	0.2	0.0	1	5	19.0	12.149074038789951	0	12	10
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1	0.2	0.0	2	5	19.0	12.149074038789951	0	12	10
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1	0.2	0.0	2	5	19.0	12.149074038789951	0	12	39
-Manufacturer#4	almond azure aquamarine papaya violet	12	1	1	0.2	0.0	3	5	19.0	12.149074038789951	0	12	27
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	0.2	0.0	1	5	21.6	16.206171663906314	1	23	31
-Manufacturer#5	almond antique medium spring khaki	6	1	1	0.2	0.0	1	5	21.6	16.206171663906314	1	23	31
-Manufacturer#5	almond antique sky peru orange	2	1	1	0.2	0.0	2	5	21.6	16.206171663906314	1	23	31
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1	0.2	0.0	2	5	21.6	16.206171663906314	1	23	6
-Manufacturer#5	almond azure blanched chiffon midnight	23	1	1	0.2	0.0	3	5	21.6	16.206171663906314	1	23	2
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	1.0	0.0	2	6	19.0	16.237815945091466	2	42	2
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	1.0	0.0	1	6	19.0	16.237815945091466	2	42	2
+Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1	1.0	0.0	1	6	19.0	16.237815945091466	2	42	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1	1.0	0.0	2	6	19.0	16.237815945091466	2	42	2
+Manufacturer#1	almond aquamarine burnished black steel	28	1	1	1.0	0.0	3	6	19.0	16.237815945091466	2	42	34
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1	1.0	0.0	3	6	19.0	16.237815945091466	2	42	6
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1.0	0.0	1	5	19.8	12.560254774486067	4	18	14
+Manufacturer#2	almond antique violet turquoise frosted	40	1	1	1.0	0.0	1	5	19.8	12.560254774486067	4	18	14
+Manufacturer#2	almond aquamarine midnight light salmon	2	1	1	1.0	0.0	2	5	19.8	12.560254774486067	4	18	14
+Manufacturer#2	almond aquamarine rose maroon antique	25	1	1	1.0	0.0	2	5	19.8	12.560254774486067	4	18	40
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1	1.0	0.0	3	5	19.8	12.560254774486067	4	18	2
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1.0	0.0	1	5	19.2	14.344336861632886	4	45	17
+Manufacturer#3	almond antique forest lavender goldenrod	14	1	1	1.0	0.0	2	5	19.2	14.344336861632886	4	45	17
+Manufacturer#3	almond antique metallic orange dim	19	1	1	1.0	0.0	1	5	19.2	14.344336861632886	4	45	17
+Manufacturer#3	almond antique misty red olive	1	1	1	1.0	0.0	2	5	19.2	14.344336861632886	4	45	14
+Manufacturer#3	almond antique olive coral navajo	45	1	1	1.0	0.0	3	5	19.2	14.344336861632886	4	45	19
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1.0	0.0	1	5	19.0	12.149074038789951	0	12	10
+Manufacturer#4	almond antique violet mint lemon	39	1	1	1.0	0.0	1	5	19.0	12.149074038789951	0	12	10
+Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1	1.0	0.0	2	5	19.0	12.149074038789951	0	12	10
+Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1	1.0	0.0	2	5	19.0	12.149074038789951	0	12	39
+Manufacturer#4	almond azure aquamarine papaya violet	12	1	1	1.0	0.0	3	5	19.0	12.149074038789951	0	12	27
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	1.0	0.0	1	5	21.6	16.206171663906314	1	23	31
+Manufacturer#5	almond antique medium spring khaki	6	1	1	1.0	0.0	1	5	21.6	16.206171663906314	1	23	31
+Manufacturer#5	almond antique sky peru orange	2	1	1	1.0	0.0	2	5	21.6	16.206171663906314	1	23	31
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1	1.0	0.0	2	5	21.6	16.206171663906314	1	23	6
+Manufacturer#5	almond azure blanched chiffon midnight	23	1	1	1.0	0.0	3	5	21.6	16.206171663906314	1	23	2
 PREHOOK: query: -- 16. testMultipleWindows
 select  p_mfgr,p_name, p_size,  
   rank() over(distribute by p_mfgr sort by p_mfgr) as r, 
@@ -744,32 +744,32 @@ window w1 as (distribute by p_mfgr sort 
 POSTHOOK: type: QUERY
 POSTHOOK: Input: default@part
 #### A masked pattern was here ####
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	0.16666666666666666	4	4	2
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	0.16666666666666666	2	4	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1	0.16666666666666666	44	10	2
-Manufacturer#1	almond aquamarine burnished black steel	28	1	1	0.16666666666666666	72	28	34
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1	0.16666666666666666	38	34	2
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1	0.16666666666666666	114	42	6
-Manufacturer#2	almond aquamarine midnight light salmon	2	1	1	0.2	56	2	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	0.2	14	14	14
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1	0.2	99	32	2
-Manufacturer#2	almond aquamarine rose maroon antique	25	1	1	0.2	81	25	40
-Manufacturer#2	almond antique violet turquoise frosted	40	1	1	0.2	54	40	14
-Manufacturer#3	almond antique misty red olive	1	1	1	0.2	51	1	14
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	1	0.2	31	14	17
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	0.2	17	31	17
-Manufacturer#3	almond antique metallic orange dim	19	1	1	0.2	50	50	17
-Manufacturer#3	almond antique olive coral navajo	45	1	1	0.2	96	45	19
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1	0.2	83	7	39
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	0.2	10	17	10
-Manufacturer#4	almond azure aquamarine papaya violet	12	1	1	0.2	95	29	27
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1	0.2	76	27	10
-Manufacturer#4	almond antique violet mint lemon	39	1	1	0.2	49	39	10
-Manufacturer#5	almond antique sky peru orange	2	1	1	0.2	39	2	31
-Manufacturer#5	almond antique medium spring khaki	6	1	1	0.2	37	8	31
-Manufacturer#5	almond azure blanched chiffon midnight	23	1	1	0.2	108	23	2
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	0.2	31	31	31
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1	0.2	85	46	6
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	1.0	4	4	2
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	1.0	2	4	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1	1.0	44	10	2
+Manufacturer#1	almond aquamarine burnished black steel	28	1	1	1.0	72	28	34
+Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1	1.0	38	34	2
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1	1.0	114	42	6
+Manufacturer#2	almond aquamarine midnight light salmon	2	1	1	1.0	56	2	14
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1.0	14	14	14
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1	1.0	99	32	2
+Manufacturer#2	almond aquamarine rose maroon antique	25	1	1	1.0	81	25	40
+Manufacturer#2	almond antique violet turquoise frosted	40	1	1	1.0	54	40	14
+Manufacturer#3	almond antique misty red olive	1	1	1	1.0	51	1	14
+Manufacturer#3	almond antique forest lavender goldenrod	14	1	1	1.0	31	14	17
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1.0	17	31	17
+Manufacturer#3	almond antique metallic orange dim	19	1	1	1.0	50	50	17
+Manufacturer#3	almond antique olive coral navajo	45	1	1	1.0	96	45	19
+Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1	1.0	83	7	39
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1.0	10	17	10
+Manufacturer#4	almond azure aquamarine papaya violet	12	1	1	1.0	95	29	27
+Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1	1.0	76	27	10
+Manufacturer#4	almond antique violet mint lemon	39	1	1	1.0	49	39	10
+Manufacturer#5	almond antique sky peru orange	2	1	1	1.0	39	2	31
+Manufacturer#5	almond antique medium spring khaki	6	1	1	1.0	37	8	31
+Manufacturer#5	almond azure blanched chiffon midnight	23	1	1	1.0	108	23	2
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	1.0	31	31	31
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1	1.0	85	46	6
 PREHOOK: query: -- 17. testCountStar
 select  p_mfgr,p_name, p_size,
 count(*) over(distribute by p_mfgr sort by p_mfgr ) as c, 
@@ -1018,7 +1018,6 @@ sum(p_retailprice) as s 
 from part 
 group by p_mfgr, p_brand
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- 22. testViewAsTableInputWithWindowing
 create view IF NOT EXISTS mfgr_price_view as 
 select p_mfgr, p_brand, 
@@ -1027,7 +1026,6 @@ from part 
 group by p_mfgr, p_brand
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@mfgr_price_view
-#### A masked pattern was here ####
 PREHOOK: query: select p_mfgr, p_brand, s, 
 sum(s) over w1  as s1
 from mfgr_price_view 
@@ -1067,7 +1065,6 @@ sum(p_retailprice) over w1  as s
 from part 
 window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
 PREHOOK: type: CREATEVIEW
-#### A masked pattern was here ####
 POSTHOOK: query: -- 23. testCreateViewWithWindowingQuery
 create view IF NOT EXISTS mfgr_brand_price_view as 
 select p_mfgr, p_brand, 
@@ -1076,7 +1073,6 @@ from part 
 window w1 as (distribute by p_mfgr sort by p_mfgr rows between 2 preceding and current row)
 POSTHOOK: type: CREATEVIEW
 POSTHOOK: Output: default@mfgr_brand_price_view
-#### A masked pattern was here ####
 PREHOOK: query: select * from mfgr_brand_price_view
 PREHOOK: type: QUERY
 PREHOOK: Input: default@mfgr_brand_price_view
@@ -1425,32 +1421,32 @@ POSTHOOK: Lineage: part_3.fv SCRIPT [(pa
 POSTHOOK: Lineage: part_3.p_mfgr SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.p_name SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
 POSTHOOK: Lineage: part_3.p_size SCRIPT [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), (part)part.FieldSchema(name:p_name, type:string, comment:null), (part)part.FieldSchema(name:p_mfgr, type:string, comment:null), (part)part.FieldSchema(name:p_brand, type:string, comment:null), (part)part.FieldSchema(name:p_type, type:string, comment:null), (part)part.FieldSchema(name:p_size, type:int, comment:null), (part)part.FieldSchema(name:p_container, type:string, comment:null), (part)part.FieldSchema(name:p_retailprice, type:double, comment:null), (part)part.FieldSchema(name:p_comment, type:string, comment:null), (part)part.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (part)part.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	0	4.0	4.0	2
-Manufacturer#1	almond antique burnished rose metallic	2	1	1	0	2.0	4.0	2
-Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1	0	44.0	10.0	2
-Manufacturer#1	almond aquamarine burnished black steel	28	1	1	0	72.0	28.0	34
-Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1	0	38.0	34.0	2
-Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1	0	114.0	42.0	6
-Manufacturer#2	almond aquamarine midnight light salmon	2	1	1	0	56.0	2.0	14
-Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	0	14.0	14.0	14
-Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1	0	99.0	32.0	2
-Manufacturer#2	almond aquamarine rose maroon antique	25	1	1	0	81.0	25.0	40
-Manufacturer#2	almond antique violet turquoise frosted	40	1	1	0	54.0	40.0	14
-Manufacturer#3	almond antique misty red olive	1	1	1	0	51.0	1.0	14
-Manufacturer#3	almond antique forest lavender goldenrod	14	1	1	0	31.0	14.0	17
-Manufacturer#3	almond antique chartreuse khaki white	17	1	1	0	17.0	31.0	17
-Manufacturer#3	almond antique metallic orange dim	19	1	1	0	50.0	50.0	17
-Manufacturer#3	almond antique olive coral navajo	45	1	1	0	96.0	45.0	19
-Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1	0	83.0	7.0	39
-Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	0	10.0	17.0	10
-Manufacturer#4	almond azure aquamarine papaya violet	12	1	1	0	95.0	29.0	27
-Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1	0	76.0	27.0	10
-Manufacturer#4	almond antique violet mint lemon	39	1	1	0	49.0	39.0	10
-Manufacturer#5	almond antique sky peru orange	2	1	1	0	39.0	2.0	31
-Manufacturer#5	almond antique medium spring khaki	6	1	1	0	37.0	8.0	31
-Manufacturer#5	almond azure blanched chiffon midnight	23	1	1	0	108.0	23.0	2
-Manufacturer#5	almond antique blue firebrick mint	31	1	1	0	31.0	31.0	31
-Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1	0	85.0	46.0	6
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	1	4.0	4.0	2
+Manufacturer#1	almond antique burnished rose metallic	2	1	1	1	2.0	4.0	2
+Manufacturer#1	almond antique salmon chartreuse burlywood	6	1	1	1	44.0	10.0	2
+Manufacturer#1	almond aquamarine burnished black steel	28	1	1	1	72.0	28.0	34
+Manufacturer#1	almond antique chartreuse lavender yellow	34	1	1	1	38.0	34.0	2
+Manufacturer#1	almond aquamarine pink moccasin thistle	42	1	1	1	114.0	42.0	6
+Manufacturer#2	almond aquamarine midnight light salmon	2	1	1	1	56.0	2.0	14
+Manufacturer#2	almond antique violet chocolate turquoise	14	1	1	1	14.0	14.0	14
+Manufacturer#2	almond aquamarine sandy cyan gainsboro	18	1	1	1	99.0	32.0	2
+Manufacturer#2	almond aquamarine rose maroon antique	25	1	1	1	81.0	25.0	40
+Manufacturer#2	almond antique violet turquoise frosted	40	1	1	1	54.0	40.0	14
+Manufacturer#3	almond antique misty red olive	1	1	1	1	51.0	1.0	14
+Manufacturer#3	almond antique forest lavender goldenrod	14	1	1	1	31.0	14.0	17
+Manufacturer#3	almond antique chartreuse khaki white	17	1	1	1	17.0	31.0	17
+Manufacturer#3	almond antique metallic orange dim	19	1	1	1	50.0	50.0	17
+Manufacturer#3	almond antique olive coral navajo	45	1	1	1	96.0	45.0	19
+Manufacturer#4	almond aquamarine yellow dodger mint	7	1	1	1	83.0	7.0	39
+Manufacturer#4	almond antique gainsboro frosted violet	10	1	1	1	10.0	17.0	10
+Manufacturer#4	almond azure aquamarine papaya violet	12	1	1	1	95.0	29.0	27
+Manufacturer#4	almond aquamarine floral ivory bisque	27	1	1	1	76.0	27.0	10
+Manufacturer#4	almond antique violet mint lemon	39	1	1	1	49.0	39.0	10
+Manufacturer#5	almond antique sky peru orange	2	1	1	1	39.0	2.0	31
+Manufacturer#5	almond antique medium spring khaki	6	1	1	1	37.0	8.0	31
+Manufacturer#5	almond azure blanched chiffon midnight	23	1	1	1	108.0	23.0	2
+Manufacturer#5	almond antique blue firebrick mint	31	1	1	1	31.0	31.0	31
+Manufacturer#5	almond aquamarine dodger light gainsboro	46	1	1	1	85.0	46.0	6
 PREHOOK: query: select * from part_3
 PREHOOK: type: QUERY
 PREHOOK: Input: default@part_3

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_expressions.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_expressions.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_expressions.q.out Wed Apr 17 07:29:38 2013
@@ -662,3 +662,59 @@ Manufacturer#5	1241.29
 Manufacturer#5	1424.0900000000001
 Manufacturer#5	1515.25
 Manufacturer#5	1534.532
+PREHOOK: query: -- multi table insert test
+create table t1 (a1 int, b1 string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: -- multi table insert test
+create table t1 (a1 int, b1 string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@t1
+PREHOOK: query: create table t2 (a1 int, b1 string)
+PREHOOK: type: CREATETABLE
+POSTHOOK: query: create table t2 (a1 int, b1 string)
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: default@t2
+PREHOOK: query: from (select sum(i) over (), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+PREHOOK: Output: default@t1
+PREHOOK: Output: default@t2
+POSTHOOK: query: from (select sum(i) over (), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+POSTHOOK: Output: default@t1
+POSTHOOK: Output: default@t2
+POSTHOOK: Lineage: t1.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+PREHOOK: query: select * from t1 limit 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: query: select * from t1 limit 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t1
+#### A masked pattern was here ####
+POSTHOOK: Lineage: t1.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+656584379	bob davidson
+656584379	alice zipper
+656584379	katie davidson
+PREHOOK: query: select * from t2 limit 3
+PREHOOK: type: QUERY
+PREHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: query: select * from t2 limit 3
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@t2
+#### A masked pattern was here ####
+POSTHOOK: Lineage: t1.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal, comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+656584379	bob davidson
+656584379	alice zipper
+656584379	katie davidson

Modified: hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_navfn.q.out
URL: http://svn.apache.org/viewvc/hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_navfn.q.out?rev=1468783&r1=1468782&r2=1468783&view=diff
==============================================================================
--- hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_navfn.q.out (original)
+++ hive/branches/HIVE-4115/ql/src/test/results/clientpositive/windowing_navfn.q.out Wed Apr 17 07:29:38 2013
@@ -579,3 +579,15 @@ alice miller	alice allen
 alice nixon	alice allen
 alice nixon	alice allen
 alice nixon	alice allen
+PREHOOK: query: select t, s, i, last_value(i) over (partition by t order by s) 
+from over10k where (s = 'oscar allen' or s = 'oscar carson') and t = 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@over10k
+#### A masked pattern was here ####
+POSTHOOK: query: select t, s, i, last_value(i) over (partition by t order by s) 
+from over10k where (s = 'oscar allen' or s = 'oscar carson') and t = 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@over10k
+#### A masked pattern was here ####
+10	oscar allen	65662	65662
+10	oscar carson	65549	65549



Mime
View raw message