You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/02/25 08:59:20 UTC
svn commit: r1571600 [44/46] - in /hive/branches/tez: ./
ant/src/org/apache/hadoop/hive/ant/
common/src/java/org/apache/hadoop/hive/common/
common/src/java/org/apache/hadoop/hive/common/type/
common/src/java/org/apache/hadoop/hive/conf/ common/src/java...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf3.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf3.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING, c4 STRING, c5 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: EXPLAIN
FROM src INSERT OVERWRITE TABLE dest1 SELECT count(CAST('' AS INT)), sum(CAST('' AS INT)), avg(CAST('' AS INT)),
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf4.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf4.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf4.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf5.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf5.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf5.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf6.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf6.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf7.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf7.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf7.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf8.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf8.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf8.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT '' WHERE src.key = 86
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_10_trims.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_10_trims.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_10_trims.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_10_trims.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: EXPLAIN
INSERT OVERWRITE TABLE dest1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_bitmap_and.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_bitmap_and.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_bitmap_and.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_bitmap_and.q.out Tue Feb 25 07:58:52 2014
@@ -22,8 +22,10 @@ POSTHOOK: query: drop table bitmap_test
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table bitmap_test (a array<bigint>, b array<bigint>)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table bitmap_test (a array<bigint>, b array<bigint>)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bitmap_test
PREHOOK: query: insert overwrite table bitmap_test
select array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0) from src tablesample (10 rows)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_bitmap_or.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_bitmap_or.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_bitmap_or.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_bitmap_or.q.out Tue Feb 25 07:58:52 2014
@@ -22,8 +22,10 @@ POSTHOOK: query: drop table bitmap_test
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table bitmap_test (a array<bigint>, b array<bigint>)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table bitmap_test (a array<bigint>, b array<bigint>)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bitmap_test
PREHOOK: query: insert overwrite table bitmap_test
select array(13,2,4,8589934592,4096,0), array(8,2,4,8589934592,128,0) from src tablesample (10 rows)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_insert1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_insert1.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_insert1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_insert1.q.out Tue Feb 25 07:58:52 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: FROM src
INSERT OVERWRITE TABLE dest1 SELECT '1234', concat(src.key) WHERE src.key < 100 group by src.key
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_insert2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_insert2.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_insert2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_insert2.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE dest1 SELECT concat('1234', 'abc', 'extra argument'), src.value WHERE src.key < 100
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_ws.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_ws.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_ws.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_concat_ws.q.out Tue Feb 25 07:58:52 2014
@@ -13,8 +13,10 @@ Example:
'www.facebook.com'
PREHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 STRING, c2 STRING, c3 STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT 'abc', 'xyz', '8675309' WHERE src.key = 86
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_explode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_explode.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_explode.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_explode.q.out Tue Feb 25 07:58:52 2014
@@ -682,8 +682,10 @@ POSTHOOK: query: drop table lazy_array_m
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table lazy_array_map (map_col map<int,string>, array_col array<string>)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table lazy_array_map (map_col map<int,string>, array_col array<string>)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@lazy_array_map
PREHOOK: query: INSERT OVERWRITE TABLE lazy_array_map select map(1,'one',2,'two',3,'three'), array('100','200','300') FROM src tablesample (1 rows)
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_field.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_field.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_field.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_field.q.out Tue Feb 25 07:58:52 2014
@@ -70,14 +70,18 @@ POSTHOOK: Input: default@src
1 2 3 4 4
PREHOOK: query: CREATE TABLE test_table(col1 STRING, col2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE test_table(col1 STRING, col2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_table
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_table
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@test_table
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_table
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@test_table
PREHOOK: query: select col1,col2,
field("66",col1),
@@ -113,14 +117,18 @@ POSTHOOK: Input: default@test_table
66 val_66 1 1 0 0 0 1 0 0 2 2
PREHOOK: query: CREATE TABLE test_table1(col1 int, col2 string) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE test_table1(col1 int, col2 string) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_table1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_table1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@test_table1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE test_table1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@test_table1
PREHOOK: query: select col1,col2,
field(66,col1),
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_get_json_object.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_get_json_object.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_get_json_object.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_get_json_object.q.out Tue Feb 25 07:58:52 2014
@@ -25,8 +25,10 @@ Syntax not supported that's worth notici
PREHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(c1 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: FROM src INSERT OVERWRITE TABLE dest1 SELECT ' abc ' WHERE src.key = 86
PREHOOK: type: QUERY
@@ -163,10 +165,12 @@ PREHOOK: query: -- Verify that get_json_
CREATE TABLE dest2(c1 STRING) STORED AS RCFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Verify that get_json_object can handle new lines in JSON values
CREATE TABLE dest2(c1 STRING) STORED AS RCFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest2
POSTHOOK: Lineage: dest1.c1 SIMPLE []
PREHOOK: query: INSERT OVERWRITE TABLE dest2 SELECT '{"a":"b\nc"}' FROM src tablesample (1 rows)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_length.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_length.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_length.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_length.q.out Tue Feb 25 07:58:52 2014
@@ -13,8 +13,10 @@ Example:
8
PREHOOK: query: CREATE TABLE dest1(len INT)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(len INT)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1 SELECT length(src1.value)
PREHOOK: type: QUERY
@@ -157,16 +159,20 @@ POSTHOOK: Lineage: dest1.len EXPRESSION
PREHOOK: query: -- Test with non-ascii characters.
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Test with non-ascii characters.
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@dest1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: EXPLAIN SELECT length(dest1.name) FROM dest1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_printf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_printf.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_printf.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_printf.q.out Tue Feb 25 07:58:52 2014
@@ -78,9 +78,11 @@ Color red, String Null: null, number1 12
PREHOOK: query: -- Test Timestamp
create table timestamp_udf (t timestamp)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Test Timestamp
create table timestamp_udf (t timestamp)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@timestamp_udf
PREHOOK: query: from (select * from src tablesample (1 rows)) s
insert overwrite table timestamp_udf
@@ -120,25 +122,31 @@ ROW FORMAT DELIMITED
FIELDS TERMINATED BY '9'
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Test Binary
CREATE TABLE binay_udf(key binary, value int)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '9'
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@binay_udf
POSTHOOK: Lineage: timestamp_udf.t EXPRESSION []
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/string.txt' INTO TABLE binay_udf
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@binay_udf
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/string.txt' INTO TABLE binay_udf
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@binay_udf
POSTHOOK: Lineage: timestamp_udf.t EXPRESSION []
PREHOOK: query: create table dest1 (key binary, value int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table dest1 (key binary, value int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: timestamp_udf.t EXPRESSION []
PREHOOK: query: insert overwrite table dest1 select transform(*) using 'cat' as key binary, value int from binay_udf
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_reverse.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_reverse.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_reverse.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_reverse.q.out Tue Feb 25 07:58:52 2014
@@ -13,8 +13,10 @@ Example:
'koobecaF'
PREHOOK: query: CREATE TABLE dest1(len STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE dest1(len STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1 SELECT reverse(src1.value)
PREHOOK: type: QUERY
@@ -159,18 +161,22 @@ PREHOOK: query: -- Test with non-ascii c
-- 0xE993AEE982B5
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Test with non-ascii characters
-- kv4.txt contains the text 0xE982B5E993AE, which should be reversed to
-- 0xE993AEE982B5
CREATE TABLE dest1(name STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@dest1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: dest1.len EXPRESSION [(src1)src1.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: SELECT count(1) FROM dest1 WHERE reverse(dest1.name) = _UTF-8 0xE993AEE982B5
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_round_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_round_2.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_round_2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_round_2.q.out Tue Feb 25 07:58:52 2014
@@ -1,9 +1,11 @@
PREHOOK: query: -- test for NaN (not-a-number)
create table tstTbl1(n double)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- test for NaN (not-a-number)
create table tstTbl1(n double)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstTbl1
PREHOOK: query: insert overwrite table tstTbl1
select 'NaN' from src tablesample (1 rows)
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_sentences.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_sentences.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_sentences.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_sentences.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE sent_tmp (val array<string>)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE sent_tmp (val array<string>)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sent_tmp
PREHOOK: query: CREATE TABLE sent_tmp2 (val string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE sent_tmp2 (val string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sent_tmp2
PREHOOK: query: INSERT OVERWRITE TABLE sent_tmp
SELECT explode(sentences(decode(unhex("486976652065737420756E20657863656C6C656E74206F7574696C20706F7572206C65732072657175C3AA74657320646520646F6E6EC3A965732C20657420706575742DC3AA74726520706C757320706F6C7976616C656E7420717565206C612074726164756374696F6E206175746F6D61746971756521206C6120706F6E6374756174696F6E206D756C7469706C65732C206465732070687261736573206D616C20666F726DC3A96573202E2E2E20636F6E667573696F6E202D20657420706F757274616E742063652055444620666F6E6374696F6E6E6520656E636F72652121"), "UTF-8"), "fr")) AS val FROM src LIMIT 3
@@ -113,15 +117,19 @@ POSTHOOK: Lineage: sent_tmp.val SCRIPT [
POSTHOOK: Lineage: sent_tmp2.val SCRIPT [(sent_tmp)sent_tmp.FieldSchema(name:val, type:array<string>, comment:null), ]
PREHOOK: query: CREATE TABLE sent_tmp (val array<string>)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE sent_tmp (val array<string>)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sent_tmp
POSTHOOK: Lineage: sent_tmp.val SCRIPT []
POSTHOOK: Lineage: sent_tmp2.val SCRIPT [(sent_tmp)sent_tmp.FieldSchema(name:val, type:array<string>, comment:null), ]
PREHOOK: query: CREATE TABLE sent_tmp2 (val string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE sent_tmp2 (val string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@sent_tmp2
POSTHOOK: Lineage: sent_tmp.val SCRIPT []
POSTHOOK: Lineage: sent_tmp2.val SCRIPT [(sent_tmp)sent_tmp.FieldSchema(name:val, type:array<string>, comment:null), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_sort_array.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_sort_array.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_sort_array.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_sort_array.q.out Tue Feb 25 07:58:52 2014
@@ -98,6 +98,7 @@ CREATE TABLE dest1 (
timestamps ARRAY<TIMESTAMP>
) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Test it against data in a table.
CREATE TABLE dest1 (
tinyints ARRAY<TINYINT>,
@@ -111,12 +112,15 @@ CREATE TABLE dest1 (
timestamps ARRAY<TIMESTAMP>
) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/primitive_type_arrays.txt' OVERWRITE INTO TABLE dest1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@dest1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/primitive_type_arrays.txt' OVERWRITE INTO TABLE dest1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@dest1
PREHOOK: query: SELECT sort_array(tinyints), sort_array(smallints), sort_array(ints),
sort_array(bigints), sort_array(booleans), sort_array(floats),
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_to_unix_timestamp.q.out Tue Feb 25 07:58:52 2014
@@ -11,14 +11,18 @@ to_unix_timestamp(date[, pattern]) - Ret
Converts the specified time to number of seconds since 1970-01-01.
PREHOOK: query: create table oneline(key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table oneline(key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@oneline
PREHOOK: query: load data local inpath '../../data/files/things.txt' into table oneline
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@oneline
POSTHOOK: query: load data local inpath '../../data/files/things.txt' into table oneline
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@oneline
PREHOOK: query: SELECT
'2009-03-20 11:30:01',
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_translate.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_translate.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_translate.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_translate.q.out Tue Feb 25 07:58:52 2014
@@ -23,14 +23,18 @@ translate('abcdef', 'ada', '192') return
PREHOOK: query: -- Create some tables to serve some input data
CREATE TABLE table_input(input STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Create some tables to serve some input data
CREATE TABLE table_input(input STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_input
PREHOOK: query: CREATE TABLE table_translate(input_string STRING, from_string STRING, to_string STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE table_translate(input_string STRING, from_string STRING, to_string STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@table_translate
PREHOOK: query: FROM src INSERT OVERWRITE TABLE table_input SELECT 'abcd' WHERE src.key = 86
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_unix_timestamp.q.out Tue Feb 25 07:58:52 2014
@@ -11,14 +11,18 @@ unix_timestamp([date[, pattern]]) - Retu
Converts the current or specified time to number of seconds since 1970-01-01.
PREHOOK: query: create table oneline(key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table oneline(key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@oneline
PREHOOK: query: load data local inpath '../../data/files/things.txt' into table oneline
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@oneline
POSTHOOK: query: load data local inpath '../../data/files/things.txt' into table oneline
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@oneline
PREHOOK: query: SELECT
'2009-03-20 11:30:01',
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udtf_json_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udtf_json_tuple.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udtf_json_tuple.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udtf_json_tuple.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table json_t (key string, jstring string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table json_t (key string, jstring string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@json_t
PREHOOK: query: insert overwrite table json_t
select * from (
@@ -409,10 +411,12 @@ PREHOOK: query: -- Verify that json_tupl
CREATE TABLE dest1(c1 STRING) STORED AS RCFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Verify that json_tuple can handle new lines in JSON values
CREATE TABLE dest1(c1 STRING) STORED AS RCFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
POSTHOOK: Lineage: json_t.jstring EXPRESSION []
POSTHOOK: Lineage: json_t.key EXPRESSION []
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udtf_parse_url_tuple.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table url_t (key string, fullurl string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table url_t (key string, fullurl string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@url_t
PREHOOK: query: insert overwrite table url_t
select * from (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udtf_posexplode.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udtf_posexplode.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udtf_posexplode.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udtf_posexplode.q.out Tue Feb 25 07:58:52 2014
@@ -5,6 +5,7 @@ subordinates ARRAY<STRING>,
deductions MAP<STRING, FLOAT>,
address STRUCT<street:STRING, city:STRING, state:STRING, zip:INT>)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE employees (
name STRING,
salary FLOAT,
@@ -12,12 +13,15 @@ subordinates ARRAY<STRING>,
deductions MAP<STRING, FLOAT>,
address STRUCT<street:STRING, city:STRING, state:STRING, zip:INT>)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@employees
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/posexplode_data.txt' INTO TABLE employees
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@employees
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/posexplode_data.txt' INTO TABLE employees
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@employees
PREHOOK: query: SELECT
name, pos, sub
Modified: hive/branches/tez/ql/src/test/results/clientpositive/unicode_notation.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/unicode_notation.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/unicode_notation.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/unicode_notation.q.out Tue Feb 25 07:58:52 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- HIVE-4618 hive should
CREATE TABLE k1( a string)ROW FORMAT DELIMITED FIELDS TERMINATED BY '\u0001'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- HIVE-4618 hive should accept unicode notation like \uxxxx
CREATE TABLE k1( a string)ROW FORMAT DELIMITED FIELDS TERMINATED BY '\u0001'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@k1
PREHOOK: query: desc formatted k1
PREHOOK: type: DESCTABLE
@@ -46,8 +48,10 @@ POSTHOOK: Input: default@k1
POSTHOOK: Output: default@k1
PREHOOK: query: CREATE TABLE k1( a string)ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE k1( a string)ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@k1
PREHOOK: query: desc formatted k1
PREHOOK: type: DESCTABLE
@@ -88,8 +92,10 @@ POSTHOOK: Input: default@k1
POSTHOOK: Output: default@k1
PREHOOK: query: CREATE TABLE k1( a string)ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE k1( a string)ROW FORMAT DELIMITED FIELDS TERMINATED BY '|'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@k1
PREHOOK: query: desc formatted k1
PREHOOK: type: DESCTABLE
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union10.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union10.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union10.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union10.q.out Tue Feb 25 07:58:52 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- union case: all subqu
create table tmptable(key string, value int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- union case: all subqueries are a map-reduce jobs, 3 way union, same input for all sub-queries, followed by filesink
create table tmptable(key string, value int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmptable
PREHOOK: query: explain
insert overwrite table tmptable
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union12.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union12.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union12.q.out Tue Feb 25 07:58:52 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- union case: all subqu
create table tmptable(key string, value int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- union case: all subqueries are a map-reduce jobs, 3 way union, different inputs for all sub-queries, followed by filesink
create table tmptable(key string, value int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmptable
PREHOOK: query: explain
insert overwrite table tmptable
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union17.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union17.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union17.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
PREHOOK: query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST2
PREHOOK: query: -- union case:map-reduce sub-queries followed by multi-table insert
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union18.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union18.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union18.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
PREHOOK: query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST2
PREHOOK: query: -- union case:map-reduce sub-queries followed by multi-table insert
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union19.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union19.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union19.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union19.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST1
PREHOOK: query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@DEST2
PREHOOK: query: -- union case:map-reduce sub-queries followed by multi-table insert
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union22.q.out Tue Feb 25 07:58:52 2014
@@ -1,12 +1,16 @@
PREHOOK: query: create table dst_union22(k1 string, k2 string, k3 string, k4 string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table dst_union22(k1 string, k2 string, k3 string, k4 string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dst_union22
PREHOOK: query: create table dst_union22_delta(k0 string, k1 string, k2 string, k3 string, k4 string, k5 string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table dst_union22_delta(k0 string, k1 string, k2 string, k3 string, k4 string, k5 string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dst_union22_delta
PREHOOK: query: insert overwrite table dst_union22 partition (ds='1')
select key, value, key , value from src
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union25.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union25.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union25.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union25.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table tmp_srcpart like srcpart
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table tmp_srcpart like srcpart
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmp_srcpart
PREHOOK: query: insert overwrite table tmp_srcpart partition (ds='2008-04-08', hr='11')
select key, value from srcpart where ds='2008-04-08' and hr='11'
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union28.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union28.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union28.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union28.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table union_subq_union(key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table union_subq_union(key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_subq_union
PREHOOK: query: explain
insert overwrite table union_subq_union
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union29.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union29.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union29.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union29.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table union_subq_union(key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table union_subq_union(key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_subq_union
PREHOOK: query: explain
insert overwrite table union_subq_union
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union3.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union3.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union3.q.out Tue Feb 25 07:58:52 2014
@@ -287,8 +287,10 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE union_out (id int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE union_out (id int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_out
PREHOOK: query: insert overwrite table union_out
SELECT *
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union30.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union30.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union30.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union30.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table union_subq_union(key int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table union_subq_union(key int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_subq_union
PREHOOK: query: explain
insert overwrite table union_subq_union
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union31.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union31.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union31.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union31.q.out Tue Feb 25 07:58:52 2014
@@ -22,13 +22,17 @@ POSTHOOK: Input: default@src
POSTHOOK: Output: default@t2
PREHOOK: query: create table t3(key string, cnt int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table t3(key string, cnt int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t3
PREHOOK: query: create table t4(value string, cnt int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table t4(value string, cnt int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t4
PREHOOK: query: explain
from
@@ -292,8 +296,10 @@ val_8 2
val_9 2
PREHOOK: query: create table t5(c1 string, cnt int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table t5(c1 string, cnt int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t5
POSTHOOK: Lineage: t3.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t3.key EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
@@ -301,8 +307,10 @@ POSTHOOK: Lineage: t4.cnt EXPRESSION [(t
POSTHOOK: Lineage: t4.value EXPRESSION [(t2)t2.FieldSchema(name:value, type:string, comment:null), (t1)t1.FieldSchema(name:value, type:string, comment:null), ]
PREHOOK: query: create table t6(c1 string, cnt int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table t6(c1 string, cnt int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t6
POSTHOOK: Lineage: t3.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t3.key EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
@@ -667,8 +675,10 @@ POSTHOOK: Lineage: t6.c1 EXPRESSION [(t2
POSTHOOK: Lineage: t6.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
PREHOOK: query: create table t7(c1 string, cnt int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table t7(c1 string, cnt int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t7
POSTHOOK: Lineage: t3.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t3.key EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
@@ -680,8 +690,10 @@ POSTHOOK: Lineage: t6.c1 EXPRESSION [(t2
POSTHOOK: Lineage: t6.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
PREHOOK: query: create table t8(c1 string, cnt int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table t8(c1 string, cnt int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t8
POSTHOOK: Lineage: t3.cnt EXPRESSION [(t2)t2.null, (t1)t1.null, ]
POSTHOOK: Lineage: t3.key EXPRESSION [(t2)t2.FieldSchema(name:key, type:string, comment:null), (t1)t1.FieldSchema(name:key, type:string, comment:null), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union33.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union33.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union33.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union33.q.out Tue Feb 25 07:58:52 2014
@@ -3,11 +3,13 @@ PREHOOK: query: -- This tests that a uni
CREATE TABLE test_src (key STRING, value STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This tests that a union all with a map only subquery on one side and a
-- subquery involving two map reduce jobs on the other runs correctly.
CREATE TABLE test_src (key STRING, value STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_src
PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE test_src
SELECT key, value FROM (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union34.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union34.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union34.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union34.q.out Tue Feb 25 07:58:52 2014
@@ -1,22 +1,30 @@
PREHOOK: query: create table src10_1 (key string, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table src10_1 (key string, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src10_1
PREHOOK: query: create table src10_2 (key string, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table src10_2 (key string, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src10_2
PREHOOK: query: create table src10_3 (key string, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table src10_3 (key string, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src10_3
PREHOOK: query: create table src10_4 (key string, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table src10_4 (key string, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src10_4
PREHOOK: query: from (select * from src tablesample (10 rows)) a
insert overwrite table src10_1 select *
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union4.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union4.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union4.q.out Tue Feb 25 07:58:52 2014
@@ -3,11 +3,13 @@ PREHOOK: query: -- union case: both subq
create table tmptable(key string, value int)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- union case: both subqueries are map-reduce jobs on same input, followed by filesink
create table tmptable(key string, value int)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmptable
PREHOOK: query: explain
insert overwrite table tmptable
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union6.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union6.q.out Tue Feb 25 07:58:52 2014
@@ -3,11 +3,13 @@ PREHOOK: query: -- union case: 1 subquer
create table tmptable(key string, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by filesink
create table tmptable(key string, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmptable
PREHOOK: query: explain
insert overwrite table tmptable
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_date.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_date.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_date.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_date.q.out Tue Feb 25 07:58:52 2014
@@ -14,6 +14,7 @@ PREHOOK: query: create table union_date_
FL_NUM int
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table union_date_1 (
ORIGIN_CITY_NAME string,
DEST_CITY_NAME string,
@@ -22,6 +23,7 @@ POSTHOOK: query: create table union_date
FL_NUM int
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_date_1
PREHOOK: query: create table union_date_2 (
ORIGIN_CITY_NAME string,
@@ -31,6 +33,7 @@ PREHOOK: query: create table union_date_
FL_NUM int
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table union_date_2 (
ORIGIN_CITY_NAME string,
DEST_CITY_NAME string,
@@ -39,18 +42,23 @@ POSTHOOK: query: create table union_date
FL_NUM int
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_date_2
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@union_date_1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@union_date_1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_2
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@union_date_2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/flights_join.txt' OVERWRITE INTO TABLE union_date_2
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@union_date_2
PREHOOK: query: select * from (
select fl_num, fl_date from union_date_1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_lateralview.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_lateralview.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_lateralview.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_lateralview.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: create table test_union_lateral_view(key int, arr_ele int, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table test_union_lateral_view(key int, arr_ele int, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@test_union_lateral_view
PREHOOK: query: EXPLAIN
INSERT OVERWRITE TABLE test_union_lateral_view
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_remove_6.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_remove_6.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_remove_6.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_remove_6.q.out Tue Feb 25 07:58:52 2014
@@ -7,6 +7,7 @@ PREHOOK: query: -- This is to test the u
create table inputTbl1(key string, val string) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization
-- Union of 2 subqueries is performed (all of which are mapred queries)
-- followed by select star and a file sink in 2 output tables.
@@ -16,22 +17,29 @@ POSTHOOK: query: -- This is to test the
create table inputTbl1(key string, val string) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@inputTbl1
PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl1
PREHOOK: query: create table outputTbl2(key string, values bigint) stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table outputTbl2(key string, values bigint) stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@outputTbl2
PREHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@inputtbl1
POSTHOOK: query: load data local inpath '../../data/files/T1.txt' into table inputTbl1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@inputtbl1
PREHOOK: query: explain
FROM (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_view.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_view.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_view.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE src_union_1 (key int, value string) PARTITIONED BY (ds string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE src_union_1 (key int, value string) PARTITIONED BY (ds string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_union_1
PREHOOK: query: CREATE INDEX src_union_1_key_idx ON TABLE src_union_1(key) AS 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
@@ -10,8 +12,10 @@ POSTHOOK: type: CREATEINDEX
POSTHOOK: Output: default@default__src_union_1_src_union_1_key_idx__
PREHOOK: query: CREATE TABLE src_union_2 (key int, value string) PARTITIONED BY (ds string, part_1 string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE src_union_2 (key int, value string) PARTITIONED BY (ds string, part_1 string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_union_2
PREHOOK: query: CREATE INDEX src_union_2_key_idx ON TABLE src_union_2(key) AS 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
@@ -20,8 +24,10 @@ POSTHOOK: type: CREATEINDEX
POSTHOOK: Output: default@default__src_union_2_src_union_2_key_idx__
PREHOOK: query: CREATE TABLE src_union_3(key int, value string) PARTITIONED BY (ds string, part_1 string, part_2 string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE src_union_3(key int, value string) PARTITIONED BY (ds string, part_1 string, part_2 string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_union_3
PREHOOK: query: CREATE INDEX src_union_3_key_idx ON TABLE src_union_3(key) AS 'COMPACT' WITH DEFERRED REBUILD
PREHOOK: type: CREATEINDEX
Modified: hive/branches/tez/ql/src/test/results/clientpositive/uniquejoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/uniquejoin.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/uniquejoin.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/uniquejoin.q.out Tue Feb 25 07:58:52 2014
@@ -1,35 +1,47 @@
PREHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@T1
PREHOOK: query: CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@T2
PREHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@T3
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@t1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T1.txt' INTO TABLE T1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@t1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T2.txt' INTO TABLE T2
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@t2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T2.txt' INTO TABLE T2
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@t2
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T3.txt' INTO TABLE T3
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@t3
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/T3.txt' INTO TABLE T3
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@t3
PREHOOK: query: FROM UNIQUEJOIN PRESERVE T1 a (a.key), PRESERVE T2 b (b.key), PRESERVE T3 c (c.key)
SELECT a.key, b.key, c.key
Modified: hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE testTable(col1 INT, col2 INT)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE testTable(col1 INT, col2 INT)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@testTable
PREHOOK: query: SHOW TBLPROPERTIES testTable
PREHOOK: type: SHOW_TBLPROPERTIES
Modified: hive/branches/tez/ql/src/test/results/clientpositive/updateAccessTime.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/updateAccessTime.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/updateAccessTime.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/updateAccessTime.q.out Tue Feb 25 07:58:52 2014
@@ -48,8 +48,10 @@ POSTHOOK: query: drop table tstsrcpart
POSTHOOK: type: DROPTABLE
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
PREHOOK: query: insert overwrite table tstsrcpart partition (ds, hr) select key, value, ds, hr from srcpart
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_1.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_1.q.out Tue Feb 25 07:58:52 2014
@@ -8,21 +8,27 @@ POSTHOOK: query: drop table varchar1_1
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table varchar1 (key varchar(10), value varchar(20))
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar1 (key varchar(10), value varchar(20))
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar1
PREHOOK: query: create table varchar1_1 (key string, value string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar1_1 (key string, value string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar1_1
PREHOOK: query: -- load from file
load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@varchar1
POSTHOOK: query: -- load from file
load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@varchar1
PREHOOK: query: select * from varchar1 order by key, value limit 2
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_2.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_2.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_2.q.out Tue Feb 25 07:58:52 2014
@@ -7,11 +7,13 @@ PREHOOK: query: create table varchar_2 (
value varchar(20)
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar_2 (
key varchar(10),
value varchar(20)
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_2
PREHOOK: query: insert overwrite table varchar_2 select * from src
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_join1.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_join1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_join1.q.out Tue Feb 25 07:58:52 2014
@@ -15,51 +15,63 @@ PREHOOK: query: create table varchar_jo
c2 varchar(10)
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar_join1_vc1 (
c1 int,
c2 varchar(10)
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_join1_vc1
PREHOOK: query: create table varchar_join1_vc2 (
c1 int,
c2 varchar(20)
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar_join1_vc2 (
c1 int,
c2 varchar(20)
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_join1_vc2
PREHOOK: query: create table varchar_join1_str (
c1 int,
c2 string
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar_join1_str (
c1 int,
c2 string
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_join1_str
PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@varchar_join1_vc1
POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@varchar_join1_vc1
PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc2
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@varchar_join1_vc2
POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_vc2
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@varchar_join1_vc2
PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_str
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@varchar_join1_str
POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_join1_str
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@varchar_join1_str
PREHOOK: query: -- Join varchar with same length varchar
select * from varchar_join1_vc1 a join varchar_join1_vc1 b on (a.c2 = b.c2) order by a.c1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_nested_types.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_nested_types.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_nested_types.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_nested_types.q.out Tue Feb 25 07:58:52 2014
@@ -24,8 +24,10 @@ POSTHOOK: query: drop table varchar_nest
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table varchar_nested_1 (key int, value varchar(20))
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar_nested_1 (key int, value varchar(20))
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_nested_1
PREHOOK: query: insert overwrite table varchar_nested_1
select key, value from src order by key limit 1
@@ -42,9 +44,11 @@ POSTHOOK: Lineage: varchar_nested_1.valu
PREHOOK: query: -- arrays
create table varchar_nested_array (c1 array<varchar(20)>)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- arrays
create table varchar_nested_array (c1 array<varchar(20)>)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_nested_array
POSTHOOK: Lineage: varchar_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -84,9 +88,11 @@ POSTHOOK: Lineage: varchar_nested_array.
PREHOOK: query: -- maps
create table varchar_nested_map (c1 map<int, varchar(20)>)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- maps
create table varchar_nested_map (c1 map<int, varchar(20)>)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_nested_map
POSTHOOK: Lineage: varchar_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
@@ -130,9 +136,11 @@ POSTHOOK: Lineage: varchar_nested_map.c1
PREHOOK: query: -- structs
create table varchar_nested_struct (c1 struct<a:int, b:varchar(20), c:string>)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- structs
create table varchar_nested_struct (c1 struct<a:int, b:varchar(20), c:string>)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_nested_struct
POSTHOOK: Lineage: varchar_nested_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: varchar_nested_1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_serde.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_serde.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_serde.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_serde.q.out Tue Feb 25 07:58:52 2014
@@ -35,6 +35,7 @@ with serdeproperties (
)
stored as textfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: --
-- RegexSerDe
--
@@ -48,12 +49,15 @@ with serdeproperties (
)
stored as textfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_serde_regex
PREHOOK: query: load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar_serde_regex
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@varchar_serde_regex
POSTHOOK: query: load data local inpath '../../data/files/srcbucket0.txt' overwrite into table varchar_serde_regex
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@varchar_serde_regex
PREHOOK: query: select * from varchar_serde_regex limit 5
PREHOOK: type: QUERY
@@ -89,6 +93,7 @@ create table varchar_serde_lb (
value varchar(20)
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: --
-- LazyBinary
--
@@ -97,6 +102,7 @@ create table varchar_serde_lb (
value varchar(20)
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_serde_lb
PREHOOK: query: alter table varchar_serde_lb set serde 'org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe'
PREHOOK: type: ALTERTABLE_SERIALIZER
@@ -156,6 +162,7 @@ create table varchar_serde_ls (
value varchar(20)
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: --
-- LazySimple
--
@@ -164,6 +171,7 @@ create table varchar_serde_ls (
value varchar(20)
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_serde_ls
POSTHOOK: Lineage: varchar_serde_lb.key SIMPLE [(varchar_serde_regex)varchar_serde_regex.FieldSchema(name:key, type:varchar(10), comment:from deserializer), ]
POSTHOOK: Lineage: varchar_serde_lb.value SIMPLE [(varchar_serde_regex)varchar_serde_regex.FieldSchema(name:value, type:varchar(20), comment:from deserializer), ]
@@ -233,6 +241,7 @@ create table varchar_serde_c (
value varchar(20)
) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: --
-- Columnar
--
@@ -241,6 +250,7 @@ create table varchar_serde_c (
value varchar(20)
) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_serde_c
POSTHOOK: Lineage: varchar_serde_lb.key SIMPLE [(varchar_serde_regex)varchar_serde_regex.FieldSchema(name:key, type:varchar(10), comment:from deserializer), ]
POSTHOOK: Lineage: varchar_serde_lb.value SIMPLE [(varchar_serde_regex)varchar_serde_regex.FieldSchema(name:value, type:varchar(20), comment:from deserializer), ]
@@ -320,6 +330,7 @@ create table varchar_serde_lbc (
value varchar(20)
) stored as rcfile
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: --
-- LazyBinaryColumnar
--
@@ -328,6 +339,7 @@ create table varchar_serde_lbc (
value varchar(20)
) stored as rcfile
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_serde_lbc
POSTHOOK: Lineage: varchar_serde_c.key SIMPLE [(varchar_serde_ls)varchar_serde_ls.FieldSchema(name:key, type:varchar(10), comment:from deserializer), ]
POSTHOOK: Lineage: varchar_serde_c.value SIMPLE [(varchar_serde_ls)varchar_serde_ls.FieldSchema(name:value, type:varchar(20), comment:from deserializer), ]
@@ -417,6 +429,7 @@ create table varchar_serde_orc (
value varchar(20)
) stored as orc
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: --
-- ORC
--
@@ -425,6 +438,7 @@ create table varchar_serde_orc (
value varchar(20)
) stored as orc
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_serde_orc
POSTHOOK: Lineage: varchar_serde_c.key SIMPLE [(varchar_serde_ls)varchar_serde_ls.FieldSchema(name:key, type:varchar(10), comment:from deserializer), ]
POSTHOOK: Lineage: varchar_serde_c.value SIMPLE [(varchar_serde_ls)varchar_serde_ls.FieldSchema(name:value, type:varchar(20), comment:from deserializer), ]
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_udf1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_udf1.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_udf1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_udf1.q.out Tue Feb 25 07:58:52 2014
@@ -4,8 +4,10 @@ POSTHOOK: query: drop table varchar_udf_
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table varchar_udf_1 (c1 string, c2 string, c3 varchar(10), c4 varchar(20))
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar_udf_1 (c1 string, c2 string, c3 varchar(10), c4 varchar(20))
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_udf_1
PREHOOK: query: insert overwrite table varchar_udf_1
select key, value, key, value from src where key = '238' limit 1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_union1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_union1.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_union1.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_union1.q.out Tue Feb 25 07:58:52 2014
@@ -15,51 +15,63 @@ PREHOOK: query: create table varchar_un
c2 varchar(10)
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar_union1_vc1 (
c1 int,
c2 varchar(10)
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_union1_vc1
PREHOOK: query: create table varchar_union1_vc2 (
c1 int,
c2 varchar(20)
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar_union1_vc2 (
c1 int,
c2 varchar(20)
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_union1_vc2
PREHOOK: query: create table varchar_union1_str (
c1 int,
c2 string
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table varchar_union1_str (
c1 int,
c2 string
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_union1_str
PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@varchar_union1_vc1
POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@varchar_union1_vc1
PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc2
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@varchar_union1_vc2
POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_vc2
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@varchar_union1_vc2
PREHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_str
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@varchar_union1_str
POSTHOOK: query: load data local inpath '../../data/files/vc1.txt' into table varchar_union1_str
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@varchar_union1_str
PREHOOK: query: -- union varchar with same length varchar
select * from (
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vectorization_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vectorization_part.q.out?rev=1571600&r1=1571599&r2=1571600&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vectorization_part.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vectorization_part.q.out Tue Feb 25 07:58:52 2014
@@ -1,7 +1,9 @@
PREHOOK: query: CREATE TABLE alltypesorc_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS ORC
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE alltypesorc_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS ORC
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@alltypesorc_part
PREHOOK: query: insert overwrite table alltypesorc_part partition (ds='2011') select * from alltypesorc limit 100
PREHOOK: type: QUERY