You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ga...@apache.org on 2014/09/14 00:09:33 UTC
svn commit: r1624788 [4/5] - in /hive/trunk:
common/src/java/org/apache/hadoop/hive/conf/ data/conf/tez/
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/history/
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/txn/compactor/
itests/sr...
Added: hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,52 @@
+PREHOOK: query: create table acid_danp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_danp
+POSTHOOK: query: create table acid_danp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_danp
+PREHOOK: query: insert into table acid_danp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_danp
+POSTHOOK: query: insert into table acid_danp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_danp
+POSTHOOK: Lineage: acid_danp.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_danp.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_danp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_danp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_danp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_danp
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: delete from acid_danp
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_danp
+PREHOOK: Output: default@acid_danp
+POSTHOOK: query: delete from acid_danp
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_danp
+POSTHOOK: Output: default@acid_danp
+PREHOOK: query: select a,b from acid_danp
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_danp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_danp
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_danp
+#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,86 @@
+PREHOOK: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dap
+POSTHOOK: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dap
+PREHOOK: query: insert into table acid_dap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dap@ds=today
+POSTHOOK: query: insert into table acid_dap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dap@ds=today
+POSTHOOK: Lineage: acid_dap PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dap PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_dap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 1000 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dap@ds=tomorrow
+POSTHOOK: query: insert into table acid_dap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 1000 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dap@ds=tomorrow
+POSTHOOK: Lineage: acid_dap PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dap PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b,ds from acid_dap order by a,b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dap
+PREHOOK: Input: default@acid_dap@ds=today
+PREHOOK: Input: default@acid_dap@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_dap order by a,b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dap
+POSTHOOK: Input: default@acid_dap@ds=today
+POSTHOOK: Input: default@acid_dap@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073051226 A34p7oRr2WvUJNf today
+-1072910839 0iqrc5 today
+-1072081801 dPkN74F7 today
+-1072076362 2uLyD28144vklju213J1mr today
+-1071480828 aw724t8c5558x2xneC624 today
+-1071363017 Anj0oF today
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070551679 iUR3Q today
+-1069736047 k17Am8uPHWk02cEf1jet today
+6981 NULL tomorrow
+6981 1FNNhmiFLGw425NA13g tomorrow
+6981 4KhrrQ0nJ7bMNTvhSCA tomorrow
+6981 K630vaVf tomorrow
+6981 Y5x3JuI3M8jngv5N tomorrow
+6981 YdG61y00526u5 tomorrow
+6981 a3EhVU6Wuy7ycJ7wY7h2gv tomorrow
+6981 o4lvY20511w0EOX3P3I82p63 tomorrow
+6981 o5mb0QP5Y48Qd4vdB0 tomorrow
+6981 sF2CRfgt2K tomorrow
+PREHOOK: query: delete from acid_dap
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dap
+PREHOOK: Input: default@acid_dap@ds=today
+PREHOOK: Input: default@acid_dap@ds=tomorrow
+PREHOOK: Output: default@acid_dap@ds=today
+PREHOOK: Output: default@acid_dap@ds=tomorrow
+POSTHOOK: query: delete from acid_dap
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dap
+POSTHOOK: Input: default@acid_dap@ds=today
+POSTHOOK: Input: default@acid_dap@ds=tomorrow
+POSTHOOK: Output: default@acid_dap@ds=today
+POSTHOOK: Output: default@acid_dap@ds=tomorrow
+PREHOOK: query: select * from acid_dap
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dap
+PREHOOK: Input: default@acid_dap@ds=today
+PREHOOK: Input: default@acid_dap@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dap
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dap
+POSTHOOK: Input: default@acid_dap@ds=today
+POSTHOOK: Input: default@acid_dap@ds=tomorrow
+#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/tez/delete_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_orig_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_orig_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_orig_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,61 @@
+PREHOOK: query: create table acid_dot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+#### A masked pattern was here ####
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dot
+POSTHOOK: query: create table acid_dot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+#### A masked pattern was here ####
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dot
+PREHOOK: query: select count(*) from acid_dot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_dot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dot
+#### A masked pattern was here ####
+12288
+PREHOOK: query: delete from acid_dot where cint < -1070551679
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dot
+PREHOOK: Output: default@acid_dot
+POSTHOOK: query: delete from acid_dot where cint < -1070551679
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dot
+POSTHOOK: Output: default@acid_dot
+PREHOOK: query: select count(*) from acid_dot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_dot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dot
+#### A masked pattern was here ####
+12280
+#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,60 @@
+PREHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dtt
+POSTHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dtt
+PREHOOK: query: insert into table acid_dtt select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dtt
+POSTHOOK: query: insert into table acid_dtt select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dtt
+POSTHOOK: Lineage: acid_dtt.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dtt.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_dtt order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dtt
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dtt order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dtt
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: delete from acid_dtt where b = '0ruyd6Y50JpdGRf6HqD' or b = '2uLyD28144vklju213J1mr'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dtt
+PREHOOK: Output: default@acid_dtt
+POSTHOOK: query: delete from acid_dtt where b = '0ruyd6Y50JpdGRf6HqD' or b = '2uLyD28144vklju213J1mr'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dtt
+POSTHOOK: Output: default@acid_dtt
+PREHOOK: query: select a,b from acid_dtt order by b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dtt
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_dtt order by b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dtt
+#### A masked pattern was here ####
+-1072910839 0iqrc5
+-1073051226 A34p7oRr2WvUJNf
+-1071363017 Anj0oF
+-1071480828 aw724t8c5558x2xneC624
+-1072081801 dPkN74F7
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+-1073279343 oj1YrV5Wa
Added: hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,62 @@
+PREHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dwnm
+POSTHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dwnm
+PREHOOK: query: insert into table acid_dwnm select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwnm
+POSTHOOK: query: insert into table acid_dwnm select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwnm
+POSTHOOK: Lineage: acid_dwnm.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwnm.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_dwnm order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnm
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dwnm order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnm
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: delete from acid_dwnm where b = 'nosuchvalue'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnm
+PREHOOK: Output: default@acid_dwnm
+POSTHOOK: query: delete from acid_dwnm where b = 'nosuchvalue'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnm
+POSTHOOK: Output: default@acid_dwnm
+PREHOOK: query: select a,b from acid_dwnm order by b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnm
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_dwnm order by b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnm
+#### A masked pattern was here ####
+-1072910839 0iqrc5
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1072076362 2uLyD28144vklju213J1mr
+-1073051226 A34p7oRr2WvUJNf
+-1071363017 Anj0oF
+-1071480828 aw724t8c5558x2xneC624
+-1072081801 dPkN74F7
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+-1073279343 oj1YrV5Wa
Added: hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,61 @@
+PREHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dwnp
+POSTHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dwnp
+PREHOOK: query: insert into table acid_dwnp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwnp
+POSTHOOK: query: insert into table acid_dwnp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwnp
+POSTHOOK: Lineage: acid_dwnp.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwnp.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_dwnp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnp
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dwnp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnp
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: delete from acid_dwnp where b = '0ruyd6Y50JpdGRf6HqD'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnp
+PREHOOK: Output: default@acid_dwnp
+POSTHOOK: query: delete from acid_dwnp where b = '0ruyd6Y50JpdGRf6HqD'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnp
+POSTHOOK: Output: default@acid_dwnp
+PREHOOK: query: select a,b from acid_dwnp order by b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_dwnp order by b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnp
+#### A masked pattern was here ####
+-1072910839 0iqrc5
+-1072076362 2uLyD28144vklju213J1mr
+-1073051226 A34p7oRr2WvUJNf
+-1071363017 Anj0oF
+-1071480828 aw724t8c5558x2xneC624
+-1072081801 dPkN74F7
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+-1073279343 oj1YrV5Wa
Added: hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,105 @@
+PREHOOK: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dwp
+POSTHOOK: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dwp
+PREHOOK: query: insert into table acid_dwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwp@ds=today
+POSTHOOK: query: insert into table acid_dwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwp@ds=today
+POSTHOOK: Lineage: acid_dwp PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwp PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_dwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwp@ds=tomorrow
+POSTHOOK: query: insert into table acid_dwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwp@ds=tomorrow
+POSTHOOK: Lineage: acid_dwp PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwp PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b,ds from acid_dwp order by a, ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwp
+PREHOOK: Input: default@acid_dwp@ds=today
+PREHOOK: Input: default@acid_dwp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_dwp order by a, ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwp
+POSTHOOK: Input: default@acid_dwp@ds=today
+POSTHOOK: Input: default@acid_dwp@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073051226 A34p7oRr2WvUJNf today
+-1072910839 0iqrc5 today
+-1072081801 dPkN74F7 today
+-1072076362 2uLyD28144vklju213J1mr today
+-1071480828 aw724t8c5558x2xneC624 today
+-1071363017 Anj0oF today
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070551679 iUR3Q today
+-1069736047 k17Am8uPHWk02cEf1jet today
+-9676535 MmMPCF2 tomorrow
+-9462165 7WLVW6F4h71Dgk7 tomorrow
+-9329892 e7sC5M0H5K6EgSTf41X tomorrow
+-9175632 UUBET8444iJDvjUlq3en tomorrow
+-9011819 A6CX2HDWN8 tomorrow
+-8987676 FhXANp2KDtMmA2gFd778pA tomorrow
+-8413710 81Rg5rR0IaInWw tomorrow
+-8230445 K6J1LIb5 tomorrow
+-7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow
+-6882225 r6gCtT4Tgo5rG tomorrow
+PREHOOK: query: delete from acid_dwp where a = '-1071363017'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwp
+PREHOOK: Input: default@acid_dwp@ds=today
+PREHOOK: Input: default@acid_dwp@ds=tomorrow
+PREHOOK: Output: default@acid_dwp@ds=today
+PREHOOK: Output: default@acid_dwp@ds=tomorrow
+POSTHOOK: query: delete from acid_dwp where a = '-1071363017'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwp
+POSTHOOK: Input: default@acid_dwp@ds=today
+POSTHOOK: Input: default@acid_dwp@ds=tomorrow
+POSTHOOK: Output: default@acid_dwp@ds=today
+POSTHOOK: Output: default@acid_dwp@ds=tomorrow
+PREHOOK: query: select * from acid_dwp order by a, ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwp
+PREHOOK: Input: default@acid_dwp@ds=today
+PREHOOK: Input: default@acid_dwp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dwp order by a, ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwp
+POSTHOOK: Input: default@acid_dwp@ds=today
+POSTHOOK: Input: default@acid_dwp@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073051226 A34p7oRr2WvUJNf today
+-1072910839 0iqrc5 today
+-1072081801 dPkN74F7 today
+-1072076362 2uLyD28144vklju213J1mr today
+-1071480828 aw724t8c5558x2xneC624 today
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070551679 iUR3Q today
+-1069736047 k17Am8uPHWk02cEf1jet today
+-9676535 MmMPCF2 tomorrow
+-9462165 7WLVW6F4h71Dgk7 tomorrow
+-9329892 e7sC5M0H5K6EgSTf41X tomorrow
+-9175632 UUBET8444iJDvjUlq3en tomorrow
+-9011819 A6CX2HDWN8 tomorrow
+-8987676 FhXANp2KDtMmA2gFd778pA tomorrow
+-8413710 81Rg5rR0IaInWw tomorrow
+-8230445 K6J1LIb5 tomorrow
+-7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow
+-6882225 r6gCtT4Tgo5rG tomorrow
Added: hive/trunk/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,92 @@
+PREHOOK: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dwhp
+POSTHOOK: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dwhp
+PREHOOK: query: insert into table acid_dwhp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwhp@ds=today
+POSTHOOK: query: insert into table acid_dwhp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwhp@ds=today
+POSTHOOK: Lineage: acid_dwhp PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwhp PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_dwhp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwhp@ds=tomorrow
+POSTHOOK: query: insert into table acid_dwhp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwhp@ds=tomorrow
+POSTHOOK: Lineage: acid_dwhp PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwhp PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b,ds from acid_dwhp order by a, ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwhp
+PREHOOK: Input: default@acid_dwhp@ds=today
+PREHOOK: Input: default@acid_dwhp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_dwhp order by a, ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwhp
+POSTHOOK: Input: default@acid_dwhp@ds=today
+POSTHOOK: Input: default@acid_dwhp@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073051226 A34p7oRr2WvUJNf today
+-1072910839 0iqrc5 today
+-1072081801 dPkN74F7 today
+-1072076362 2uLyD28144vklju213J1mr today
+-1071480828 aw724t8c5558x2xneC624 today
+-1071363017 Anj0oF today
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070551679 iUR3Q today
+-1069736047 k17Am8uPHWk02cEf1jet today
+-9676535 MmMPCF2 tomorrow
+-9462165 7WLVW6F4h71Dgk7 tomorrow
+-9329892 e7sC5M0H5K6EgSTf41X tomorrow
+-9175632 UUBET8444iJDvjUlq3en tomorrow
+-9011819 A6CX2HDWN8 tomorrow
+-8987676 FhXANp2KDtMmA2gFd778pA tomorrow
+-8413710 81Rg5rR0IaInWw tomorrow
+-8230445 K6J1LIb5 tomorrow
+-7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow
+-6882225 r6gCtT4Tgo5rG tomorrow
+PREHOOK: query: delete from acid_dwhp where ds = 'today'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwhp
+PREHOOK: Input: default@acid_dwhp@ds=today
+PREHOOK: Output: default@acid_dwhp@ds=today
+POSTHOOK: query: delete from acid_dwhp where ds = 'today'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwhp
+POSTHOOK: Input: default@acid_dwhp@ds=today
+POSTHOOK: Output: default@acid_dwhp@ds=today
+PREHOOK: query: select * from acid_dwhp order by a, ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwhp
+PREHOOK: Input: default@acid_dwhp@ds=today
+PREHOOK: Input: default@acid_dwhp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dwhp order by a, ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwhp
+POSTHOOK: Input: default@acid_dwhp@ds=today
+POSTHOOK: Input: default@acid_dwhp@ds=tomorrow
+#### A masked pattern was here ####
+-9676535 MmMPCF2 tomorrow
+-9462165 7WLVW6F4h71Dgk7 tomorrow
+-9329892 e7sC5M0H5K6EgSTf41X tomorrow
+-9175632 UUBET8444iJDvjUlq3en tomorrow
+-9011819 A6CX2HDWN8 tomorrow
+-8987676 FhXANp2KDtMmA2gFd778pA tomorrow
+-8413710 81Rg5rR0IaInWw tomorrow
+-8230445 K6J1LIb5 tomorrow
+-7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow
+-6882225 r6gCtT4Tgo5rG tomorrow
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,80 @@
+PREHOOK: query: create table acid_iot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_iot
+POSTHOOK: query: create table acid_iot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_iot
+PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_iot
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@acid_iot
+POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_iot
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@acid_iot
+PREHOOK: query: select count(*) from acid_iot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_iot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iot
+#### A masked pattern was here ####
+12288
+PREHOOK: query: insert into table acid_iot select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2,
+ cboolean1, cboolean2 from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_iot
+POSTHOOK: query: insert into table acid_iot select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2,
+ cboolean1, cboolean2 from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_iot
+POSTHOOK: Lineage: acid_iot.cbigint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cboolean1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cboolean1, type:boolean, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cboolean2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cboolean2, type:boolean, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cdouble SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cdouble, type:double, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cfloat SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_iot.csmallint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:csmallint, type:smallint, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cstring1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cstring2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring2, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_iot.ctimestamp1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: acid_iot.ctimestamp2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: acid_iot.ctinyint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
+PREHOOK: query: select count(*) from acid_iot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_iot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iot
+#### A masked pattern was here ####
+12298
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,78 @@
+PREHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_iud
+POSTHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_iud
+PREHOOK: query: insert into table acid_iud select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_iud
+POSTHOOK: query: insert into table acid_iud select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_iud
+POSTHOOK: Lineage: acid_iud.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_iud.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_iud order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_iud order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: update acid_iud set b = 'fred'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+PREHOOK: Output: default@acid_iud
+POSTHOOK: query: update acid_iud set b = 'fred'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+POSTHOOK: Output: default@acid_iud
+PREHOOK: query: select a,b from acid_iud order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_iud order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+-1073279343 fred
+-1073051226 fred
+-1072910839 fred
+-1072081801 fred
+-1072076362 fred
+-1071480828 fred
+-1071363017 fred
+-1070883071 fred
+-1070551679 fred
+-1069736047 fred
+PREHOOK: query: delete from acid_iud
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+PREHOOK: Output: default@acid_iud
+POSTHOOK: query: delete from acid_iud
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+POSTHOOK: Output: default@acid_iud
+PREHOOK: query: select a,b from acid_iud order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_iud order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,45 @@
+PREHOOK: query: create table ivdp(i int,
+ de decimal(5,2),
+ vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ivdp
+POSTHOOK: query: create table ivdp(i int,
+ de decimal(5,2),
+ vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@ivdp
+PREHOOK: query: insert into table ivdp partition (ds) values
+ (1, 109.23, 'and everywhere that mary went', 'today'),
+ (6553, 923.19, 'the lamb was sure to go', 'tomorrow')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@ivdp
+POSTHOOK: query: insert into table ivdp partition (ds) values
+ (1, 109.23, 'and everywhere that mary went', 'today'),
+ (6553, 923.19, 'the lamb was sure to go', 'tomorrow')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@ivdp@ds=today
+POSTHOOK: Output: default@ivdp@ds=tomorrow
+POSTHOOK: Lineage: ivdp PARTITION(ds=today).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=today).i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=today).vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=tomorrow).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=tomorrow).i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=tomorrow).vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+PREHOOK: query: select * from ivdp order by ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ivdp
+PREHOOK: Input: default@ivdp@ds=today
+PREHOOK: Input: default@ivdp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from ivdp order by ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ivdp
+POSTHOOK: Input: default@ivdp@ds=today
+POSTHOOK: Input: default@ivdp@ds=tomorrow
+#### A masked pattern was here ####
+1 109.23 and everywhere that mary went today
+6553 923.19 the lamb was sure to go tomorrow
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,64 @@
+PREHOOK: query: create table acid_ivnp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) clustered by (i) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_ivnp
+POSTHOOK: query: create table acid_ivnp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) clustered by (i) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_ivnp
+PREHOOK: query: insert into table acid_ivnp values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_ivnp
+POSTHOOK: query: insert into table acid_ivnp values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_ivnp
+POSTHOOK: Lineage: acid_ivnp.bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.d EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.f EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.si EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.t EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.ti EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
+PREHOOK: query: select ti, si, i, bi, f, d, de, t, dt, s, vc, ch from acid_ivnp order by ti
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivnp
+#### A masked pattern was here ####
+POSTHOOK: query: select ti, si, i, bi, f, d, de, t, dt, s, vc, ch from acid_ivnp order by ti
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivnp
+#### A masked pattern was here ####
+1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 mary had a little lamb ring around the rosie red
+3 25 6553 429496729 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 its fleece was white as snow a pocket full of posies blue
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,82 @@
+PREHOOK: query: create table acid_ivot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_ivot
+POSTHOOK: query: create table acid_ivot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_ivot
+PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@acid_ivot
+POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@acid_ivot
+PREHOOK: query: select count(*) from acid_ivot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_ivot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivot
+#### A masked pattern was here ####
+12288
+PREHOOK: query: insert into table acid_ivot values
+ (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
+ (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_ivot
+POSTHOOK: query: insert into table acid_ivot values
+ (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
+ (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_ivot
+POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cboolean2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cdouble EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cfloat EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.csmallint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.ctimestamp1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.ctimestamp2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.ctinyint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+PREHOOK: query: select count(*) from acid_ivot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_ivot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivot
+#### A masked pattern was here ####
+12290
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,66 @@
+PREHOOK: query: create table acid_ivp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_ivp
+POSTHOOK: query: create table acid_ivp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_ivp
+PREHOOK: query: insert into table acid_ivp partition (ds='today') values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_ivp@ds=today
+POSTHOOK: query: insert into table acid_ivp partition (ds='today') values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_ivp@ds=today
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).d EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).f EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).si EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).t EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).ti EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
+PREHOOK: query: select * from acid_ivp order by i
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivp
+PREHOOK: Input: default@acid_ivp@ds=today
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_ivp order by i
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivp
+POSTHOOK: Input: default@acid_ivp@ds=today
+#### A masked pattern was here ####
+3 25 6553 429496729 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 its fleece was white as snow a pocket full of posies blue today
+1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 mary had a little lamb ring around the rosie red today
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,33 @@
+PREHOOK: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_ivtt
+POSTHOOK: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_ivtt
+PREHOOK: query: insert into table acid_ivtt values
+ (1, 109.23, 'mary had a little lamb'),
+ (429496729, 0.14, 'its fleece was white as snow')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_ivtt
+POSTHOOK: query: insert into table acid_ivtt values
+ (1, 109.23, 'mary had a little lamb'),
+ (429496729, 0.14, 'its fleece was white as snow')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_ivtt
+POSTHOOK: Lineage: acid_ivtt.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivtt.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivtt.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+PREHOOK: query: select i, de, vc from acid_ivtt order by i
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivtt
+#### A masked pattern was here ####
+POSTHOOK: query: select i, de, vc from acid_ivtt order by i
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivtt
+#### A masked pattern was here ####
+1 109.23 mary had a little lamb
+429496729 0.14 its fleece was white as snow
Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_after_multiple_inserts.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_after_multiple_inserts.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_after_multiple_inserts.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_after_multiple_inserts.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,74 @@
+PREHOOK: query: create table acid_uami(i int,
+ de decimal(5,2),
+ vc varchar(128)) clustered by (i) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_uami
+POSTHOOK: query: create table acid_uami(i int,
+ de decimal(5,2),
+ vc varchar(128)) clustered by (i) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_uami
+PREHOOK: query: insert into table acid_uami values
+ (1, 109.23, 'mary had a little lamb'),
+ (6553, 923.19, 'its fleece was white as snow')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_uami
+POSTHOOK: query: insert into table acid_uami values
+ (1, 109.23, 'mary had a little lamb'),
+ (6553, 923.19, 'its fleece was white as snow')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_uami
+POSTHOOK: Lineage: acid_uami.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_uami.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_uami.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+PREHOOK: query: insert into table acid_uami values
+ (10, 119.23, 'and everywhere that mary went'),
+ (65530, 823.19, 'the lamb was sure to go')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__2
+PREHOOK: Output: default@acid_uami
+POSTHOOK: query: insert into table acid_uami values
+ (10, 119.23, 'and everywhere that mary went'),
+ (65530, 823.19, 'the lamb was sure to go')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__2
+POSTHOOK: Output: default@acid_uami
+POSTHOOK: Lineage: acid_uami.de EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_uami.i EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_uami.vc EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+PREHOOK: query: select * from acid_uami order by de
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uami
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_uami order by de
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uami
+#### A masked pattern was here ####
+1 109.23 mary had a little lamb
+10 119.23 and everywhere that mary went
+65530 823.19 the lamb was sure to go
+6553 923.19 its fleece was white as snow
+PREHOOK: query: update acid_uami set de = 3.14 where de = 109.23 or de = 119.23
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uami
+PREHOOK: Output: default@acid_uami
+POSTHOOK: query: update acid_uami set de = 3.14 where de = 109.23 or de = 119.23
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uami
+POSTHOOK: Output: default@acid_uami
+PREHOOK: query: select * from acid_uami order by de
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uami
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_uami order by de
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uami
+#### A masked pattern was here ####
+1 3.14 mary had a little lamb
+10 3.14 and everywhere that mary went
+65530 823.19 the lamb was sure to go
+6553 923.19 its fleece was white as snow
Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_all_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_all_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_all_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_all_non_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,62 @@
+PREHOOK: query: create table acid_uanp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_uanp
+POSTHOOK: query: create table acid_uanp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_uanp
+PREHOOK: query: insert into table acid_uanp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_uanp
+POSTHOOK: query: insert into table acid_uanp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_uanp
+POSTHOOK: Lineage: acid_uanp.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uanp.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_uanp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uanp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_uanp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uanp
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: update acid_uanp set b = 'fred'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uanp
+PREHOOK: Output: default@acid_uanp
+POSTHOOK: query: update acid_uanp set b = 'fred'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uanp
+POSTHOOK: Output: default@acid_uanp
+PREHOOK: query: select a,b from acid_uanp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uanp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_uanp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uanp
+#### A masked pattern was here ####
+-1073279343 fred
+-1073051226 fred
+-1072910839 fred
+-1072081801 fred
+-1072076362 fred
+-1071480828 fred
+-1071363017 fred
+-1070883071 fred
+-1070551679 fred
+-1069736047 fred
Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,106 @@
+PREHOOK: query: create table acid_uap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_uap
+POSTHOOK: query: create table acid_uap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_uap
+PREHOOK: query: insert into table acid_uap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_uap@ds=today
+POSTHOOK: query: insert into table acid_uap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_uap@ds=today
+POSTHOOK: Lineage: acid_uap PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uap PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_uap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 10 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_uap@ds=tomorrow
+POSTHOOK: query: insert into table acid_uap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 10 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_uap@ds=tomorrow
+POSTHOOK: Lineage: acid_uap PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uap PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b,ds from acid_uap order by a,b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uap
+PREHOOK: Input: default@acid_uap@ds=today
+PREHOOK: Input: default@acid_uap@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_uap order by a,b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uap
+POSTHOOK: Input: default@acid_uap@ds=today
+POSTHOOK: Input: default@acid_uap@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073051226 A34p7oRr2WvUJNf today
+-1072910839 0iqrc5 today
+-1072081801 dPkN74F7 today
+-1072076362 2uLyD28144vklju213J1mr today
+-1071480828 aw724t8c5558x2xneC624 today
+-1071363017 Anj0oF today
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070551679 iUR3Q today
+-1069736047 k17Am8uPHWk02cEf1jet today
+762 3WsVeqb28VWEEOLI8ail tomorrow
+762 40ks5556SV tomorrow
+762 BLoMwUJ51ns6pd tomorrow
+762 a10E76jX35YwquKCTA tomorrow
+762 q5y2Vy1 tomorrow
+6981 1FNNhmiFLGw425NA13g tomorrow
+6981 K630vaVf tomorrow
+6981 YdG61y00526u5 tomorrow
+6981 a3EhVU6Wuy7ycJ7wY7h2gv tomorrow
+6981 o4lvY20511w0EOX3P3I82p63 tomorrow
+PREHOOK: query: update acid_uap set b = 'fred'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uap
+PREHOOK: Input: default@acid_uap@ds=today
+PREHOOK: Input: default@acid_uap@ds=tomorrow
+PREHOOK: Output: default@acid_uap@ds=today
+PREHOOK: Output: default@acid_uap@ds=tomorrow
+POSTHOOK: query: update acid_uap set b = 'fred'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uap
+POSTHOOK: Input: default@acid_uap@ds=today
+POSTHOOK: Input: default@acid_uap@ds=tomorrow
+POSTHOOK: Output: default@acid_uap@ds=today
+POSTHOOK: Output: default@acid_uap@ds=tomorrow
+PREHOOK: query: select a,b,ds from acid_uap order by a,b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uap
+PREHOOK: Input: default@acid_uap@ds=today
+PREHOOK: Input: default@acid_uap@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_uap order by a,b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uap
+POSTHOOK: Input: default@acid_uap@ds=today
+POSTHOOK: Input: default@acid_uap@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 fred today
+-1073051226 fred today
+-1072910839 fred today
+-1072081801 fred today
+-1072076362 fred today
+-1071480828 fred today
+-1071363017 fred today
+-1070883071 fred today
+-1070551679 fred today
+-1069736047 fred today
+762 fred tomorrow
+762 fred tomorrow
+762 fred tomorrow
+762 fred tomorrow
+762 fred tomorrow
+6981 fred tomorrow
+6981 fred tomorrow
+6981 fred tomorrow
+6981 fred tomorrow
+6981 fred tomorrow
Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_all_types.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_all_types.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_all_types.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_all_types.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,153 @@
+PREHOOK: query: create table acid_uat(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(36),
+ b boolean) clustered by (i) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_uat
+POSTHOOK: query: create table acid_uat(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(36),
+ b boolean) clustered by (i) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_uat
+PREHOOK: query: insert into table acid_uat
+ select ctinyint,
+ csmallint,
+ cint,
+ cbigint,
+ cfloat,
+ cdouble,
+ cast(cfloat as decimal(5,2)),
+ ctimestamp1,
+ cast(ctimestamp2 as date),
+ cstring1,
+ cast(cstring1 as varchar(128)),
+ cast(cstring2 as char(36)),
+ cboolean1
+ from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_uat
+POSTHOOK: query: insert into table acid_uat
+ select ctinyint,
+ csmallint,
+ cint,
+ cbigint,
+ cfloat,
+ cdouble,
+ cast(cfloat as decimal(5,2)),
+ ctimestamp1,
+ cast(ctimestamp2 as date),
+ cstring1,
+ cast(cstring1 as varchar(128)),
+ cast(cstring2 as char(36)),
+ cboolean1
+ from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_uat
+POSTHOOK: Lineage: acid_uat.b SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cboolean1, type:boolean, comment:null), ]
+POSTHOOK: Lineage: acid_uat.bi SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ]
+POSTHOOK: Lineage: acid_uat.ch EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring2, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_uat.d SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cdouble, type:double, comment:null), ]
+POSTHOOK: Lineage: acid_uat.de EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ]
+POSTHOOK: Lineage: acid_uat.dt EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: acid_uat.f SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ]
+POSTHOOK: Lineage: acid_uat.i SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uat.s SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_uat.si SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:csmallint, type:smallint, comment:null), ]
+POSTHOOK: Lineage: acid_uat.t SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: acid_uat.ti SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
+POSTHOOK: Lineage: acid_uat.vc EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_uat order by i
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uat
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_uat order by i
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uat
+#### A masked pattern was here ####
+11 NULL -1073279343 -1595604468 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
+NULL -7382 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1970-01-01 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false
+11 NULL -1072910839 2048385991 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
+NULL 8373 -1072081801 1864027286 NULL 8373.0 NULL NULL 1970-01-01 dPkN74F7 dPkN74F7 4KWs6gw7lv2WYd66P true
+NULL -5470 -1072076362 1864027286 NULL -5470.0 NULL NULL 1970-01-01 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true
+-51 NULL -1071480828 -1401575336 -51.0 NULL -51.0 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
+8 NULL -1071363017 1349676361 8.0 NULL 8.0 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
+NULL -741 -1070883071 -1645852809 NULL -741.0 NULL NULL 1970-01-01 0ruyd6Y50JpdGRf6HqD 0ruyd6Y50JpdGRf6HqD xH7445Rals48VOulSyR5F false
+NULL -947 -1070551679 1864027286 NULL -947.0 NULL NULL 1970-01-01 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false
+11 NULL -1069736047 -453772520 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
+PREHOOK: query: update acid_uat set
+ ti = 1,
+ si = 2,
+ i = 3,
+ bi = 4,
+ f = 3.14,
+ d = 6.28,
+ de = 5.99,
+ t = '2014-09-01 09:44.23.23',
+ dt = '2014-09-01',
+ s = 'its a beautiful day in the neighbhorhood',
+ vc = 'a beautiful day for a neighbor',
+ ch = 'wont you be mine',
+ b = true
+ where s = '0ruyd6Y50JpdGRf6HqD'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uat
+PREHOOK: Output: default@acid_uat
+POSTHOOK: query: update acid_uat set
+ ti = 1,
+ si = 2,
+ i = 3,
+ bi = 4,
+ f = 3.14,
+ d = 6.28,
+ de = 5.99,
+ t = '2014-09-01 09:44.23.23',
+ dt = '2014-09-01',
+ s = 'its a beautiful day in the neighbhorhood',
+ vc = 'a beautiful day for a neighbor',
+ ch = 'wont you be mine',
+ b = true
+ where s = '0ruyd6Y50JpdGRf6HqD'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uat
+POSTHOOK: Output: default@acid_uat
+PREHOOK: query: select * from acid_uat order by i
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uat
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_uat order by i
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uat
+#### A masked pattern was here ####
+11 NULL -1073279343 -1595604468 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL oj1YrV5Wa oj1YrV5Wa P76636jJ6qM17d7DIy true
+NULL -7382 -1073051226 -1887561756 NULL -7382.0 NULL NULL 1970-01-01 A34p7oRr2WvUJNf A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d false
+11 NULL -1072910839 2048385991 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL 0iqrc5 0iqrc5 KbaDXiN85adbHRx58v false
+NULL 8373 -1072081801 1864027286 NULL 8373.0 NULL NULL 1970-01-01 dPkN74F7 dPkN74F7 4KWs6gw7lv2WYd66P true
+NULL -5470 -1072076362 1864027286 NULL -5470.0 NULL NULL 1970-01-01 2uLyD28144vklju213J1mr 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P true
+-51 NULL -1071480828 -1401575336 -51.0 NULL -51.0 1969-12-31 16:00:08.451 NULL aw724t8c5558x2xneC624 aw724t8c5558x2xneC624 4uE7l74tESBiKfu7c8wM7GA true
+8 NULL -1071363017 1349676361 8.0 NULL 8.0 1969-12-31 16:00:15.892 NULL Anj0oF Anj0oF IwE1G7Qb0B1NEfV030g true
+NULL -947 -1070551679 1864027286 NULL -947.0 NULL NULL 1970-01-01 iUR3Q iUR3Q 4KWs6gw7lv2WYd66P false
+11 NULL -1069736047 -453772520 11.0 NULL 11.0 1969-12-31 16:00:02.351 NULL k17Am8uPHWk02cEf1jet k17Am8uPHWk02cEf1jet qrXLLNX1 true
+1 2 3 4 3.14 6.28 5.99 NULL 2014-09-01 its a beautiful day in the neighbhorhood a beautiful day for a neighbor wont you be mine true
Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_orig_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_orig_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_orig_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,59 @@
+PREHOOK: query: create table acid_uot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+#### A masked pattern was here ####
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_uot
+POSTHOOK: query: create table acid_uot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+#### A masked pattern was here ####
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_uot
+PREHOOK: query: update acid_uot set cstring1 = 'fred' where cint < -1070551679
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uot
+PREHOOK: Output: default@acid_uot
+POSTHOOK: query: update acid_uot set cstring1 = 'fred' where cint < -1070551679
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uot
+POSTHOOK: Output: default@acid_uot
+PREHOOK: query: select * from acid_uot where cstring1 = 'fred'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uot
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_uot where cstring1 = 'fred'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uot
+#### A masked pattern was here ####
+-51 NULL -1071480828 -1401575336 -51.0 NULL fred 4uE7l74tESBiKfu7c8wM7GA 1969-12-31 16:00:08.451 NULL true true
+NULL -5470 -1072076362 1864027286 NULL -5470.0 fred 4KWs6gw7lv2WYd66P NULL 1969-12-31 16:00:01.836 true true
+NULL 8373 -1072081801 1864027286 NULL 8373.0 fred 4KWs6gw7lv2WYd66P NULL 1969-12-31 15:59:56.465 true true
+8 NULL -1071363017 1349676361 8.0 NULL fred IwE1G7Qb0B1NEfV030g 1969-12-31 16:00:15.892 NULL true true
+NULL -7382 -1073051226 -1887561756 NULL -7382.0 fred 4hA4KQj2vD3fI6gX82220d NULL 1969-12-31 16:00:10.331 false false
+11 NULL -1073279343 -1595604468 11.0 NULL fred P76636jJ6qM17d7DIy 1969-12-31 16:00:02.351 NULL true true
+11 NULL -1072910839 2048385991 11.0 NULL fred KbaDXiN85adbHRx58v 1969-12-31 16:00:02.351 NULL false false
+NULL -741 -1070883071 -1645852809 NULL -741.0 fred xH7445Rals48VOulSyR5F NULL 1969-12-31 15:59:51.293 false false
+#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_tmp_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_tmp_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_tmp_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,62 @@
+PREHOOK: query: create table acid_utt(a int, b varchar(128)) clustered by (b) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_utt
+POSTHOOK: query: create table acid_utt(a int, b varchar(128)) clustered by (b) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_utt
+PREHOOK: query: insert into table acid_utt select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_utt
+POSTHOOK: query: insert into table acid_utt select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_utt
+POSTHOOK: Lineage: acid_utt.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_utt.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_utt order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_utt
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_utt order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_utt
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: update acid_utt set b = 'fred' where b = '0ruyd6Y50JpdGRf6HqD'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_utt
+PREHOOK: Output: default@acid_utt
+POSTHOOK: query: update acid_utt set b = 'fred' where b = '0ruyd6Y50JpdGRf6HqD'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_utt
+POSTHOOK: Output: default@acid_utt
+PREHOOK: query: select * from acid_utt order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_utt
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_utt order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_utt
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 fred
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet