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 [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...
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