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/08/27 19:36:26 UTC
svn commit: r1620949 [3/4] - in /hive/trunk:
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/negative/
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/security/authorization/plug...
Modified: hive/trunk/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/describe_formatted_view_partitioned.q.out Wed Aug 27 17:36:23 2014
@@ -10,6 +10,8 @@ FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view_partitioned
POSTHOOK: query: CREATE VIEW view_partitioned
PARTITIONED ON (value)
AS
@@ -18,6 +20,7 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view_partitioned
PREHOOK: query: ALTER VIEW view_partitioned
ADD PARTITION (value='val_86')
Modified: hive/trunk/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/describe_formatted_view_partitioned_json.q.out Wed Aug 27 17:36:23 2014
@@ -10,6 +10,8 @@ FROM src
WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@view_partitioned
POSTHOOK: query: CREATE VIEW view_partitioned
PARTITIONED ON (value)
AS
@@ -18,6 +20,7 @@ FROM src
WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@view_partitioned
PREHOOK: query: ALTER VIEW view_partitioned
ADD PARTITION (value='val_86')
Modified: hive/trunk/ql/src/test/results/clientpositive/describe_syntax.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/describe_syntax.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/describe_syntax.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/describe_syntax.q.out Wed Aug 27 17:36:23 2014
@@ -7,11 +7,10 @@ POSTHOOK: Output: database:db1
PREHOOK: query: CREATE TABLE db1.t1(key1 INT, value1 STRING) PARTITIONED BY (ds STRING, part STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:db1
-PREHOOK: Output: db1@db1.t1
+PREHOOK: Output: db1@t1
POSTHOOK: query: CREATE TABLE db1.t1(key1 INT, value1 STRING) PARTITIONED BY (ds STRING, part STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db1
-POSTHOOK: Output: db1@db1.t1
POSTHOOK: Output: db1@t1
PREHOOK: query: use db1
PREHOOK: type: SWITCHDATABASE
Modified: hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/drop_multi_partitions.q.out Wed Aug 27 17:36:23 2014
@@ -7,11 +7,10 @@ POSTHOOK: Output: database:dmp
PREHOOK: query: create table dmp.mp (a string) partitioned by (b string, c string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:dmp
-PREHOOK: Output: dmp@dmp.mp
+PREHOOK: Output: dmp@mp
POSTHOOK: query: create table dmp.mp (a string) partitioned by (b string, c string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:dmp
-POSTHOOK: Output: dmp@dmp.mp
POSTHOOK: Output: dmp@mp
PREHOOK: query: alter table dmp.mp add partition (b='1', c='1')
PREHOOK: type: ALTERTABLE_ADDPARTS
Modified: hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out Wed Aug 27 17:36:23 2014
@@ -13,20 +13,18 @@ POSTHOOK: Output: database:ex2
PREHOOK: query: CREATE TABLE ex1.exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:ex1
-PREHOOK: Output: ex1@ex1.exchange_part_test1
+PREHOOK: Output: ex1@exchange_part_test1
POSTHOOK: query: CREATE TABLE ex1.exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:ex1
-POSTHOOK: Output: ex1@ex1.exchange_part_test1
POSTHOOK: Output: ex1@exchange_part_test1
PREHOOK: query: CREATE TABLE ex2.exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:ex2
-PREHOOK: Output: ex2@ex2.exchange_part_test2
+PREHOOK: Output: ex2@exchange_part_test2
POSTHOOK: query: CREATE TABLE ex2.exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:ex2
-POSTHOOK: Output: ex2@ex2.exchange_part_test2
POSTHOOK: Output: ex2@exchange_part_test2
PREHOOK: query: SHOW PARTITIONS ex1.exchange_part_test1
PREHOOK: type: SHOWPARTITIONS
Modified: hive/trunk/ql/src/test/results/clientpositive/explain_dependency.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/explain_dependency.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/explain_dependency.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/explain_dependency.q.out Wed Aug 27 17:36:23 2014
@@ -4,19 +4,25 @@ PREHOOK: query: -- This test is used for
CREATE VIEW V1 AS SELECT key, value from src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V1
POSTHOOK: query: -- This test is used for testing EXPLAIN DEPENDENCY command
-- Create some views
CREATE VIEW V1 AS SELECT key, value from src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V1
PREHOOK: query: CREATE VIEW V2 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V2
POSTHOOK: query: CREATE VIEW V2 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V2
PREHOOK: query: CREATE VIEW V3 AS
SELECT src1.key, src2.value FROM V2 src1
@@ -25,6 +31,8 @@ PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@v2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V3
POSTHOOK: query: CREATE VIEW V3 AS
SELECT src1.key, src2.value FROM V2 src1
JOIN src src2 ON src1.key = src2.key WHERE src1.ds IS NOT NULL
@@ -32,6 +40,7 @@ POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@v2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V3
PREHOOK: query: CREATE VIEW V4 AS
SELECT src1.key, src2.value as value1, src3.value as value2
@@ -41,6 +50,8 @@ PREHOOK: Input: default@src
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@v1
PREHOOK: Input: default@v2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V4
POSTHOOK: query: CREATE VIEW V4 AS
SELECT src1.key, src2.value as value1, src3.value as value2
FROM V1 src1 JOIN V2 src2 on src1.key = src2.key JOIN src src3 ON src2.key = src3.key
@@ -49,6 +60,7 @@ POSTHOOK: Input: default@src
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@v1
POSTHOOK: Input: default@v2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V4
PREHOOK: query: -- Simple select queries, union queries and join queries
EXPLAIN DEPENDENCY
@@ -111,11 +123,14 @@ PREHOOK: query: -- The table should show
CREATE VIEW V5 as SELECT * FROM srcpart where ds = '10'
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V5
POSTHOOK: query: -- The table should show up in the explain dependency even if none
-- of the partitions are selected.
CREATE VIEW V5 as SELECT * FROM srcpart where ds = '10'
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V5
PREHOOK: query: EXPLAIN DEPENDENCY SELECT * FROM V5
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/explain_logical.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/explain_logical.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/explain_logical.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/explain_logical.q.out Wed Aug 27 17:36:23 2014
@@ -4,19 +4,25 @@ PREHOOK: query: -- This test is used for
CREATE VIEW V1 AS SELECT key, value from src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V1
POSTHOOK: query: -- This test is used for testing EXPLAIN LOGICAL command
-- Create some views
CREATE VIEW V1 AS SELECT key, value from src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V1
PREHOOK: query: CREATE VIEW V2 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V2
POSTHOOK: query: CREATE VIEW V2 AS SELECT ds, key, value FROM srcpart WHERE ds IS NOT NULL
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V2
PREHOOK: query: CREATE VIEW V3 AS
SELECT src1.key, src2.value FROM V2 src1
@@ -25,6 +31,8 @@ PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@v2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V3
POSTHOOK: query: CREATE VIEW V3 AS
SELECT src1.key, src2.value FROM V2 src1
JOIN src src2 ON src1.key = src2.key WHERE src1.ds IS NOT NULL
@@ -32,6 +40,7 @@ POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@v2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V3
PREHOOK: query: CREATE VIEW V4 AS
SELECT src1.key, src2.value as value1, src3.value as value2
@@ -41,6 +50,8 @@ PREHOOK: Input: default@src
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@v1
PREHOOK: Input: default@v2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V4
POSTHOOK: query: CREATE VIEW V4 AS
SELECT src1.key, src2.value as value1, src3.value as value2
FROM V1 src1 JOIN V2 src2 on src1.key = src2.key JOIN src src3 ON src2.key = src3.key
@@ -49,6 +60,7 @@ POSTHOOK: Input: default@src
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@v1
POSTHOOK: Input: default@v2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V4
PREHOOK: query: -- Simple select queries, union queries and join queries
EXPLAIN LOGICAL
@@ -678,11 +690,14 @@ PREHOOK: query: -- The table should show
CREATE VIEW V5 as SELECT * FROM srcpart where ds = '10'
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@srcpart
+PREHOOK: Output: database:default
+PREHOOK: Output: default@V5
POSTHOOK: query: -- The table should show up in the explain logical even if none
-- of the partitions are selected.
CREATE VIEW V5 as SELECT * FROM srcpart where ds = '10'
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@srcpart
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@V5
PREHOOK: query: EXPLAIN LOGICAL SELECT * FROM V5
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/fileformat_sequencefile.q.out Wed Aug 27 17:36:23 2014
@@ -18,7 +18,7 @@ STAGE PLANS:
columns: key int, value string
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.mapred.SequenceFileOutputFormat
- name: dest1
+ name: default.dest1
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.SequenceFileInputFormat'
Modified: hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/fileformat_text.q.out Wed Aug 27 17:36:23 2014
@@ -18,7 +18,7 @@ STAGE PLANS:
columns: key int, value string
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- name: dest1
+ name: default.dest1
PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS
INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat'
Modified: hive/trunk/ql/src/test/results/clientpositive/global_limit.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/global_limit.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/global_limit.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/global_limit.q.out Wed Aug 27 17:36:23 2014
@@ -50,10 +50,13 @@ PREHOOK: query: -- need one file
create table gl_tgt as select key from gl_src1 limit 1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@gl_src1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@gl_tgt
POSTHOOK: query: -- need one file
create table gl_tgt as select key from gl_src1 limit 1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@gl_src1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@gl_tgt
PREHOOK: query: select * from gl_tgt ORDER BY key ASC
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/groupby_duplicate_key.q.out Wed Aug 27 17:36:23 2014
@@ -140,7 +140,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dummy
+ name: default.dummy
Stage: Stage-2
Stats-Aggr Operator
@@ -149,10 +149,13 @@ PREHOOK: query: create table dummy as
select distinct key, "X" as dummy1, "X" as dummy2 from src tablesample (10 rows)
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dummy
POSTHOOK: query: create table dummy as
select distinct key, "X" as dummy1, "X" as dummy2 from src tablesample (10 rows)
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dummy
PREHOOK: query: select key,dummy1,dummy2 from dummy
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/index_auto_empty.q.out Wed Aug 27 17:36:23 2014
@@ -12,12 +12,11 @@ PREHOOK: query: -- Create temp, and popu
CREATE TABLE it.temp(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:it
-PREHOOK: Output: it@it.temp
+PREHOOK: Output: it@temp
POSTHOOK: query: -- Create temp, and populate it with some values in src.
CREATE TABLE it.temp(key STRING, val STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:it
-POSTHOOK: Output: it@it.temp
POSTHOOK: Output: it@temp
PREHOOK: query: -- Build an index on it.temp.
CREATE INDEX temp_index ON TABLE it.temp(key) as 'COMPACT' WITH DEFERRED REBUILD
Modified: hive/trunk/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input15.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input15.q.out Wed Aug 27 17:36:23 2014
@@ -16,7 +16,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: TEST15
+ name: default.TEST15
PREHOOK: query: CREATE TABLE TEST15(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/input46.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/input46.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/input46.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/input46.q.out Wed Aug 27 17:36:23 2014
@@ -7,34 +7,38 @@ POSTHOOK: Output: database:table_in_data
PREHOOK: query: create table table_in_database_creation.test1 as select * from src limit 1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:table_in_database_creation
+PREHOOK: Output: table_in_database_creation@test1
POSTHOOK: query: create table table_in_database_creation.test1 as select * from src limit 1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:table_in_database_creation
POSTHOOK: Output: table_in_database_creation@test1
-PREHOOK: query: create table `table_in_database_creation.test2` as select * from src limit 1
+PREHOOK: query: create table `table_in_database_creation`.`test2` as select * from src limit 1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
-POSTHOOK: query: create table `table_in_database_creation.test2` as select * from src limit 1
+PREHOOK: Output: database:table_in_database_creation
+PREHOOK: Output: table_in_database_creation@test2
+POSTHOOK: query: create table `table_in_database_creation`.`test2` as select * from src limit 1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:table_in_database_creation
POSTHOOK: Output: table_in_database_creation@test2
PREHOOK: query: create table table_in_database_creation.test3 (a string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:table_in_database_creation
-PREHOOK: Output: table_in_database_creation@table_in_database_creation.test3
+PREHOOK: Output: table_in_database_creation@test3
POSTHOOK: query: create table table_in_database_creation.test3 (a string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:table_in_database_creation
-POSTHOOK: Output: table_in_database_creation@table_in_database_creation.test3
POSTHOOK: Output: table_in_database_creation@test3
-PREHOOK: query: create table `table_in_database_creation.test4` (a string)
+PREHOOK: query: create table `table_in_database_creation`.`test4` (a string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:table_in_database_creation
-PREHOOK: Output: table_in_database_creation@table_in_database_creation.test4
-POSTHOOK: query: create table `table_in_database_creation.test4` (a string)
+PREHOOK: Output: table_in_database_creation@test4
+POSTHOOK: query: create table `table_in_database_creation`.`test4` (a string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:table_in_database_creation
-POSTHOOK: Output: table_in_database_creation@table_in_database_creation.test4
POSTHOOK: Output: table_in_database_creation@test4
PREHOOK: query: drop database table_in_database_creation cascade
PREHOOK: type: DROPDATABASE
Modified: hive/trunk/ql/src/test/results/clientpositive/inputddl1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/inputddl1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/inputddl1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/inputddl1.q.out Wed Aug 27 17:36:23 2014
@@ -15,7 +15,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: INPUTDDL1
+ name: default.INPUTDDL1
PREHOOK: query: CREATE TABLE INPUTDDL1(key INT, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/inputddl2.q.out Wed Aug 27 17:36:23 2014
@@ -16,7 +16,7 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
partition columns: ds string, country string
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: INPUTDDL2
+ name: default.INPUTDDL2
PREHOOK: query: CREATE TABLE INPUTDDL2(key INT, value STRING) PARTITIONED BY(ds STRING, country STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/inputddl3.q.out Wed Aug 27 17:36:23 2014
@@ -16,7 +16,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: INPUTDDL3
+ name: default.INPUTDDL3
PREHOOK: query: CREATE TABLE INPUTDDL3(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/insert1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert1.q.out Wed Aug 27 17:36:23 2014
@@ -217,12 +217,11 @@ POSTHOOK: Output: database:x
PREHOOK: query: create table x.insert1(key int, value string) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:x
-PREHOOK: Output: x@x.insert1
+PREHOOK: Output: x@insert1
POSTHOOK: query: create table x.insert1(key int, value string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:x
POSTHOOK: Output: x@insert1
-POSTHOOK: Output: x@x.insert1
PREHOOK: query: explain insert into table x.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1)
PREHOOK: type: QUERY
POSTHOOK: query: explain insert into table x.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1)
@@ -635,11 +634,10 @@ POSTHOOK: Output: database:db1
PREHOOK: query: CREATE TABLE db1.result(col1 STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:db1
-PREHOOK: Output: db1@db1.result
+PREHOOK: Output: db1@result
POSTHOOK: query: CREATE TABLE db1.result(col1 STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db1
-POSTHOOK: Output: db1@db1.result
POSTHOOK: Output: db1@result
PREHOOK: query: INSERT OVERWRITE TABLE db1.result SELECT 'db1_insert1' FROM src LIMIT 1
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert2_overwrite_partitions.q.out Wed Aug 27 17:36:23 2014
@@ -13,11 +13,10 @@ POSTHOOK: Output: database:db2
PREHOOK: query: CREATE TABLE db1.sourceTable (one string,two string) PARTITIONED BY (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:db1
-PREHOOK: Output: db1@db1.sourceTable
+PREHOOK: Output: db1@sourceTable
POSTHOOK: query: CREATE TABLE db1.sourceTable (one string,two string) PARTITIONED BY (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db1
-POSTHOOK: Output: db1@db1.sourceTable
POSTHOOK: Output: db1@sourceTable
PREHOOK: query: load data local inpath '../../data/files/kv1.txt' INTO TABLE db1.sourceTable partition(ds='2011-11-11')
PREHOOK: type: LOAD
@@ -39,11 +38,10 @@ POSTHOOK: Output: db1@sourcetable@ds=201
PREHOOK: query: CREATE TABLE db2.destinTable (one string,two string) PARTITIONED BY (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:db2
-PREHOOK: Output: db2@db2.destinTable
+PREHOOK: Output: db2@destinTable
POSTHOOK: query: CREATE TABLE db2.destinTable (one string,two string) PARTITIONED BY (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:db2
-POSTHOOK: Output: db2@db2.destinTable
POSTHOOK: Output: db2@destinTable
PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE db2.destinTable PARTITION (ds='2011-11-11')
SELECT one,two FROM db1.sourceTable WHERE ds='2011-11-11' order by one desc, two desc limit 5
Modified: hive/trunk/ql/src/test/results/clientpositive/join41.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join41.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join41.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join41.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: create table s1 as select * from src where key = 0
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@s1
POSTHOOK: query: create table s1 as select * from src where key = 0
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@s1
PREHOOK: query: EXPLAIN
SELECT * FROM s1 src1 LEFT OUTER JOIN s1 src2 ON (src1.key = src2.key AND src2.key > 10)
Modified: hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/join_filters_overlap.q.out Wed Aug 27 17:36:23 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/join_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_view.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_view.q.out Wed Aug 27 17:36:23 2014
@@ -28,12 +28,15 @@ create view v as select invites.bar, inv
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@invites
PREHOOK: Input: default@invites2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v
POSTHOOK: query: -- test join views: see HIVE-1989
create view v as select invites.bar, invites2.foo, invites2.ds from invites join invites2 on invites.ds=invites2.ds
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@invites
POSTHOOK: Input: default@invites2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@v
PREHOOK: query: explain select * from v where ds='2011-09-01'
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view_noalias.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view_noalias.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lateral_view_noalias.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lateral_view_noalias.q.out Wed Aug 27 17:36:23 2014
@@ -130,10 +130,13 @@ PREHOOK: query: -- view
create view lv_noalias as SELECT myTab.* from src LATERAL VIEW explode(map('key1', 100, 'key2', 200)) myTab limit 2
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@lv_noalias
POSTHOOK: query: -- view
create view lv_noalias as SELECT myTab.* from src LATERAL VIEW explode(map('key1', 100, 'key2', 200)) myTab limit 2
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@lv_noalias
PREHOOK: query: explain select * from lv_noalias a join lv_noalias b on a.key=b.key
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/lateral_view_outer.q.out Wed Aug 27 17:36:23 2014
@@ -185,9 +185,12 @@ POSTHOOK: Input: default@src
PREHOOK: query: create table array_valued as select key, if (key > 300, array(value, value), null) as value from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@array_valued
POSTHOOK: query: create table array_valued as select key, if (key > 300, array(value, value), null) as value from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@array_valued
PREHOOK: query: explain
select * from array_valued LATERAL VIEW OUTER explode(value) C AS a limit 10
Modified: hive/trunk/ql/src/test/results/clientpositive/merge3.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/merge3.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/merge3.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/merge3.q.out Wed Aug 27 17:36:23 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_insert_lateral_view.q.out Wed Aug 27 17:36:23 2014
@@ -3,11 +3,14 @@ PREHOOK: query: -- SORT_QUERY_RESULTS
create table src_10 as select * from src limit 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src_10
POSTHOOK: query: -- SORT_QUERY_RESULTS
create table src_10 as select * from src limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_10
PREHOOK: query: create table src_lv1 (key string, value string)
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/multi_join_union.q.out Wed Aug 27 17:36:23 2014
@@ -1,30 +1,42 @@
PREHOOK: query: CREATE TABLE src11 as SELECT * FROM src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src11
POSTHOOK: query: CREATE TABLE src11 as SELECT * FROM src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src11
PREHOOK: query: CREATE TABLE src12 as SELECT * FROM src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src12
POSTHOOK: query: CREATE TABLE src12 as SELECT * FROM src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src12
PREHOOK: query: CREATE TABLE src13 as SELECT * FROM src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src13
POSTHOOK: query: CREATE TABLE src13 as SELECT * FROM src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src13
PREHOOK: query: CREATE TABLE src14 as SELECT * FROM src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@src14
POSTHOOK: query: CREATE TABLE src14 as SELECT * FROM src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src14
PREHOOK: query: EXPLAIN SELECT * FROM
src11 a JOIN
Modified: hive/trunk/ql/src/test/results/clientpositive/nestedvirtual.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nestedvirtual.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nestedvirtual.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nestedvirtual.q.out Wed Aug 27 17:36:23 2014
@@ -18,10 +18,13 @@ PREHOOK: query: create table jssarma_nil
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@pokes
PREHOOK: Input: default@pokes2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@jssarma_nilzma_bad
POSTHOOK: query: create table jssarma_nilzma_bad as select a.val, a.filename, a.offset from (select hash(foo) as val, INPUT__FILE__NAME as filename, BLOCK__OFFSET__INSIDE__FILE as offset from pokes) a join pokes2 b on (a.val = b.foo)
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@pokes
POSTHOOK: Input: default@pokes2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@jssarma_nilzma_bad
PREHOOK: query: drop table jssarma_nilzma_bad
PREHOOK: type: DROPTABLE
@@ -67,10 +70,13 @@ PREHOOK: query: create table jssarma_nil
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@pokes
PREHOOK: Input: default@pokes2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@jssarma_nilzma_bad
POSTHOOK: query: create table jssarma_nilzma_bad as select a.val, a.filename, a.offset from (select hash(foo) as val, INPUT__FILE__NAME as filename, BLOCK__OFFSET__INSIDE__FILE as offset from pokes) a join pokes2 b on (a.val = b.foo)
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@pokes
POSTHOOK: Input: default@pokes2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@jssarma_nilzma_bad
PREHOOK: query: drop table jssarma_nilzma_bad
PREHOOK: type: DROPTABLE
@@ -116,10 +122,13 @@ PREHOOK: query: create table jssarma_nil
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@pokes
PREHOOK: Input: default@pokes2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@jssarma_nilzma_bad
POSTHOOK: query: create table jssarma_nilzma_bad as select a.val, a.filename, a.offset from (select hash(foo) as val, INPUT__FILE__NAME as filename, BLOCK__OFFSET__INSIDE__FILE as offset from pokes) a join pokes2 b on (a.val = b.foo)
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@pokes
POSTHOOK: Input: default@pokes2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@jssarma_nilzma_bad
PREHOOK: query: drop table jssarma_nilzma_bad
PREHOOK: type: DROPTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nonmr_fetch.q.out Wed Aug 27 17:36:23 2014
@@ -1015,7 +1015,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: srcx
+ name: default.srcx
Stage: Stage-2
Stats-Aggr Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/nullformat.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullformat.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullformat.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullformat.q.out Wed Aug 27 17:36:23 2014
@@ -53,7 +53,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: null_tab1
+ name: default.null_tab1
PREHOOK: query: CREATE TABLE null_tab1(a STRING, b STRING) ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull'
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/nullformatCTAS.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/nullformatCTAS.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/nullformatCTAS.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/nullformatCTAS.q.out Wed Aug 27 17:36:23 2014
@@ -97,7 +97,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: null_tab3
+ name: default.null_tab3
Stage: Stage-2
Stats-Aggr Operator
@@ -136,10 +136,13 @@ PREHOOK: query: CREATE TABLE null_tab3 R
AS SELECT a, b FROM base_tab
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@base_tab
+PREHOOK: Output: database:default
+PREHOOK: Output: default@null_tab3
POSTHOOK: query: CREATE TABLE null_tab3 ROW FORMAT DELIMITED NULL DEFINED AS 'fooNull'
AS SELECT a, b FROM base_tab
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@base_tab
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@null_tab3
PREHOOK: query: DESCRIBE EXTENDED null_tab3
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/orc_createas1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/orc_createas1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/orc_createas1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/orc_createas1.q.out Wed Aug 27 17:36:23 2014
@@ -105,7 +105,7 @@ STAGE PLANS:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
serde name: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: orc_createas1b
+ name: default.orc_createas1b
Stage: Stage-2
Stats-Aggr Operator
@@ -131,11 +131,14 @@ PREHOOK: query: CREATE TABLE orc_createa
SELECT * FROM src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_createas1b
POSTHOOK: query: CREATE TABLE orc_createas1b
STORED AS ORC AS
SELECT * FROM src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_createas1b
PREHOOK: query: EXPLAIN SELECT * FROM orc_createas1b ORDER BY key LIMIT 5
PREHOOK: type: QUERY
@@ -261,7 +264,7 @@ STAGE PLANS:
input format: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat
output format: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat
serde name: org.apache.hadoop.hive.ql.io.orc.OrcSerde
- name: orc_createas1c
+ name: default.orc_createas1c
Stage: Stage-2
Stats-Aggr Operator
@@ -290,6 +293,8 @@ PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@orc_createas1a
PREHOOK: Input: default@orc_createas1a@ds=1
PREHOOK: Input: default@orc_createas1a@ds=2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@orc_createas1c
POSTHOOK: query: CREATE TABLE orc_createas1c
STORED AS ORC AS
SELECT key, value, PMOD(HASH(key), 50) as part
@@ -298,6 +303,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@orc_createas1a
POSTHOOK: Input: default@orc_createas1a@ds=1
POSTHOOK: Input: default@orc_createas1a@ds=2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@orc_createas1c
PREHOOK: query: SELECT SUM(HASH(c)) FROM (
SELECT TRANSFORM(key, value) USING 'tr \t _' AS (c)
Modified: hive/trunk/ql/src/test/results/clientpositive/parallel_orderby.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parallel_orderby.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/parallel_orderby.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/parallel_orderby.q.out Wed Aug 27 17:36:23 2014
@@ -76,7 +76,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: total_ordered
+ name: default.total_ordered
Stage: Stage-2
Stats-Aggr Operator
@@ -84,9 +84,12 @@ STAGE PLANS:
PREHOOK: query: create table total_ordered as select * from src5 order by key, value
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src5
+PREHOOK: Output: database:default
+PREHOOK: Output: default@total_ordered
POSTHOOK: query: create table total_ordered as select * from src5 order by key, value
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src5
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@total_ordered
PREHOOK: query: desc formatted total_ordered
PREHOOK: type: DESCTABLE
@@ -195,9 +198,12 @@ POSTHOOK: Output: default@total_ordered
PREHOOK: query: create table total_ordered as select * from src5 order by key, value
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src5
+PREHOOK: Output: database:default
+PREHOOK: Output: default@total_ordered
POSTHOOK: query: create table total_ordered as select * from src5 order by key, value
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src5
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@total_ordered
PREHOOK: query: desc formatted total_ordered
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/parquet_ctas.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parquet_ctas.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/parquet_ctas.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/parquet_ctas.q.out Wed Aug 27 17:36:23 2014
@@ -39,9 +39,12 @@ POSTHOOK: Lineage: staging.value SIMPLE
PREHOOK: query: create table parquet_ctas stored as parquet as select * from staging
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@staging
+PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_ctas
POSTHOOK: query: create table parquet_ctas stored as parquet as select * from staging
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@staging
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@parquet_ctas
PREHOOK: query: describe parquet_ctas
PREHOOK: type: DESCTABLE
@@ -72,9 +75,12 @@ POSTHOOK: Input: default@parquet_ctas
PREHOOK: query: create table parquet_ctas_advanced stored as parquet as select key+1,concat(value,"value") from staging
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@staging
+PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_ctas_advanced
POSTHOOK: query: create table parquet_ctas_advanced stored as parquet as select key+1,concat(value,"value") from staging
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@staging
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@parquet_ctas_advanced
PREHOOK: query: describe parquet_ctas_advanced
PREHOOK: type: DESCTABLE
@@ -105,9 +111,12 @@ POSTHOOK: Input: default@parquet_ctas_ad
PREHOOK: query: create table parquet_ctas_alias stored as parquet as select key+1 as mykey,concat(value,"value") as myvalue from staging
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@staging
+PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_ctas_alias
POSTHOOK: query: create table parquet_ctas_alias stored as parquet as select key+1 as mykey,concat(value,"value") as myvalue from staging
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@staging
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@parquet_ctas_alias
PREHOOK: query: describe parquet_ctas_alias
PREHOOK: type: DESCTABLE
@@ -138,9 +147,12 @@ POSTHOOK: Input: default@parquet_ctas_al
PREHOOK: query: create table parquet_ctas_mixed stored as parquet as select key,key+1,concat(value,"value") as myvalue from staging
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@staging
+PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_ctas_mixed
POSTHOOK: query: create table parquet_ctas_mixed stored as parquet as select key,key+1,concat(value,"value") as myvalue from staging
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@staging
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@parquet_ctas_mixed
PREHOOK: query: describe parquet_ctas_mixed
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/parquet_join.q.out Wed Aug 27 17:36:23 2014
@@ -39,16 +39,22 @@ POSTHOOK: Lineage: staging.value SIMPLE
PREHOOK: query: create table parquet_jointable1 stored as parquet as select * from staging
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@staging
+PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_jointable1
POSTHOOK: query: create table parquet_jointable1 stored as parquet as select * from staging
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@staging
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@parquet_jointable1
PREHOOK: query: create table parquet_jointable2 stored as parquet as select key,key+1,concat(value,"value") as myvalue from staging
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@staging
+PREHOOK: Output: database:default
+PREHOOK: Output: default@parquet_jointable2
POSTHOOK: query: create table parquet_jointable2 stored as parquet as select key,key+1,concat(value,"value") as myvalue from staging
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@staging
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@parquet_jointable2
PREHOOK: query: -- MR join
Modified: hive/trunk/ql/src/test/results/clientpositive/partition_decode_name.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_decode_name.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_decode_name.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_decode_name.q.out Wed Aug 27 17:36:23 2014
@@ -6,6 +6,8 @@ from (select '2011-01-11', '2011-01-11+1
select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@sc
POSTHOOK: query: create table sc as select *
from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows)
union all
@@ -14,6 +16,7 @@ from (select '2011-01-11', '2011-01-11+1
select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sc
PREHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/partition_special_char.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/partition_special_char.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/partition_special_char.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/partition_special_char.q.out Wed Aug 27 17:36:23 2014
@@ -6,6 +6,8 @@ from (select '2011-01-11', '2011-01-11+1
select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@sc
POSTHOOK: query: create table sc as select *
from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows)
union all
@@ -14,6 +16,7 @@ from (select '2011-01-11', '2011-01-11+1
select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sc
PREHOOK: query: create table sc_part (key string) partitioned by (ts string) stored as rcfile
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_field_garbage.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_field_garbage.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ppd_field_garbage.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ppd_field_garbage.q.out Wed Aug 27 17:36:23 2014
@@ -11,9 +11,12 @@ POSTHOOK: Output: default@test_issue
PREHOOK: query: CREATE VIEW v_test_issue AS SELECT fileid, i.user, test_c.user_c.age FROM test_issue LATERAL VIEW explode(infos) info AS i
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@test_issue
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v_test_issue
POSTHOOK: query: CREATE VIEW v_test_issue AS SELECT fileid, i.user, test_c.user_c.age FROM test_issue LATERAL VIEW explode(infos) info AS i
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@test_issue
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@v_test_issue
PREHOOK: query: -- dummy data
LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_issue
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
Files hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out Wed Aug 27 17:36:23 2014 differ
Modified: hive/trunk/ql/src/test/results/clientpositive/ptf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ptf.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/ptf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/ptf.q.out Wed Aug 27 17:36:23 2014
@@ -772,6 +772,8 @@ from part
group by p_mfgr, p_brand
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@part
+PREHOOK: Output: database:default
+PREHOOK: Output: default@mfgr_price_view
POSTHOOK: query: -- 16. testViewAsTableInputToPTF
create view IF NOT EXISTS mfgr_price_view as
select p_mfgr, p_brand,
@@ -780,6 +782,7 @@ from part
group by p_mfgr, p_brand
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@part
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@mfgr_price_view
PREHOOK: query: select p_mfgr, p_brand, s,
sum(s) over w1 as s1
Modified: hive/trunk/ql/src/test/results/clientpositive/query_result_fileformat.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/query_result_fileformat.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/query_result_fileformat.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/query_result_fileformat.q.out Wed Aug 27 17:36:23 2014
@@ -4,12 +4,15 @@ PREHOOK: query: create table nzhang_test
http://asdf' value from src limit 1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@nzhang_test1
POSTHOOK: query: create table nzhang_test1 stored as sequencefile as select 'key1' as key, 'value
1
http://asdf' value from src limit 1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@nzhang_test1
PREHOOK: query: select * from nzhang_test1
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/quotedid_basic.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/quotedid_basic.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/quotedid_basic.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/quotedid_basic.q.out Wed Aug 27 17:36:23 2014
@@ -359,12 +359,15 @@ select `x+1```, `y&y`
from t4 where `x+1``` < '200'
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@t4
+PREHOOK: Output: database:default
+PREHOOK: Output: default@v1
POSTHOOK: query: -- view
create view v1 as
select `x+1```, `y&y`
from t4 where `x+1``` < '200'
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@t4
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@v1
PREHOOK: query: select `x+1```, `y&y`, rank() over(partition by `x+1``` order by `y&y`)
from v1
Modified: hive/trunk/ql/src/test/results/clientpositive/rcfile_createas1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/rcfile_createas1.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/rcfile_createas1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/rcfile_createas1.q.out Wed Aug 27 17:36:23 2014
@@ -105,7 +105,7 @@ STAGE PLANS:
input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
serde name: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: rcfile_createas1b
+ name: default.rcfile_createas1b
Stage: Stage-2
Stats-Aggr Operator
@@ -134,6 +134,8 @@ PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@rcfile_createas1a
PREHOOK: Input: default@rcfile_createas1a@ds=1
PREHOOK: Input: default@rcfile_createas1a@ds=2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@rcfile_createas1b
POSTHOOK: query: CREATE TABLE rcfile_createas1b
STORED AS RCFILE AS
SELECT key, value, PMOD(HASH(key), 50) as part
@@ -142,6 +144,7 @@ POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@rcfile_createas1a
POSTHOOK: Input: default@rcfile_createas1a@ds=1
POSTHOOK: Input: default@rcfile_createas1a@ds=2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@rcfile_createas1b
PREHOOK: query: SELECT SUM(HASH(c)) FROM (
SELECT TRANSFORM(key, value) USING 'tr \t _' AS (c)
Modified: hive/trunk/ql/src/test/results/clientpositive/rcfile_default_format.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/rcfile_default_format.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/rcfile_default_format.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/rcfile_default_format.q.out Wed Aug 27 17:36:23 2014
@@ -39,9 +39,12 @@ Storage Desc Params:
PREHOOK: query: CREATE TABLE rcfile_default_format_ctas AS SELECT key,value FROM src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@rcfile_default_format_ctas
POSTHOOK: query: CREATE TABLE rcfile_default_format_ctas AS SELECT key,value FROM src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@rcfile_default_format_ctas
PREHOOK: query: DESCRIBE FORMATTED rcfile_default_format_ctas
PREHOOK: type: DESCTABLE
@@ -134,9 +137,12 @@ Storage Desc Params:
PREHOOK: query: CREATE TABLE textfile_default_format_ctas AS SELECT key,value FROM rcfile_default_format_ctas
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@rcfile_default_format_ctas
+PREHOOK: Output: database:default
+PREHOOK: Output: default@textfile_default_format_ctas
POSTHOOK: query: CREATE TABLE textfile_default_format_ctas AS SELECT key,value FROM rcfile_default_format_ctas
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@rcfile_default_format_ctas
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@textfile_default_format_ctas
PREHOOK: query: DESCRIBE FORMATTED textfile_default_format_ctas
PREHOOK: type: DESCTABLE
@@ -177,9 +183,12 @@ Storage Desc Params:
PREHOOK: query: CREATE TABLE rcfile_default_format_ctas_default_serde AS SELECT key,value FROM rcfile_default_format_ctas
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@rcfile_default_format_ctas
+PREHOOK: Output: database:default
+PREHOOK: Output: default@rcfile_default_format_ctas_default_serde
POSTHOOK: query: CREATE TABLE rcfile_default_format_ctas_default_serde AS SELECT key,value FROM rcfile_default_format_ctas
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@rcfile_default_format_ctas
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@rcfile_default_format_ctas_default_serde
PREHOOK: query: DESCRIBE FORMATTED rcfile_default_format_ctas_default_serde
PREHOOK: type: DESCTABLE
@@ -258,9 +267,12 @@ Storage Desc Params:
PREHOOK: query: CREATE TABLE rcfile_ctas_default_serde STORED AS rcfile AS SELECT key,value FROM rcfile_default_format_ctas
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@rcfile_default_format_ctas
+PREHOOK: Output: database:default
+PREHOOK: Output: default@rcfile_ctas_default_serde
POSTHOOK: query: CREATE TABLE rcfile_ctas_default_serde STORED AS rcfile AS SELECT key,value FROM rcfile_default_format_ctas
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@rcfile_default_format_ctas
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@rcfile_ctas_default_serde
PREHOOK: query: DESCRIBE FORMATTED rcfile_ctas_default_serde
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/sample_islocalmode_hook.q.out Wed Aug 27 17:36:23 2014
@@ -48,19 +48,25 @@ PREHOOK: Input: default@sih_i_part
PREHOOK: Input: default@sih_i_part@p=1
PREHOOK: Input: default@sih_i_part@p=2
PREHOOK: Input: default@sih_i_part@p=3
+PREHOOK: Output: database:default
+PREHOOK: Output: default@sih_src
POSTHOOK: query: create table sih_src as select key, value from sih_i_part order by key, value
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@sih_i_part
POSTHOOK: Input: default@sih_i_part@p=1
POSTHOOK: Input: default@sih_i_part@p=2
POSTHOOK: Input: default@sih_i_part@p=3
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sih_src
PREHOOK: query: create table sih_src2 as select key, value from sih_src order by key, value
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@sih_src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@sih_src2
POSTHOOK: query: create table sih_src2 as select key, value from sih_src order by key, value
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@sih_src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sih_src2
PREHOOK: query: -- Relaxing hive.exec.mode.local.auto.input.files.max=1.
-- Hadoop20 will not generate more splits than there are files (one).
Modified: hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/semijoin.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: create table t1 as select cast(key as int) key, value from src where key <= 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: create table t1 as select cast(key as int) key, value from src where key <= 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: select * from t1 sort by key
PREHOOK: type: QUERY
@@ -27,9 +30,12 @@ POSTHOOK: Input: default@t1
PREHOOK: query: create table t2 as select cast(2*key as int) key, value from t1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@t1
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
POSTHOOK: query: create table t2 as select cast(2*key as int) key, value from t1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@t1
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t2
PREHOOK: query: select * from t2 sort by key
PREHOOK: type: QUERY
@@ -54,10 +60,13 @@ PREHOOK: query: create table t3 as selec
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@t1
PREHOOK: Input: default@t2
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t3
POSTHOOK: query: create table t3 as select * from (select * from t1 union all select * from t2) b
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t3
PREHOOK: query: select * from t3 sort by key, value
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/serde_regex.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/serde_regex.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/serde_regex.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/serde_regex.q.out Wed Aug 27 17:36:23 2014
@@ -45,7 +45,7 @@ STAGE PLANS:
serde name: org.apache.hadoop.hive.serde2.RegexSerDe
serde properties:
input.regex ([^ ]*) ([^ ]*) ([^ ]*) (-|\[[^\]]*\]) ([^ "]*|"[^"]*") (-|[0-9]*) (-|[0-9]*)(?: ([^ "]*|"[^"]*") ([^ "]*|"[^"]*"))?
- name: serde_regex
+ name: default.serde_regex
PREHOOK: query: CREATE TABLE serde_regex(
host STRING,
@@ -160,7 +160,7 @@ STAGE PLANS:
serde name: org.apache.hadoop.hive.serde2.RegexSerDe
serde properties:
input.regex ([^ ]*) ([^ ]*)
- name: serde_regex1
+ name: default.serde_regex1
PREHOOK: query: CREATE TABLE serde_regex1(
key decimal(38,18),
Modified: hive/trunk/ql/src/test/results/clientpositive/show_create_table_db_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/show_create_table_db_table.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/show_create_table_db_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/show_create_table_db_table.q.out Wed Aug 27 17:36:23 2014
@@ -17,11 +17,10 @@ tmp_feng
PREHOOK: query: CREATE TABLE tmp_feng.tmp_showcrt (key string, value int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:tmp_feng
-PREHOOK: Output: tmp_feng@tmp_feng.tmp_showcrt
+PREHOOK: Output: tmp_feng@tmp_showcrt
POSTHOOK: query: CREATE TABLE tmp_feng.tmp_showcrt (key string, value int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:tmp_feng
-POSTHOOK: Output: tmp_feng@tmp_feng.tmp_showcrt
POSTHOOK: Output: tmp_feng@tmp_showcrt
PREHOOK: query: USE default
PREHOOK: type: SWITCHDATABASE
Modified: hive/trunk/ql/src/test/results/clientpositive/show_create_table_temp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/show_create_table_temp_table.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/show_create_table_temp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/show_create_table_temp_table.q.out Wed Aug 27 17:36:23 2014
@@ -7,12 +7,11 @@ POSTHOOK: Output: database:tmpdb
PREHOOK: query: create temporary table tmpdb.tmp1 (c1 string, c2 string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:tmpdb
-PREHOOK: Output: tmpdb@tmpdb.tmp1
+PREHOOK: Output: tmpdb@tmp1
POSTHOOK: query: create temporary table tmpdb.tmp1 (c1 string, c2 string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:tmpdb
POSTHOOK: Output: tmpdb@tmp1
-POSTHOOK: Output: tmpdb@tmpdb.tmp1
PREHOOK: query: show create table tmpdb.tmp1
PREHOOK: type: SHOW_CREATETABLE
PREHOOK: Input: tmpdb@tmp1
Modified: hive/trunk/ql/src/test/results/clientpositive/show_create_table_view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/show_create_table_view.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/show_create_table_view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/show_create_table_view.q.out Wed Aug 27 17:36:23 2014
@@ -3,11 +3,14 @@ PREHOOK: query: -- Test SHOW CREATE TABL
CREATE VIEW tmp_copy_src AS SELECT * FROM src
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_copy_src
POSTHOOK: query: -- Test SHOW CREATE TABLE on a view name.
CREATE VIEW tmp_copy_src AS SELECT * FROM src
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmp_copy_src
PREHOOK: query: SHOW CREATE TABLE tmp_copy_src
PREHOOK: type: SHOW_CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/skewjoin_noskew.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/skewjoin_noskew.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/skewjoin_noskew.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/skewjoin_noskew.q.out Wed Aug 27 17:36:23 2014
@@ -147,7 +147,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: noskew
+ name: default.noskew
Stage: Stage-3
Stats-Aggr Operator
@@ -155,9 +155,12 @@ STAGE PLANS:
PREHOOK: query: create table noskew as select a.* from src a join src b on a.key=b.key order by a.key limit 30
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@noskew
POSTHOOK: query: create table noskew as select a.* from src a join src b on a.key=b.key order by a.key limit 30
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@noskew
PREHOOK: query: select * from noskew
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin9.q.out Wed Aug 27 17:36:23 2014
@@ -352,7 +352,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: smb_mapjoin9_results
+ name: default.smb_mapjoin9_results
Stage: Stage-3
Stats-Aggr Operator
@@ -397,6 +397,8 @@ PREHOOK: Input: default@hive_test_smb_bu
PREHOOK: Input: default@hive_test_smb_bucket1@ds=2010-10-15
PREHOOK: Input: default@hive_test_smb_bucket2
PREHOOK: Input: default@hive_test_smb_bucket2@ds=2010-10-15
+PREHOOK: Output: database:default
+PREHOOK: Output: default@smb_mapjoin9_results
POSTHOOK: query: create table smb_mapjoin9_results as
SELECT /* + MAPJOIN(b) */ b.key as k1, b.value, b.ds, a.key as k2
FROM hive_test_smb_bucket1 a JOIN
@@ -407,6 +409,7 @@ POSTHOOK: Input: default@hive_test_smb_b
POSTHOOK: Input: default@hive_test_smb_bucket1@ds=2010-10-15
POSTHOOK: Input: default@hive_test_smb_bucket2
POSTHOOK: Input: default@hive_test_smb_bucket2@ds=2010-10-15
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@smb_mapjoin9_results
PREHOOK: query: drop table smb_mapjoin9_results
PREHOOK: type: DROPTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/stats5.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats5.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats5.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats5.q.out Wed Aug 27 17:36:23 2014
@@ -1,9 +1,12 @@
PREHOOK: query: create table analyze_src as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@analyze_src
POSTHOOK: query: create table analyze_src as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@analyze_src
PREHOOK: query: explain analyze table analyze_src compute statistics
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/stats_counter.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats_counter.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/stats_counter.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/stats_counter.q.out Wed Aug 27 17:36:23 2014
@@ -2,10 +2,13 @@ PREHOOK: query: -- by analyze
create table dummy1 as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dummy1
POSTHOOK: query: -- by analyze
create table dummy1 as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dummy1
PREHOOK: query: analyze table dummy1 compute statistics
PREHOOK: type: QUERY
@@ -55,10 +58,13 @@ PREHOOK: query: -- by autogather
create table dummy2 as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dummy2
POSTHOOK: query: -- by autogather
create table dummy2 as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dummy2
PREHOOK: query: desc formatted dummy2
PREHOOK: type: DESCTABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/str_to_map.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/str_to_map.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/str_to_map.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/str_to_map.q.out Wed Aug 27 17:36:23 2014
@@ -187,9 +187,12 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tbl_s2m as select 'ABC=CC_333=444' as t from src tablesample (3 rows)
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tbl_s2m
POSTHOOK: query: create table tbl_s2m as select 'ABC=CC_333=444' as t from src tablesample (3 rows)
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl_s2m
PREHOOK: query: select str_to_map(t,'_','=')['333'] from tbl_s2m
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out Wed Aug 27 17:36:23 2014
@@ -125,6 +125,8 @@ where exists
where b.value = a.value and a.key = b.key and a.value > 'val_9')
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@cv1
POSTHOOK: query: -- view test
create view cv1 as
select *
@@ -135,6 +137,7 @@ where exists
where b.value = a.value and a.key = b.key and a.value > 'val_9')
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@cv1
PREHOOK: query: select * from cv1
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out Wed Aug 27 17:36:23 2014
@@ -320,6 +320,8 @@ having exists
)
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@cv1
POSTHOOK: query: -- view test
create view cv1 as
select b.key, count(*) as c
@@ -332,6 +334,7 @@ having exists
)
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@cv1
PREHOOK: query: select * from cv1
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_notin.q.out Wed Aug 27 17:36:23 2014
@@ -1413,22 +1413,28 @@ create view T1_v as
select key from src where key <'11'
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@T1_v
POSTHOOK: query: -- null check
create view T1_v as
select key from src where key <'11'
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@T1_v
PREHOOK: query: create view T2_v as
select case when key > '104' then null else key end as key from T1_v
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
PREHOOK: Input: default@t1_v
+PREHOOK: Output: database:default
+PREHOOK: Output: default@T2_v
POSTHOOK: query: create view T2_v as
select case when key > '104' then null else key end as key from T1_v
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
POSTHOOK: Input: default@t1_v
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@T2_v
Warning: Shuffle Join JOIN[24][tables = [t1_v, sq_1_notin_nullcheck]] in Stage 'Stage-2:MAPRED' is a cross product
PREHOOK: query: explain
Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/subquery_views.q.out Wed Aug 27 17:36:23 2014
@@ -10,6 +10,8 @@ where exists
where b.value = a.value and a.key = b.key and a.value > 'val_9')
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@cv1
POSTHOOK: query: -- SORT_QUERY_RESULTS
-- exists test
@@ -22,6 +24,7 @@ where exists
where b.value = a.value and a.key = b.key and a.value > 'val_9')
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@cv1
PREHOOK: query: select *
from cv1 where cv1.key in (select key from cv1 c where c.key > '95')
@@ -51,6 +54,8 @@ where b.key not in
)
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@cv2
POSTHOOK: query: -- not in test
create view cv2 as
select *
@@ -62,6 +67,7 @@ where b.key not in
)
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@cv2
Warning: Shuffle Join JOIN[42][tables = [b, sq_1_notin_nullcheck]] in Stage 'Stage-5:MAPRED' is a cross product
Warning: Shuffle Join JOIN[18][tables = [b, sq_1_notin_nullcheck]] in Stage 'Stage-1:MAPRED' is a cross product
@@ -416,6 +422,8 @@ group by key, value
having count(*) in (select count(*) from src s1 where s1.key > '9' group by s1.key )
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@cv3
POSTHOOK: query: -- in where + having
create view cv3 as
select key, value, count(*)
@@ -425,6 +433,7 @@ group by key, value
having count(*) in (select count(*) from src s1 where s1.key > '9' group by s1.key )
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@cv3
PREHOOK: query: select * from cv3
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/symlink_text_input_format.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/symlink_text_input_format.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/symlink_text_input_format.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/symlink_text_input_format.q.out Wed Aug 27 17:36:23 2014
@@ -18,7 +18,7 @@ STAGE PLANS:
columns: key string, value string
input format: org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
- name: symlink_text_input_format
+ name: default.symlink_text_input_format
PREHOOK: query: CREATE TABLE symlink_text_input_format (key STRING, value STRING) STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat'
PREHOOK: type: CREATETABLE
Modified: hive/trunk/ql/src/test/results/clientpositive/temp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/temp_table.q.out?rev=1620949&r1=1620948&r2=1620949&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/temp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/temp_table.q.out Wed Aug 27 17:36:23 2014
@@ -59,7 +59,7 @@ STAGE PLANS:
#### A masked pattern was here ####
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: foo
+ name: default.foo
isTemporary: true
Stage: Stage-2
@@ -98,9 +98,12 @@ STAGE PLANS:
PREHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM src WHERE key % 2 = 0
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@foo
POSTHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM src WHERE key % 2 = 0
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@foo
PREHOOK: query: EXPLAIN CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1
PREHOOK: type: CREATETABLE_AS_SELECT
@@ -163,7 +166,7 @@ STAGE PLANS:
#### A masked pattern was here ####
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: bar
+ name: default.bar
isTemporary: true
Stage: Stage-2
@@ -202,9 +205,12 @@ STAGE PLANS:
PREHOOK: query: CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@bar
POSTHOOK: query: CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bar
PREHOOK: query: DESCRIBE foo
PREHOOK: type: DESCTABLE
@@ -452,9 +458,12 @@ POSTHOOK: type: SHOWTABLES
PREHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM default.foo
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@foo
+PREHOOK: Output: database:two
+PREHOOK: Output: two@foo
POSTHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM default.foo
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@foo
+POSTHOOK: Output: database:two
POSTHOOK: Output: two@foo
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES