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 [36/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/orc_empty_files.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_empty_files.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_empty_files.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_empty_files.q.out Fri Aug 22 21:36:47 2014
@@ -5,6 +5,7 @@ STORED AS INPUTFORMAT 'org.apache.hadoop
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_orc
POSTHOOK: query: CREATE TABLE test_orc (key STRING, cnt INT)
CLUSTERED BY (key) INTO 3 BUCKETS
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_empty_strings.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_empty_strings.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_empty_strings.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_empty_strings.q.out Fri Aug 22 21:36:47 2014
@@ -6,6 +6,7 @@ STORED AS INPUTFORMAT 'org.apache.hadoop
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_orc
POSTHOOK: query: -- SORT_QUERY_RESULTS
CREATE TABLE test_orc (key STRING)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_ends_with_nulls.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_ends_with_nulls.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_ends_with_nulls.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_ends_with_nulls.q.out Fri Aug 22 21:36:47 2014
@@ -4,6 +4,7 @@ STORED AS INPUTFORMAT 'org.apache.hadoop
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_orc
POSTHOOK: query: CREATE TABLE test_orc (key STRING)
ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.orc.OrcSerde'
STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat'
@@ -26,6 +27,7 @@ PREHOOK: query: -- nulls.txt is a file c
CREATE TABLE src_null(a STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_null
POSTHOOK: query: -- nulls.txt is a file containing a non-null string row followed by 1000 null string rows
-- this produces the effect that the number of non-null rows between the last and second
-- to last index stride are the same (there's only two index strides)
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge1.q.out Fri Aug 22 21:36:47 2014
@@ -10,6 +10,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer
PARTITIONED BY (ds STRING, part STRING) STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orcfile_merge1
POSTHOOK: query: CREATE TABLE orcfile_merge1 (key INT, value STRING)
PARTITIONED BY (ds STRING, part STRING) STORED AS ORC
POSTHOOK: type: CREATETABLE
@@ -19,6 +20,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer
PARTITIONED BY (ds STRING, part STRING) STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orcfile_merge1b
POSTHOOK: query: CREATE TABLE orcfile_merge1b (key INT, value STRING)
PARTITIONED BY (ds STRING, part STRING) STORED AS ORC
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge2.q.out Fri Aug 22 21:36:47 2014
@@ -7,6 +7,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer
STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orcfile_merge2a
POSTHOOK: query: CREATE TABLE orcfile_merge2a (key INT, value STRING)
PARTITIONED BY (one string, two string, three string)
STORED AS ORC
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge3.q.out Fri Aug 22 21:36:47 2014
@@ -10,6 +10,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer
PARTITIONED BY (ds string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orcfile_merge3a
POSTHOOK: query: CREATE TABLE orcfile_merge3a (key int, value string)
PARTITIONED BY (ds string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
@@ -18,6 +19,7 @@ POSTHOOK: Output: default@orcfile_merge3
PREHOOK: query: CREATE TABLE orcfile_merge3b (key int, value string) STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orcfile_merge3b
POSTHOOK: query: CREATE TABLE orcfile_merge3b (key int, value string) STORED AS ORC
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge4.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_merge4.q.out Fri Aug 22 21:36:47 2014
@@ -10,6 +10,7 @@ PREHOOK: query: CREATE TABLE orcfile_mer
PARTITIONED BY (ds string) STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orcfile_merge3a
POSTHOOK: query: CREATE TABLE orcfile_merge3a (key int, value string)
PARTITIONED BY (ds string) STORED AS ORC
POSTHOOK: type: CREATETABLE
@@ -18,6 +19,7 @@ POSTHOOK: Output: default@orcfile_merge3
PREHOOK: query: CREATE TABLE orcfile_merge3b (key int, value string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orcfile_merge3b
POSTHOOK: query: CREATE TABLE orcfile_merge3b (key int, value string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_min_max.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_min_max.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_min_max.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_min_max.q.out Fri Aug 22 21:36:47 2014
@@ -20,6 +20,7 @@ collection items terminated by ','
map keys terminated by ':' stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@alltypes
POSTHOOK: query: create table if not exists alltypes (
bo boolean,
ti tinyint,
@@ -46,6 +47,7 @@ POSTHOOK: Output: default@alltypes
PREHOOK: query: create table alltypes_orc like alltypes
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@alltypes_orc
POSTHOOK: query: create table alltypes_orc like alltypes
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_char.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_char.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_char.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_char.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table newtypesorc(c char(10), v varchar(10), d decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@newtypesorc
POSTHOOK: query: create table newtypesorc(c char(10), v varchar(10), d decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_date.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_date.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_date.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_date.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table newtypesorc(c char(10), v varchar(10), d decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@newtypesorc
POSTHOOK: query: create table newtypesorc(c char(10), v varchar(10), d decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_decimal.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_decimal.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_decimal.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table newtypesorc(c char(10), v varchar(10), d decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@newtypesorc
POSTHOOK: query: create table newtypesorc(c char(10), v varchar(10), d decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -253,6 +254,42 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypesorc
#### A masked pattern was here ####
81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as decimal)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as decimal)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as decimal)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=cast('11.22' as decimal)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+-252951929000
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22BD
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22BD
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
+PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22BD
+PREHOOK: type: QUERY
+PREHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+POSTHOOK: query: select sum(hash(*)) from newtypesorc where d<=11.22BD
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@newtypesorc
+#### A masked pattern was here ####
+81475875500
PREHOOK: query: select sum(hash(*)) from newtypesorc where d<=12
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypesorc
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_varchar.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_varchar.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_varchar.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_ppd_varchar.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table newtypesorc(c char(10), v varchar(10), d decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@newtypesorc
POSTHOOK: query: create table newtypesorc(c char(10), v varchar(10), d decimal(5,3), da date) stored as orc tblproperties("orc.stripe.size"="16777216")
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_predicate_pushdown.q.out Fri Aug 22 21:36:47 2014
@@ -14,6 +14,7 @@ CREATE TABLE orc_pred(t tinyint,
STORED AS ORC
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_pred
POSTHOOK: query: -- SORT_QUERY_RESULTS
CREATE TABLE orc_pred(t tinyint,
@@ -54,6 +55,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@staging
POSTHOOK: query: CREATE TABLE staging(t tinyint,
si smallint,
i int,
@@ -257,7 +259,7 @@ POSTHOOK: query: SELECT * FROM orc_pred
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
-124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty
+124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty
PREHOOK: query: SELECT * FROM orc_pred WHERE t>2 limit 1
PREHOOK: type: QUERY
PREHOOK: Input: default@orc_pred
@@ -266,7 +268,7 @@ POSTHOOK: query: SELECT * FROM orc_pred
POSTHOOK: type: QUERY
POSTHOOK: Input: default@orc_pred
#### A masked pattern was here ####
-124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.4 yard duty
+124 336 65664 4294967435 74.72 42.47 true bob davidson 2013-03-01 09:11:58.703302 45.40 yard duty
PREHOOK: query: SELECT SUM(HASH(t)) FROM orc_pred
WHERE t IS NOT NULL
AND t < 0
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_split_elimination.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_split_elimination.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_split_elimination.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_split_elimination.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS
create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_split_elim
POSTHOOK: query: -- SORT_QUERY_RESULTS
create table orc_split_elim (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) stored as orc
@@ -267,6 +268,7 @@ PREHOOK: query: -- partitioned table
create table orc_split_elim_part (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) partitioned by (country string, year int) stored as orc
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_split_elim_part
POSTHOOK: query: -- partitioned table
create table orc_split_elim_part (userid bigint, string1 string, subtype double, decimal1 decimal, ts timestamp) partitioned by (country string, year int) stored as orc
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_vectorization_ppd.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_vectorization_ppd.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_vectorization_ppd.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_vectorization_ppd.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: -- create table with 100
create table srcorc(key string, value string) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@srcorc
POSTHOOK: query: -- create table with 1000 rows
create table srcorc(key string, value string) stored as textfile
POSTHOOK: type: CREATETABLE
@@ -36,6 +37,7 @@ s3 string)
stored as ORC tblproperties("orc.row.index.stride"="1000", "orc.stripe.size"="100000", "orc.compress.size"="10000")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@vectororc
POSTHOOK: query: -- load table with each row group having 1000 rows and stripe 1 & 2 having 5000 & 2000 rows respectively
create table if not exists vectororc
(s1 string,
@@ -141,6 +143,7 @@ s3 string)
stored as ORC tblproperties("orc.row.index.stride"="1000", "orc.stripe.size"="100000", "orc.compress.size"="10000")
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@testorc
POSTHOOK: query: -- since vectororc table has multiple orc file we will load them into a single file using another table
create table if not exists testorc
(s1 string,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/orc_wide_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/orc_wide_table.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/orc_wide_table.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/orc_wide_table.q.out Fri Aug 22 21:36:47 2014
@@ -2010,6 +2010,7 @@ PREHOOK: query: create table test_txt(
) row format delimited fields terminated by ','
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_txt
POSTHOOK: query: create table test_txt(
c1 varchar(64),
c2 int,
@@ -4026,6 +4027,7 @@ POSTHOOK: Output: default@test_txt
PREHOOK: query: create table test_orc like test_txt
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_orc
POSTHOOK: query: create table test_orc like test_txt
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/order_within_subquery.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/order_within_subquery.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/order_within_subquery.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/order_within_subquery.q.out Fri Aug 22 21:36:47 2014
@@ -11,6 +11,7 @@ PREHOOK: query: CREATE TABLE part(
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@part
POSTHOOK: query: CREATE TABLE part(
p_partkey INT,
p_name STRING,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/outer_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/outer_join_ppr.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/outer_join_ppr.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/outer_join_ppr.q.out Fri Aug 22 21:36:47 2014 differ
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parallel.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parallel.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parallel.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parallel.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS
create table if not exists src_a like src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_a
POSTHOOK: query: -- SORT_QUERY_RESULTS
create table if not exists src_a like src
@@ -12,6 +13,7 @@ POSTHOOK: Output: default@src_a
PREHOOK: query: create table if not exists src_b like src
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_b
POSTHOOK: query: create table if not exists src_b like src
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parallel_orderby.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parallel_orderby.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parallel_orderby.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parallel_orderby.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table src5 (key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src5
POSTHOOK: query: create table src5 (key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_columnar.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_columnar.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_columnar.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_columnar.q.out Fri Aug 22 21:36:47 2014
@@ -18,6 +18,7 @@ PREHOOK: query: CREATE TABLE parquet_col
FIELDS TERMINATED BY '|'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_columnar_access_stage
POSTHOOK: query: CREATE TABLE parquet_columnar_access_stage (
s string,
i int,
@@ -35,6 +36,7 @@ PREHOOK: query: CREATE TABLE parquet_col
) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_columnar_access
POSTHOOK: query: CREATE TABLE parquet_columnar_access (
s string,
x int,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_create.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_create.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_create.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_create.q.out Fri Aug 22 21:36:47 2014
@@ -18,6 +18,7 @@ COLLECTION ITEMS TERMINATED BY ','
MAP KEYS TERMINATED BY ':'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_create_staging
POSTHOOK: query: CREATE TABLE parquet_create_staging (
id int,
str string,
@@ -40,6 +41,7 @@ PREHOOK: query: CREATE TABLE parquet_cre
) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_create
POSTHOOK: query: CREATE TABLE parquet_create (
id int,
str string,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_ctas.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_ctas.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_ctas.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_ctas.q.out Fri Aug 22 21:36:47 2014
@@ -21,6 +21,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table staging (key int, value string) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@staging
POSTHOOK: query: create table staging (key int, value string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_decimal.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_decimal.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_decimal.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_decimal.q.out Fri Aug 22 21:36:47 2014
@@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE dec(name string, value decimal(8,4))
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@dec
POSTHOOK: query: CREATE TABLE dec(name string, value decimal(8,4))
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -24,6 +25,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE parq_dec(name string, value decimal(5,2)) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parq_dec
POSTHOOK: query: CREATE TABLE parq_dec(name string, value decimal(5,2)) STORED AS PARQUET
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -61,9 +63,9 @@ Mary 4.33
Cluck 5.96
Tom -12.25
Mary 33.33
-Tom 19
-Beck 0
-Beck 79.9
+Tom 19.00
+Beck 0.00
+Beck 79.90
PREHOOK: query: TRUNCATE TABLE parq_dec
PREHOOK: type: TRUNCATETABLE
PREHOOK: Output: default@parq_dec
@@ -105,6 +107,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE parq_dec1(name string, value decimal(4,1)) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parq_dec1
POSTHOOK: query: CREATE TABLE parq_dec1(name string, value decimal(4,1)) STORED AS PARQUET
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -137,12 +140,12 @@ POSTHOOK: Input: default@parq_dec1
77.3
55.7
4.3
-6
+6.0
12.3
33.3
0.2
3.2
-8
+8.0
PREHOOK: query: DROP TABLE dec
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@dec
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_decimal1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_decimal1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_decimal1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_decimal1.q.out Fri Aug 22 21:36:47 2014
@@ -6,6 +6,7 @@ PREHOOK: query: CREATE TABLE dec_comp(ar
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' COLLECTION ITEMS TERMINATED BY ',' MAP KEYS TERMINATED by ':'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@dec_comp
POSTHOOK: query: CREATE TABLE dec_comp(arr ARRAY<decimal(5,2)>, m MAP<String, decimal(5,2)>, s STRUCT<i:int, d:decimal(5,2)>)
ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' COLLECTION ITEMS TERMINATED BY ',' MAP KEYS TERMINATED by ':'
POSTHOOK: type: CREATETABLE
@@ -27,7 +28,7 @@ POSTHOOK: query: SELECT * FROM dec_comp
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dec_comp
#### A masked pattern was here ####
-[3.14,6.28,7.3] {"k1":92.77,"k2":29.39} {"i":5,"d":9.03}
+[3.14,6.28,7.30] {"k1":92.77,"k2":29.39} {"i":5,"d":9.03}
[12.4,1.33,0.34] {"k2":2.79,"k4":29.09} {"i":11,"d":0.03}
PREHOOK: query: DROP TABLE IF EXISTS parq_dec_comp
PREHOOK: type: DROPTABLE
@@ -37,6 +38,7 @@ PREHOOK: query: CREATE TABLE parq_dec_co
STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parq_dec_comp
POSTHOOK: query: CREATE TABLE parq_dec_comp(arr ARRAY<decimal(5,2)>, m MAP<String, decimal(5,2)>, s STRUCT<i:int, d:decimal(5,2)>)
STORED AS PARQUET
POSTHOOK: type: CREATETABLE
@@ -70,8 +72,8 @@ POSTHOOK: query: SELECT * FROM parq_dec_
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parq_dec_comp
#### A masked pattern was here ####
-[3.14,6.28,7.3] {"k2":29.39,"k1":92.77} {"i":5,"d":9.03}
-[12.4,1.33,0.34] {"k4":29.09,"k2":2.79} {"i":11,"d":0.03}
+[3.14,6.28,7.30] {"k2":29.39,"k1":92.77} {"i":5,"d":9.03}
+[12.40,1.33,0.34] {"k4":29.09,"k2":2.79} {"i":11,"d":0.03}
PREHOOK: query: DROP TABLE dec_comp
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@dec_comp
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_mixed_case.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_mixed_case.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_mixed_case.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_mixed_case.q.out Fri Aug 22 21:36:47 2014
@@ -11,6 +11,7 @@ PREHOOK: query: CREATE TABLE parquet_mix
) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_mixed_case
POSTHOOK: query: CREATE TABLE parquet_mixed_case (
lowerCase string,
UPPERcase string,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_partitioned.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_partitioned.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_partitioned.q.out Fri Aug 22 21:36:47 2014
@@ -18,6 +18,7 @@ PREHOOK: query: CREATE TABLE parquet_par
FIELDS TERMINATED BY '|'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_partitioned_staging
POSTHOOK: query: CREATE TABLE parquet_partitioned_staging (
id int,
str string,
@@ -34,6 +35,7 @@ PREHOOK: query: CREATE TABLE parquet_par
STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_partitioned
POSTHOOK: query: CREATE TABLE parquet_partitioned (
id int,
str string
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_serde.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_serde.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_serde.q.out Fri Aug 22 21:36:47 2014
@@ -11,6 +11,7 @@ PREHOOK: query: CREATE TABLE parquet_mix
FIELDS TERMINATED BY '|'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_mixed_fileformat
POSTHOOK: query: CREATE TABLE parquet_mixed_fileformat (
id int,
str string,
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/parquet_types.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/parquet_types.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/parquet_types.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/parquet_types.q.out Fri Aug 22 21:36:47 2014
@@ -13,11 +13,14 @@ PREHOOK: query: CREATE TABLE parquet_typ
cfloat float,
cdouble double,
cstring1 string,
- t timestamp
+ t timestamp,
+ cchar char(5),
+ cvarchar varchar(10)
) ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_types_staging
POSTHOOK: query: CREATE TABLE parquet_types_staging (
cint int,
ctinyint tinyint,
@@ -25,7 +28,9 @@ POSTHOOK: query: CREATE TABLE parquet_ty
cfloat float,
cdouble double,
cstring1 string,
- t timestamp
+ t timestamp,
+ cchar char(5),
+ cvarchar varchar(10)
) ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
POSTHOOK: type: CREATETABLE
@@ -38,10 +43,13 @@ PREHOOK: query: CREATE TABLE parquet_typ
cfloat float,
cdouble double,
cstring1 string,
- t timestamp
+ t timestamp,
+ cchar char(5),
+ cvarchar varchar(10)
) STORED AS PARQUET
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_types
POSTHOOK: query: CREATE TABLE parquet_types (
cint int,
ctinyint tinyint,
@@ -49,7 +57,9 @@ POSTHOOK: query: CREATE TABLE parquet_ty
cfloat float,
cdouble double,
cstring1 string,
- t timestamp
+ t timestamp,
+ cchar char(5),
+ cvarchar varchar(10)
) STORED AS PARQUET
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -70,12 +80,14 @@ POSTHOOK: query: INSERT OVERWRITE TABLE
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parquet_types_staging
POSTHOOK: Output: default@parquet_types
+POSTHOOK: Lineage: parquet_types.cchar SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cchar, type:char(5), comment:null), ]
POSTHOOK: Lineage: parquet_types.cdouble SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cdouble, type:double, comment:null), ]
POSTHOOK: Lineage: parquet_types.cfloat SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cfloat, type:float, comment:null), ]
POSTHOOK: Lineage: parquet_types.cint SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cint, type:int, comment:null), ]
POSTHOOK: Lineage: parquet_types.csmallint SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:csmallint, type:smallint, comment:null), ]
POSTHOOK: Lineage: parquet_types.cstring1 SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cstring1, type:string, comment:null), ]
POSTHOOK: Lineage: parquet_types.ctinyint SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
+POSTHOOK: Lineage: parquet_types.cvarchar SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:cvarchar, type:varchar(10), comment:null), ]
POSTHOOK: Lineage: parquet_types.t SIMPLE [(parquet_types_staging)parquet_types_staging.FieldSchema(name:t, type:timestamp, comment:null), ]
PREHOOK: query: SELECT * FROM parquet_types
PREHOOK: type: QUERY
@@ -85,27 +97,27 @@ POSTHOOK: query: SELECT * FROM parquet_t
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parquet_types
#### A masked pattern was here ####
-100 1 1 1.0 0.0 abc 2011-01-01 01:01:01.111111111
-101 2 2 1.1 0.3 def 2012-02-02 02:02:02.222222222
-102 3 3 1.2 0.6 ghi 2013-03-03 03:03:03.333333333
-103 1 4 1.3 0.9 jkl 2014-04-04 04:04:04.444444444
-104 2 5 1.4 1.2 mno 2015-05-05 05:05:05.555555555
-105 3 1 1.0 1.5 pqr 2016-06-06 06:06:06.666666666
-106 1 2 1.1 1.8 stu 2017-07-07 07:07:07.777777777
-107 2 3 1.2 2.1 vwx 2018-08-08 08:08:08.888888888
-108 3 4 1.3 2.4 yza 2019-09-09 09:09:09.999999999
-109 1 5 1.4 2.7 bcd 2020-10-10 10:10:10.101010101
-110 2 1 1.0 3.0 efg 2021-11-11 11:11:11.111111111
-111 3 2 1.1 3.3 hij 2022-12-12 12:12:12.121212121
-112 1 3 1.2 3.6 klm 2023-01-02 13:13:13.131313131
-113 2 4 1.3 3.9 nop 2024-02-02 14:14:14.141414141
-114 3 5 1.4 4.2 qrs 2025-03-03 15:15:15.151515151
-115 1 1 1.0 4.5 tuv 2026-04-04 16:16:16.161616161
-116 2 2 1.1 4.8 wxy 2027-05-05 17:17:17.171717171
-117 3 3 1.2 5.1 zab 2028-06-06 18:18:18.181818181
-118 1 4 1.3 5.4 cde 2029-07-07 19:19:19.191919191
-119 2 5 1.4 5.7 fgh 2030-08-08 20:20:20.202020202
-120 3 1 1.0 6.0 ijk 2031-09-09 21:21:21.212121212
+100 1 1 1.0 0.0 abc 2011-01-01 01:01:01.111111111 a a
+101 2 2 1.1 0.3 def 2012-02-02 02:02:02.222222222 ab ab
+102 3 3 1.2 0.6 ghi 2013-03-03 03:03:03.333333333 abc abc
+103 1 4 1.3 0.9 jkl 2014-04-04 04:04:04.444444444 abcd abcd
+104 2 5 1.4 1.2 mno 2015-05-05 05:05:05.555555555 abcde abcde
+105 3 1 1.0 1.5 pqr 2016-06-06 06:06:06.666666666 abcde abcdef
+106 1 2 1.1 1.8 stu 2017-07-07 07:07:07.777777777 abcde abcdefg
+107 2 3 1.2 2.1 vwx 2018-08-08 08:08:08.888888888 bcdef abcdefgh
+108 3 4 1.3 2.4 yza 2019-09-09 09:09:09.999999999 cdefg abcdefghij
+109 1 5 1.4 2.7 bcd 2020-10-10 10:10:10.101010101 klmno abcdedef
+110 2 1 1.0 3.0 efg 2021-11-11 11:11:11.111111111 pqrst abcdede
+111 3 2 1.1 3.3 hij 2022-12-12 12:12:12.121212121 nopqr abcded
+112 1 3 1.2 3.6 klm 2023-01-02 13:13:13.131313131 opqrs abcdd
+113 2 4 1.3 3.9 nop 2024-02-02 14:14:14.141414141 pqrst abc
+114 3 5 1.4 4.2 qrs 2025-03-03 15:15:15.151515151 qrstu b
+115 1 1 1.0 4.5 tuv 2026-04-04 16:16:16.161616161 rstuv abcded
+116 2 2 1.1 4.8 wxy 2027-05-05 17:17:17.171717171 stuvw abcded
+117 3 3 1.2 5.1 zab 2028-06-06 18:18:18.181818181 tuvwx abcded
+118 1 4 1.3 5.4 cde 2029-07-07 19:19:19.191919191 uvwzy abcdede
+119 2 5 1.4 5.7 fgh 2030-08-08 20:20:20.202020202 vwxyz abcdede
+120 3 1 1.0 6.0 ijk 2031-09-09 21:21:21.212121212 wxyza abcde
PREHOOK: query: SELECT ctinyint,
MAX(cint),
MIN(csmallint),
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partInit.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partInit.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partInit.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partInit.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE empty (c INT) PARTITIONED BY (p INT)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@empty
POSTHOOK: query: CREATE TABLE empty (c INT) PARTITIONED BY (p INT)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- The property needs to
create table mytbl (c1 tinyint) partitioned by (c2 string) tblproperties ('a'='myval','b'='yourval','c'='noval')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@mytbl
POSTHOOK: query: -- The property needs to be unset at the end of the test till HIVE-3109/HIVE-3112 is fixed
create table mytbl (c1 tinyint) partitioned by (c2 string) tblproperties ('a'='myval','b'='yourval','c'='noval')
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props_empty.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props_empty.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props_empty.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props_empty.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table mytbl (c1 tinyint) partitioned by (c2 string) tblproperties ('a'='myval','b'='yourval','c'='noval')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@mytbl
POSTHOOK: query: create table mytbl (c1 tinyint) partitioned by (c2 string) tblproperties ('a'='myval','b'='yourval','c'='noval')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props_with_star.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props_with_star.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props_with_star.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/part_inherit_tbl_props_with_star.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- The property needs to
create table mytbl (c1 tinyint) partitioned by (c2 string) tblproperties ('a'='myval','b'='yourval','c'='noval')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@mytbl
POSTHOOK: query: -- The property needs to be unset at the end of the test till HIVE-3109/HIVE-3112 is fixed
create table mytbl (c1 tinyint) partitioned by (c2 string) tblproperties ('a'='myval','b'='yourval','c'='noval')
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partcols1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partcols1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partcols1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partcols1.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table test1(col1 string) partitioned by (partitionId int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test1
POSTHOOK: query: create table test1(col1 string) partitioned by (partitionId int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_date.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_date.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_date.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_date.q.out Fri Aug 22 21:36:47 2014
@@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_date_1
POSTHOOK: query: create table partition_date_1 (key string, value string) partitioned by (dt date, region string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_date2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_date2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_date2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_date2.q.out Fri Aug 22 21:36:47 2014
@@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table partition_date2_1 (key string, value string) partitioned by (dt date, region int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_date2_1
POSTHOOK: query: create table partition_date2_1 (key string, value string) partitioned by (dt date, region int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_decode_name.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_decode_name.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_decode_name.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_decode_name.q.out Fri Aug 22 21:36:47 2014
@@ -18,6 +18,7 @@ POSTHOOK: Output: default@sc
PREHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@sc_part
POSTHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_schema1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_schema1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_schema1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_schema1.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table partition_schema1(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_schema1
POSTHOOK: query: create table partition_schema1(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_serde_format.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_serde_format.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_serde_format.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_serde_format.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table src_part_serde (key int, value string) partitioned by (ds string) stored as sequencefile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@src_part_serde
POSTHOOK: query: create table src_part_serde (key int, value string) partitioned by (ds string) stored as sequencefile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_special_char.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_special_char.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_special_char.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_special_char.q.out Fri Aug 22 21:36:47 2014
@@ -18,6 +18,7 @@ POSTHOOK: Output: default@sc
PREHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@sc_part
POSTHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_type_check.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_type_check.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_type_check.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_type_check.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: -- begin part(string, st
CREATE TABLE tab1 (id1 int,id2 string) PARTITIONED BY(month string,day string) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tab1
POSTHOOK: query: -- begin part(string, string) pass(string, int)
CREATE TABLE tab1 (id1 int,id2 string) PARTITIONED BY(month string,day string) stored as textfile
POSTHOOK: type: CREATETABLE
@@ -44,6 +45,7 @@ PREHOOK: query: -- begin part(string, in
CREATE TABLE tab1 (id1 int,id2 string) PARTITIONED BY(month string,day int) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tab1
POSTHOOK: query: -- begin part(string, int) pass(string, string)
CREATE TABLE tab1 (id1 int,id2 string) PARTITIONED BY(month string,day int) stored as textfile
POSTHOOK: type: CREATETABLE
@@ -86,6 +88,7 @@ PREHOOK: query: -- begin part(string, da
create table tab1 (id1 int, id2 string) PARTITIONED BY(month string,day date) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tab1
POSTHOOK: query: -- begin part(string, date) pass(string, date)
create table tab1 (id1 int, id2 string) PARTITIONED BY(month string,day date) stored as textfile
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_varchar1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_varchar1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_varchar1.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_varchar1.q.out Fri Aug 22 21:36:47 2014
@@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table partition_varchar_1 (key string, value varchar(20)) partitioned by (dt varchar(10), region int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_varchar_1
POSTHOOK: query: create table partition_varchar_1 (key string, value varchar(20)) partitioned by (dt varchar(10), region int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_varchar2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_varchar2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_varchar2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_varchar2.q.out Fri Aug 22 21:36:47 2014
@@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table partition_varchar_2 (key string, value varchar(20)) partitioned by (dt varchar(15), region int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_varchar_2
POSTHOOK: query: create table partition_varchar_2 (key string, value varchar(20)) partitioned by (dt varchar(15), region int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_vs_table_metadata.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table partition_vs_table(key string, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_vs_table
POSTHOOK: query: create table partition_vs_table(key string, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat10.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat10.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat10.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: -- This tests that the s
create table prt(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@prt
POSTHOOK: query: -- This tests that the schema can be changed for binary serde data
create table prt(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat11.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat11.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat11.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: -- This tests that the s
create table partition_test_partitioned(key string, value string) partitioned by (dt string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: -- This tests that the schema can be changed for binary serde data
create table partition_test_partitioned(key string, value string) partitioned by (dt string) stored as rcfile
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat12.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat12.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat12.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: -- This tests that the s
create table partition_test_partitioned(key string, value string) partitioned by (dt string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: -- This tests that the schema can be changed for binary serde data
create table partition_test_partitioned(key string, value string) partitioned by (dt string) stored as rcfile
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat13.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat13.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat13.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: -- This tests that the s
create table T1(key string, value string) partitioned by (dt string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@T1
POSTHOOK: query: -- This tests that the schema can be changed for partitioned tables for binary serde data for joins
create table T1(key string, value string) partitioned by (dt string) stored as rcfile
POSTHOOK: type: CREATETABLE
@@ -54,6 +55,7 @@ POSTHOOK: Output: default@t1
PREHOOK: query: create table T2(key string, value string) partitioned by (dt string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@T2
POSTHOOK: query: create table T2(key string, value string) partitioned by (dt string) stored as rcfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat14.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat14.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat14.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: CREATE TABLE tbl1(key in
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tbl1
POSTHOOK: query: CREATE TABLE tbl1(key int, value string) PARTITIONED by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS rcfile
POSTHOOK: type: CREATETABLE
@@ -11,6 +12,7 @@ PREHOOK: query: CREATE TABLE tbl2(key in
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@tbl2
POSTHOOK: query: CREATE TABLE tbl2(key int, value string) PARTITIONED by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS rcfile
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat15.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat15.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat15.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat15.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ create table partition_test_partitioned(
partitioned by (dt string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: -- This tests that the schema can be changed for binary serde data
create table partition_test_partitioned(key string, value string)
partitioned by (dt string) stored as rcfile
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat16.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat16.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat16.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat16.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ create table partition_test_partitioned(
partitioned by (dt string) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: -- This tests that the schema can be changed for binary serde data
create table partition_test_partitioned(key string, value string)
partitioned by (dt string) stored as textfile
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat17.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat17.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat17.q.out Fri Aug 22 21:36:47 2014
@@ -13,6 +13,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE PW17(USER STRING, COMPLEXDT ARRAY<INT>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@PW17
POSTHOOK: query: CREATE TABLE PW17(USER STRING, COMPLEXDT ARRAY<INT>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -68,6 +69,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE PW17_2(USER STRING, COMPLEXDT ARRAY<INT>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@PW17_2
POSTHOOK: query: CREATE TABLE PW17_2(USER STRING, COMPLEXDT ARRAY<INT>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe1'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -98,6 +100,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE PW17_3(USER STRING, COMPLEXDT ARRAY<ARRAY<INT> >) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@PW17_3
POSTHOOK: query: CREATE TABLE PW17_3(USER STRING, COMPLEXDT ARRAY<ARRAY<INT> >) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -151,6 +154,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE PW17_4(USER STRING, COMPLEXDT ARRAY<ARRAY<INT> >) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@PW17_4
POSTHOOK: query: CREATE TABLE PW17_4(USER STRING, COMPLEXDT ARRAY<ARRAY<INT> >) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe3'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat18.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat18.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat18.q.out Fri Aug 22 21:36:47 2014
@@ -15,6 +15,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE PW18(USER STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@PW18
POSTHOOK: query: CREATE TABLE PW18(USER STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) PARTITIONED BY (YEAR STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -62,6 +63,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE PW18_2(USER STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@PW18_2
POSTHOOK: query: CREATE TABLE PW18_2(USER STRING, COMPLEXDT UNIONTYPE<INT, DOUBLE>) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.CustomSerDe5'
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat2.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat3.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat3.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat4.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat4.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat5.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat5.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat6.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat6.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat6.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat7.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat7.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat7.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: create table partition_test_partitioned(key string, value string) partitioned by (dt string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat8.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat8.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat8.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- This tests that a que
create table partition_test_partitioned(key string, value string) partitioned by (dt string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: -- This tests that a query can span multiple partitions which can not only have different file formats, but
-- also different serdes
create table partition_test_partitioned(key string, value string) partitioned by (dt string) stored as rcfile
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat9.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat9.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partition_wise_fileformat9.q.out Fri Aug 22 21:36:47 2014
@@ -3,6 +3,7 @@ PREHOOK: query: -- This tests that a que
create table partition_test_partitioned(key string, value string) partitioned by (dt string) stored as rcfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@partition_test_partitioned
POSTHOOK: query: -- This tests that a query can span multiple partitions which can not only have different file formats, but
-- also different serdes
create table partition_test_partitioned(key string, value string) partitioned by (dt string) stored as rcfile
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/partitions_json.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/partitions_json.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/partitions_json.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/partitions_json.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@add_part_test
POSTHOOK: query: CREATE TABLE add_part_test (key STRING, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/pcr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/pcr.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/pcr.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/pcr.q.out Fri Aug 22 21:36:47 2014 differ
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ppd_constant_expr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_constant_expr.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_constant_expr.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_constant_expr.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE ppd_constant_expr(c1 STRING, c2 INT, c3 DOUBLE) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@ppd_constant_expr
POSTHOOK: query: CREATE TABLE ppd_constant_expr(c1 STRING, c2 INT, c3 DOUBLE) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ppd_field_garbage.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_field_garbage.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_field_garbage.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_field_garbage.q.out Fri Aug 22 21:36:47 2014
@@ -2,6 +2,7 @@ PREHOOK: query: -- ppd leaves invalid ex
CREATE TABLE test_issue (fileid int, infos ARRAY<STRUCT<user:INT>>, test_c STRUCT<user_c:STRUCT<age:INT>>)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_issue
POSTHOOK: query: -- ppd leaves invalid expr in field expr
CREATE TABLE test_issue (fileid int, infos ARRAY<STRUCT<user:INT>>, test_c STRUCT<user_c:STRUCT<age:INT>>)
POSTHOOK: type: CREATETABLE
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join4.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join4.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table dual(a string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@dual
POSTHOOK: query: create table dual(a string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -12,6 +13,7 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table test_tbl (id string,name string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@test_tbl
POSTHOOK: query: create table test_tbl (id string,name string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join5.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join5.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: create table t1 (id1 string, id2 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: create table t1 (id1 string, id2 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -8,6 +9,7 @@ POSTHOOK: Output: default@t1
PREHOOK: query: create table t2 (id string, d int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
POSTHOOK: query: create table t2 (id string, d int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -80,7 +82,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
1 {VALUE._col0}
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1, _col6
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -96,7 +98,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: int)
+ value expressions: _col0 (type: string), _col1 (type: string), _col6 (type: int)
TableScan
alias: c
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
@@ -112,12 +114,12 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col6}
1 {VALUE._col1}
- outputColumnNames: _col0, _col1, _col5, _col9
+ outputColumnNames: _col0, _col1, _col6, _col11
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: int), _col9 (type: int)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: int), _col11 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -188,7 +190,7 @@ STAGE PLANS:
condition expressions:
0 {KEY.reducesinkkey0} {KEY.reducesinkkey1}
1 {VALUE._col0}
- outputColumnNames: _col0, _col1, _col5
+ outputColumnNames: _col0, _col1, _col6
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
@@ -204,7 +206,7 @@ STAGE PLANS:
Reduce Output Operator
sort order:
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col5 (type: int)
+ value expressions: _col0 (type: string), _col1 (type: string), _col6 (type: int)
TableScan
alias: c
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
@@ -220,15 +222,15 @@ STAGE PLANS:
condition map:
Inner Join 0 to 1
condition expressions:
- 0 {VALUE._col0} {VALUE._col1} {VALUE._col5}
+ 0 {VALUE._col0} {VALUE._col1} {VALUE._col6}
1 {VALUE._col1}
- outputColumnNames: _col0, _col1, _col5, _col9
+ outputColumnNames: _col0, _col1, _col6, _col11
Statistics: Num rows: 1 Data size: 3 Basic stats: COMPLETE Column stats: NONE
Filter Operator
- predicate: ((_col5 > 1) or (_col9 > 1)) (type: boolean)
+ predicate: ((_col6 > 1) or (_col11 > 1)) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), _col5 (type: int), _col9 (type: int)
+ expressions: _col0 (type: string), _col1 (type: string), _col6 (type: int), _col11 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join_filter.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join_filter.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
Files hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join_filter.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/ppd_join_filter.q.out Fri Aug 22 21:36:47 2014 differ
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ppd_multi_insert.q.out
URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ppd_multi_insert.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff
==============================================================================
--- hive/branches/cbo/ql/src/test/results/clientpositive/ppd_multi_insert.q.out (original)
+++ hive/branches/cbo/ql/src/test/results/clientpositive/ppd_multi_insert.q.out Fri Aug 22 21:36:47 2014
@@ -1,6 +1,7 @@
PREHOOK: query: CREATE TABLE mi1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@mi1
POSTHOOK: query: CREATE TABLE mi1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -8,6 +9,7 @@ POSTHOOK: Output: default@mi1
PREHOOK: query: CREATE TABLE mi2(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@mi2
POSTHOOK: query: CREATE TABLE mi2(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
@@ -15,6 +17,7 @@ POSTHOOK: Output: default@mi2
PREHOOK: query: CREATE TABLE mi3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
+PREHOOK: Output: default@mi3
POSTHOOK: query: CREATE TABLE mi3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default