Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/ctas.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/ctas.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/ctas.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/ctas.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- EXCLUDE_HADOOP_MAJOR_ create table nzhang_Tmp(a int, b string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_Tmp POSTHOOK: query: -- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S) create table nzhang_Tmp(a int, b string) @@ -875,6 +876,7 @@ POSTHOOK: Output: default@nzhang_ctas5 PREHOOK: query: create table nzhang_ctas6 (key string, `to` string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_ctas6 POSTHOOK: query: create table nzhang_ctas6 (key string, `to` string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ CREATE TABLE src1_rot13_iof(key STRING, OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13OutputFormat' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src1_rot13_iof POSTHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE src1_rot13_iof(key STRING, value STRING) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/dynpart_sort_optimization.q.out Fri Aug 22 21:36:47 2014 @@ -14,6 +14,7 @@ PREHOOK: query: create table over1k( fields terminated by '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k POSTHOOK: query: create table over1k( t tinyint, si smallint, @@ -47,6 +48,7 @@ PREHOOK: query: create table over1k_part partitioned by (ds string, t tinyint) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k_part POSTHOOK: query: create table over1k_part( si smallint, i int, @@ -59,6 +61,7 @@ POSTHOOK: Output: default@over1k_part PREHOOK: query: create table over1k_part_limit like over1k_part PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k_part_limit POSTHOOK: query: create table over1k_part_limit like over1k_part POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -72,6 +75,7 @@ PREHOOK: query: create table over1k_part clustered by (si) into 4 buckets PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k_part_buck POSTHOOK: query: create table over1k_part_buck( si smallint, i int, @@ -92,6 +96,7 @@ PREHOOK: query: create table over1k_part sorted by (f) into 4 buckets PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k_part_buck_sort POSTHOOK: query: create table over1k_part_buck_sort( si smallint, i int, @@ -1218,6 +1223,7 @@ create table over1k_part2( partitioned by (ds string, t tinyint) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k_part2 POSTHOOK: query: -- tests for HIVE-6883 create table over1k_part2( si smallint, @@ -1686,6 +1692,7 @@ create table over1k_part_buck_sort2( sorted by (f) into 1 buckets PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k_part_buck_sort2 POSTHOOK: query: -- hadoop-1 does not honor number of reducers in local mode. There is always only 1 reducer irrespective of the number of buckets. -- Hence all records go to one bucket and all other buckets will be empty. Similar to HIVE-6867. However, hadoop-2 honors number -- of reducers and records are spread across all reducers. To avoid this inconsistency we will make number of buckets to 1 for this test. Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/enforce_order.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/enforce_order.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/enforce_order.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/enforce_order.q.out Fri Aug 22 21:36:47 2014 @@ -9,6 +9,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table table_asc(key string, value string) clustered by (key) sorted by (key ASC) into 1 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@table_asc POSTHOOK: query: create table table_asc(key string, value string) clustered by (key) sorted by (key ASC) into 1 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -16,6 +17,7 @@ POSTHOOK: Output: default@table_asc PREHOOK: query: create table table_desc(key string, value string) clustered by (key) sorted by (key DESC) into 1 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@table_desc POSTHOOK: query: create table table_desc(key string, value string) clustered by (key) sorted by (key DESC) into 1 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/filter_join_breaktask.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/filter_join_breaktask2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/filter_join_breaktask2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/filter_join_breaktask2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/filter_join_breaktask2.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: create table T1(c1 strin partitioned by (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@T1 POSTHOOK: query: create table T1(c1 string, c2 string, c3 string, c4 string, c5 string, c6 string, c7 string) partitioned by (ds string) POSTHOOK: type: CREATETABLE @@ -10,6 +11,7 @@ POSTHOOK: Output: default@T1 PREHOOK: query: create table T2(c1 string, c2 string, c3 string, c0 string, c4 string, c5 string, c6 string, c7 string, c8 string, c9 string, c10 string, c11 string, c12 string, c13 string, c14 string, c15 string, c16 string, c17 string, c18 string, c19 string, c20 string, c21 string, c22 string, c23 string, c24 string, c25 string) partitioned by (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@T2 POSTHOOK: query: create table T2(c1 string, c2 string, c3 string, c0 string, c4 string, c5 string, c6 string, c7 string, c8 string, c9 string, c10 string, c11 string, c12 string, c13 string, c14 string, c15 string, c16 string, c17 string, c18 string, c19 string, c20 string, c21 string, c22 string, c23 string, c24 string, c25 string) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -17,6 +19,7 @@ POSTHOOK: Output: default@T2 PREHOOK: query: create table T3 (c0 bigint, c1 bigint, c2 int) partitioned by (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@T3 POSTHOOK: query: create table T3 (c0 bigint, c1 bigint, c2 int) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -24,6 +27,7 @@ POSTHOOK: Output: default@T3 PREHOOK: query: create table T4 (c0 bigint, c1 string, c2 string, c3 string, c4 string, c5 string, c6 string, c7 string, c8 string, c9 string, c10 string, c11 string, c12 string, c13 string, c14 string, c15 string, c16 string, c17 string, c18 string, c19 string, c20 string, c21 string, c22 string, c23 string, c24 string, c25 string, c26 string, c27 string, c28 string, c29 string, c30 string, c31 string, c32 string, c33 string, c34 string, c35 string, c36 string, c37 string, c38 string, c39 string, c40 string, c41 string, c42 string, c43 string, c44 string, c45 string, c46 string, c47 string, c48 string, c49 string, c50 string, c51 string, c52 string, c53 string, c54 string, c55 string, c56 string, c57 string, c58 string, c59 string, c60 string, c61 string, c62 string, c63 string, c64 string, c65 string, c66 string, c67 bigint, c68 string, c69 string, c70 bigint, c71 bigint, c72 bigint, c73 string, c74 string, c75 string, c76 string, c77 string, c78 string, c79 string, c80 string, c8 1 bigint, c82 bigint, c83 bigint) partitioned by (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@T4 POSTHOOK: query: create table T4 (c0 bigint, c1 string, c2 string, c3 string, c4 string, c5 string, c6 string, c7 string, c8 string, c9 string, c10 string, c11 string, c12 string, c13 string, c14 string, c15 string, c16 string, c17 string, c18 string, c19 string, c20 string, c21 string, c22 string, c23 string, c24 string, c25 string, c26 string, c27 string, c28 string, c29 string, c30 string, c31 string, c32 string, c33 string, c34 string, c35 string, c36 string, c37 string, c38 string, c39 string, c40 string, c41 string, c42 string, c43 string, c44 string, c45 string, c46 string, c47 string, c48 string, c49 string, c50 string, c51 string, c52 string, c53 string, c54 string, c55 string, c56 string, c57 string, c58 string, c59 string, c60 string, c61 string, c62 string, c63 string, c64 string, c65 string, c66 string, c67 bigint, c68 string, c69 string, c70 bigint, c71 bigint, c72 bigint, c73 string, c74 string, c75 string, c76 string, c77 string, c78 string, c79 string, c80 string, c 81 bigint, c82 bigint, c83 bigint) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest_g1 POSTHOOK: query: CREATE TABLE dest_g1(key INT, value DOUBLE) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby2.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest_g2 POSTHOOK: query: CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/groupby3.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 DOUBLE, c6 DOUBLE, c7 DOUBLE, c8 DOUBLE, c9 DOUBLE) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 DOUBLE, c2 DOUBLE, c3 DOUBLE, c4 DOUBLE, c5 DOUBLE, c6 DOUBLE, c7 DOUBLE, c8 DOUBLE, c9 DOUBLE) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert1.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS create table insert1(key int, value string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@insert1 POSTHOOK: query: -- SORT_QUERY_RESULTS create table insert1(key int, value string) stored as textfile @@ -12,6 +13,7 @@ POSTHOOK: Output: default@insert1 PREHOOK: query: create table insert2(key int, value string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@insert2 POSTHOOK: query: create table insert2(key int, value string) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -133,16 +135,20 @@ STAGE PLANS: PREHOOK: query: -- HIVE-3465 create database x PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:x POSTHOOK: query: -- HIVE-3465 create database x POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:x PREHOOK: query: create table x.insert1(key int, value string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:x +PREHOOK: Output: x@x.insert1 POSTHOOK: query: create table x.insert1(key int, value string) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:x POSTHOOK: Output: x@insert1 +POSTHOOK: Output: x@x.insert1 PREHOOK: query: explain insert into table x.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) PREHOOK: type: QUERY POSTHOOK: query: explain insert into table x.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) @@ -338,16 +344,21 @@ STAGE PLANS: PREHOOK: query: -- HIVE-3676 CREATE DATABASE db2 PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:db2 POSTHOOK: query: -- HIVE-3676 CREATE DATABASE db2 POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:db2 PREHOOK: query: USE db2 PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:db2 POSTHOOK: query: USE db2 POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:db2 PREHOOK: query: CREATE TABLE result(col1 STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:db2 +PREHOOK: Output: db2@result POSTHOOK: query: CREATE TABLE result(col1 STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db2 @@ -382,18 +393,24 @@ db2_insert1 db2_insert2 PREHOOK: query: USE default PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default POSTHOOK: query: USE default POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default PREHOOK: query: CREATE DATABASE db1 PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:db1 POSTHOOK: query: CREATE DATABASE db1 POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:db1 PREHOOK: query: CREATE TABLE db1.result(col1 STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:db1 +PREHOOK: Output: db1@db1.result POSTHOOK: query: CREATE TABLE db1.result(col1 STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:db1 +POSTHOOK: Output: db1@db1.result POSTHOOK: Output: db1@result PREHOOK: query: INSERT OVERWRITE TABLE db1.result SELECT 'db1_insert1' FROM src LIMIT 1 PREHOOK: type: QUERY Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_into1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_into1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_into1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_into1.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE insert_into1 (key int, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@insert_into1 POSTHOOK: query: CREATE TABLE insert_into1 (key int, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_into2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_into2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_into2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/insert_into2.q.out Fri Aug 22 21:36:47 2014 @@ -6,6 +6,7 @@ PREHOOK: query: CREATE TABLE insert_into PARTITIONED BY (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@insert_into2 POSTHOOK: query: CREATE TABLE insert_into2 (key int, value string) PARTITIONED BY (ds string) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/join1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/join1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/join1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/join1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest_j1 POSTHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -61,10 +62,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} 1 {VALUE._col0} - outputColumnNames: _col0, _col5 + outputColumnNames: _col0, _col6 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: UDFToInteger(_col0) (type: int), _col5 (type: string) + expressions: UDFToInteger(_col0) (type: int), _col6 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/leftsemijoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/leftsemijoin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/leftsemijoin.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/leftsemijoin.q.out Fri Aug 22 21:36:47 2014 @@ -14,6 +14,7 @@ PREHOOK: query: CREATE TABLE sales (name ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@sales POSTHOOK: query: CREATE TABLE sales (name STRING, id INT) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' POSTHOOK: type: CREATETABLE @@ -23,6 +24,7 @@ PREHOOK: query: CREATE TABLE things (id ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@things POSTHOOK: query: CREATE TABLE things (id INT, name STRING) partitioned by (ds string) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part1.q.out Fri Aug 22 21:36:47 2014 @@ -15,6 +15,7 @@ ds=2008-04-09/hr=12 PREHOOK: query: create table if not exists nzhang_part1 like srcpart PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_part1 POSTHOOK: query: create table if not exists nzhang_part1 like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -22,6 +23,7 @@ POSTHOOK: Output: default@nzhang_part1 PREHOOK: query: create table if not exists nzhang_part2 like srcpart PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_part2 POSTHOOK: query: create table if not exists nzhang_part2 like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part2.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ create table if not exists nzhang_part_b clustered by (key) into 10 buckets PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_part_bucket POSTHOOK: query: -- SORT_QUERY_RESULTS create table if not exists nzhang_part_bucket (key string, value string) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/load_dyn_part3.q.out Fri Aug 22 21:36:47 2014 @@ -15,6 +15,7 @@ ds=2008-04-09/hr=12 PREHOOK: query: create table if not exists nzhang_part3 like srcpart PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@nzhang_part3 POSTHOOK: query: create table if not exists nzhang_part3 like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapjoin_decimal.q.out Fri Aug 22 21:36:47 2014 @@ -13,6 +13,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@over1k POSTHOOK: query: CREATE TABLE over1k(t tinyint, si smallint, i int, @@ -40,6 +41,7 @@ POSTHOOK: Output: default@over1k PREHOOK: query: CREATE TABLE t1(dec decimal(4,2)) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t1 POSTHOOK: query: CREATE TABLE t1(dec decimal(4,2)) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -56,6 +58,7 @@ POSTHOOK: Lineage: t1.dec SIMPLE [(over1 PREHOOK: query: CREATE TABLE t2(dec decimal(4,0)) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t2 POSTHOOK: query: CREATE TABLE t2(dec decimal(4,0)) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -116,12 +119,12 @@ STAGE PLANS: keys: 0 dec (type: decimal(4,2)) 1 dec (type: decimal(4,0)) - outputColumnNames: _col0, _col3 + outputColumnNames: _col0, _col4 input vertices: 1 Map 1 Statistics: Num rows: 577 Data size: 64680 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: decimal(4,2)), _col3 (type: decimal(4,0)) + expressions: _col0 (type: decimal(4,2)), _col4 (type: decimal(4,0)) outputColumnNames: _col0, _col1 Statistics: Num rows: 577 Data size: 64680 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -148,112 +151,112 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@t1 POSTHOOK: Input: default@t2 #### A masked pattern was here #### -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -45 45 -45 45 -45 45 -45 45 -45 45 -79 79 -79 79 -79 79 -79 79 -79 79 -79 79 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -6 6 -6 6 -6 6 -6 6 -6 6 -6 6 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) PREHOOK: type: QUERY PREHOOK: Input: default@t1 @@ -264,112 +267,112 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@t1 POSTHOOK: Input: default@t2 #### A masked pattern was here #### -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -45 45 -45 45 -45 45 -45 45 -45 45 -79 79 -79 79 -79 79 -79 79 -79 79 -79 79 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -6 6 -6 6 -6 6 -6 6 -6 6 -6 6 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 PREHOOK: query: select t1.dec, t2.dec from t1 join t2 on (t1.dec=t2.dec) PREHOOK: type: QUERY PREHOOK: Input: default@t1 @@ -380,109 +383,109 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@t1 POSTHOOK: Input: default@t2 #### A masked pattern was here #### -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -9 9 -45 45 -45 45 -45 45 -45 45 -45 45 -79 79 -79 79 -79 79 -79 79 -79 79 -79 79 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -17 17 -6 6 -6 6 -6 6 -6 6 -6 6 -6 6 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -62 62 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -64 64 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -89 89 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -70 70 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 -14 14 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +9.00 9 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +45.00 45 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +79.00 79 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +17.00 17 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +6.00 6 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +62.00 62 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +64.00 64 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +89.00 89 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +70.00 70 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 +14.00 14 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapreduce1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapreduce1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapreduce1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapreduce1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapreduce2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapreduce2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapreduce2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/mapreduce2.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(key INT, ten INT, one INT, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/merge1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/merge1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/merge1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/merge1.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table dest1(key int, val int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: create table dest1(key int, val int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -424,6 +425,7 @@ POSTHOOK: Output: default@dest1 PREHOOK: query: create table test_src(key string, value string) partitioned by (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_src POSTHOOK: query: create table test_src(key string, value string) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -431,6 +433,7 @@ POSTHOOK: Output: default@test_src PREHOOK: query: create table dest1(key string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: create table dest1(key string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/merge2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/merge2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/merge2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/merge2.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table test1(key int, val int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test1 POSTHOOK: query: create table test1(key int, val int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -424,6 +425,7 @@ POSTHOOK: Output: default@test1 PREHOOK: query: create table test_src(key string, value string) partitioned by (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_src POSTHOOK: query: create table test_src(key string, value string) partitioned by (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -431,6 +433,7 @@ POSTHOOK: Output: default@test_src PREHOOK: query: create table test1(key string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test1 POSTHOOK: query: create table test1(key string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadata_only_queries.q.out Fri Aug 22 21:36:47 2014 @@ -14,6 +14,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, @@ -53,6 +54,7 @@ PREHOOK: query: create table stats_tbl( bin binary) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@stats_tbl POSTHOOK: query: create table stats_tbl( t tinyint, si smallint, @@ -82,6 +84,7 @@ PREHOOK: query: create table stats_tbl_p bin binary) partitioned by (dt string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@stats_tbl_part POSTHOOK: query: create table stats_tbl_part( t tinyint, si smallint, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadataonly1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadataonly1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadataonly1.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/metadataonly1.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/mrr.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/mrr.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/mrr.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/mrr.q.out Fri Aug 22 21:36:47 2014 @@ -445,15 +445,15 @@ STAGE PLANS: condition expressions: 0 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col4, _col5 + outputColumnNames: _col5, _col6 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col4 (type: string), _col5 (type: string) - outputColumnNames: _col4, _col5 + expressions: _col5 (type: string), _col6 (type: string) + outputColumnNames: _col5, _col6 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: count(DISTINCT _col5) - keys: _col4 (type: string), _col5 (type: string) + aggregations: count(DISTINCT _col6) + keys: _col5 (type: string), _col6 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE @@ -852,17 +852,17 @@ STAGE PLANS: keys: 0 key (type: string) 1 key (type: string) - outputColumnNames: _col4, _col5 + outputColumnNames: _col5, _col6 input vertices: 0 Map 4 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col4 (type: string), _col5 (type: string) - outputColumnNames: _col4, _col5 + expressions: _col5 (type: string), _col6 (type: string) + outputColumnNames: _col5, _col6 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: count(DISTINCT _col5) - keys: _col4 (type: string), _col5 (type: string) + aggregations: count(DISTINCT _col6) + keys: _col5 (type: string), _col6 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_analyze.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_analyze.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_analyze.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/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/tez/orc_merge1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge1.q.out Fri Aug 22 21:36:47 2014 @@ -10,6 +10,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer PARTITIONED BY (ds STRING, part STRING) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orcfile_merge1 POSTHOOK: query: CREATE TABLE orcfile_merge1 (key INT, value STRING) PARTITIONED BY (ds STRING, part STRING) STORED AS ORC POSTHOOK: type: CREATETABLE @@ -19,6 +20,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer PARTITIONED BY (ds STRING, part STRING) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orcfile_merge1b POSTHOOK: query: CREATE TABLE orcfile_merge1b (key INT, value STRING) PARTITIONED BY (ds STRING, part STRING) STORED AS ORC POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge2.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orcfile_merge2a POSTHOOK: query: CREATE TABLE orcfile_merge2a (key INT, value STRING) PARTITIONED BY (one string, two string, three string) STORED AS ORC Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge3.q.out Fri Aug 22 21:36:47 2014 @@ -10,6 +10,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer PARTITIONED BY (ds string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orcfile_merge3a POSTHOOK: query: CREATE TABLE orcfile_merge3a (key int, value string) PARTITIONED BY (ds string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE @@ -18,6 +19,7 @@ POSTHOOK: Output: default@orcfile_merge3 PREHOOK: query: CREATE TABLE orcfile_merge3b (key int, value string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orcfile_merge3b POSTHOOK: query: CREATE TABLE orcfile_merge3b (key int, value string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge4.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge4.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/orc_merge4.q.out Fri Aug 22 21:36:47 2014 @@ -10,6 +10,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer PARTITIONED BY (ds string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orcfile_merge3a POSTHOOK: query: CREATE TABLE orcfile_merge3a (key int, value string) PARTITIONED BY (ds string) STORED AS ORC POSTHOOK: type: CREATETABLE @@ -18,6 +19,7 @@ POSTHOOK: Output: default@orcfile_merge3 PREHOOK: query: CREATE TABLE orcfile_merge3b (key int, value string) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orcfile_merge3b POSTHOOK: query: CREATE TABLE orcfile_merge3b (key int, value string) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/ptf.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/ptf.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/ptf.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/ptf.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, @@ -826,6 +827,7 @@ dr INT, s DOUBLE) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part_4 POSTHOOK: query: -- 17. testMultipleInserts2SWQsWithPTF CREATE TABLE part_4( p_mfgr STRING, @@ -848,6 +850,7 @@ cud DOUBLE, fv1 INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@part_5 POSTHOOK: query: CREATE TABLE part_5( p_mfgr STRING, p_name STRING, @@ -896,20 +899,20 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@part POSTHOOK: Output: default@part_4 POSTHOOK: Output: default@part_5 -POSTHOOK: Lineage: part_4.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_4.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_4.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_4.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_4.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_4.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_5.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_5.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_5.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_5.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_5.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_5.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_5.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_5.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_4.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_4.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_4.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_4.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_4.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_4.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_5.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_5.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_5.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_5.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_5.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_5.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_5.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_5.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:), ] PREHOOK: query: select * from part_4 PREHOOK: type: QUERY PREHOOK: Input: default@part_4 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/sample1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/sample1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/sample1.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/sample1.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/scriptfile1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/scriptfile1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/scriptfile1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/scriptfile1.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- EXCLUDE_OS_WINDOWS CREATE TABLE dest1(key INT, value STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: -- EXCLUDE_OS_WINDOWS CREATE TABLE dest1(key INT, value STRING) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/stats_counter_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/stats_counter_partitioned.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/stats_counter_partitioned.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/stats_counter_partitioned.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- partitioned table ana create table dummy (key string, value string) partitioned by (ds string, hr string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dummy POSTHOOK: query: -- partitioned table analyze create table dummy (key string, value string) partitioned by (ds string, hr string) @@ -140,6 +141,7 @@ PREHOOK: query: -- static partitioned ta create table dummy (key string, value string) partitioned by (ds string, hr string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dummy POSTHOOK: query: -- static partitioned table on insert create table dummy (key string, value string) partitioned by (ds string, hr string) @@ -263,6 +265,7 @@ PREHOOK: query: -- dynamic partitioned t create table dummy (key int) partitioned by (hr int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dummy POSTHOOK: query: -- dynamic partitioned table on insert create table dummy (key int) partitioned by (hr int) @@ -272,6 +275,7 @@ POSTHOOK: Output: default@dummy PREHOOK: query: CREATE TABLE tbl(key int, value int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl POSTHOOK: query: CREATE TABLE tbl(key int, value int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/stats_noscan_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/stats_noscan_1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/stats_noscan_1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/stats_noscan_1.q.out Fri Aug 22 21:36:47 2014 @@ -4,6 +4,7 @@ PREHOOK: query: -- test analyze table .. create table analyze_srcpart like srcpart PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@analyze_srcpart POSTHOOK: query: -- test analyze table ... compute statistics noscan -- 1. test full spec @@ -294,6 +295,7 @@ PREHOOK: query: -- 2. test partial spec create table analyze_srcpart_partial like srcpart PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@analyze_srcpart_partial POSTHOOK: query: -- 2. test partial spec create table analyze_srcpart_partial like srcpart POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/subquery_in.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/subquery_in.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/subquery_in.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/subquery_in.q.out Fri Aug 22 21:36:47 2014 @@ -20,6 +20,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, @@ -67,6 +68,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@lineitem POSTHOOK: query: CREATE TABLE lineitem (L_ORDERKEY INT, L_PARTKEY INT, L_SUPPKEY INT, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/temp_table.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/temp_table.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/temp_table.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/temp_table.q.out Fri Aug 22 21:36:47 2014 @@ -283,6 +283,7 @@ POSTHOOK: Input: default@foo PREHOOK: query: CREATE TEMPORARY TABLE baz LIKE foo PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@baz POSTHOOK: query: CREATE TEMPORARY TABLE baz LIKE foo POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -300,6 +301,7 @@ POSTHOOK: Lineage: baz.value SIMPLE [(fo PREHOOK: query: CREATE TEMPORARY TABLE bay (key string, value string) STORED AS orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@bay POSTHOOK: query: CREATE TEMPORARY TABLE bay (key string, value string) STORED AS orc POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -359,12 +361,16 @@ srcbucket2 srcpart PREHOOK: query: CREATE DATABASE two PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:two POSTHOOK: query: CREATE DATABASE two POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:two PREHOOK: query: USE two PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:two POSTHOOK: query: USE two POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:two PREHOOK: query: SHOW TABLES PREHOOK: type: SHOWTABLES POSTHOOK: query: SHOW TABLES @@ -383,8 +389,10 @@ POSTHOOK: type: SHOWTABLES foo PREHOOK: query: use default PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default POSTHOOK: query: use default POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default PREHOOK: query: DROP DATABASE two CASCADE PREHOOK: type: DROPDATABASE PREHOOK: Input: database:two Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_dml.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_dml.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_dml.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_dml.q.out Fri Aug 22 21:36:47 2014 @@ -421,6 +421,7 @@ PREHOOK: query: -- dyn partitions CREATE TABLE tmp_src_part (c string) PARTITIONED BY (d int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tmp_src_part POSTHOOK: query: -- dyn partitions CREATE TABLE tmp_src_part (c string) PARTITIONED BY (d int) POSTHOOK: type: CREATETABLE @@ -837,6 +838,7 @@ PREHOOK: query: -- multi insert CREATE TABLE even (c int, d string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@even POSTHOOK: query: -- multi insert CREATE TABLE even (c int, d string) POSTHOOK: type: CREATETABLE @@ -845,6 +847,7 @@ POSTHOOK: Output: default@even PREHOOK: query: CREATE TABLE odd (c int, d string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@odd POSTHOOK: query: CREATE TABLE odd (c int, d string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_fsstat.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_fsstat.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_fsstat.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_fsstat.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE tab_part (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tab_part POSTHOOK: query: CREATE TABLE tab_part (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@tab_part PREHOOK: query: CREATE TABLE t1 (key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@t1 POSTHOOK: query: CREATE TABLE t1 (key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table orc_src (key string, value string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@orc_src POSTHOOK: query: create table orc_src (key string, value string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -68,10 +69,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} 1 {KEY.reducesinkkey0} - outputColumnNames: _col0, _col4 + outputColumnNames: _col0, _col5 Statistics: Num rows: 275 Data size: 48400 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (_col0 = _col4) (type: boolean) + predicate: (_col0 = _col5) (type: boolean) Statistics: Num rows: 137 Data size: 24112 Basic stats: COMPLETE Column stats: NONE Select Operator Statistics: Num rows: 137 Data size: 24112 Basic stats: COMPLETE Column stats: NONE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_join_tests.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_join_tests.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_join_tests.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/tez_join_tests.q.out Fri Aug 22 21:36:47 2014 @@ -58,10 +58,10 @@ STAGE PLANS: condition expressions: 0 1 {KEY.reducesinkkey0} {VALUE._col0} - outputColumnNames: _col4, _col5 + outputColumnNames: _col5, _col6 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col4 (type: string), _col5 (type: string) + expressions: _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator