You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by th...@apache.org on 2014/02/20 16:44:58 UTC
svn commit: r1570238 [9/28] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/common/
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/negative/
hbase-handler/src/test/results/posit...
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_table_serde2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_table_serde2.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_table_serde2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_table_serde2.q.out Thu Feb 20 15:44:37 2014
@@ -3,11 +3,13 @@ PREHOOK: query: -- Tests that when overw
CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Tests that when overwriting a partition in a table after altering the serde properties
-- the partition metadata is updated as well.
CREATE TABLE tst1(key STRING, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tst1
PREHOOK: query: DESCRIBE FORMATTED tst1
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_varchar1.q.out Thu Feb 20 15:44:37 2014
@@ -4,8 +4,10 @@ POSTHOOK: query: drop table alter_varcha
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table alter_varchar_1 (key string, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table alter_varchar_1 (key string, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@alter_varchar_1
PREHOOK: query: insert overwrite table alter_varchar_1
select key, value from src order by key limit 5
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_varchar2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_varchar2.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_varchar2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_varchar2.q.out Thu Feb 20 15:44:37 2014
@@ -8,10 +8,12 @@ PREHOOK: query: create table alter_varch
c1 varchar(255)
) partitioned by (hr int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table alter_varchar2 (
c1 varchar(255)
) partitioned by (hr int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@alter_varchar2
PREHOOK: query: insert overwrite table alter_varchar2 partition (hr=1)
select value from src tablesample (1 rows)
Modified: hive/trunk/ql/src/test/results/clientpositive/alter_view_rename.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/alter_view_rename.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/alter_view_rename.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/alter_view_rename.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE invites (foo INT, bar STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@invites
PREHOOK: query: CREATE VIEW view1 as SELECT * FROM invites
PREHOOK: type: CREATEVIEW
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_filter.q.out Thu Feb 20 15:44:37 2014
@@ -5,6 +5,7 @@ PREHOOK: query: create table if not exis
year int
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists loc_staging (
state string,
locid int,
@@ -12,11 +13,14 @@ POSTHOOK: query: create table if not exi
year int
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_staging
PREHOOK: query: create table loc_orc like loc_staging
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table loc_orc like loc_staging
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_orc
PREHOOK: query: alter table loc_orc set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
@@ -28,9 +32,11 @@ POSTHOOK: Input: default@loc_orc
POSTHOOK: Output: default@loc_orc
PREHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@loc_staging
POSTHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@loc_staging
PREHOOK: query: insert overwrite table loc_orc select * from loc_staging
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_groupby.q.out Thu Feb 20 15:44:37 2014
@@ -5,6 +5,7 @@ PREHOOK: query: create table if not exis
year int
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists loc_staging (
state string,
locid int,
@@ -12,11 +13,14 @@ POSTHOOK: query: create table if not exi
year int
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_staging
PREHOOK: query: create table loc_orc like loc_staging
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table loc_orc like loc_staging
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_orc
PREHOOK: query: alter table loc_orc set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
@@ -28,9 +32,11 @@ POSTHOOK: Input: default@loc_orc
POSTHOOK: Output: default@loc_orc
PREHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@loc_staging
POSTHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@loc_staging
PREHOOK: query: insert overwrite table loc_orc select * from loc_staging
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_join.q.out Thu Feb 20 15:44:37 2014
@@ -3,22 +3,26 @@ PREHOOK: query: create table if not exis
deptid int
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists emp_staging (
lastname string,
deptid int
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@emp_staging
PREHOOK: query: create table if not exists dept_staging (
deptid int,
deptname string
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists dept_staging (
deptid int,
deptname string
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dept_staging
PREHOOK: query: create table if not exists loc_staging (
state string,
@@ -27,6 +31,7 @@ PREHOOK: query: create table if not exis
year int
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists loc_staging (
state string,
locid int,
@@ -34,11 +39,14 @@ POSTHOOK: query: create table if not exi
year int
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_staging
PREHOOK: query: create table if not exists emp_orc like emp_staging
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists emp_orc like emp_staging
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@emp_orc
PREHOOK: query: alter table emp_orc set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
@@ -50,8 +58,10 @@ POSTHOOK: Input: default@emp_orc
POSTHOOK: Output: default@emp_orc
PREHOOK: query: create table if not exists dept_orc like dept_staging
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists dept_orc like dept_staging
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dept_orc
PREHOOK: query: alter table dept_orc set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
@@ -63,8 +73,10 @@ POSTHOOK: Input: default@dept_orc
POSTHOOK: Output: default@dept_orc
PREHOOK: query: create table loc_orc like loc_staging
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table loc_orc like loc_staging
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_orc
PREHOOK: query: alter table loc_orc set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
@@ -76,21 +88,27 @@ POSTHOOK: Input: default@loc_orc
POSTHOOK: Output: default@loc_orc
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/emp.txt' OVERWRITE INTO TABLE emp_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@emp_staging
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/emp.txt' OVERWRITE INTO TABLE emp_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@emp_staging
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dept.txt' OVERWRITE INTO TABLE dept_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@dept_staging
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/dept.txt' OVERWRITE INTO TABLE dept_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@dept_staging
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/loc.txt' OVERWRITE INTO TABLE loc_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@loc_staging
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/loc.txt' OVERWRITE INTO TABLE loc_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@loc_staging
PREHOOK: query: insert overwrite table emp_orc select * from emp_staging
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_limit.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_limit.q.out Thu Feb 20 15:44:37 2014
@@ -5,6 +5,7 @@ PREHOOK: query: create table if not exis
year int
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists loc_staging (
state string,
locid int,
@@ -12,11 +13,14 @@ POSTHOOK: query: create table if not exi
year int
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_staging
PREHOOK: query: create table loc_orc like loc_staging
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table loc_orc like loc_staging
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_orc
PREHOOK: query: alter table loc_orc set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
@@ -28,9 +32,11 @@ POSTHOOK: Input: default@loc_orc
POSTHOOK: Output: default@loc_orc
PREHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@loc_staging
POSTHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@loc_staging
PREHOOK: query: insert overwrite table loc_orc select * from loc_staging
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_part.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_part.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_part.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_part.q.out Thu Feb 20 15:44:37 2014
@@ -5,6 +5,7 @@ PREHOOK: query: create table if not exis
year string
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists loc_staging (
state string,
locid int,
@@ -12,12 +13,15 @@ POSTHOOK: query: create table if not exi
year string
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_staging
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/loc.txt' OVERWRITE INTO TABLE loc_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@loc_staging
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/loc.txt' OVERWRITE INTO TABLE loc_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@loc_staging
PREHOOK: query: create table if not exists loc_orc (
state string,
@@ -25,12 +29,14 @@ PREHOOK: query: create table if not exis
zip bigint
) partitioned by(year string) stored as orc
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists loc_orc (
state string,
locid int,
zip bigint
) partitioned by(year string) stored as orc
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_orc
PREHOOK: query: -- basicStatState: NONE colStatState: NONE
explain extended select * from loc_orc
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_select.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_select.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_select.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_select.q.out Thu Feb 20 15:44:37 2014
@@ -18,6 +18,7 @@ PREHOOK: query: create table if not exis
collection items terminated by ','
map keys terminated by ':' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists alltypes (
bo1 boolean,
ti1 tinyint,
@@ -38,11 +39,14 @@ POSTHOOK: query: create table if not exi
collection items terminated by ','
map keys terminated by ':' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@alltypes
PREHOOK: query: create table alltypes_orc like alltypes
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table alltypes_orc like alltypes
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@alltypes_orc
PREHOOK: query: alter table alltypes_orc set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
@@ -54,9 +58,11 @@ POSTHOOK: Input: default@alltypes_orc
POSTHOOK: Output: default@alltypes_orc
PREHOOK: query: load data local inpath '../../data/files/alltypes.txt' overwrite into table alltypes
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@alltypes
POSTHOOK: query: load data local inpath '../../data/files/alltypes.txt' overwrite into table alltypes
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@alltypes
PREHOOK: query: insert overwrite table alltypes_orc select * from alltypes
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_table.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_table.q.out Thu Feb 20 15:44:37 2014
@@ -3,16 +3,20 @@ PREHOOK: query: create table if not exis
deptid int
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists emp_staging (
lastname string,
deptid int
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@emp_staging
PREHOOK: query: create table if not exists emp_orc like emp_staging
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists emp_orc like emp_staging
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@emp_orc
PREHOOK: query: alter table emp_orc set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
@@ -64,9 +68,11 @@ STAGE PLANS:
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/emp.txt' OVERWRITE INTO TABLE emp_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@emp_staging
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/emp.txt' OVERWRITE INTO TABLE emp_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@emp_staging
PREHOOK: query: insert overwrite table emp_orc select * from emp_staging
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/annotate_stats_union.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/annotate_stats_union.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/annotate_stats_union.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/annotate_stats_union.q.out Thu Feb 20 15:44:37 2014
@@ -5,6 +5,7 @@ PREHOOK: query: create table if not exis
year int
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table if not exists loc_staging (
state string,
locid int,
@@ -12,11 +13,14 @@ POSTHOOK: query: create table if not exi
year int
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_staging
PREHOOK: query: create table loc_orc like loc_staging
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table loc_orc like loc_staging
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@loc_orc
PREHOOK: query: alter table loc_orc set fileformat orc
PREHOOK: type: ALTERTABLE_FILEFORMAT
@@ -28,9 +32,11 @@ POSTHOOK: Input: default@loc_orc
POSTHOOK: Output: default@loc_orc
PREHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@loc_staging
POSTHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@loc_staging
PREHOOK: query: insert overwrite table loc_orc select * from loc_staging
PREHOOK: type: QUERY
@@ -607,6 +613,7 @@ PREHOOK: query: create table if not exis
year int
) row format delimited fields terminated by '|' stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:test
POSTHOOK: query: create table if not exists loc_staging (
state string,
locid int,
@@ -614,6 +621,7 @@ POSTHOOK: query: create table if not exi
year int
) row format delimited fields terminated by '|' stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:test
POSTHOOK: Output: test@loc_staging
POSTHOOK: Lineage: loc_orc.locid SIMPLE [(loc_staging)loc_staging.FieldSchema(name:locid, type:int, comment:null), ]
POSTHOOK: Lineage: loc_orc.state SIMPLE [(loc_staging)loc_staging.FieldSchema(name:state, type:string, comment:null), ]
@@ -621,8 +629,10 @@ POSTHOOK: Lineage: loc_orc.year SIMPLE [
POSTHOOK: Lineage: loc_orc.zip SIMPLE [(loc_staging)loc_staging.FieldSchema(name:zip, type:bigint, comment:null), ]
PREHOOK: query: create table loc_orc like loc_staging
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:test
POSTHOOK: query: create table loc_orc like loc_staging
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:test
POSTHOOK: Output: test@loc_orc
POSTHOOK: Lineage: loc_orc.locid SIMPLE [(loc_staging)loc_staging.FieldSchema(name:locid, type:int, comment:null), ]
POSTHOOK: Lineage: loc_orc.state SIMPLE [(loc_staging)loc_staging.FieldSchema(name:state, type:string, comment:null), ]
@@ -642,9 +652,11 @@ POSTHOOK: Lineage: loc_orc.year SIMPLE [
POSTHOOK: Lineage: loc_orc.zip SIMPLE [(loc_staging)loc_staging.FieldSchema(name:zip, type:bigint, comment:null), ]
PREHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: test@loc_staging
POSTHOOK: query: load data local inpath '../../data/files/loc.txt' overwrite into table loc_staging
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: test@loc_staging
POSTHOOK: Lineage: loc_orc.locid SIMPLE [(loc_staging)loc_staging.FieldSchema(name:locid, type:int, comment:null), ]
POSTHOOK: Lineage: loc_orc.state SIMPLE [(loc_staging)loc_staging.FieldSchema(name:state, type:string, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/archive_excludeHadoop20.q.out Thu Feb 20 15:44:37 2014
@@ -12,8 +12,10 @@ POSTHOOK: query: drop table tstsrcpart
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tstsrc like src
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tstsrc like src
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrc
PREHOOK: query: insert overwrite table tstsrc select key, value from src
PREHOOK: type: QUERY
@@ -27,8 +29,10 @@ POSTHOOK: Lineage: tstsrc.key SIMPLE [(s
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: create table tstsrcpart (key string, value string) partitioned by (ds string, hr string) clustered by (key) into 10 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tstsrcpart (key string, value string) partitioned by (ds string, hr string) clustered by (key) into 10 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrcpart
POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -277,10 +281,12 @@ PREHOOK: query: CREATE TABLE harbucket(k
PARTITIONED by (ds STRING)
CLUSTERED BY (key) INTO 10 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE harbucket(key INT)
PARTITIONED by (ds STRING)
CLUSTERED BY (key) INTO 10 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@harbucket
POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -433,9 +439,11 @@ POSTHOOK: Lineage: tstsrcpart PARTITION(
PREHOOK: query: CREATE TABLE old_name(key INT)
PARTITIONED by (ds STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE old_name(key INT)
PARTITIONED by (ds STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@old_name
POSTHOOK: Lineage: harbucket PARTITION(ds=1).key EXPRESSION [(tstsrc)tstsrc.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/archive_multi.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/archive_multi.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/archive_multi.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/archive_multi.q.out Thu Feb 20 15:44:37 2014
@@ -8,8 +8,10 @@ POSTHOOK: query: drop table tstsrcpart
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tstsrc like src
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tstsrc like src
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrc
PREHOOK: query: insert overwrite table tstsrc select key, value from src
PREHOOK: type: QUERY
@@ -23,8 +25,10 @@ POSTHOOK: Lineage: tstsrc.key SIMPLE [(s
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: create table tstsrcpart like srcpart
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tstsrcpart like srcpart
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrcpart
POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_1_sql_std.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table src_autho_test (key STRING, value STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table src_autho_test (key STRING, value STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_autho_test
PREHOOK: query: set role ADMIN
PREHOOK: type: SHOW_ROLES
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_2.q.out Thu Feb 20 15:44:37 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table authorization_part (key int, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table authorization_part (key int, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@authorization_part
PREHOOK: query: create table src_auth_tmp as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
@@ -53,14 +55,14 @@ PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table authorization_part
POSTHOOK: type: SHOW_GRANT
default authorization_part hive_test_user USER Create false -1 hive_test_user
-default authorization_part hive_test_user USER Update false -1 hive_test_user
default authorization_part hive_test_user USER Drop false -1 hive_test_user
+default authorization_part hive_test_user USER Update false -1 hive_test_user
PREHOOK: query: alter table authorization_part add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Input: default@authorization_part
+PREHOOK: Output: default@authorization_part
POSTHOOK: query: alter table authorization_part add partition (ds='2010')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Input: default@authorization_part
+POSTHOOK: Output: default@authorization_part
POSTHOOK: Output: default@authorization_part@ds=2010
PREHOOK: query: show grant user hive_test_user on table authorization_part partition (ds='2010')
PREHOOK: type: SHOW_GRANT
@@ -225,14 +227,14 @@ POSTHOOK: type: SHOW_GRANT
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
default authorization_part hive_test_user USER Create false -1 hive_test_user
-default authorization_part hive_test_user USER Update false -1 hive_test_user
default authorization_part hive_test_user USER Drop false -1 hive_test_user
+default authorization_part hive_test_user USER Update false -1 hive_test_user
PREHOOK: query: alter table authorization_part add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Input: default@authorization_part
+PREHOOK: Output: default@authorization_part
POSTHOOK: query: alter table authorization_part add partition (ds='2010')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Input: default@authorization_part
+POSTHOOK: Output: default@authorization_part
POSTHOOK: Output: default@authorization_part@ds=2010
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
@@ -296,9 +298,9 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
default authorization_part hive_test_user USER Create false -1 hive_test_user
-default authorization_part hive_test_user USER Update false -1 hive_test_user
default authorization_part hive_test_user USER Drop false -1 hive_test_user
default authorization_part hive_test_user USER Select false -1 hive_test_user
+default authorization_part hive_test_user USER Update false -1 hive_test_user
PREHOOK: query: select key from authorization_part where ds='2010' order by key limit 20
PREHOOK: type: QUERY
PREHOOK: Input: default@authorization_part
@@ -352,8 +354,8 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
default authorization_part hive_test_user USER Create false -1 hive_test_user
-default authorization_part hive_test_user USER Update false -1 hive_test_user
default authorization_part hive_test_user USER Drop false -1 hive_test_user
+default authorization_part hive_test_user USER Update false -1 hive_test_user
PREHOOK: query: show grant user hive_test_user on table authorization_part partition (ds='2010')
PREHOOK: type: SHOW_GRANT
POSTHOOK: query: show grant user hive_test_user on table authorization_part partition (ds='2010')
@@ -447,10 +449,10 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
PREHOOK: query: alter table authorization_part add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Input: default@authorization_part
+PREHOOK: Output: default@authorization_part
POSTHOOK: query: alter table authorization_part add partition (ds='2010')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Input: default@authorization_part
+POSTHOOK: Output: default@authorization_part
POSTHOOK: Output: default@authorization_part@ds=2010
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
@@ -677,10 +679,10 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
PREHOOK: query: alter table authorization_part add partition (ds='2010')
PREHOOK: type: ALTERTABLE_ADDPARTS
-PREHOOK: Input: default@authorization_part
+PREHOOK: Output: default@authorization_part
POSTHOOK: query: alter table authorization_part add partition (ds='2010')
POSTHOOK: type: ALTERTABLE_ADDPARTS
-POSTHOOK: Input: default@authorization_part
+POSTHOOK: Output: default@authorization_part
POSTHOOK: Output: default@authorization_part@ds=2010
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_6.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_6.q.out Thu Feb 20 15:44:37 2014
@@ -11,8 +11,10 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@src_auth_tmp
PREHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@authorization_part
PREHOOK: query: ALTER TABLE authorization_part SET TBLPROPERTIES ("PARTITION_LEVEL_PRIVILEGE"="TRUE")
PREHOOK: type: ALTERTABLE_PROPERTIES
@@ -160,8 +162,10 @@ POSTHOOK: Lineage: authorization_part PA
POSTHOOK: Lineage: authorization_part PARTITION(ds=2011).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
PREHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table authorization_part (key int, value string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@authorization_part
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).key EXPRESSION [(src_auth_tmp)src_auth_tmp.FieldSchema(name:key, type:string, comment:null), ]
POSTHOOK: Lineage: authorization_part PARTITION(ds=2010).value SIMPLE [(src_auth_tmp)src_auth_tmp.FieldSchema(name:value, type:string, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_7.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_7.q.out Thu Feb 20 15:44:37 2014
@@ -4,8 +4,10 @@ POSTHOOK: query: GRANT ALL TO USER hive_
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: CREATE TABLE src_authorization_7 (key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE src_authorization_7 (key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_authorization_7
PREHOOK: query: DESCRIBE src_authorization_7
PREHOOK: type: DESCTABLE
@@ -31,8 +33,10 @@ POSTHOOK: query: GRANT ALL TO GROUP hive
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: CREATE TABLE src_authorization_7 (key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE src_authorization_7 (key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_authorization_7
PREHOOK: query: DESCRIBE src_authorization_7
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_8.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_8.q.out Thu Feb 20 15:44:37 2014
@@ -4,8 +4,10 @@ POSTHOOK: query: GRANT ALL TO USER hive_
POSTHOOK: type: GRANT_PRIVILEGE
PREHOOK: query: CREATE TABLE tbl_j5jbymsx8e (key INT, value STRING) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl_j5jbymsx8e (key INT, value STRING) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl_j5jbymsx8e
PREHOOK: query: CREATE VIEW view_j5jbymsx8e_1 as SELECT * FROM tbl_j5jbymsx8e
PREHOOK: type: CREATEVIEW
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_9.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_9.q.out Thu Feb 20 15:44:37 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table dummy (key string, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table dummy (key string, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dummy
PREHOOK: query: grant select on database default to user hive_test_user
PREHOOK: type: GRANT_PRIVILEGE
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_admin_almighty1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_admin_almighty1.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_admin_almighty1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_admin_almighty1.q.out Thu Feb 20 15:44:37 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- actions from admin sh
create table t1(i int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- actions from admin should work as if admin has all privileges
create table t1(i int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: show current roles
PREHOOK: type: SHOW_ROLES
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_create_table_owner_privs.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table create_table_creator_priv_test(i int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table create_table_creator_priv_test(i int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@create_table_creator_priv_test
PREHOOK: query: -- all privileges should have been set for user
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_grant_table_priv.q.out Thu Feb 20 15:44:37 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- current user has been
CREATE TABLE table_priv1(i int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!)
CREATE TABLE table_priv1(i int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_priv1
PREHOOK: query: -- all privileges should have been set for user
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_owner_actions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_owner_actions.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_owner_actions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_owner_actions.q.out Thu Feb 20 15:44:37 2014
@@ -1,9 +1,11 @@
#### A masked pattern was here ####
create table t1(i int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
#### A masked pattern was here ####
create table t1(i int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: ALTER TABLE t1 SET SERDEPROPERTIES ('field.delim' = ',')
PREHOOK: type: ALTERTABLE_SERDEPROPERTIES
@@ -23,8 +25,10 @@ POSTHOOK: Input: default@t1
POSTHOOK: Output: default@t1
PREHOOK: query: create table t1(i int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table t1(i int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: create view vt1 as select * from t1
PREHOOK: type: CREATEVIEW
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_revoke_table_priv.q.out Thu Feb 20 15:44:37 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- current user has been
CREATE TABLE table_priv_rev(i int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- current user has been set (comment line before the set cmd is resulting in parse error!!)
CREATE TABLE table_priv_rev(i int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_priv_rev
PREHOOK: query: -- grant insert privilege to user2
GRANT INSERT ON table_priv_rev TO USER user2
Modified: hive/trunk/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/authorization_view_sqlstd.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table t1(i int, j int, k int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table t1(i int, j int, k int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: -- protecting certain columns
create view vt1 as select i,k from t1
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join1.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join1.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j1
PREHOOK: query: explain
FROM src src1 JOIN src src2 ON (src1.key = src2.key)
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join14_hadoop20.q.out Thu Feb 20 15:44:37 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- INCLUDE_HADOOP_MAJOR_
CREATE TABLE dest1(c1 INT, c2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- INCLUDE_HADOOP_MAJOR_VERSIONS(0.20, 0.20S)
CREATE TABLE dest1(c1 INT, c2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM src JOIN srcpart ON src.key = srcpart.key AND srcpart.ds = '2008-04-08' and src.key > 100
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join17.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join17.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join17.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join17.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(key1 INT, value1 STRING, key2 INT, value2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key1 INT, value1 STRING, key2 INT, value2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM src src1 JOIN src src2 ON (src1.key = src2.key)
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join19.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join19.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join19.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join19.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join2.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join2.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j2
PREHOOK: query: explain
FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key + src2.key = src3.key)
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join24.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join24.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join24.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join24.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table tst1(key STRING, cnt INT)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tst1(key STRING, cnt INT)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tst1
PREHOOK: query: INSERT OVERWRITE TABLE tst1
SELECT a.key, count(1) FROM src a group by a.key
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join25.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join25.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join25.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join25.q.out Thu Feb 20 15:44:37 2014
@@ -1,9 +1,11 @@
PREHOOK: query: -- This test tests the scenario when the mapper dies. So, create a conditional task for the mapjoin
CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This test tests the scenario when the mapper dies. So, create a conditional task for the mapjoin
CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest1 SELECT src1.key, src2.value
@@ -54,8 +56,10 @@ POSTHOOK: Lineage: dest1.value SIMPLE [(
407444119660
PREHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j2
POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
@@ -112,8 +116,10 @@ POSTHOOK: Lineage: dest_j2.value SIMPLE
33815990627
PREHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j1
POSTHOOK: Lineage: dest1.key EXPRESSION [(srcpart)src1.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(src)src2.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join26.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join26.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join26.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join26.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest_j1(key INT, cnt INT)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest_j1(key INT, cnt INT)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest_j1
PREHOOK: query: EXPLAIN
INSERT OVERWRITE TABLE dest_j1
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join3.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join3.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM src src1 JOIN src src2 ON (src1.key = src2.key) JOIN src src3 ON (src1.key = src3.key)
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join32.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join32.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join32.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join32.q.out Thu Feb 20 15:44:37 2014
@@ -1,14 +1,18 @@
PREHOOK: query: -- empty tables
create table studenttab10k (name string, age int, gpa double)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- empty tables
create table studenttab10k (name string, age int, gpa double)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@studenttab10k
PREHOOK: query: create table votertab10k (name string, age int, registration string, contributions float)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table votertab10k (name string, age int, registration string, contributions float)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@votertab10k
PREHOOK: query: explain select s.name, count(distinct registration)
from studenttab10k s join votertab10k v
@@ -111,14 +115,18 @@ POSTHOOK: Input: default@votertab10k
PREHOOK: query: -- smb
create table studenttab10k_smb (name string, age int, gpa double) clustered by (name) sorted by (name) into 2 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- smb
create table studenttab10k_smb (name string, age int, gpa double) clustered by (name) sorted by (name) into 2 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@studenttab10k_smb
PREHOOK: query: create table votertab10k_smb (name string, age int, registration string, contributions float) clustered by (name) sorted by (name) into 2 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table votertab10k_smb (name string, age int, registration string, contributions float) clustered by (name) sorted by (name) into 2 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@votertab10k_smb
PREHOOK: query: explain select s.name, count(distinct registration)
from studenttab10k_smb s join votertab10k_smb v
@@ -202,27 +210,35 @@ POSTHOOK: Input: default@votertab10k_smb
#### A masked pattern was here ####
PREHOOK: query: load data local inpath '../../data/files/empty1.txt' into table studenttab10k_smb
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@studenttab10k_smb
POSTHOOK: query: load data local inpath '../../data/files/empty1.txt' into table studenttab10k_smb
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@studenttab10k_smb
PREHOOK: query: load data local inpath '../../data/files/empty2.txt' into table studenttab10k_smb
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@studenttab10k_smb
POSTHOOK: query: load data local inpath '../../data/files/empty2.txt' into table studenttab10k_smb
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@studenttab10k_smb
PREHOOK: query: load data local inpath '../../data/files/empty1.txt' into table votertab10k_smb
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@votertab10k_smb
POSTHOOK: query: load data local inpath '../../data/files/empty1.txt' into table votertab10k_smb
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@votertab10k_smb
PREHOOK: query: load data local inpath '../../data/files/empty2.txt' into table votertab10k_smb
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@votertab10k_smb
POSTHOOK: query: load data local inpath '../../data/files/empty2.txt' into table votertab10k_smb
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@votertab10k_smb
PREHOOK: query: explain select s.name, count(distinct registration)
from studenttab10k_smb s join votertab10k_smb v
@@ -307,40 +323,52 @@ POSTHOOK: Input: default@votertab10k_smb
PREHOOK: query: -- smb + partitions
create table studenttab10k_part (name string, age int, gpa double) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- smb + partitions
create table studenttab10k_part (name string, age int, gpa double) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@studenttab10k_part
PREHOOK: query: create table votertab10k_part (name string, age int, registration string, contributions float) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table votertab10k_part (name string, age int, registration string, contributions float) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@votertab10k_part
PREHOOK: query: load data local inpath '../../data/files/empty1.txt' into table studenttab10k_part partition (p='foo')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@studenttab10k_part
POSTHOOK: query: load data local inpath '../../data/files/empty1.txt' into table studenttab10k_part partition (p='foo')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@studenttab10k_part
POSTHOOK: Output: default@studenttab10k_part@p=foo
PREHOOK: query: load data local inpath '../../data/files/empty2.txt' into table studenttab10k_part partition (p='foo')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@studenttab10k_part@p=foo
POSTHOOK: query: load data local inpath '../../data/files/empty2.txt' into table studenttab10k_part partition (p='foo')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@studenttab10k_part@p=foo
PREHOOK: query: load data local inpath '../../data/files/empty1.txt' into table votertab10k_part partition (p='foo')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@votertab10k_part
POSTHOOK: query: load data local inpath '../../data/files/empty1.txt' into table votertab10k_part partition (p='foo')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@votertab10k_part
POSTHOOK: Output: default@votertab10k_part@p=foo
PREHOOK: query: load data local inpath '../../data/files/empty2.txt' into table votertab10k_part partition (p='foo')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@votertab10k_part@p=foo
POSTHOOK: query: load data local inpath '../../data/files/empty2.txt' into table votertab10k_part partition (p='foo')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@votertab10k_part@p=foo
PREHOOK: query: explain select s.name, count(distinct registration)
from studenttab10k_part s join votertab10k_part v
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join4.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join5.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join6.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join7.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING, c5 INT, c6 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING, c5 INT, c6 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join8.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM (
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join9.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join9.q.out Thu Feb 20 15:44:37 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: explain
FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join_filters.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join_filters.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join_filters.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join_filters.q.out Thu Feb 20 15:44:37 2014
@@ -1,13 +1,17 @@
PREHOOK: query: CREATE TABLE myinput1(key int, value int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE myinput1(key int, value int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@myinput1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in3.txt' INTO TABLE myinput1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@myinput1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in3.txt' INTO TABLE myinput1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@myinput1
PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value
PREHOOK: type: QUERY
@@ -245,37 +249,49 @@ POSTHOOK: Input: default@myinput1
3078400
PREHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@smb_input1
PREHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@smb_input2
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@smb_input1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@smb_input1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input2
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@smb_input2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' into table smb_input2
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input2
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input2
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@smb_input2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in2.txt' into table smb_input2
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@smb_input2
PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b on a.key > 40 AND a.value > 50 AND a.key = a.value AND b.key > 40 AND b.value > 50 AND b.key = b.value
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join_nulls.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join_nulls.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join_nulls.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join_nulls.q.out Thu Feb 20 15:44:37 2014
@@ -1,13 +1,17 @@
PREHOOK: query: CREATE TABLE myinput1(key int, value int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE myinput1(key int, value int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@myinput1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' INTO TABLE myinput1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@myinput1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/in1.txt' INTO TABLE myinput1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@myinput1
PREHOOK: query: SELECT sum(hash(a.key,a.value,b.key,b.value)) FROM myinput1 a JOIN myinput1 b
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out Thu Feb 20 15:44:37 2014
@@ -2,16 +2,20 @@ PREHOOK: query: -- HIVE-5056 RS has expr
create table testsrc ( `key` int,`val` string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- HIVE-5056 RS has expression list for values, but it's ignored in MapJoinProcessor
create table testsrc ( `key` int,`val` string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@testsrc
PREHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table testsrc
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@testsrc
POSTHOOK: query: load data local inpath '../../data/files/kv1.txt' overwrite into table testsrc
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@testsrc
PREHOOK: query: drop table if exists orderpayment_small
PREHOOK: type: DROPTABLE
@@ -19,8 +23,10 @@ POSTHOOK: query: drop table if exists or
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table orderpayment_small (`dealid` int,`date` string,`time` string, `cityid` int, `userid` int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table orderpayment_small (`dealid` int,`date` string,`time` string, `cityid` int, `userid` int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@orderpayment_small
PREHOOK: query: insert overwrite table orderpayment_small select 748, '2011-03-24', '2011-03-24', 55 ,5372613 from testsrc tablesample (1 rows)
PREHOOK: type: QUERY
@@ -46,8 +52,10 @@ POSTHOOK: Lineage: orderpayment_small.ti
POSTHOOK: Lineage: orderpayment_small.userid SIMPLE []
PREHOOK: query: create table user_small( userid int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table user_small( userid int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@user_small
POSTHOOK: Lineage: orderpayment_small.cityid SIMPLE []
POSTHOOK: Lineage: orderpayment_small.date SIMPLE []
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out Thu Feb 20 15:44:37 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl1
PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl2
PREHOOK: query: insert overwrite table tbl1
select * from src where key < 10
@@ -1420,8 +1424,10 @@ POSTHOOK: Lineage: tbl2.value SIMPLE [(s
20
PREHOOK: query: CREATE TABLE dest1(key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: tbl1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tbl1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -1429,8 +1435,10 @@ POSTHOOK: Lineage: tbl2.key EXPRESSION [
POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: CREATE TABLE dest2(key int, val1 string, val2 string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest2(key int, val1 string, val2 string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest2
POSTHOOK: Lineage: tbl1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tbl1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -1746,8 +1754,10 @@ POSTHOOK: Lineage: tbl2.key EXPRESSION [
POSTHOOK: Lineage: tbl2.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: CREATE TABLE dest2(key int, cnt int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest2(key int, cnt int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest2
POSTHOOK: Lineage: dest1.key SIMPLE [(tbl1)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: dest1.value SIMPLE [(tbl1)a.FieldSchema(name:value, type:string, comment:null), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out Thu Feb 20 15:44:37 2014
@@ -3,79 +3,103 @@ PREHOOK: query: -- small 1 part, 2 bucke
CREATE TABLE bucket_small (key string, value string) partitioned by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- small 1 part, 2 bucket & big 2 part, 4 bucket
CREATE TABLE bucket_small (key string, value string) partitioned by (ds string)
CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucket_small
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_small
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket1outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_small
POSTHOOK: Output: default@bucket_small@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_small@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/smallsrcsortbucket2outof4.txt' INTO TABLE bucket_small partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_small@ds=2008-04-08
PREHOOK: query: CREATE TABLE bucket_big (key string, value string) partitioned by (ds string) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE bucket_big (key string, value string) partitioned by (ds string) CLUSTERED BY (key) SORTED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bucket_big
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-08
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-08')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-08
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket1outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket2outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket3outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@bucket_big@ds=2008-04-09
POSTHOOK: query: load data local inpath '../../data/files/srcsortbucket4outof4.txt' INTO TABLE bucket_big partition(ds='2008-04-09')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@bucket_big@ds=2008-04-09
PREHOOK: query: -- Since size is being used to find the big table, the order of the tables in the join does not matter
explain extended select count(*) FROM bucket_small a JOIN bucket_big b ON a.key = b.key