hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ga...@apache.org
Subject svn commit: r1624788 [5/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...
Date Sat, 13 Sep 2014 22:09:33 GMT
Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_two_cols.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_two_cols.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_two_cols.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_two_cols.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,63 @@
+PREHOOK: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_utc
+POSTHOOK: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_utc
+PREHOOK: query: insert into table acid_utc select cint, cast(cstring1 as varchar(128)), cfloat from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_utc
+POSTHOOK: query: insert into table acid_utc select cint, cast(cstring1 as varchar(128)), cfloat from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_utc
+POSTHOOK: Lineage: acid_utc.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_utc.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_utc.c SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ]
+PREHOOK: query: select * from acid_utc order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_utc
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_utc order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_utc
+#### A masked pattern was here ####
+-1073279343	oj1YrV5Wa	11.0
+-1073051226	A34p7oRr2WvUJNf	NULL
+-1072910839	0iqrc5	11.0
+-1072081801	dPkN74F7	NULL
+-1072076362	2uLyD28144vklju213J1mr	NULL
+-1071480828	aw724t8c5558x2xneC624	-51.0
+-1071363017	Anj0oF	8.0
+-1070883071	0ruyd6Y50JpdGRf6HqD	NULL
+-1070551679	iUR3Q	NULL
+-1069736047	k17Am8uPHWk02cEf1jet	11.0
+PREHOOK: query: update acid_utc set b = 'fred',c = 3.14
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_utc
+PREHOOK: Output: default@acid_utc
+POSTHOOK: query: update acid_utc set b = 'fred',c = 3.14
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_utc
+POSTHOOK: Output: default@acid_utc
+PREHOOK: query: select * from acid_utc order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_utc
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_utc order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_utc
+#### A masked pattern was here ####
+-1073279343	fred	3.14
+-1073051226	fred	3.14
+-1072910839	fred	3.14
+-1072081801	fred	3.14
+-1072076362	fred	3.14
+-1071480828	fred	3.14
+-1071363017	fred	3.14
+-1070883071	fred	3.14
+-1070551679	fred	3.14
+-1069736047	fred	3.14

Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_where_no_match.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_where_no_match.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_where_no_match.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_where_no_match.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,62 @@
+PREHOOK: query: create table acid_wnm(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_wnm
+POSTHOOK: query: create table acid_wnm(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_wnm
+PREHOOK: query: insert into table acid_wnm 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_wnm
+POSTHOOK: query: insert into table acid_wnm 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_wnm
+POSTHOOK: Lineage: acid_wnm.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_wnm.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_wnm order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_wnm
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_wnm order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_wnm
+#### 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_wnm set b = 'fred' where b = 'nosuchvalue'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_wnm
+PREHOOK: Output: default@acid_wnm
+POSTHOOK: query: update acid_wnm set b = 'fred' where b = 'nosuchvalue'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_wnm
+POSTHOOK: Output: default@acid_wnm
+PREHOOK: query: select * from acid_wnm order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_wnm
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_wnm order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_wnm
+#### 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

Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_where_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_where_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_where_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_where_non_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,62 @@
+PREHOOK: query: create table acid_uwnp(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_uwnp
+POSTHOOK: query: create table acid_uwnp(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_uwnp
+PREHOOK: query: insert into table acid_uwnp 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_uwnp
+POSTHOOK: query: insert into table acid_uwnp 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_uwnp
+POSTHOOK: Lineage: acid_uwnp.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uwnp.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_uwnp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwnp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_uwnp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwnp
+#### 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_uwnp set b = 'fred' where b = '0ruyd6Y50JpdGRf6HqD'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwnp
+PREHOOK: Output: default@acid_uwnp
+POSTHOOK: query: update acid_uwnp set b = 'fred' where b = '0ruyd6Y50JpdGRf6HqD'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwnp
+POSTHOOK: Output: default@acid_uwnp
+PREHOOK: query: select * from acid_uwnp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwnp
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_uwnp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwnp
+#### 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

Added: hive/trunk/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,106 @@
+PREHOOK: query: create table acid_uwp(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_uwp
+POSTHOOK: query: create table acid_uwp(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_uwp
+PREHOOK: query: insert into table acid_uwp 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_uwp@ds=today
+POSTHOOK: query: insert into table acid_uwp 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_uwp@ds=today
+POSTHOOK: Lineage: acid_uwp PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uwp PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_uwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 100 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_uwp@ds=tomorrow
+POSTHOOK: query: insert into table acid_uwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 100 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_uwp@ds=tomorrow
+POSTHOOK: Lineage: acid_uwp PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uwp PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b,ds from acid_uwp order by a, ds, b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwp
+PREHOOK: Input: default@acid_uwp@ds=today
+PREHOOK: Input: default@acid_uwp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_uwp order by a, ds, b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwp
+POSTHOOK: Input: default@acid_uwp@ds=today
+POSTHOOK: Input: default@acid_uwp@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_uwp set b = 'fred' where b = 'k17Am8uPHWk02cEf1jet'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwp
+PREHOOK: Input: default@acid_uwp@ds=today
+PREHOOK: Input: default@acid_uwp@ds=tomorrow
+PREHOOK: Output: default@acid_uwp@ds=today
+PREHOOK: Output: default@acid_uwp@ds=tomorrow
+POSTHOOK: query: update acid_uwp set b = 'fred' where b = 'k17Am8uPHWk02cEf1jet'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwp
+POSTHOOK: Input: default@acid_uwp@ds=today
+POSTHOOK: Input: default@acid_uwp@ds=tomorrow
+POSTHOOK: Output: default@acid_uwp@ds=today
+POSTHOOK: Output: default@acid_uwp@ds=tomorrow
+PREHOOK: query: select * from acid_uwp order by a, ds, b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwp
+PREHOOK: Input: default@acid_uwp@ds=today
+PREHOOK: Input: default@acid_uwp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_uwp order by a, ds, b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwp
+POSTHOOK: Input: default@acid_uwp@ds=today
+POSTHOOK: Input: default@acid_uwp@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	fred	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

Added: hive/trunk/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/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/update_all_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_all_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_all_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/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/update_all_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_all_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_all_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/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/update_all_types.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_all_types.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_all_types.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/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/update_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_orig_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_orig_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/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/update_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_tmp_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_tmp_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/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

Added: hive/trunk/ql/src/test/results/clientpositive/update_two_cols.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_two_cols.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_two_cols.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/update_two_cols.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,63 @@
+PREHOOK: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_utc
+POSTHOOK: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_utc
+PREHOOK: query: insert into table acid_utc select cint, cast(cstring1 as varchar(128)), cfloat from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_utc
+POSTHOOK: query: insert into table acid_utc select cint, cast(cstring1 as varchar(128)), cfloat from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_utc
+POSTHOOK: Lineage: acid_utc.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_utc.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_utc.c SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ]
+PREHOOK: query: select * from acid_utc order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_utc
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_utc order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_utc
+#### A masked pattern was here ####
+-1073279343	oj1YrV5Wa	11.0
+-1073051226	A34p7oRr2WvUJNf	NULL
+-1072910839	0iqrc5	11.0
+-1072081801	dPkN74F7	NULL
+-1072076362	2uLyD28144vklju213J1mr	NULL
+-1071480828	aw724t8c5558x2xneC624	-51.0
+-1071363017	Anj0oF	8.0
+-1070883071	0ruyd6Y50JpdGRf6HqD	NULL
+-1070551679	iUR3Q	NULL
+-1069736047	k17Am8uPHWk02cEf1jet	11.0
+PREHOOK: query: update acid_utc set b = 'fred',c = 3.14
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_utc
+PREHOOK: Output: default@acid_utc
+POSTHOOK: query: update acid_utc set b = 'fred',c = 3.14
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_utc
+POSTHOOK: Output: default@acid_utc
+PREHOOK: query: select * from acid_utc order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_utc
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_utc order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_utc
+#### A masked pattern was here ####
+-1073279343	fred	3.14
+-1073051226	fred	3.14
+-1072910839	fred	3.14
+-1072081801	fred	3.14
+-1072076362	fred	3.14
+-1071480828	fred	3.14
+-1071363017	fred	3.14
+-1070883071	fred	3.14
+-1070551679	fred	3.14
+-1069736047	fred	3.14

Added: hive/trunk/ql/src/test/results/clientpositive/update_where_no_match.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_where_no_match.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_where_no_match.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/update_where_no_match.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,62 @@
+PREHOOK: query: create table acid_wnm(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_wnm
+POSTHOOK: query: create table acid_wnm(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_wnm
+PREHOOK: query: insert into table acid_wnm 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_wnm
+POSTHOOK: query: insert into table acid_wnm 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_wnm
+POSTHOOK: Lineage: acid_wnm.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_wnm.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_wnm order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_wnm
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_wnm order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_wnm
+#### 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_wnm set b = 'fred' where b = 'nosuchvalue'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_wnm
+PREHOOK: Output: default@acid_wnm
+POSTHOOK: query: update acid_wnm set b = 'fred' where b = 'nosuchvalue'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_wnm
+POSTHOOK: Output: default@acid_wnm
+PREHOOK: query: select * from acid_wnm order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_wnm
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_wnm order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_wnm
+#### 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

Added: hive/trunk/ql/src/test/results/clientpositive/update_where_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_where_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_where_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/update_where_non_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,62 @@
+PREHOOK: query: create table acid_uwnp(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_uwnp
+POSTHOOK: query: create table acid_uwnp(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_uwnp
+PREHOOK: query: insert into table acid_uwnp 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_uwnp
+POSTHOOK: query: insert into table acid_uwnp 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_uwnp
+POSTHOOK: Lineage: acid_uwnp.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uwnp.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_uwnp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwnp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_uwnp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwnp
+#### 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_uwnp set b = 'fred' where b = '0ruyd6Y50JpdGRf6HqD'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwnp
+PREHOOK: Output: default@acid_uwnp
+POSTHOOK: query: update acid_uwnp set b = 'fred' where b = '0ruyd6Y50JpdGRf6HqD'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwnp
+POSTHOOK: Output: default@acid_uwnp
+PREHOOK: query: select * from acid_uwnp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwnp
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_uwnp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwnp
+#### 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

Added: hive/trunk/ql/src/test/results/clientpositive/update_where_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/update_where_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_where_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/update_where_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,106 @@
+PREHOOK: query: create table acid_uwp(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_uwp
+POSTHOOK: query: create table acid_uwp(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_uwp
+PREHOOK: query: insert into table acid_uwp 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_uwp@ds=today
+POSTHOOK: query: insert into table acid_uwp 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_uwp@ds=today
+POSTHOOK: Lineage: acid_uwp PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uwp PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_uwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 100 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_uwp@ds=tomorrow
+POSTHOOK: query: insert into table acid_uwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 100 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_uwp@ds=tomorrow
+POSTHOOK: Lineage: acid_uwp PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_uwp PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b,ds from acid_uwp order by a, ds, b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwp
+PREHOOK: Input: default@acid_uwp@ds=today
+PREHOOK: Input: default@acid_uwp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_uwp order by a, ds, b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwp
+POSTHOOK: Input: default@acid_uwp@ds=today
+POSTHOOK: Input: default@acid_uwp@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_uwp set b = 'fred' where b = 'k17Am8uPHWk02cEf1jet'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwp
+PREHOOK: Input: default@acid_uwp@ds=today
+PREHOOK: Input: default@acid_uwp@ds=tomorrow
+PREHOOK: Output: default@acid_uwp@ds=today
+PREHOOK: Output: default@acid_uwp@ds=tomorrow
+POSTHOOK: query: update acid_uwp set b = 'fred' where b = 'k17Am8uPHWk02cEf1jet'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwp
+POSTHOOK: Input: default@acid_uwp@ds=today
+POSTHOOK: Input: default@acid_uwp@ds=tomorrow
+POSTHOOK: Output: default@acid_uwp@ds=today
+POSTHOOK: Output: default@acid_uwp@ds=tomorrow
+PREHOOK: query: select * from acid_uwp order by a, ds, b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_uwp
+PREHOOK: Input: default@acid_uwp@ds=today
+PREHOOK: Input: default@acid_uwp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_uwp order by a, ds, b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_uwp
+POSTHOOK: Input: default@acid_uwp@ds=today
+POSTHOOK: Input: default@acid_uwp@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	fred	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



Mime
View raw message