Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table smallTbl1(key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@smallTbl1 POSTHOOK: query: create table smallTbl1(key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -24,6 +25,7 @@ RUN: Stage-2:STATS PREHOOK: query: create table smallTbl2(key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@smallTbl2 POSTHOOK: query: create table smallTbl2(key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -47,6 +49,7 @@ RUN: Stage-2:STATS PREHOOK: query: create table smallTbl3(key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@smallTbl3 POSTHOOK: query: create table smallTbl3(key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -70,6 +73,7 @@ RUN: Stage-2:STATS PREHOOK: query: create table smallTbl4(key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@smallTbl4 POSTHOOK: query: create table smallTbl4(key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -93,6 +97,7 @@ RUN: Stage-2:STATS PREHOOK: query: create table bigTbl(key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@bigTbl POSTHOOK: query: create table bigTbl(key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -678,6 +683,7 @@ RUN: Stage-0:DDL PREHOOK: query: create table bigTbl(key1 string, key2 string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@bigTbl POSTHOOK: query: create table bigTbl(key1 string, key2 string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -879,9 +885,9 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 File Output Operator compressed: false @@ -1376,9 +1382,9 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 File Output Operator compressed: false @@ -1422,10 +1428,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} 1 {KEY.reducesinkkey0} - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -1700,10 +1706,10 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Map Join Operator @@ -2004,10 +2010,10 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Map Join Operator @@ -2361,9 +2367,9 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 File Output Operator compressed: false @@ -2858,9 +2864,9 @@ STAGE PLANS: keys: 0 key1 (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 File Output Operator compressed: false @@ -2904,10 +2910,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} 1 {KEY.reducesinkkey0} - outputColumnNames: _col0, _col1, _col2, _col5 + outputColumnNames: _col0, _col1, _col2, _col6 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col2 (type: string), _col2 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col6 (type: string), _col2 (type: string), _col2 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4 Statistics: Num rows: 687 Data size: 9924 Basic stats: COMPLETE Column stats: NONE File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multiMapJoin2.q.out Fri Aug 22 21:36:47 2014 @@ -2191,6 +2191,7 @@ PREHOOK: query: -- Check if we can corre CREATE TABLE part_table(key string, value string) PARTITIONED BY (partitionId int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part_table POSTHOOK: query: -- Check if we can correctly handle partitioned table. CREATE TABLE part_table(key string, value string) PARTITIONED BY (partitionId int) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS create table src_multi1 like src PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_multi1 POSTHOOK: query: -- SORT_QUERY_RESULTS create table src_multi1 like src @@ -12,6 +13,7 @@ POSTHOOK: Output: default@src_multi1 PREHOOK: query: create table src_multi2 like src PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_multi2 POSTHOOK: query: create table src_multi2 like src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby.q.out Fri Aug 22 21:36:47 2014 @@ -4,6 +4,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS create table e1 (key string, count int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@e1 POSTHOOK: query: -- SORT_QUERY_RESULTS --HIVE-3699 Multiple insert overwrite into multiple tables query stores same results in all tables @@ -14,6 +15,7 @@ POSTHOOK: Output: default@e1 PREHOOK: query: create table e2 (key string, count int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@e2 POSTHOOK: query: create table e2 (key string, count int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby2.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: --HIVE-3699 Multiple ins create table e1 (count int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@e1 POSTHOOK: query: --HIVE-3699 Multiple insert overwrite into multiple tables query stores same results in all tables create table e1 (count int) POSTHOOK: type: CREATETABLE @@ -10,6 +11,7 @@ POSTHOOK: Output: default@e1 PREHOOK: query: create table e2 (percentile double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@e2 POSTHOOK: query: create table e2 (percentile double) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_gby3.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table e1 (key string, keyD double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@e1 POSTHOOK: query: create table e1 (key string, keyD double) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@e1 PREHOOK: query: create table e2 (key string, keyD double, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@e2 POSTHOOK: query: create table e2 (key string, keyD double, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -15,6 +17,7 @@ POSTHOOK: Output: default@e2 PREHOOK: query: create table e3 (key string, keyD double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@e3 POSTHOOK: query: create table e3 (key string, keyD double) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out Fri Aug 22 21:36:47 2014 @@ -12,6 +12,7 @@ POSTHOOK: Output: default@src_10 PREHOOK: query: create table src_lv1 (key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_lv1 POSTHOOK: query: create table src_lv1 (key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -19,6 +20,7 @@ POSTHOOK: Output: default@src_lv1 PREHOOK: query: create table src_lv2 (key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_lv2 POSTHOOK: query: create table src_lv2 (key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -26,6 +28,7 @@ POSTHOOK: Output: default@src_lv2 PREHOOK: query: create table src_lv3 (key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_lv3 POSTHOOK: query: create table src_lv3 (key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -81,10 +84,10 @@ STAGE PLANS: outputColumnNames: key Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) + expressions: _col0 (type: string), _col5 (type: double) outputColumnNames: _col0, _col1 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -103,10 +106,10 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) + expressions: _col0 (type: string), _col5 (type: double) outputColumnNames: _col0, _col1 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -124,10 +127,10 @@ STAGE PLANS: outputColumnNames: key Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) + expressions: _col0 (type: string), _col5 (type: double) outputColumnNames: _col0, _col1 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -146,10 +149,10 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) + expressions: _col0 (type: string), _col5 (type: double) outputColumnNames: _col0, _col1 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -280,9 +283,9 @@ POSTHOOK: Input: default@src_10 POSTHOOK: Output: default@src_lv1 POSTHOOK: Output: default@src_lv2 POSTHOOK: Lineage: src_lv1.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] -POSTHOOK: Lineage: src_lv1.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: src_lv1.value SIMPLE [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] -POSTHOOK: Lineage: src_lv2.value SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: src_lv2.value SIMPLE [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] PREHOOK: query: select * from src_lv1 PREHOOK: type: QUERY PREHOOK: Input: default@src_lv1 @@ -381,14 +384,14 @@ STAGE PLANS: outputColumnNames: key Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(_col4) + aggregations: sum(_col5) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 @@ -407,14 +410,14 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(_col4) + aggregations: sum(_col5) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 @@ -432,14 +435,14 @@ STAGE PLANS: outputColumnNames: key Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(_col4) + aggregations: sum(_col5) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 @@ -458,14 +461,14 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(_col4) + aggregations: sum(_col5) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 @@ -567,9 +570,9 @@ POSTHOOK: Input: default@src_10 POSTHOOK: Output: default@src_lv1 POSTHOOK: Output: default@src_lv2 POSTHOOK: Lineage: src_lv1.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] -POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] -POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] PREHOOK: query: select * from src_lv1 PREHOOK: type: QUERY PREHOOK: Input: default@src_lv1 @@ -652,14 +655,14 @@ STAGE PLANS: outputColumnNames: key Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(_col4) + aggregations: sum(_col5) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 @@ -678,14 +681,14 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(_col4) + aggregations: sum(_col5) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 @@ -843,7 +846,7 @@ POSTHOOK: Output: default@src_lv1 POSTHOOK: Output: default@src_lv2 POSTHOOK: Output: default@src_lv3 POSTHOOK: Lineage: src_lv1.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] -POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] POSTHOOK: Lineage: src_lv2.key SIMPLE [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ] POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] @@ -943,15 +946,15 @@ STAGE PLANS: outputColumnNames: key Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col4 (type: double), _col0 (type: string) - outputColumnNames: _col4, _col0 + expressions: _col5 (type: double), _col0 (type: string) + outputColumnNames: _col5, _col0 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: sum(DISTINCT _col0) - keys: _col4 (type: double), _col0 (type: string) + keys: _col5 (type: double), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE @@ -968,15 +971,15 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col4 (type: double), _col0 (type: string) - outputColumnNames: _col4, _col0 + expressions: _col5 (type: double), _col0 (type: string) + outputColumnNames: _col5, _col0 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: sum(DISTINCT _col0) - keys: _col4 (type: double), _col0 (type: string) + keys: _col5 (type: double), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE @@ -992,15 +995,15 @@ STAGE PLANS: outputColumnNames: key Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col4 (type: double), _col0 (type: string) - outputColumnNames: _col4, _col0 + expressions: _col5 (type: double), _col0 (type: string) + outputColumnNames: _col5, _col0 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: sum(DISTINCT _col0) - keys: _col4 (type: double), _col0 (type: string) + keys: _col5 (type: double), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE @@ -1018,15 +1021,15 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col4 (type: double), _col0 (type: string) - outputColumnNames: _col4, _col0 + expressions: _col5 (type: double), _col0 (type: string) + outputColumnNames: _col5, _col0 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: sum(DISTINCT _col0) - keys: _col4 (type: double), _col0 (type: string) + keys: _col5 (type: double), _col0 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE @@ -1187,9 +1190,9 @@ POSTHOOK: Input: default@src_10 POSTHOOK: Output: default@src_lv1 POSTHOOK: Output: default@src_lv2 POSTHOOK: Output: default@src_lv3 -POSTHOOK: Lineage: src_lv1.key SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: src_lv1.key SIMPLE [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] POSTHOOK: Lineage: src_lv1.value SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] -POSTHOOK: Lineage: src_lv2.key SIMPLE [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: src_lv2.key SIMPLE [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] POSTHOOK: Lineage: src_lv2.value SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ] POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] @@ -1270,6 +1273,7 @@ val_98 98.0 PREHOOK: query: create table src_lv4 (key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_lv4 POSTHOOK: query: create table src_lv4 (key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -1317,15 +1321,15 @@ STAGE PLANS: outputColumnNames: key Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(DISTINCT _col4) - keys: _col0 (type: string), _col4 (type: double) + aggregations: sum(DISTINCT _col5) + keys: _col0 (type: string), _col5 (type: double) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE @@ -1342,15 +1346,15 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(DISTINCT _col4) - keys: _col0 (type: string), _col4 (type: double) + aggregations: sum(DISTINCT _col5) + keys: _col0 (type: string), _col5 (type: double) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE @@ -1366,15 +1370,15 @@ STAGE PLANS: outputColumnNames: key Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(DISTINCT _col4) - keys: _col0 (type: string), _col4 (type: double) + aggregations: sum(DISTINCT _col5) + keys: _col0 (type: string), _col5 (type: double) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE @@ -1392,15 +1396,15 @@ STAGE PLANS: Statistics: Num rows: 10 Data size: 104 Basic stats: COMPLETE Column stats: NONE function name: explode Lateral View Join Operator - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col4 (type: double) - outputColumnNames: _col0, _col4 + expressions: _col0 (type: string), _col5 (type: double) + outputColumnNames: _col0, _col5 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: sum(DISTINCT _col4) - keys: _col0 (type: string), _col4 (type: double) + aggregations: sum(DISTINCT _col5) + keys: _col0 (type: string), _col5 (type: double) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 20 Data size: 208 Basic stats: COMPLETE Column stats: NONE @@ -1602,9 +1606,9 @@ POSTHOOK: Output: default@src_lv2 POSTHOOK: Output: default@src_lv3 POSTHOOK: Output: default@src_lv4 POSTHOOK: Lineage: src_lv1.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] -POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: src_lv1.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] POSTHOOK: Lineage: src_lv2.key SCRIPT [(src_10)src_10.FieldSchema(name:key, type:string, comment:null), ] -POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ] +POSTHOOK: Lineage: src_lv2.value EXPRESSION [(src_10)src_10.FieldSchema(name:ROW__ID, type:struct<transactionId:bigint,bucketId:int,rowId:bigint>, comment:), ] POSTHOOK: Lineage: src_lv3.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ] POSTHOOK: Lineage: src_lv3.value EXPRESSION [(src_10)src_10.null, ] POSTHOOK: Lineage: src_lv4.key SIMPLE [(src_10)src_10.FieldSchema(name:value, type:string, comment:null), ] Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_insert_move_tasks_share_dependencies.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS create table src_multi1 like src PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_multi1 POSTHOOK: query: -- SORT_QUERY_RESULTS create table src_multi1 like src @@ -12,6 +13,7 @@ POSTHOOK: Output: default@src_multi1 PREHOOK: query: create table src_multi2 like src PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_multi2 POSTHOOK: query: create table src_multi2 like src POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_join_union.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_join_union.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multi_join_union.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_join_union.q.out Fri Aug 22 21:36:47 2014 @@ -88,10 +88,10 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator condition expressions: - 0 {_col0} {_col1} {_col4} {_col5} + 0 {_col0} {_col1} {_col5} {_col6} 1 {_col0} keys: - 0 _col5 (type: string) + 0 _col6 (type: string) 1 _col1 (type: string) c-subquery2:a-subquery2:src14 TableScan @@ -112,10 +112,10 @@ STAGE PLANS: Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator condition expressions: - 0 {_col0} {_col1} {_col4} {_col5} + 0 {_col0} {_col1} {_col5} {_col6} 1 {_col0} keys: - 0 _col5 (type: string) + 0 _col6 (type: string) 1 _col1 (type: string) Stage: Stage-6 @@ -136,21 +136,21 @@ STAGE PLANS: keys: 0 key (type: string) 1 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {_col0} {_col1} {_col4} {_col5} + 0 {_col0} {_col1} {_col5} {_col6} 1 {_col0} {_col1} keys: - 0 _col5 (type: string) + 0 _col6 (type: string) 1 _col1 (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multi_sahooks.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multi_sahooks.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multi_sahooks.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multi_sahooks.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ DummySemanticAnalyzerHook1 Post: Hive ro PREHOOK: query: create table tbl_sahook (c string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl_sahook POSTHOOK: query: create table tbl_sahook (c string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -37,6 +38,7 @@ DummySemanticAnalyzerHook1 Post: Hive ro PREHOOK: query: create table tbl_sahooks (c string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl_sahooks POSTHOOK: query: create table tbl_sahooks (c string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -67,6 +69,7 @@ DummySemanticAnalyzerHook1 Post: Hive ro PREHOOK: query: create table tbl_sahooks (c string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl_sahooks POSTHOOK: query: create table tbl_sahooks (c string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -99,6 +102,7 @@ DummySemanticAnalyzerHook1 Post: Hive ro PREHOOK: query: create table tbl_sahooks (c string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl_sahooks POSTHOOK: query: create table tbl_sahooks (c string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/multigroupby_singlemr.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/multigroupby_singlemr.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/multigroupby_singlemr.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/multigroupby_singlemr.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE TBL(C1 INT, C2 INT, C3 INT, C4 INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@TBL POSTHOOK: query: CREATE TABLE TBL(C1 INT, C2 INT, C3 INT, C4 INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@TBL PREHOOK: query: CREATE TABLE DEST1(d1 INT, d2 INT) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@DEST1 POSTHOOK: query: CREATE TABLE DEST1(d1 INT, d2 INT) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -15,6 +17,7 @@ POSTHOOK: Output: default@DEST1 PREHOOK: query: CREATE TABLE DEST2(d1 INT, d2 INT, d3 INT) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@DEST2 POSTHOOK: query: CREATE TABLE DEST2(d1 INT, d2 INT, d3 INT) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -22,6 +25,7 @@ POSTHOOK: Output: default@DEST2 PREHOOK: query: CREATE TABLE DEST3(d1 INT, d2 INT, d3 INT, d4 INT) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@DEST3 POSTHOOK: query: CREATE TABLE DEST3(d1 INT, d2 INT, d3 INT, d4 INT) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -29,6 +33,7 @@ POSTHOOK: Output: default@DEST3 PREHOOK: query: CREATE TABLE DEST4(d1 INT, d2 INT, d3 INT, d4 INT) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@DEST4 POSTHOOK: query: CREATE TABLE DEST4(d1 INT, d2 INT, d3 INT, d4 INT) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nested_complex.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nested_complex.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nested_complex.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nested_complex.q.out Fri Aug 22 21:36:47 2014 @@ -12,6 +12,7 @@ WITH SERDEPROPERTIES ( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@nestedcomplex POSTHOOK: query: create table nestedcomplex ( simple_int int, max_nested_array array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<array<int>>>>>>>>>>>>>>>>>>>>>>>, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nestedvirtual.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nestedvirtual.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nestedvirtual.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nestedvirtual.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE pokes (foo INT, bar STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@pokes POSTHOOK: query: CREATE TABLE pokes (foo INT, bar STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@pokes PREHOOK: query: create table pokes2(foo INT, bar STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@pokes2 POSTHOOK: query: create table pokes2(foo INT, bar STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -48,6 +50,7 @@ POSTHOOK: Output: default@pokes2 PREHOOK: query: CREATE TABLE pokes (foo INT, bar STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@pokes POSTHOOK: query: CREATE TABLE pokes (foo INT, bar STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -55,6 +58,7 @@ POSTHOOK: Output: default@pokes PREHOOK: query: create table pokes2(foo INT, bar STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@pokes2 POSTHOOK: query: create table pokes2(foo INT, bar STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -95,6 +99,7 @@ POSTHOOK: Output: default@pokes2 PREHOOK: query: CREATE TABLE pokes (foo INT, bar STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@pokes POSTHOOK: query: CREATE TABLE pokes (foo INT, bar STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -102,6 +107,7 @@ POSTHOOK: Output: default@pokes PREHOOK: query: create table pokes2(foo INT, bar STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@pokes2 POSTHOOK: query: create table pokes2(foo INT, bar STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/newline.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/newline.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/newline.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/newline.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS create table tmp_tmp(key string, value string) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tmp_tmp POSTHOOK: query: -- SORT_QUERY_RESULTS create table tmp_tmp(key string, value string) stored as rcfile @@ -52,6 +53,7 @@ POSTHOOK: Output: default@tmp_tmp PREHOOK: query: create table tmp_tmp(key string, value string) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tmp_tmp POSTHOOK: query: create table tmp_tmp(key string, value string) stored as rcfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/no_hooks.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/no_hooks.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/no_hooks.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/no_hooks.q.out Fri Aug 22 21:36:47 2014 @@ -38,10 +38,10 @@ STAGE PLANS: condition expressions: 0 {VALUE._col0} {VALUE._col1} 1 {VALUE._col0} {VALUE._col1} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nomore_ambiguous_table_col.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nomore_ambiguous_table_col.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nomore_ambiguous_table_col.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nomore_ambiguous_table_col.q.out Fri Aug 22 21:36:47 2014 @@ -9,6 +9,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table ambiguous (key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@ambiguous POSTHOOK: query: create table ambiguous (key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nonmr_fetch.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nonmr_fetch.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nonmr_fetch.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nonmr_fetch.q.out Fri Aug 22 21:36:47 2014 @@ -1121,10 +1121,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_input37.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE table(string string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@table POSTHOOK: query: CREATE TABLE table(string string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nonreserved_keywords_insert_into1.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE insert (key INT, as STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@insert POSTHOOK: query: CREATE TABLE insert (key INT, as STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias2.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(dummy STRING, key INT, value DOUBLE) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/notable_alias3.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c string, key INT, value DOUBLE) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c string, key INT, value DOUBLE) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/null_column.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/null_column.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/null_column.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/null_column.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table temp_null(a int) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@temp_null POSTHOOK: query: create table temp_null(a int) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -30,6 +31,7 @@ NULL NULL PREHOOK: query: create table tt(a int, b string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tt POSTHOOK: query: create table tt(a int, b string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -61,6 +63,7 @@ NULL NULL PREHOOK: query: create table tt_b(a int, b string) row format serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe" PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tt_b POSTHOOK: query: create table tt_b(a int, b string) row format serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe" POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -106,6 +109,7 @@ POSTHOOK: Output: target/warehouse/null_ PREHOOK: query: create table temp_null2 (key string, value string) partitioned by (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@temp_null2 POSTHOOK: query: create table temp_null2 (key string, value string) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullformat.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullformat.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nullformat.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nullformat.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@base_tab POSTHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -57,6 +58,7 @@ STAGE PLANS: PREHOOK: query: CREATE TABLE null_tab1(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@null_tab1 POSTHOOK: query: CREATE TABLE null_tab1(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull' POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullformatCTAS.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullformatCTAS.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nullformatCTAS.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nullformatCTAS.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@base_tab POSTHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullformatdir.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullformatdir.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nullformatdir.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nullformatdir.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@base_tab POSTHOOK: query: CREATE TABLE base_tab(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -58,6 +59,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE null_tab2(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@null_tab2 POSTHOOK: query: CREATE TABLE null_tab2(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull' POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup3.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstparttbl POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -91,6 +92,7 @@ POSTHOOK: Input: default@tstparttbl@ds=2 PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstparttbl2 POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -189,6 +191,7 @@ POSTHOOK: Output: default@tstparttbl PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstparttbl POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -287,6 +290,7 @@ POSTHOOK: Output: default@tstparttbl2 PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstparttbl2 POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup5.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nullgroup5.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstparttbl POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -17,6 +18,7 @@ POSTHOOK: Output: default@tstparttbl@ds= PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstparttbl2 POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullinput.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullinput.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nullinput.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nullinput.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table tstnullinut(a string, b string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstnullinut POSTHOOK: query: create table tstnullinut(a string, b string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullinput2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullinput2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nullinput2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nullinput2.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table nulltbl(key int) partitioned by (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@nulltbl POSTHOOK: query: create table nulltbl(key int) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/nullscript.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/nullscript.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/nullscript.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/nullscript.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE nullscript(KEY STRING, VALUE STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@nullscript POSTHOOK: query: CREATE TABLE nullscript(KEY STRING, VALUE STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/optional_outer.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/optional_outer.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/optional_outer.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/optional_outer.q.out Fri Aug 22 21:36:47 2014 @@ -35,10 +35,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -92,10 +92,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -149,10 +149,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -206,10 +206,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -263,10 +263,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -320,10 +320,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_analyze.q.out Fri Aug 22 21:36:47 2014 @@ -8,6 +8,7 @@ PREHOOK: query: CREATE TABLE orc_create_ state string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people_staging POSTHOOK: query: CREATE TABLE orc_create_people_staging ( id int, first_name string, @@ -40,6 +41,7 @@ CREATE TABLE orc_create_people ( STORED AS orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people POSTHOOK: query: -- non-partitioned table -- partial scan gather CREATE TABLE orc_create_people ( @@ -136,6 +138,7 @@ CREATE TABLE orc_create_people ( STORED AS orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people POSTHOOK: query: -- auto stats gather CREATE TABLE orc_create_people ( id int, @@ -226,6 +229,7 @@ PARTITIONED BY (state string) STORED AS orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people POSTHOOK: query: -- partitioned table -- partial scan gather CREATE TABLE orc_create_people ( @@ -383,6 +387,7 @@ PARTITIONED BY (state string) STORED AS orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people POSTHOOK: query: -- auto stats gather CREATE TABLE orc_create_people ( id int, @@ -533,6 +538,7 @@ into 4 buckets STORED AS orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people POSTHOOK: query: -- partitioned and bucketed table -- partial scan gather CREATE TABLE orc_create_people ( @@ -696,6 +702,7 @@ into 4 buckets STORED AS orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people POSTHOOK: query: -- auto stats gather CREATE TABLE orc_create_people ( id int, @@ -847,6 +854,7 @@ PARTITIONED BY (state string) STORED AS orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people POSTHOOK: query: -- create table with partitions containing text and ORC files. -- ORC files implements StatsProvidingRecordReader but text files does not. -- So the partition containing text file should not have statistics. Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_create.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_create.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/orc_create.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_create.q.out Fri Aug 22 21:36:47 2014 @@ -33,6 +33,7 @@ PREHOOK: query: CREATE TABLE orc_create_ MAP KEYS TERMINATED BY ':' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_staging POSTHOOK: query: CREATE TABLE orc_create_staging ( str STRING, mp MAP<STRING,STRING>, @@ -86,6 +87,7 @@ PREHOOK: query: CREATE TABLE orc_create STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create POSTHOOK: query: CREATE TABLE orc_create (key INT, value STRING) PARTITIONED BY (ds string) STORED AS ORC @@ -140,6 +142,7 @@ PREHOOK: query: CREATE TABLE orc_create PARTITIONED BY (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create POSTHOOK: query: CREATE TABLE orc_create (key INT, value STRING) PARTITIONED BY (ds string) POSTHOOK: type: CREATETABLE @@ -237,6 +240,7 @@ PREHOOK: query: CREATE TABLE orc_create PARTITIONED BY (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create POSTHOOK: query: CREATE TABLE orc_create (key INT, value STRING) PARTITIONED BY (ds string) POSTHOOK: type: CREATETABLE @@ -286,6 +290,7 @@ PREHOOK: query: CREATE TABLE orc_create_ ) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_complex POSTHOOK: query: CREATE TABLE orc_create_complex ( str STRING, mp MAP<STRING,STRING>, @@ -424,6 +429,7 @@ PREHOOK: query: CREATE TABLE orc_create_ state string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people_staging POSTHOOK: query: CREATE TABLE orc_create_people_staging ( id int, first_name string, @@ -456,6 +462,7 @@ PARTITIONED BY (state string) STORED AS orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_create_people POSTHOOK: query: CREATE TABLE orc_create_people ( id int, first_name string, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_createas1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_createas1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/orc_createas1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_createas1.q.out Fri Aug 22 21:36:47 2014 @@ -14,6 +14,7 @@ PREHOOK: query: CREATE TABLE orc_createa PARTITIONED BY (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_createas1a POSTHOOK: query: CREATE TABLE orc_createas1a (key INT, value STRING) PARTITIONED BY (ds string) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_dictionary_threshold.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_dictionary_threshold.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/orc_dictionary_threshold.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_dictionary_threshold.q.out Fri Aug 22 21:36:47 2014 @@ -8,6 +8,7 @@ STORED AS INPUTFORMAT 'org.apache.hadoop OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_orc POSTHOOK: query: -- Set the threshold to -1 to guarantee dictionary encoding is turned off -- Tests that the data can be read back correctly when a string column is stored -- without dictionary encoding @@ -63,6 +64,7 @@ POSTHOOK: Output: default@test_orc PREHOOK: query: CREATE TABLE src_thousand(key STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_thousand POSTHOOK: query: CREATE TABLE src_thousand(key STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ STORED AS INPUTFORMAT 'org.apache.hadoop OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_orc POSTHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE test_orc (key STRING) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_diff_part_cols2.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ CREATE TABLE test_orc (key STRING) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_orc POSTHOOK: query: -- Create a table with one column, write to it, then add an additional column -- This can break reads