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
