Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing.q.out Fri Aug 22 21:36:47 2014 @@ -16,6 +16,7 @@ CREATE TABLE part( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part POSTHOOK: query: -- data setup CREATE TABLE part( p_partkey INT, @@ -1263,6 +1264,7 @@ dr INT, s DOUBLE) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part_1 POSTHOOK: query: -- 25. testMultipleInserts3SWQs CREATE TABLE part_1( p_mfgr STRING, @@ -1285,6 +1287,7 @@ s2 DOUBLE, fv1 INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part_2 POSTHOOK: query: CREATE TABLE part_2( p_mfgr STRING, p_name STRING, @@ -1306,6 +1309,7 @@ ca INT, fv INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part_3 POSTHOOK: query: CREATE TABLE part_3( p_mfgr STRING, p_name STRING, @@ -1366,26 +1370,26 @@ POSTHOOK: Input: default@part POSTHOOK: Output: default@part_1 POSTHOOK: Output: default@part_2 POSTHOOK: Output: default@part_3 -POSTHOOK: Lineage: part_1.dr 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_1.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_1.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_1.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:), ] -POSTHOOK: Lineage: part_1.r 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_1.s 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_2.cud 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_2.dr 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_2.fv1 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_2.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_2.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_2.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:), ] -POSTHOOK: Lineage: part_2.r 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_2.s2 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.c 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.ca 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.fv 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_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:), ] +POSTHOOK: Lineage: part_1.dr 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_1.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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_1.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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_1.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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_1.r 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_1.s 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_2.cud 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_2.dr 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_2.fv1 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_2.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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_2.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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_2.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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_2.r 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_2.s2 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_3.c 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_3.ca 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +POSTHOOK: Lineage: part_3.fv 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] +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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, 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:), (part)part.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] PREHOOK: query: select * from part_1 PREHOOK: type: QUERY PREHOOK: Input: default@part_1 @@ -2330,3 +2334,25 @@ where p_mfgr = 'Manufacturer#6' POSTHOOK: type: QUERY POSTHOOK: Input: default@part #### A masked pattern was here #### +PREHOOK: query: -- 46. window sz is same as partition sz +select p_retailprice, avg(p_retailprice) over (partition by p_mfgr order by p_name rows between current row and 6 following), +sum(p_retailprice) over (partition by p_mfgr order by p_name rows between current row and 6 following) +from part +where p_mfgr='Manufacturer#1' +PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### +POSTHOOK: query: -- 46. window sz is same as partition sz +select p_retailprice, avg(p_retailprice) over (partition by p_mfgr order by p_name rows between current row and 6 following), +sum(p_retailprice) over (partition by p_mfgr order by p_name rows between current row and 6 following) +from part +where p_mfgr='Manufacturer#1' +POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### +1173.15 1458.2883333333336 8749.730000000001 +1173.15 1515.3160000000003 7576.580000000002 +1753.76 1600.8575000000003 6403.430000000001 +1602.59 1549.8900000000003 4649.670000000001 +1414.42 1523.5400000000004 3047.080000000001 +1632.66 1632.6600000000008 1632.6600000000008
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out Fri Aug 22 21:36:47 2014 @@ -16,6 +16,7 @@ CREATE TABLE part( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part POSTHOOK: query: -- data setup CREATE TABLE part( p_partkey INT, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_columnPruning.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_columnPruning.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_columnPruning.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_columnPruning.q.out Fri Aug 22 21:36:47 2014 @@ -16,6 +16,7 @@ CREATE TABLE part( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part POSTHOOK: query: -- data setup CREATE TABLE part( p_partkey INT, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_decimal.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_decimal.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_decimal.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_decimal.q.out Fri Aug 22 21:36:47 2014 @@ -16,6 +16,7 @@ CREATE TABLE part( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part POSTHOOK: query: -- data setup CREATE TABLE part( p_partkey INT, @@ -52,6 +53,7 @@ PREHOOK: query: create table part_dec( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part_dec POSTHOOK: query: create table part_dec( p_partkey INT, p_name STRING, @@ -97,8 +99,8 @@ from part_dec POSTHOOK: type: QUERY POSTHOOK: Input: default@part_dec #### A masked pattern was here #### -Manufacturer#1 1173.15 1173.15 2346.3 -Manufacturer#1 1173.15 1173.15 2346.3 +Manufacturer#1 1173.15 1173.15 2346.30 +Manufacturer#1 1173.15 1173.15 2346.30 Manufacturer#1 1414.42 1173.15 3760.72 Manufacturer#1 1602.59 1173.15 5363.31 Manufacturer#1 1632.66 1173.15 6995.97 @@ -116,7 +118,7 @@ Manufacturer#3 1922.98 1190.27 7532.61 Manufacturer#4 1206.26 1206.26 1206.26 Manufacturer#4 1290.35 1206.26 2496.61 Manufacturer#4 1375.42 1206.26 3872.03 -Manufacturer#4 1620.67 1206.26 5492.7 +Manufacturer#4 1620.67 1206.26 5492.70 Manufacturer#4 1844.92 1206.26 7337.62 Manufacturer#5 1018.1 1018.1 1018.1 Manufacturer#5 1464.48 1018.1 2482.58 @@ -137,8 +139,8 @@ from part_dec POSTHOOK: type: QUERY POSTHOOK: Input: default@part_dec #### A masked pattern was here #### -Manufacturer#1 1173.15 1173.15 2346.3 -Manufacturer#1 1173.15 1173.15 2346.3 +Manufacturer#1 1173.15 1173.15 2346.30 +Manufacturer#1 1173.15 1173.15 2346.30 Manufacturer#1 1414.42 1414.42 1414.42 Manufacturer#1 1602.59 1602.59 1602.59 Manufacturer#1 1632.66 1632.66 1632.66 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_expressions.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_expressions.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_expressions.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_expressions.q.out Fri Aug 22 21:36:47 2014 @@ -16,6 +16,7 @@ CREATE TABLE part( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part POSTHOOK: query: -- data setup CREATE TABLE part( p_partkey INT, @@ -59,6 +60,7 @@ PREHOOK: query: create table over10k( fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over10k POSTHOOK: query: create table over10k( t tinyint, si smallint, @@ -672,6 +674,7 @@ PREHOOK: query: -- multi table insert te create table t1 (a1 int, b1 string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t1 POSTHOOK: query: -- multi table insert test create table t1 (a1 int, b1 string) POSTHOOK: type: CREATETABLE @@ -680,6 +683,7 @@ POSTHOOK: Output: default@t1 PREHOOK: query: create table t2 (a1 int, b1 string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t2 POSTHOOK: query: create table t2 (a1 int, b1 string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -694,10 +698,10 @@ 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(4,2), 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(4,2), 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(4,2), 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(4,2), 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.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(4,2), 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:), (over10k)over10k.FieldSchema(name:ROW__ID, type:struct<transactionId: bigint,bucketId:int,rowId:bigint>, 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(4,2), 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:), (over10k)over10k.FieldSchema(name:ROW__ID, type:struct<transactionId: bigint,bucketId:int,rowId:bigint>, 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(4,2), 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:), (over10k)over10k.FieldSchema(name:ROW__ID, type:struct<transactionId: bigint,bucketId:int,rowId:bigint>, 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(4,2), 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:), (over10k)over10k.FieldSchema(name:ROW__ID, type:struct<transactionId: bigint,bucketId:int,rowId:bigint>, comment:), ] PREHOOK: query: select * from t1 limit 3 PREHOOK: type: QUERY PREHOOK: Input: default@t1 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out Fri Aug 22 21:36:47 2014 @@ -18,6 +18,7 @@ PREHOOK: query: create table over10k( fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over10k POSTHOOK: query: create table over10k( t tinyint, si smallint, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_navfn.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_navfn.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_navfn.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_navfn.q.out Fri Aug 22 21:36:47 2014 @@ -18,6 +18,7 @@ PREHOOK: query: create table over10k( fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over10k POSTHOOK: query: create table over10k( t tinyint, si smallint, @@ -276,13 +277,13 @@ POSTHOOK: Input: default@over10k 65536 98.42 65536 0.93 65536 83.48 -65536 75.7 +65536 75.70 65536 88.04 65536 94.09 65536 33.45 65536 44.41 65536 22.15 -65536 20.5 +65536 20.50 65536 58.86 65536 30.91 65536 74.47 @@ -299,9 +300,9 @@ POSTHOOK: Input: default@over10k 65536 80.26 65536 35.07 65536 95.88 -65536 30.6 +65536 30.60 65536 46.97 -65536 58.8 +65536 58.80 65536 5.72 65536 29.27 65536 62.25 @@ -325,7 +326,7 @@ POSTHOOK: Input: default@over10k 65537 35.86 65537 47.75 65537 1.12 -65537 52.9 +65537 52.90 65537 53.92 65537 43.45 65537 7.52 @@ -339,20 +340,20 @@ POSTHOOK: Input: default@over10k 65537 56.48 65537 83.21 65537 56.52 -65537 36.6 -65537 59.7 +65537 36.60 +65537 59.70 65537 80.14 -65537 66.3 +65537 66.30 65537 94.87 65537 40.92 -65537 25.2 +65537 25.20 65537 7.36 65538 NULL 65538 53.35 65538 54.64 65538 76.67 65538 15.17 -65538 1.2 +65538 1.20 65538 13.71 65538 81.59 65538 43.33 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_ntile.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_ntile.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_ntile.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_ntile.q.out Fri Aug 22 21:36:47 2014 @@ -18,6 +18,7 @@ PREHOOK: query: create table over10k( fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over10k POSTHOOK: query: create table over10k( t tinyint, si smallint, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_rank.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_rank.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_rank.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_rank.q.out Fri Aug 22 21:36:47 2014 @@ -18,6 +18,7 @@ PREHOOK: query: create table over10k( fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over10k POSTHOOK: query: create table over10k( t tinyint, si smallint, @@ -507,16 +508,16 @@ where rnk = 1 limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### -2013-03-01 09:11:58.70307 0.5 1 -2013-03-01 09:11:58.70307 0.5 1 -2013-03-01 09:11:58.70307 0.5 1 -2013-03-01 09:11:58.70307 0.5 1 -2013-03-01 09:11:58.70307 0.5 1 -2013-03-01 09:11:58.70307 0.5 1 -2013-03-01 09:11:58.70307 0.5 1 -2013-03-01 09:11:58.70307 0.5 1 -2013-03-01 09:11:58.70307 0.5 1 -2013-03-01 09:11:58.70307 0.5 1 +2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.50 1 +2013-03-01 09:11:58.70307 0.50 1 PREHOOK: query: select ts, dec, rnk from (select ts, dec, @@ -545,16 +546,16 @@ where dec = 89.5 limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### -2013-03-01 09:11:58.703124 89.5 1 -2013-03-01 09:11:58.703124 89.5 1 -2013-03-01 09:11:58.703124 89.5 1 -2013-03-01 09:11:58.703124 89.5 1 -2013-03-01 09:11:58.703124 89.5 1 -2013-03-01 09:11:58.703124 89.5 1 -2013-03-01 09:11:58.703124 89.5 1 -2013-03-01 09:11:58.703124 89.5 1 -2013-03-01 09:11:58.703124 89.5 1 -2013-03-01 09:11:58.703124 89.5 1 +2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.50 1 +2013-03-01 09:11:58.703124 89.50 1 PREHOOK: query: select ts, dec, rnk from (select ts, dec, @@ -585,13 +586,13 @@ where rnk = 1 limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@over10k #### A masked pattern was here #### -2013-03-01 09:11:58.70307 37.3 1 -2013-03-01 09:11:58.70307 37.3 1 -2013-03-01 09:11:58.70307 37.3 1 -2013-03-01 09:11:58.70307 37.3 1 -2013-03-01 09:11:58.70307 37.3 1 -2013-03-01 09:11:58.70307 37.3 1 -2013-03-01 09:11:58.70307 37.3 1 -2013-03-01 09:11:58.70307 37.3 1 -2013-03-01 09:11:58.70307 37.3 1 -2013-03-01 09:11:58.70307 37.3 1 +2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.30 1 +2013-03-01 09:11:58.70307 37.30 1 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_streaming.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_streaming.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_streaming.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_streaming.q.out Fri Aug 22 21:36:47 2014 @@ -16,6 +16,7 @@ CREATE TABLE part( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part POSTHOOK: query: -- data setup CREATE TABLE part( p_partkey INT, @@ -59,6 +60,7 @@ PREHOOK: query: create table over10k( fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over10k POSTHOOK: query: create table over10k( t tinyint, si smallint, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_udaf.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_udaf.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_udaf.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_udaf.q.out Fri Aug 22 21:36:47 2014 @@ -18,6 +18,7 @@ PREHOOK: query: create table over10k( fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over10k POSTHOOK: query: create table over10k( t tinyint, si smallint, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/windowing_windowspec.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/windowing_windowspec.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/windowing_windowspec.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/windowing_windowspec.q.out Fri Aug 22 21:36:47 2014 @@ -18,6 +18,7 @@ PREHOOK: query: create table over10k( fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over10k POSTHOOK: query: create table over10k( t tinyint, si smallint, Modified: hive/branches/cbo/ql/src/test/results/compiler/plan/case_sensitivity.q.xml URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/compiler/plan/case_sensitivity.q.xml?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/compiler/plan/case_sensitivity.q.xml (original) +++ hive/branches/cbo/ql/src/test/results/compiler/plan/case_sensitivity.q.xml Fri Aug 22 21:36:47 2014 @@ -1184,7 +1184,7 @@ <string>src_thrift</string> </void> <void property="type"> - <object class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> + <object id="PrimitiveTypeInfo2" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> <void property="typeName"> <string>bigint</string> </void> @@ -1214,6 +1214,52 @@ </void> </object> </void> + <void method="add"> + <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> + <void property="hiddenVirtualCol"> + <boolean>true</boolean> + </void> + <void property="internalName"> + <string>ROW__ID</string> + </void> + <void property="tabAlias"> + <string>src_thrift</string> + </void> + <void property="type"> + <object class="org.apache.hadoop.hive.serde2.typeinfo.StructTypeInfo"> + <void property="allStructFieldNames"> + <object class="java.util.ArrayList"> + <void method="add"> + <string>transactionid</string> + </void> + <void method="add"> + <string>bucketid</string> + </void> + <void method="add"> + <string>rowid</string> + </void> + </object> + </void> + <void property="allStructFieldTypeInfos"> + <object class="java.util.ArrayList"> + <void method="add"> + <object idref="PrimitiveTypeInfo2"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo1"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo2"/> + </void> + </object> + </void> + </object> + </void> + <void property="typeName"> + <string>struct<transactionid:bigint,bucketid:int,rowid:bigint></string> + </void> + </object> + </void> </void> </object> </void> Modified: hive/branches/cbo/ql/src/test/results/compiler/plan/cast1.q.xml URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/compiler/plan/cast1.q.xml?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/compiler/plan/cast1.q.xml (original) +++ hive/branches/cbo/ql/src/test/results/compiler/plan/cast1.q.xml Fri Aug 22 21:36:47 2014 @@ -1039,7 +1039,7 @@ <string>src</string> </void> <void property="type"> - <object class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> + <object id="PrimitiveTypeInfo4" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> <void property="typeName"> <string>bigint</string> </void> @@ -1069,6 +1069,52 @@ </void> </object> </void> + <void method="add"> + <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> + <void property="hiddenVirtualCol"> + <boolean>true</boolean> + </void> + <void property="internalName"> + <string>ROW__ID</string> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="type"> + <object class="org.apache.hadoop.hive.serde2.typeinfo.StructTypeInfo"> + <void property="allStructFieldNames"> + <object class="java.util.ArrayList"> + <void method="add"> + <string>transactionid</string> + </void> + <void method="add"> + <string>bucketid</string> + </void> + <void method="add"> + <string>rowid</string> + </void> + </object> + </void> + <void property="allStructFieldTypeInfos"> + <object class="java.util.ArrayList"> + <void method="add"> + <object idref="PrimitiveTypeInfo4"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo0"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo4"/> + </void> + </object> + </void> + </object> + </void> + <void property="typeName"> + <string>struct<transactionid:bigint,bucketid:int,rowid:bigint></string> + </void> + </object> + </void> </void> </object> </void> Modified: hive/branches/cbo/ql/src/test/results/compiler/plan/groupby1.q.xml URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/compiler/plan/groupby1.q.xml?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/compiler/plan/groupby1.q.xml (original) +++ hive/branches/cbo/ql/src/test/results/compiler/plan/groupby1.q.xml Fri Aug 22 21:36:47 2014 @@ -571,7 +571,7 @@ <void method="add"> <object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc"> <void property="typeInfo"> - <object class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> + <object id="PrimitiveTypeInfo2" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> <void property="typeName"> <string>int</string> </void> @@ -705,7 +705,7 @@ <string>src</string> </void> <void property="typeInfo"> - <object id="PrimitiveTypeInfo2" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> + <object id="PrimitiveTypeInfo3" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> <void property="typeName"> <string>bigint</string> </void> @@ -745,6 +745,50 @@ </object> </void> <void method="put"> + <string>ROW__ID</string> + <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> + <void property="column"> + <string>ROW__ID</string> + </void> + <void property="isPartitionColOrVirtualCol"> + <boolean>true</boolean> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="typeInfo"> + <object id="StructTypeInfo0" class="org.apache.hadoop.hive.serde2.typeinfo.StructTypeInfo"> + <void property="allStructFieldNames"> + <object class="java.util.ArrayList"> + <void method="add"> + <string>transactionid</string> + </void> + <void method="add"> + <string>bucketid</string> + </void> + <void method="add"> + <string>rowid</string> + </void> + </object> + </void> + <void property="allStructFieldTypeInfos"> + <object class="java.util.ArrayList"> + <void method="add"> + <object idref="PrimitiveTypeInfo3"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo2"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo3"/> + </void> + </object> + </void> + </object> + </void> + </object> + </void> + <void method="put"> <string>key</string> <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> <void property="column"> @@ -920,7 +964,7 @@ <string>src</string> </void> <void property="type"> - <object idref="PrimitiveTypeInfo2"/> + <object idref="PrimitiveTypeInfo3"/> </void> <void property="typeName"> <string>bigint</string> @@ -946,6 +990,25 @@ </void> </object> </void> + <void method="add"> + <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> + <void property="hiddenVirtualCol"> + <boolean>true</boolean> + </void> + <void property="internalName"> + <string>ROW__ID</string> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="type"> + <object idref="StructTypeInfo0"/> + </void> + <void property="typeName"> + <string>struct<transactionid:bigint,bucketid:int,rowid:bigint></string> + </void> + </object> + </void> </void> </object> </void> Modified: hive/branches/cbo/ql/src/test/results/compiler/plan/groupby2.q.xml URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/compiler/plan/groupby2.q.xml?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/compiler/plan/groupby2.q.xml (original) +++ hive/branches/cbo/ql/src/test/results/compiler/plan/groupby2.q.xml Fri Aug 22 21:36:47 2014 @@ -832,6 +832,50 @@ </object> </void> <void method="put"> + <string>ROW__ID</string> + <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> + <void property="column"> + <string>ROW__ID</string> + </void> + <void property="isPartitionColOrVirtualCol"> + <boolean>true</boolean> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="typeInfo"> + <object id="StructTypeInfo0" class="org.apache.hadoop.hive.serde2.typeinfo.StructTypeInfo"> + <void property="allStructFieldNames"> + <object class="java.util.ArrayList"> + <void method="add"> + <string>transactionid</string> + </void> + <void method="add"> + <string>bucketid</string> + </void> + <void method="add"> + <string>rowid</string> + </void> + </object> + </void> + <void property="allStructFieldTypeInfos"> + <object class="java.util.ArrayList"> + <void method="add"> + <object idref="PrimitiveTypeInfo3"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo2"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo3"/> + </void> + </object> + </void> + </object> + </void> + </object> + </void> + <void method="put"> <string>key</string> <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> <void property="column"> @@ -1033,6 +1077,25 @@ </void> </object> </void> + <void method="add"> + <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> + <void property="hiddenVirtualCol"> + <boolean>true</boolean> + </void> + <void property="internalName"> + <string>ROW__ID</string> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="type"> + <object idref="StructTypeInfo0"/> + </void> + <void property="typeName"> + <string>struct<transactionid:bigint,bucketid:int,rowid:bigint></string> + </void> + </object> + </void> </void> </object> </void> Modified: hive/branches/cbo/ql/src/test/results/compiler/plan/groupby3.q.xml URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/compiler/plan/groupby3.q.xml?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/compiler/plan/groupby3.q.xml (original) +++ hive/branches/cbo/ql/src/test/results/compiler/plan/groupby3.q.xml Fri Aug 22 21:36:47 2014 @@ -1078,6 +1078,50 @@ </object> </void> <void method="put"> + <string>ROW__ID</string> + <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> + <void property="column"> + <string>ROW__ID</string> + </void> + <void property="isPartitionColOrVirtualCol"> + <boolean>true</boolean> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="typeInfo"> + <object id="StructTypeInfo1" class="org.apache.hadoop.hive.serde2.typeinfo.StructTypeInfo"> + <void property="allStructFieldNames"> + <object class="java.util.ArrayList"> + <void method="add"> + <string>transactionid</string> + </void> + <void method="add"> + <string>bucketid</string> + </void> + <void method="add"> + <string>rowid</string> + </void> + </object> + </void> + <void property="allStructFieldTypeInfos"> + <object class="java.util.ArrayList"> + <void method="add"> + <object idref="PrimitiveTypeInfo1"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo3"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo1"/> + </void> + </object> + </void> + </object> + </void> + </object> + </void> + <void method="put"> <string>key</string> <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> <void property="column"> @@ -1251,6 +1295,25 @@ </void> </object> </void> + <void method="add"> + <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> + <void property="hiddenVirtualCol"> + <boolean>true</boolean> + </void> + <void property="internalName"> + <string>ROW__ID</string> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="type"> + <object idref="StructTypeInfo1"/> + </void> + <void property="typeName"> + <string>struct<transactionid:bigint,bucketid:int,rowid:bigint></string> + </void> + </object> + </void> </void> </object> </void> Modified: hive/branches/cbo/ql/src/test/results/compiler/plan/groupby4.q.xml URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/compiler/plan/groupby4.q.xml?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/compiler/plan/groupby4.q.xml (original) +++ hive/branches/cbo/ql/src/test/results/compiler/plan/groupby4.q.xml Fri Aug 22 21:36:47 2014 @@ -516,6 +516,50 @@ </object> </void> <void method="put"> + <string>ROW__ID</string> + <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> + <void property="column"> + <string>ROW__ID</string> + </void> + <void property="isPartitionColOrVirtualCol"> + <boolean>true</boolean> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="typeInfo"> + <object id="StructTypeInfo0" class="org.apache.hadoop.hive.serde2.typeinfo.StructTypeInfo"> + <void property="allStructFieldNames"> + <object class="java.util.ArrayList"> + <void method="add"> + <string>transactionid</string> + </void> + <void method="add"> + <string>bucketid</string> + </void> + <void method="add"> + <string>rowid</string> + </void> + </object> + </void> + <void property="allStructFieldTypeInfos"> + <object class="java.util.ArrayList"> + <void method="add"> + <object idref="PrimitiveTypeInfo2"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo1"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo2"/> + </void> + </object> + </void> + </object> + </void> + </object> + </void> + <void method="put"> <string>key</string> <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> <void property="column"> @@ -689,6 +733,25 @@ </void> </object> </void> + <void method="add"> + <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> + <void property="hiddenVirtualCol"> + <boolean>true</boolean> + </void> + <void property="internalName"> + <string>ROW__ID</string> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="type"> + <object idref="StructTypeInfo0"/> + </void> + <void property="typeName"> + <string>struct<transactionid:bigint,bucketid:int,rowid:bigint></string> + </void> + </object> + </void> </void> </object> </void> Modified: hive/branches/cbo/ql/src/test/results/compiler/plan/groupby5.q.xml URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/compiler/plan/groupby5.q.xml?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/compiler/plan/groupby5.q.xml (original) +++ hive/branches/cbo/ql/src/test/results/compiler/plan/groupby5.q.xml Fri Aug 22 21:36:47 2014 @@ -423,7 +423,7 @@ <void method="add"> <object class="org.apache.hadoop.hive.ql.plan.ExprNodeConstantDesc"> <void property="typeInfo"> - <object class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> + <object id="PrimitiveTypeInfo2" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> <void property="typeName"> <string>int</string> </void> @@ -557,7 +557,7 @@ <string>src</string> </void> <void property="typeInfo"> - <object id="PrimitiveTypeInfo2" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> + <object id="PrimitiveTypeInfo3" class="org.apache.hadoop.hive.serde2.typeinfo.PrimitiveTypeInfo"> <void property="typeName"> <string>bigint</string> </void> @@ -597,6 +597,50 @@ </object> </void> <void method="put"> + <string>ROW__ID</string> + <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> + <void property="column"> + <string>ROW__ID</string> + </void> + <void property="isPartitionColOrVirtualCol"> + <boolean>true</boolean> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="typeInfo"> + <object id="StructTypeInfo0" class="org.apache.hadoop.hive.serde2.typeinfo.StructTypeInfo"> + <void property="allStructFieldNames"> + <object class="java.util.ArrayList"> + <void method="add"> + <string>transactionid</string> + </void> + <void method="add"> + <string>bucketid</string> + </void> + <void method="add"> + <string>rowid</string> + </void> + </object> + </void> + <void property="allStructFieldTypeInfos"> + <object class="java.util.ArrayList"> + <void method="add"> + <object idref="PrimitiveTypeInfo3"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo2"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo3"/> + </void> + </object> + </void> + </object> + </void> + </object> + </void> + <void method="put"> <string>key</string> <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> <void property="column"> @@ -772,7 +816,7 @@ <string>src</string> </void> <void property="type"> - <object idref="PrimitiveTypeInfo2"/> + <object idref="PrimitiveTypeInfo3"/> </void> <void property="typeName"> <string>bigint</string> @@ -798,6 +842,25 @@ </void> </object> </void> + <void method="add"> + <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> + <void property="hiddenVirtualCol"> + <boolean>true</boolean> + </void> + <void property="internalName"> + <string>ROW__ID</string> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="type"> + <object idref="StructTypeInfo0"/> + </void> + <void property="typeName"> + <string>struct<transactionid:bigint,bucketid:int,rowid:bigint></string> + </void> + </object> + </void> </void> </object> </void> Modified: hive/branches/cbo/ql/src/test/results/compiler/plan/groupby6.q.xml URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/compiler/plan/groupby6.q.xml?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/compiler/plan/groupby6.q.xml (original) +++ hive/branches/cbo/ql/src/test/results/compiler/plan/groupby6.q.xml Fri Aug 22 21:36:47 2014 @@ -516,6 +516,50 @@ </object> </void> <void method="put"> + <string>ROW__ID</string> + <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> + <void property="column"> + <string>ROW__ID</string> + </void> + <void property="isPartitionColOrVirtualCol"> + <boolean>true</boolean> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="typeInfo"> + <object id="StructTypeInfo0" class="org.apache.hadoop.hive.serde2.typeinfo.StructTypeInfo"> + <void property="allStructFieldNames"> + <object class="java.util.ArrayList"> + <void method="add"> + <string>transactionid</string> + </void> + <void method="add"> + <string>bucketid</string> + </void> + <void method="add"> + <string>rowid</string> + </void> + </object> + </void> + <void property="allStructFieldTypeInfos"> + <object class="java.util.ArrayList"> + <void method="add"> + <object idref="PrimitiveTypeInfo2"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo1"/> + </void> + <void method="add"> + <object idref="PrimitiveTypeInfo2"/> + </void> + </object> + </void> + </object> + </void> + </object> + </void> + <void method="put"> <string>key</string> <object class="org.apache.hadoop.hive.ql.plan.ExprNodeColumnDesc"> <void property="column"> @@ -689,6 +733,25 @@ </void> </object> </void> + <void method="add"> + <object class="org.apache.hadoop.hive.ql.exec.ColumnInfo"> + <void property="hiddenVirtualCol"> + <boolean>true</boolean> + </void> + <void property="internalName"> + <string>ROW__ID</string> + </void> + <void property="tabAlias"> + <string>src</string> + </void> + <void property="type"> + <object idref="StructTypeInfo0"/> + </void> + <void property="typeName"> + <string>struct<transactionid:bigint,bucketid:int,rowid:bigint></string> + </void> + </object> + </void> </void> </object> </void>