You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/08/22 23:37:21 UTC
svn commit: r1619936 [41/49] - in /hive/branches/cbo: ./ accumulo-handler/
ant/src/org/apache/hadoop/hive/ant/ bin/
common/src/java/org/apache/hadoop/hive/ant/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hadoop/hive/c...
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out Fri Aug 22 21:36:47 2014
@@ -5,6 +5,7 @@ PREHOOK: query: -- This test verifies wr
create table tmptable(key string) partitioned by (part string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tmptable
POSTHOOK: query: -- This test verifies writing a query using dynamic partitions
-- which results in no partitions actually being created with
-- hive.stats.reliable set to true
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_partition.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_partition.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_partition.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/stats_empty_partition.q.out Fri Aug 22 21:36:47 2014
@@ -4,6 +4,7 @@ PREHOOK: query: -- This test verifies th
create table tmptable(key string, value string) partitioned by (part string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tmptable
POSTHOOK: query: -- This test verifies that writing an empty partition succeeds when
-- hive.stats.reliable is set to true.
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/stats_invalidation.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_invalidation.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_invalidation.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/stats_invalidation.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE stats_invalid (key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@stats_invalid
POSTHOOK: query: CREATE TABLE stats_invalid (key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/stats_list_bucket.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_list_bucket.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_list_bucket.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/stats_list_bucket.q.out Fri Aug 22 21:36:47 2014
@@ -19,6 +19,7 @@ stored as directories
stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@stats_list_bucket
POSTHOOK: query: create table stats_list_bucket (
c1 string,
c2 string
@@ -108,6 +109,7 @@ stored as directories
stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@stats_list_bucket_1
POSTHOOK: query: -- Also try non-partitioned table with list bucketing.
-- Stats should show the same number of rows.
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/stats_noscan_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_noscan_1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_noscan_1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/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/stats_noscan_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_noscan_2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_noscan_2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/stats_noscan_2.q.out Fri Aug 22 21:36:47 2014
@@ -4,6 +4,7 @@ PREHOOK: query: -- test analyze table co
PREHOOK: type: CREATETABLE
#### A masked pattern was here ####
PREHOOK: Output: database:default
+PREHOOK: Output: default@anaylyze_external
POSTHOOK: query: -- test analyze table compute statistiscs [noscan] on external table
-- 1 test table
#### A masked pattern was here ####
@@ -126,6 +127,7 @@ PREHOOK: query: -- 2 test partition
create table texternal(key string, val string) partitioned by (insertdate string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@texternal
POSTHOOK: query: -- 2 test partition
-- prepare data
create table texternal(key string, val string) partitioned by (insertdate string)
@@ -167,6 +169,7 @@ PREHOOK: query: -- create external table
PREHOOK: type: CREATETABLE
#### A masked pattern was here ####
PREHOOK: Output: database:default
+PREHOOK: Output: default@anaylyze_external
POSTHOOK: query: -- create external table
#### A masked pattern was here ####
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/stats_only_null.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_only_null.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_only_null.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/stats_only_null.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE temps_null(a double, b int, c STRING, d smallint) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@temps_null
POSTHOOK: query: CREATE TABLE temps_null(a double, b int, c STRING, d smallint) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -8,6 +9,7 @@ POSTHOOK: Output: default@temps_null
PREHOOK: query: CREATE TABLE stats_null(a double, b int, c STRING, d smallint) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@stats_null
POSTHOOK: query: CREATE TABLE stats_null(a double, b int, c STRING, d smallint) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -15,6 +17,7 @@ POSTHOOK: Output: default@stats_null
PREHOOK: query: CREATE TABLE stats_null_part(a double, b int, c STRING, d smallint) partitioned by (dt string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@stats_null_part
POSTHOOK: query: CREATE TABLE stats_null_part(a double, b int, c STRING, d smallint) partitioned by (dt string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/stats_partscan_1_23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_partscan_1_23.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_partscan_1_23.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/stats_partscan_1_23.q.out Fri Aug 22 21:36:47 2014
@@ -11,6 +11,7 @@ partitioned by (ds string, hr string)
stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@analyze_srcpart_partial_scan
POSTHOOK: query: -- INCLUDE_HADOOP_MAJOR_VERSIONS(0.23)
-- This test uses mapred.max.split.size/mapred.max.split.size for controlling
-- number of input splits.
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/stats_publisher_error_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/stats_publisher_error_1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/stats_publisher_error_1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/stats_publisher_error_1.q.out Fri Aug 22 21:36:47 2014
@@ -7,6 +7,7 @@ PREHOOK: query: -- In this test, there i
create table tmptable(key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tmptable
POSTHOOK: query: -- In this test, there is a dummy stats publisher which throws an error when various
-- methods are called (as indicated by the parameter hive.test.dummystats.publisher)
-- Since stats need not be reliable (by setting hive.stats.reliable to false), the
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/statsfs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/statsfs.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/statsfs.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/statsfs.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- stats computation on
create table t1 (key string, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: -- stats computation on partitioned table with analyze command
create table t1 (key string, value string) partitioned by (ds string)
@@ -138,6 +139,7 @@ PREHOOK: query: -- stats computation on
create table t1 (key string, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: -- stats computation on partitioned table with autogather on insert query
create table t1 (key string, value string) partitioned by (ds string)
@@ -259,6 +261,7 @@ PREHOOK: query: -- analyze stmt on unpar
create table t1 (key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: -- analyze stmt on unpartitioned table
create table t1 (key string, value string)
@@ -330,6 +333,7 @@ PREHOOK: query: -- stats computation on
create table t1 (key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: -- stats computation on unpartitioned table with autogather on insert query
create table t1 (key string, value string)
@@ -396,6 +400,7 @@ PREHOOK: query: -- stats computation on
create table t1 (key string, value string) partitioned by (ds string, hr string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: -- stats computation on partitioned table with autogather on insert query with dynamic partitioning
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/storage_format_descriptor.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/storage_format_descriptor.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/storage_format_descriptor.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/storage_format_descriptor.q.out Fri Aug 22 21:36:47 2014
@@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE stored_as_custom_text_serde(key string, value string) STORED AS customtextserde
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@stored_as_custom_text_serde
POSTHOOK: query: CREATE TABLE stored_as_custom_text_serde(key string, value string) STORED AS customtextserde
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/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/subquery_in_explain_rewrite.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in_explain_rewrite.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in_explain_rewrite.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in_explain_rewrite.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,
@@ -55,6 +56,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/subquery_in_having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in_having.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in_having.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_in_having.q.out Fri Aug 22 21:36:47 2014
@@ -14,6 +14,7 @@ CREATE TABLE part(
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@part
POSTHOOK: query: -- SORT_QUERY_RESULTS
-- data setup
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_multiinsert.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_multiinsert.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_multiinsert.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_multiinsert.q.out Fri Aug 22 21:36:47 2014
@@ -4,6 +4,7 @@ PREHOOK: query: CREATE TABLE src_4(
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_4
POSTHOOK: query: CREATE TABLE src_4(
key STRING,
value STRING
@@ -18,6 +19,7 @@ PREHOOK: query: CREATE TABLE src_5(
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_5
POSTHOOK: query: CREATE TABLE src_5(
key STRING,
value STRING
@@ -180,10 +182,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 34 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col4 is null (type: boolean)
+ predicate: _col5 is null (type: boolean)
Statistics: Num rows: 17 Data size: 3516 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
@@ -742,10 +744,10 @@ STAGE PLANS:
keys:
0 _col0 (type: string)
1 _col0 (type: string)
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 34 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col4 is null (type: boolean)
+ predicate: _col5 is null (type: boolean)
Statistics: Num rows: 17 Data size: 3516 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notexists.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notexists.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notexists.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notexists.q.out Fri Aug 22 21:36:47 2014
@@ -56,10 +56,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey1} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey1}
- outputColumnNames: _col0, _col1, _col6
+ outputColumnNames: _col0, _col1, _col7
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col6 is null (type: boolean)
+ predicate: _col7 is null (type: boolean)
Statistics: Num rows: 15 Data size: 3093 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
@@ -309,10 +309,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1, _col6
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col5 is null (type: boolean)
+ predicate: _col6 is null (type: boolean)
Statistics: Num rows: 15 Data size: 3093 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin.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,
@@ -63,6 +64,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,
@@ -225,10 +227,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {VALUE._col0}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 34 Data size: 7032 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col4 is null (type: boolean)
+ predicate: _col5 is null (type: boolean)
Statistics: Num rows: 17 Data size: 3516 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
@@ -466,10 +468,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {KEY.reducesinkkey1} {VALUE._col3}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col1, _col2, _col5, _col11
+ outputColumnNames: _col1, _col2, _col5, _col12
Statistics: Num rows: 17 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col11 is null (type: boolean)
+ predicate: _col12 is null (type: boolean)
Statistics: Num rows: 8 Data size: 1806 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int)
@@ -740,10 +742,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col1} {VALUE._col5}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col1, _col5, _col11
+ outputColumnNames: _col1, _col5, _col12
Statistics: Num rows: 36 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col11 is null (type: boolean)
+ predicate: _col12 is null (type: boolean)
Statistics: Num rows: 18 Data size: 1919 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col1 (type: string), _col5 (type: int)
@@ -1037,10 +1039,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col1} {KEY.reducesinkkey1} {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col1, _col2, _col5, _col11
+ outputColumnNames: _col1, _col2, _col5, _col12
Statistics: Num rows: 17 Data size: 3839 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col11 is null (type: boolean)
+ predicate: _col12 is null (type: boolean)
Statistics: Num rows: 8 Data size: 1806 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin_having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin_having.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin_having.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_notin_having.q.out Fri Aug 22 21:36:47 2014
@@ -16,6 +16,7 @@ CREATE TABLE part(
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@part
POSTHOOK: query: -- data setup
CREATE TABLE part(
p_partkey INT,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_unqualcolumnrefs.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,
@@ -34,6 +35,7 @@ POSTHOOK: Output: default@part
PREHOOK: query: create table src11 (key1 string, value1 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src11
POSTHOOK: query: create table src11 (key1 string, value1 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -51,6 +53,7 @@ PREHOOK: query: create table part2(
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@part2
POSTHOOK: query: create table part2(
p2_partkey INT,
p2_name STRING,
@@ -856,10 +859,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {KEY.reducesinkkey1} {VALUE._col3}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col1, _col2, _col5, _col11
+ outputColumnNames: _col1, _col2, _col5, _col12
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Filter Operator
- predicate: _col11 is null (type: boolean)
+ predicate: _col12 is null (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/subquery_views.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/subquery_views.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/subquery_views.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/subquery_views.q.out Fri Aug 22 21:36:47 2014
@@ -193,10 +193,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col4
+ outputColumnNames: _col0, _col5
Statistics: Num rows: 5 Data size: 1212 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col4 is null (type: boolean)
+ predicate: _col5 is null (type: boolean)
Statistics: Num rows: 2 Data size: 484 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string)
@@ -360,10 +360,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
1 {KEY.reducesinkkey0}
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
Statistics: Num rows: 17 Data size: 3636 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: _col4 is null (type: boolean)
+ predicate: _col5 is null (type: boolean)
Statistics: Num rows: 8 Data size: 1711 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: _col0 (type: string), _col1 (type: string)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/symlink_text_input_format.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/symlink_text_input_format.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/symlink_text_input_format.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/symlink_text_input_format.q.out Fri Aug 22 21:36:47 2014
@@ -23,6 +23,7 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@symlink_text_input_format
POSTHOOK: query: CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/table_access_keys_stats.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/table_access_keys_stats.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/table_access_keys_stats.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/table_access_keys_stats.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- This test is used for
CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@T1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1
PREHOOK: type: LOAD
#### A masked pattern was here ####
@@ -10,9 +11,11 @@ PREHOOK: Output: default@t1
PREHOOK: query: CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@T2
PREHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@T3
PREHOOK: query: -- Simple group-by queries
SELECT key, count(1) FROM T1 GROUP BY key
PREHOOK: type: QUERY
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tablename_with_select.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tablename_with_select.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tablename_with_select.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tablename_with_select.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE tmp_select(a INT, b STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_select
POSTHOOK: query: CREATE TABLE tmp_select(a INT, b STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/temp_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/temp_table.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/temp_table.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/temp_table.q.out Fri Aug 22 21:36:47 2014
@@ -357,6 +357,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
@@ -374,6 +375,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
@@ -433,12 +435,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
@@ -457,8 +463,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/temp_table_external.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_external.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_external.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_external.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ Found 1 items
PREHOOK: type: CREATETABLE
#### A masked pattern was here ####
PREHOOK: Output: database:default
+PREHOOK: Output: default@temp_table_external
#### A masked pattern was here ####
POSTHOOK: type: CREATETABLE
#### A masked pattern was here ####
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_gb1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_gb1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_gb1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_gb1.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: -- Taken from groupby2.q
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: -- Taken from groupby2.q
CREATE TABLE dest_g2(key STRING, c1 INT, c2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_join1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_join1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_join1.q.out Fri Aug 22 21:36:47 2014
@@ -60,10 +60,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -148,10 +148,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -238,10 +238,10 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0}
1 {VALUE._col0}
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col5 (type: string)
+ expressions: _col0 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1
Statistics: Num rows: 5 Data size: 57 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_names.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_names.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_names.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_names.q.out Fri Aug 22 21:36:47 2014
@@ -1,10 +1,12 @@
PREHOOK: query: -- Test temp tables with upper/lower case names
create temporary table Default.Temp_Table_Names (C1 string, c2 string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: Default@Default.Temp_Table_Names
PREHOOK: Output: database:default
POSTHOOK: query: -- Test temp tables with upper/lower case names
create temporary table Default.Temp_Table_Names (C1 string, c2 string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: Default@Default.Temp_Table_Names
POSTHOOK: Output: Default@Temp_Table_Names
POSTHOOK: Output: database:default
PREHOOK: query: show tables 'Temp_Table*'
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_options1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_options1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_options1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_options1.q.out Fri Aug 22 21:36:47 2014
@@ -6,6 +6,7 @@ lines terminated by '\n'
stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@impressions
POSTHOOK: query: -- Delimiter test, taken from delimiter.q
create temporary table impressions (imp string, msg string)
row format delimited
@@ -72,6 +73,7 @@ with serdeproperties (
stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@date_serde_regex
POSTHOOK: query: -- Try different SerDe formats, taken from date_serde.q
--
@@ -274,6 +276,7 @@ create temporary table date_serde_lb (
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@date_serde_lb
POSTHOOK: query: --
-- LazyBinary
--
@@ -331,6 +334,7 @@ create temporary table date_serde_ls (
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@date_serde_ls
POSTHOOK: query: --
-- LazySimple
--
@@ -388,6 +392,7 @@ create temporary table date_serde_c (
) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@date_serde_c
POSTHOOK: query: --
-- Columnar
--
@@ -445,6 +450,7 @@ create temporary table date_serde_lbc (
) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@date_serde_lbc
POSTHOOK: query: --
-- LazyBinaryColumnar
--
@@ -502,6 +508,7 @@ create temporary table date_serde_orc (
) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@date_serde_orc
POSTHOOK: query: --
-- ORC
--
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_precedence.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_precedence.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_precedence.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_precedence.q.out Fri Aug 22 21:36:47 2014
@@ -1,16 +1,20 @@
PREHOOK: query: create database ttp
PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:ttp
POSTHOOK: query: create database ttp
POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:ttp
PREHOOK: query: -- Create non-temp tables
create table ttp.tab1 (a1 string, a2 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:ttp
+PREHOOK: Output: ttp@ttp.tab1
POSTHOOK: query: -- Create non-temp tables
create table ttp.tab1 (a1 string, a2 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:ttp
POSTHOOK: Output: ttp@tab1
+POSTHOOK: Output: ttp@ttp.tab1
PREHOOK: query: insert overwrite table ttp.tab1 select * from src where key = 5 limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -43,10 +47,12 @@ POSTHOOK: Input: ttp@tab1
PREHOOK: query: create table ttp.tab2 (b1 string, b2 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:ttp
+PREHOOK: Output: ttp@ttp.tab2
POSTHOOK: query: create table ttp.tab2 (b1 string, b2 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:ttp
POSTHOOK: Output: ttp@tab2
+POSTHOOK: Output: ttp@ttp.tab2
PREHOOK: query: insert overwrite table ttp.tab2 select * from src where key = 2 limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -78,11 +84,13 @@ PREHOOK: query: -- Now create temp table
create temporary table ttp.tab1 (c1 int, c2 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:ttp
+PREHOOK: Output: ttp@ttp.tab1
POSTHOOK: query: -- Now create temp table with same name
create temporary table ttp.tab1 (c1 int, c2 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:ttp
POSTHOOK: Output: ttp@tab1
+POSTHOOK: Output: ttp@ttp.tab1
PREHOOK: query: insert overwrite table ttp.tab1 select * from src where key = 0 limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
@@ -117,9 +125,11 @@ POSTHOOK: Input: ttp@tab1
PREHOOK: query: -- rename the temp table, and now we can see our non-temp table again
use ttp
PREHOOK: type: SWITCHDATABASE
+PREHOOK: Input: database:ttp
POSTHOOK: query: -- rename the temp table, and now we can see our non-temp table again
use ttp
POSTHOOK: type: SWITCHDATABASE
+POSTHOOK: Input: database:ttp
PREHOOK: query: alter table tab1 rename to tab2
PREHOOK: type: ALTERTABLE_RENAME
PREHOOK: Input: ttp@tab1
@@ -131,8 +141,10 @@ POSTHOOK: Output: ttp@tab1
POSTHOOK: Output: ttp@tab2
PREHOOK: query: use default
PREHOOK: type: SWITCHDATABASE
+PREHOOK: Input: database:default
POSTHOOK: query: use default
POSTHOOK: type: SWITCHDATABASE
+POSTHOOK: Input: database:default
PREHOOK: query: describe ttp.tab1
PREHOOK: type: DESCTABLE
PREHOOK: Input: ttp@tab1
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_windowing_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_windowing_expressions.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_windowing_expressions.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/temp_table_windowing_expressions.q.out Fri Aug 22 21:36:47 2014
@@ -16,6 +16,7 @@ CREATE TEMPORARY TABLE part(
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@part
POSTHOOK: query: -- data setup
CREATE TEMPORARY TABLE part(
p_partkey INT,
@@ -59,6 +60,7 @@ PREHOOK: query: create temporary table o
fields terminated by '|'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@over10k
POSTHOOK: query: create temporary table over10k(
t tinyint,
si smallint,
@@ -672,6 +674,7 @@ PREHOOK: query: -- multi table insert te
create table t1 (a1 int, b1 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: -- multi table insert test
create table t1 (a1 int, b1 string)
POSTHOOK: type: CREATETABLE
@@ -680,6 +683,7 @@ POSTHOOK: Output: default@t1
PREHOOK: query: create table t2 (a1 int, b1 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
POSTHOOK: query: create table t2 (a1 int, b1 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -694,10 +698,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@over10k
POSTHOOK: Output: default@t1
POSTHOOK: Output: default@t2
-POSTHOOK: Lineage: t1.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal(4,2), comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal(4,2), comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal(4,2), comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
-POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal(4,2), comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), ]
+POSTHOOK: Lineage: t1.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal(4,2), comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), (over10k)over10k.FieldSchema(name:ROW__ID, type:struct<transactionId:
bigint,bucketId:int,rowId:bigint>, comment:), ]
+POSTHOOK: Lineage: t1.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal(4,2), comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), (over10k)over10k.FieldSchema(name:ROW__ID, type:struct<transactionId:
bigint,bucketId:int,rowId:bigint>, comment:), ]
+POSTHOOK: Lineage: t2.a1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal(4,2), comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), (over10k)over10k.FieldSchema(name:ROW__ID, type:struct<transactionId:
bigint,bucketId:int,rowId:bigint>, comment:), ]
+POSTHOOK: Lineage: t2.b1 SCRIPT [(over10k)over10k.FieldSchema(name:t, type:tinyint, comment:null), (over10k)over10k.FieldSchema(name:si, type:smallint, comment:null), (over10k)over10k.FieldSchema(name:i, type:int, comment:null), (over10k)over10k.FieldSchema(name:b, type:bigint, comment:null), (over10k)over10k.FieldSchema(name:f, type:float, comment:null), (over10k)over10k.FieldSchema(name:d, type:double, comment:null), (over10k)over10k.FieldSchema(name:bo, type:boolean, comment:null), (over10k)over10k.FieldSchema(name:s, type:string, comment:null), (over10k)over10k.FieldSchema(name:ts, type:timestamp, comment:null), (over10k)over10k.FieldSchema(name:dec, type:decimal(4,2), comment:null), (over10k)over10k.FieldSchema(name:bin, type:binary, comment:null), (over10k)over10k.FieldSchema(name:BLOCK__OFFSET__INSIDE__FILE, type:bigint, comment:), (over10k)over10k.FieldSchema(name:INPUT__FILE__NAME, type:string, comment:), (over10k)over10k.FieldSchema(name:ROW__ID, type:struct<transactionId:
bigint,bucketId:int,rowId:bigint>, comment:), ]
PREHOOK: query: select * from t1 limit 3
PREHOOK: type: QUERY
PREHOOK: Input: default@t1
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/test_boolean_whereclause.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/test_boolean_whereclause.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/test_boolean_whereclause.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/test_boolean_whereclause.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table if not exists test_boolean(dummy tinyint)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_boolean
POSTHOOK: query: create table if not exists test_boolean(dummy tinyint)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_2_orc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_2_orc.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_2_orc.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_2_orc.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string, ts string) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_orc_merge_test_part
POSTHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string, ts string) stored as orc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_orc.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table src_orc_merge_test(key int, value string) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_orc_merge_test
POSTHOOK: query: create table src_orc_merge_test(key int, value string) stored as orc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -116,6 +117,7 @@ POSTHOOK: Input: default@src_orc_merge_t
PREHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_orc_merge_test_part
POSTHOOK: query: create table src_orc_merge_test_part(key int, value string) partitioned by (ds string) stored as orc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/alter_merge_stats_orc.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table src_orc_merge_test_stat(key int, value string) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_orc_merge_test_stat
POSTHOOK: query: create table src_orc_merge_test_stat(key int, value string) stored as orc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -157,6 +158,7 @@ Storage Desc Params:
PREHOOK: query: create table src_orc_merge_test_part_stat(key int, value string) partitioned by (ds string) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_orc_merge_test_part_stat
POSTHOOK: query: create table src_orc_merge_test_part_stat(key int, value string) partitioned by (ds string) stored as orc
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_join1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/auto_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
@@ -43,12 +44,12 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col5
+ outputColumnNames: _col0, _col6
input vertices:
0 Map 2
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/bucket2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket2.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket2.q.out Fri Aug 22 21:36:47 2014 differ
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket3.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket3.q.out Fri Aug 22 21:36:47 2014 differ
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket4.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket4.q.out Fri Aug 22 21:36:47 2014 differ
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez1.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE srcbucket_mapjoin(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@srcbucket_mapjoin
POSTHOOK: query: CREATE TABLE srcbucket_mapjoin(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -8,6 +9,7 @@ POSTHOOK: Output: default@srcbucket_mapj
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
@@ -15,6 +17,7 @@ POSTHOOK: Output: default@tab_part
PREHOOK: query: CREATE TABLE srcbucket_mapjoin_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@srcbucket_mapjoin_part
POSTHOOK: query: CREATE TABLE srcbucket_mapjoin_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
@@ -86,6 +89,7 @@ POSTHOOK: Lineage: tab_part PARTITION(ds
PREHOOK: query: CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tab
POSTHOOK: query: CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -140,12 +144,12 @@ STAGE PLANS:
keys:
0 key (type: int)
1 key (type: int)
- outputColumnNames: _col0, _col1, _col6
+ outputColumnNames: _col0, _col1, _col7
input vertices:
0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col7 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -336,17 +340,17 @@ STAGE PLANS:
keys:
0 key (type: int)
1 key (type: int)
- outputColumnNames: _col5, _col6
+ outputColumnNames: _col6, _col7
input vertices:
1 Map 4
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col5 (type: int), _col6 (type: string)
- outputColumnNames: _col5, _col6
+ expressions: _col6 (type: int), _col7 (type: string)
+ outputColumnNames: _col6, _col7
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Group By Operator
- aggregations: sum(substr(_col6, 5))
- keys: _col5 (type: int)
+ aggregations: sum(substr(_col7, 5))
+ keys: _col6 (type: int)
mode: hash
outputColumnNames: _col0, _col1
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
@@ -611,13 +615,13 @@ STAGE PLANS:
0 key (type: int)
1 key (type: int)
2 key (type: int)
- outputColumnNames: _col0, _col1, _col6
+ outputColumnNames: _col0, _col1, _col7
input vertices:
1 Map 1
2 Map 2
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col7 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -976,12 +980,12 @@ STAGE PLANS:
keys:
0 value (type: string)
1 value (type: string)
- outputColumnNames: _col0, _col1, _col6
+ outputColumnNames: _col0, _col1, _col7
input vertices:
0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col7 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -1015,6 +1019,7 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE tab1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tab1
POSTHOOK: query: CREATE TABLE tab1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -1069,12 +1074,12 @@ STAGE PLANS:
keys:
0 key (type: int)
1 key (type: int)
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1, _col6
input vertices:
0 Map 2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: string), _col5 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -1164,12 +1169,12 @@ STAGE PLANS:
keys:
0 _col1 (type: string)
1 value (type: string)
- outputColumnNames: _col0, _col10
+ outputColumnNames: _col0, _col12
input vertices:
1 Map 1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col10 (type: int)
+ expressions: _col0 (type: int), _col12 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/bucket_map_join_tez2.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE srcbucket_mapjoin(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@srcbucket_mapjoin
POSTHOOK: query: CREATE TABLE srcbucket_mapjoin(key int, value string) partitioned by (ds string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -8,6 +9,7 @@ POSTHOOK: Output: default@srcbucket_mapj
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
@@ -15,6 +17,7 @@ POSTHOOK: Output: default@tab_part
PREHOOK: query: CREATE TABLE srcbucket_mapjoin_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@srcbucket_mapjoin_part
POSTHOOK: query: CREATE TABLE srcbucket_mapjoin_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
@@ -86,6 +89,7 @@ POSTHOOK: Lineage: tab_part PARTITION(ds
PREHOOK: query: CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tab
POSTHOOK: query: CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -163,12 +167,12 @@ STAGE PLANS:
keys:
0 _col1 (type: string)
1 value (type: string)
- outputColumnNames: _col0, _col10
+ outputColumnNames: _col0, _col12
input vertices:
1 Map 1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col10 (type: int)
+ expressions: _col0 (type: int), _col12 (type: int)
outputColumnNames: _col0, _col1
Statistics: Num rows: 302 Data size: 3213 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -202,6 +206,7 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE tab1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tab1
POSTHOOK: query: CREATE TABLE tab1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -256,12 +261,12 @@ STAGE PLANS:
keys:
0 UDFToDouble(key) (type: double)
1 UDFToDouble(key) (type: double)
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1, _col6
input vertices:
0 Map 2
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: int), _col1 (type: string), _col5 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 133 Data size: 1411 Basic stats: COMPLETE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/count.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/count.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/count.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/count.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table abcd (a int, b int, c int, d int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@abcd
POSTHOOK: query: create table abcd (a int, b int, c int, d int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/create_merge_compressed.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/create_merge_compressed.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/create_merge_compressed.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/create_merge_compressed.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table src_rc_merge_test(key int, value string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_rc_merge_test
POSTHOOK: query: create table src_rc_merge_test(key int, value string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -16,6 +17,7 @@ POSTHOOK: Output: default@src_rc_merge_t
PREHOOK: query: create table tgt_rc_merge_test(key int, value string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tgt_rc_merge_test
POSTHOOK: query: create table tgt_rc_merge_test(key int, value string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_1.q.out Fri Aug 22 21:36:47 2014
@@ -60,10 +60,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: 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
@@ -142,24 +142,24 @@ 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: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
sort order:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
Reducer 3
Reduce Operator Tree:
Join Operator
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col4} {VALUE._col5}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col5} {VALUE._col6}
1 {VALUE._col0} {VALUE._col1}
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
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), _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: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -282,10 +282,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
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)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -394,10 +394,10 @@ STAGE PLANS:
condition expressions:
0 {VALUE._col0} {VALUE._col1}
1 {VALUE._col0}
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
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)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
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/tez/cross_product_check_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/tez/cross_product_check_2.q.out Fri Aug 22 21:36:47 2014
@@ -57,12 +57,12 @@ STAGE PLANS:
keys:
0
1
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
input vertices:
1 Map 1
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
@@ -113,14 +113,14 @@ STAGE PLANS:
keys:
0 key (type: string)
1 key (type: string)
- outputColumnNames: _col0, _col1, _col4, _col5
+ outputColumnNames: _col0, _col1, _col5, _col6
input vertices:
1 Map 2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
sort order:
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string)
+ value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string)
Map 2
Map Operator Tree:
TableScan
@@ -144,17 +144,17 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {_col0} {_col1} {_col4} {_col5}
+ 0 {_col0} {_col1} {_col5} {_col6}
1 {key} {value}
keys:
0
1
- outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9
+ outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11
input vertices:
0 Map 1
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), _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: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -257,12 +257,12 @@ STAGE PLANS:
keys:
0
1
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
input vertices:
1 Reducer 2
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)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -367,12 +367,12 @@ STAGE PLANS:
keys:
0
1
- outputColumnNames: _col0, _col1, _col4
+ outputColumnNames: _col0, _col1, _col5
input vertices:
1 Reducer 2
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)
+ expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 31 Data size: 6393 Basic stats: COMPLETE Column stats: NONE
File Output Operator