You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by th...@apache.org on 2014/02/20 16:44:58 UTC
svn commit: r1570238 [28/28] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/common/
contrib/src/test/results/clientnegative/
contrib/src/test/results/clientpositive/
hbase-handler/src/test/results/negative/
hbase-handler/src/test/results/posi...
Modified: hive/trunk/ql/src/test/results/clientpositive/varchar_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_1.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_1.q.out Thu Feb 20 15:44:37 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/trunk/ql/src/test/results/clientpositive/varchar_2.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_2.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_2.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_2.q.out Thu Feb 20 15:44:37 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/trunk/ql/src/test/results/clientpositive/varchar_join1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_join1.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_join1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_join1.q.out Thu Feb 20 15:44:37 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/trunk/ql/src/test/results/clientpositive/varchar_nested_types.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_nested_types.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_nested_types.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_nested_types.q.out Thu Feb 20 15:44:37 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/trunk/ql/src/test/results/clientpositive/varchar_serde.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_serde.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_serde.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_serde.q.out Thu Feb 20 15:44:37 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/trunk/ql/src/test/results/clientpositive/varchar_udf1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_udf1.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_udf1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_udf1.q.out Thu Feb 20 15:44:37 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/trunk/ql/src/test/results/clientpositive/varchar_union1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/varchar_union1.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/varchar_union1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/varchar_union1.q.out Thu Feb 20 15:44:37 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/trunk/ql/src/test/results/clientpositive/vectorization_part.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_part.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_part.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_part.q.out Thu Feb 20 15:44:37 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
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorization_part_project.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorization_part_project.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorization_part_project.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorization_part_project.q.out Thu Feb 20 15:44:37 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
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out Thu Feb 20 15:44:37 2014
@@ -3,44 +3,52 @@ PREHOOK: query: create table vsmb_bucket
SORTED BY (key) INTO 1 BUCKETS
STORED AS ORC
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table vsmb_bucket_1(key int, value string)
CLUSTERED BY (key)
SORTED BY (key) INTO 1 BUCKETS
STORED AS ORC
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vsmb_bucket_1
PREHOOK: query: create table vsmb_bucket_2(key int, value string)
CLUSTERED BY (key)
SORTED BY (key) INTO 1 BUCKETS
STORED AS ORC
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table vsmb_bucket_2(key int, value string)
CLUSTERED BY (key)
SORTED BY (key) INTO 1 BUCKETS
STORED AS ORC
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vsmb_bucket_2
PREHOOK: query: create table vsmb_bucket_RC(key int, value string)
CLUSTERED BY (key)
SORTED BY (key) INTO 1 BUCKETS
STORED AS RCFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table vsmb_bucket_RC(key int, value string)
CLUSTERED BY (key)
SORTED BY (key) INTO 1 BUCKETS
STORED AS RCFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vsmb_bucket_RC
PREHOOK: query: create table vsmb_bucket_TXT(key int, value string)
CLUSTERED BY (key)
SORTED BY (key) INTO 1 BUCKETS
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table vsmb_bucket_TXT(key int, value string)
CLUSTERED BY (key)
SORTED BY (key) INTO 1 BUCKETS
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@vsmb_bucket_TXT
PREHOOK: query: insert into table vsmb_bucket_1 select cint, cstring1 from alltypesorc limit 2
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_context.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_context.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_context.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_context.q.out Thu Feb 20 15:44:37 2014
@@ -1,9 +1,11 @@
PREHOOK: query: create table store(s_store_sk int, s_city string)
stored as orc
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table store(s_store_sk int, s_city string)
stored as orc
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@store
PREHOOK: query: insert overwrite table store
select cint, cstring1
@@ -26,9 +28,11 @@ POSTHOOK: Lineage: store.s_store_sk SIMP
PREHOOK: query: create table store_sales(ss_store_sk int, ss_hdemo_sk int, ss_net_profit double)
stored as orc
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table store_sales(ss_store_sk int, ss_hdemo_sk int, ss_net_profit double)
stored as orc
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@store_sales
POSTHOOK: Lineage: store.s_city SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:from deserializer), ]
POSTHOOK: Lineage: store.s_store_sk SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:from deserializer), ]
@@ -56,9 +60,11 @@ POSTHOOK: Lineage: store_sales.ss_store_
PREHOOK: query: create table household_demographics(hd_demo_sk int)
stored as orc
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table household_demographics(hd_demo_sk int)
stored as orc
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@household_demographics
POSTHOOK: Lineage: store.s_city SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:from deserializer), ]
POSTHOOK: Lineage: store.s_store_sk SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:from deserializer), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out Thu Feb 20 15:44:37 2014
@@ -8,6 +8,7 @@ STORED AS
INPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: --This query must pass even when vectorized reader is not available for
--RC files. The query must fall back to the non-vector mode and run successfully.
@@ -18,6 +19,7 @@ STORED AS
INPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileInputFormat'
OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@columnTable
PREHOOK: query: FROM src
INSERT OVERWRITE TABLE columnTable SELECT src.key, src.value LIMIT 10
Modified: hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out Thu Feb 20 15:44:37 2014
@@ -2,10 +2,12 @@ PREHOOK: query: -- Test timestamp functi
CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- Test timestamp functions in vectorized mode to verify they run correctly end-to-end.
CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@alltypesorc_string
PREHOOK: query: INSERT OVERWRITE TABLE alltypesorc_string
SELECT
@@ -29,8 +31,10 @@ POSTHOOK: Lineage: alltypesorc_string.ct
POSTHOOK: Lineage: alltypesorc_string.stimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:from deserializer), ]
PREHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@alltypesorc_wrong
POSTHOOK: Lineage: alltypesorc_string.ctimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:from deserializer), ]
POSTHOOK: Lineage: alltypesorc_string.stimestamp1 EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:from deserializer), ]
Modified: hive/trunk/ql/src/test/results/clientpositive/view.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/view.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/view.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/view.q.out Thu Feb 20 15:44:37 2014
@@ -9,32 +9,40 @@ POSTHOOK: type: SWITCHDATABASE
PREHOOK: query: CREATE TABLE table1 (key STRING, value STRING)
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:db1
POSTHOOK: query: CREATE TABLE table1 (key STRING, value STRING)
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@table1
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table1
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: db1@table1
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table1
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: db1@table1
PREHOOK: query: CREATE TABLE table2 (key STRING, value STRING)
STORED AS TEXTFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:db1
POSTHOOK: query: CREATE TABLE table2 (key STRING, value STRING)
STORED AS TEXTFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:db1
POSTHOOK: Output: db1@table2
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table2
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: db1@table2
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt'
OVERWRITE INTO TABLE table2
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: db1@table2
PREHOOK: query: -- relative reference, no alias
CREATE VIEW v1 AS SELECT * FROM table1
Modified: hive/trunk/ql/src/test/results/clientpositive/view_cast.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/view_cast.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/view_cast.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/view_cast.q.out Thu Feb 20 15:44:37 2014
@@ -4,21 +4,27 @@ POSTHOOK: query: DROP TABLE IF EXISTS at
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE IF NOT EXISTS atab (ks_uid BIGINT, sr_uid STRING, sr_id STRING, tstamp STRING, m_id STRING, act STRING, at_sr_uid STRING, tstamp_type STRING, original_m_id STRING, original_tstamp STRING, registered_flag TINYINT, at_ks_uid BIGINT) PARTITIONED BY (dt STRING,nt STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE IF NOT EXISTS atab (ks_uid BIGINT, sr_uid STRING, sr_id STRING, tstamp STRING, m_id STRING, act STRING, at_sr_uid STRING, tstamp_type STRING, original_m_id STRING, original_tstamp STRING, registered_flag TINYINT, at_ks_uid BIGINT) PARTITIONED BY (dt STRING,nt STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@atab
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130312', nt='tw')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@atab
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130312', nt='tw')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@atab
POSTHOOK: Output: default@atab@dt=20130312/nt=tw
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130311', nt='tw')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@atab
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v1.txt' INTO TABLE atab PARTITION (dt='20130311', nt='tw')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@atab
POSTHOOK: Output: default@atab@dt=20130311/nt=tw
PREHOOK: query: DROP TABLE IF EXISTS mstab
@@ -27,14 +33,18 @@ POSTHOOK: query: DROP TABLE IF EXISTS m
POSTHOOK: type: DROPTABLE
PREHOOK: query: CREATE TABLE mstab(ks_uid INT, csc INT) PARTITIONED BY (dt STRING)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE mstab(ks_uid INT, csc INT) PARTITIONED BY (dt STRING)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@mstab
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v2.txt' INTO TABLE mstab PARTITION (dt='20130311')
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@mstab
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/v2.txt' INTO TABLE mstab PARTITION (dt='20130311')
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@mstab
POSTHOOK: Output: default@mstab@dt=20130311
PREHOOK: query: DROP VIEW IF EXISTS aa_view_tw
Modified: hive/trunk/ql/src/test/results/clientpositive/virtual_column.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/virtual_column.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/virtual_column.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/virtual_column.q.out Thu Feb 20 15:44:37 2014
@@ -350,8 +350,10 @@ POSTHOOK: Input: default@src
97 val_97
PREHOOK: query: CREATE TABLE src_index_test_rc (key int, value string) STORED AS RCFILE
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE src_index_test_rc (key int, value string) STORED AS RCFILE
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@src_index_test_rc
PREHOOK: query: INSERT OVERWRITE TABLE src_index_test_rc SELECT * FROM src
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing.q.out Thu Feb 20 15:44:37 2014
@@ -15,6 +15,7 @@ CREATE TABLE part(
p_comment STRING
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- data setup
CREATE TABLE part(
p_partkey INT,
@@ -28,12 +29,15 @@ CREATE TABLE part(
p_comment STRING
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@part
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@part
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@part
PREHOOK: query: -- 1. testWindowing
select p_mfgr, p_name, p_size,
@@ -1258,6 +1262,7 @@ r INT,
dr INT,
s DOUBLE)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- 25. testMultipleInserts3SWQs
CREATE TABLE part_1(
p_mfgr STRING,
@@ -1267,6 +1272,7 @@ r INT,
dr INT,
s DOUBLE)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@part_1
PREHOOK: query: CREATE TABLE part_2(
p_mfgr STRING,
@@ -1278,6 +1284,7 @@ cud INT,
s2 DOUBLE,
fv1 INT)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE part_2(
p_mfgr STRING,
p_name STRING,
@@ -1288,6 +1295,7 @@ cud INT,
s2 DOUBLE,
fv1 INT)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@part_2
PREHOOK: query: CREATE TABLE part_3(
p_mfgr STRING,
@@ -1297,6 +1305,7 @@ c INT,
ca INT,
fv INT)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: CREATE TABLE part_3(
p_mfgr STRING,
p_name STRING,
@@ -1305,6 +1314,7 @@ c INT,
ca INT,
fv INT)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@part_3
PREHOOK: query: from part
INSERT OVERWRITE TABLE part_1
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_adjust_rowcontainer_sz.q.out Thu Feb 20 15:44:37 2014
@@ -15,6 +15,7 @@ CREATE TABLE part(
p_comment STRING
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- data setup
CREATE TABLE part(
p_partkey INT,
@@ -28,12 +29,15 @@ CREATE TABLE part(
p_comment STRING
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@part
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@part
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@part
PREHOOK: query: select p_mfgr, p_name, p_size,
rank() over(distribute by p_mfgr sort by p_name) as r,
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_columnPruning.q.out Thu Feb 20 15:44:37 2014
@@ -15,6 +15,7 @@ CREATE TABLE part(
p_comment STRING
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- data setup
CREATE TABLE part(
p_partkey INT,
@@ -28,12 +29,15 @@ CREATE TABLE part(
p_comment STRING
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@part
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@part
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@part
PREHOOK: query: -- 1. testQueryLevelPartitionColsNotInSelect
select p_size,
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_expressions.q.out Thu Feb 20 15:44:37 2014
@@ -15,6 +15,7 @@ CREATE TABLE part(
p_comment STRING
)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- data setup
CREATE TABLE part(
p_partkey INT,
@@ -28,12 +29,15 @@ CREATE TABLE part(
p_comment STRING
)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@part
PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@part
POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/part_tiny.txt' overwrite into table part
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@part
PREHOOK: query: drop table over10k
PREHOOK: type: DROPTABLE
@@ -54,6 +58,7 @@ PREHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table over10k(
t tinyint,
si smallint,
@@ -69,12 +74,15 @@ POSTHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@over10k
PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@over10k
POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@over10k
PREHOOK: query: select p_mfgr, p_retailprice, p_size,
round(sum(p_retailprice) over w1 , 2) = round(sum(lag(p_retailprice,1,0.0)) over w1 + last_value(p_retailprice) over w1 , 2),
@@ -663,14 +671,18 @@ Manufacturer#5 1534.532
PREHOOK: query: -- multi table insert test
create table t1 (a1 int, b1 string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: -- multi table insert test
create table t1 (a1 int, b1 string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: create table t2 (a1 int, b1 string)
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table t2 (a1 int, b1 string)
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t2
PREHOOK: query: from (select sum(i) over (partition by ts order by i), s from over10k) tt insert overwrite table t1 select * insert overwrite table t2 select *
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_multipartitioning.q.out Thu Feb 20 15:44:37 2014
@@ -17,6 +17,7 @@ PREHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table over10k(
t tinyint,
si smallint,
@@ -32,12 +33,15 @@ POSTHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@over10k
PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@over10k
POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, rank() over (partition by s order by si), sum(b) over (partition by s order by si) from over10k limit 100
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_navfn.q.out Thu Feb 20 15:44:37 2014
@@ -17,6 +17,7 @@ PREHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table over10k(
t tinyint,
si smallint,
@@ -32,12 +33,15 @@ POSTHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@over10k
PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@over10k
POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, row_number() over (partition by d order by dec) from over10k limit 100
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_ntile.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_ntile.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_ntile.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_ntile.q.out Thu Feb 20 15:44:37 2014
@@ -17,6 +17,7 @@ PREHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table over10k(
t tinyint,
si smallint,
@@ -32,12 +33,15 @@ POSTHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@over10k
PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@over10k
POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@over10k
PREHOOK: query: select i, ntile(10) over (partition by s order by i) from over10k limit 100
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_rank.q.out Thu Feb 20 15:44:37 2014
@@ -17,6 +17,7 @@ PREHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table over10k(
t tinyint,
si smallint,
@@ -32,12 +33,15 @@ POSTHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@over10k
PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@over10k
POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, rank() over (partition by f order by t) from over10k limit 100
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_udaf.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_udaf.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_udaf.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_udaf.q.out Thu Feb 20 15:44:37 2014
@@ -17,6 +17,7 @@ PREHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table over10k(
t tinyint,
si smallint,
@@ -32,12 +33,15 @@ POSTHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@over10k
PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@over10k
POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, min(i) over (partition by s) from over10k limit 100
PREHOOK: type: QUERY
Modified: hive/trunk/ql/src/test/results/clientpositive/windowing_windowspec.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/windowing_windowspec.q.out?rev=1570238&r1=1570237&r2=1570238&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/windowing_windowspec.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/windowing_windowspec.q.out Thu Feb 20 15:44:37 2014
@@ -17,6 +17,7 @@ PREHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
POSTHOOK: query: create table over10k(
t tinyint,
si smallint,
@@ -32,12 +33,15 @@ POSTHOOK: query: create table over10k(
row format delimited
fields terminated by '|'
POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@over10k
PREHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
PREHOOK: type: LOAD
+#### A masked pattern was here ####
PREHOOK: Output: default@over10k
POSTHOOK: query: load data local inpath '../../data/files/over10k' into table over10k
POSTHOOK: type: LOAD
+#### A masked pattern was here ####
POSTHOOK: Output: default@over10k
PREHOOK: query: select s, sum(b) over (partition by i order by s,b rows unbounded preceding) from over10k limit 100
PREHOOK: type: QUERY