You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by am...@apache.org on 2013/04/17 09:29:46 UTC
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...
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