You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2014/03/21 05:24:04 UTC
svn commit: r1579880 [11/16] - in /hive/branches/branch-0.13:
common/src/java/org/apache/hadoop/hive/conf/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/positive/
itests/test-serde/src/main/java/org/apache/hadoop/hive/serde2/ ...
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/statsfs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/statsfs.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/statsfs.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/statsfs.q.out Fri Mar 21 04:23:57 2014
@@ -49,13 +49,13 @@ POSTHOOK: query: describe formatted t1 p
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
+ds string
# Detailed Partition Information
Partition Value: [2010]
@@ -88,13 +88,13 @@ POSTHOOK: query: describe formatted t1 p
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
+ds string
# Detailed Partition Information
Partition Value: [2011]
@@ -172,13 +172,13 @@ POSTHOOK: Lineage: t1 PARTITION(ds=2011)
POSTHOOK: Lineage: t1 PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
+ds string
# Detailed Partition Information
Partition Value: [2010]
@@ -215,13 +215,13 @@ POSTHOOK: Lineage: t1 PARTITION(ds=2011)
POSTHOOK: Lineage: t1 PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
+ds string
# Detailed Partition Information
Partition Value: [2011]
@@ -309,8 +309,8 @@ POSTHOOK: Lineage: t1 PARTITION(ds=2011)
POSTHOOK: Lineage: t1 PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -390,8 +390,8 @@ POSTHOOK: Lineage: t1 PARTITION(ds=2011)
POSTHOOK: Lineage: t1 PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -504,14 +504,14 @@ POSTHOOK: Lineage: t1 PARTITION(ds=2011)
POSTHOOK: Lineage: t1 PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
-hr string None
+ds string
+hr string
# Detailed Partition Information
Partition Value: [2008-04-08, 11]
@@ -558,14 +558,14 @@ POSTHOOK: Lineage: t1 PARTITION(ds=2011)
POSTHOOK: Lineage: t1 PARTITION(ds=2011).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-ds string None
-hr string None
+ds string
+hr string
# Detailed Partition Information
Partition Value: [2008-04-09, 12]
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/tablename_with_select.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/tablename_with_select.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/tablename_with_select.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/tablename_with_select.q.out Fri Mar 21 04:23:57 2014
@@ -9,8 +9,8 @@ PREHOOK: query: DESCRIBE tmp_select
PREHOOK: type: DESCTABLE
POSTHOOK: query: DESCRIBE tmp_select
POSTHOOK: type: DESCTABLE
-a int None
-b string None
+a int
+b string
PREHOOK: query: INSERT OVERWRITE TABLE tmp_select SELECT key, value FROM src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/transform_ppr1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/transform_ppr1.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/transform_ppr1.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/transform_ppr1.q.out Fri Mar 21 04:23:57 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/transform_ppr2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/transform_ppr2.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/transform_ppr2.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/transform_ppr2.q.out Fri Mar 21 04:23:57 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/truncate_column.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/truncate_column.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/truncate_column.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/truncate_column.q.out Fri Mar 21 04:23:57 2014
@@ -29,8 +29,8 @@ POSTHOOK: Lineage: test_tab.key SIMPLE [
POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -97,8 +97,8 @@ POSTHOOK: Lineage: test_tab.key SIMPLE [
POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -183,8 +183,8 @@ POSTHOOK: Lineage: test_tab.value SIMPLE
POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -259,8 +259,8 @@ POSTHOOK: Lineage: test_tab.value SIMPLE
POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Detailed Table Information
Database: default
@@ -351,8 +351,8 @@ POSTHOOK: Lineage: test_tab.value SIMPLE
POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string from deserializer
-value string from deserializer
+key string
+value string
# Detailed Table Information
Database: default
@@ -432,8 +432,8 @@ POSTHOOK: Lineage: test_tab.value SIMPLE
POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string from deserializer
-value string from deserializer
+key string
+value string
# Detailed Table Information
Database: default
@@ -515,8 +515,8 @@ POSTHOOK: Lineage: test_tab.value SIMPLE
POSTHOOK: Lineage: test_tab.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string from deserializer
-value string from deserializer
+key string
+value string
# Detailed Table Information
Database: default
@@ -615,13 +615,13 @@ POSTHOOK: Lineage: test_tab_part PARTITI
POSTHOOK: Lineage: test_tab_part PARTITION(part=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-part string None
+part string
# Detailed Partition Information
Partition Value: [1]
@@ -706,13 +706,13 @@ POSTHOOK: Lineage: test_tab_part PARTITI
POSTHOOK: Lineage: test_tab_part PARTITION(part=1).value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
# col_name data_type comment
-key string None
-value string None
+key string
+value string
# Partition Information
# col_name data_type comment
-part string None
+part string
# Detailed Partition Information
Partition Value: [1]
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_explode.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_explode.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_explode.q.out Fri Mar 21 04:23:57 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_reflect2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_reflect2.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_reflect2.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/udf_reflect2.q.out Fri Mar 21 04:23:57 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/udtf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/udtf_explode.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/udtf_explode.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/udtf_explode.q.out Fri Mar 21 04:23:57 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/unicode_notation.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/unicode_notation.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/unicode_notation.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/unicode_notation.q.out Fri Mar 21 04:23:57 2014
@@ -15,7 +15,7 @@ POSTHOOK: query: desc formatted k1
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a string None
+a string
# Detailed Table Information
Database: default
@@ -59,7 +59,7 @@ POSTHOOK: query: desc formatted k1
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a string None
+a string
# Detailed Table Information
Database: default
@@ -103,7 +103,7 @@ POSTHOOK: query: desc formatted k1
POSTHOOK: type: DESCTABLE
# col_name data_type comment
-a string None
+a string
# Detailed Table Information
Database: default
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union22.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union22.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/union22.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/union22.q.out Fri Mar 21 04:23:57 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union24.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union24.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/union24.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/union24.q.out Fri Mar 21 04:23:57 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_ppr.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
Files hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_ppr.q.out (original) and hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_ppr.q.out Fri Mar 21 04:23:57 2014 differ
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_1.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_1.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_1.q.out Fri Mar 21 04:23:57 2014
@@ -10,6 +10,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- There is no need to write the temporary results of the sub-queries, and then read them
@@ -22,17 +23,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -182,8 +188,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -193,6 +199,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_10.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_10.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_10.q.out Fri Mar 21 04:23:57 2014
@@ -14,6 +14,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 subqueries is performed (one of which is a map-only query, and the
-- other one contains a nested union where one of the sub-queries requires a map-reduce
@@ -30,17 +31,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -248,8 +254,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -259,6 +265,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 340
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_11.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_11.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_11.q.out Fri Mar 21 04:23:57 2014
@@ -14,6 +14,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 subqueries is performed (one of which is a map-only query, and the
-- other one contains a nested union where also contains map only sub-queries),
@@ -30,17 +31,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -226,8 +232,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION []
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -237,6 +243,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 1
+ numRows -1
+ rawDataSize -1
+ totalSize 115
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_12.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_12.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_12.q.out Fri Mar 21 04:23:57 2014
@@ -13,6 +13,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 subqueries is performed (one of which is a map-only query, and the
-- other one is a map-join query), followed by select star and a file sink.
@@ -28,17 +29,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -194,8 +200,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)b.FieldSchema(name:val, type:string, comment:null), ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -205,6 +211,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_13.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_13.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_13.q.out Fri Mar 21 04:23:57 2014
@@ -13,6 +13,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 subqueries is performed (one of which is a mapred query, and the
-- other one is a map-join query), followed by select star and a file sink.
@@ -28,17 +29,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -217,8 +223,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)b.FieldSchema(name:val, type:string, comment:null), (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -228,6 +234,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_14.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_14.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_14.q.out Fri Mar 21 04:23:57 2014
@@ -14,6 +14,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 subqueries is performed (one of which is a map-only query, and the
-- other one contains a join, which should be performed as a map-join query at runtime),
@@ -30,17 +31,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -196,8 +202,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)b.FieldSchema(name:val, type:string, comment:null), ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -207,6 +213,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_15.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_15.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_15.q.out Fri Mar 21 04:23:57 2014
@@ -13,6 +13,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- and the results are written to a table using dynamic partitions.
@@ -28,17 +29,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
@@ -195,13 +201,13 @@ POSTHOOK: Lineage: outputtbl1 PARTITION(
POSTHOOK: Lineage: outputtbl1 PARTITION(ds=2).values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Partition Information
# col_name data_type comment
-ds string None
+ds string
# Detailed Table Information
Database: default
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_16.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_16.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_16.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_16.q.out Fri Mar 21 04:23:57 2014
@@ -12,6 +12,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- and the results are written to a table using dynamic partitions.
@@ -26,17 +27,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
@@ -219,13 +225,13 @@ POSTHOOK: Lineage: outputtbl1 PARTITION(
POSTHOOK: Lineage: outputtbl1 PARTITION(ds=2).values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Partition Information
# col_name data_type comment
-ds string None
+ds string
# Detailed Table Information
Database: default
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_17.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_17.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_17.q.out Fri Mar 21 04:23:57 2014
@@ -10,6 +10,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- and the results are written to a table using dynamic partitions.
@@ -22,17 +23,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
@@ -150,13 +156,13 @@ POSTHOOK: Lineage: outputtbl1 PARTITION(
POSTHOOK: Lineage: outputtbl1 PARTITION(ds=2).values EXPRESSION []
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Partition Information
# col_name data_type comment
-ds string None
+ds string
# Detailed Table Information
Database: default
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_18.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_18.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_18.q.out Fri Mar 21 04:23:57 2014
@@ -12,6 +12,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, ds string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- There is no need to write the temporary results of the sub-queries, and then read them
@@ -26,17 +27,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, ds string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1 partition (ds)
@@ -213,13 +219,13 @@ POSTHOOK: Lineage: outputtbl1 PARTITION(
POSTHOOK: Lineage: outputtbl1 PARTITION(ds=28).values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Partition Information
# col_name data_type comment
-ds string None
+ds string
# Detailed Table Information
Database: default
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_19.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_19.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_19.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_19.q.out Fri Mar 21 04:23:57 2014
@@ -10,6 +10,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- There is no need to write the temporary results of the sub-queries, and then read them
@@ -22,17 +23,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -182,8 +188,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -193,6 +199,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_2.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_2.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_2.q.out Fri Mar 21 04:23:57 2014
@@ -11,6 +11,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 3 subqueries is performed (exactly one of which requires a map-reduce job)
-- followed by select star and a file sink.
@@ -24,17 +25,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -189,8 +195,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -200,6 +206,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 3
+ numRows -1
+ rawDataSize -1
+ totalSize 408
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_20.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_20.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_20.q.out Fri Mar 21 04:23:57 2014
@@ -11,6 +11,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select and a file sink
-- However, the order of the columns in the select list is different. So, union cannot
@@ -24,17 +25,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(values bigint, key string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(values bigint, key string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -184,8 +190,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-values bigint None
-key string None
+values bigint
+key string
# Detailed Table Information
Database: default
@@ -195,6 +201,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_21.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_21.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_21.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_21.q.out Fri Mar 21 04:23:57 2014
@@ -11,6 +11,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select and a file sink
-- However, all the columns are not selected. So, union cannot
@@ -24,17 +25,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -182,7 +188,7 @@ POSTHOOK: type: DESCTABLE
POSTHOOK: Lineage: outputtbl1.key EXPRESSION [(inputtbl1)inputtbl1.FieldSchema(name:key, type:string, comment:null), (inputtbl1)inputtbl1.FieldSchema(name:key, type:string, comment:null), ]
# col_name data_type comment
-key string None
+key string
# Detailed Table Information
Database: default
@@ -192,6 +198,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_22.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_22.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_22.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_22.q.out Fri Mar 21 04:23:57 2014
@@ -10,6 +10,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select and a file sink
-- However, some columns are repeated. So, union cannot be removed.
@@ -22,17 +23,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint, values2 bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint, values2 bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -184,9 +190,9 @@ POSTHOOK: Lineage: outputtbl1.values EXP
POSTHOOK: Lineage: outputtbl1.values2 EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
-values2 bigint None
+key string
+values bigint
+values2 bigint
# Detailed Table Information
Database: default
@@ -196,6 +202,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_23.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_23.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_23.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_23.q.out Fri Mar 21 04:23:57 2014
@@ -11,6 +11,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- There is no need to write the temporary results of the sub-queries, and then read them
@@ -24,17 +25,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -223,8 +229,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)b.null, (inputtbl1)a.null, (inputtbl1)b.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -234,6 +240,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_24.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_24.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_24.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_24.q.out Fri Mar 21 04:23:57 2014
@@ -9,6 +9,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- There is no need to write the temporary results of the sub-queries, and then read them
@@ -20,17 +21,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key double, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key double, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: EXPLAIN
INSERT OVERWRITE TABLE outputTbl1
@@ -180,8 +186,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key double None
-values bigint None
+key double
+values bigint
# Detailed Table Information
Database: default
@@ -191,6 +197,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_3.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_3.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_3.q.out Fri Mar 21 04:23:57 2014
@@ -11,6 +11,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->remove->filesink optimization
-- Union of 3 subqueries is performed (all of which are map-only queries)
-- followed by select star and a file sink.
@@ -24,17 +25,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -174,8 +180,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION []
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -185,6 +191,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 1
+ numRows -1
+ rawDataSize -1
+ totalSize 72
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_4.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_4.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_4.q.out Fri Mar 21 04:23:57 2014
@@ -10,6 +10,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- There is no need to write the temporary results of the sub-queries, and then read them
@@ -22,17 +23,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -226,8 +232,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -237,6 +243,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_5.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_5.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_5.q.out Fri Mar 21 04:23:57 2014
@@ -12,6 +12,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 3 subqueries is performed (exactly one of which requires a map-reduce job)
-- followed by select star and a file sink.
@@ -26,17 +27,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -235,8 +241,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -246,6 +252,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 3
+ numRows -1
+ rawDataSize -1
+ totalSize 408
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_7.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_7.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_7.q.out Fri Mar 21 04:23:57 2014
@@ -12,6 +12,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 map-reduce subqueries is performed followed by select star and a file sink
-- There is no need to write the temporary results of the sub-queries, and then read them
@@ -26,17 +27,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -186,8 +192,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, (inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -197,6 +203,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_8.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_8.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_8.q.out Fri Mar 21 04:23:57 2014
@@ -13,6 +13,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 3 subqueries is performed (exactly one of which requires a map-reduce job)
-- followed by select star and a file sink.
@@ -28,17 +29,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -193,8 +199,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -204,6 +210,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 3
+ numRows -1
+ rawDataSize -1
+ totalSize 408
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_9.q.out?rev=1579880&r1=1579879&r2=1579880&view=diff
==============================================================================
--- hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_9.q.out (original)
+++ hive/branches/branch-0.13/ql/src/test/results/clientpositive/union_remove_9.q.out Fri Mar 21 04:23:57 2014
@@ -12,6 +12,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 subqueries is performed (one of which contains a union and is map-only),
-- and the other one is a map-reduce query followed by select star and a file sink.
@@ -26,17 +27,22 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
insert overwrite table outputTbl1
@@ -232,8 +238,8 @@ POSTHOOK: Lineage: outputtbl1.key EXPRES
POSTHOOK: Lineage: outputtbl1.values EXPRESSION [(inputtbl1)inputtbl1.null, ]
# col_name data_type comment
-key string None
-values bigint None
+key string
+values bigint
# Detailed Table Information
Database: default
@@ -243,6 +249,11 @@ Retention: 0
#### A masked pattern was here ####
Table Type: MANAGED_TABLE
Table Parameters:
+ COLUMN_STATS_ACCURATE false
+ numFiles 2
+ numRows -1
+ rawDataSize -1
+ totalSize 272
#### A masked pattern was here ####
# Storage Information