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 [3/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/queries/clientpositive/delete_whole_partition.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/delete_whole_partition.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/delete_whole_partition.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/delete_whole_partition.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,16 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+set hive.mapred.supports.subdirectories=true;
+
+create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc;
+
+insert into table acid_dwhp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10;
+insert into table acid_dwhp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10;
+
+select a,b,ds from acid_dwhp order by a, ds;
+
+delete from acid_dwhp where ds = 'today';
+
+select * from acid_dwhp order by a, ds;
Added: hive/trunk/ql/src/test/queries/clientpositive/insert_orig_table.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/insert_orig_table.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/insert_orig_table.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/insert_orig_table.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,28 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+create table acid_iot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc;
+
+LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_iot;
+
+select count(*) from acid_iot;
+
+insert into table acid_iot select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2,
+ cboolean1, cboolean2 from alltypesorc where cint < 0 order by cint limit 10;
+
+select count(*) from acid_iot;
+
Added: hive/trunk/ql/src/test/queries/clientpositive/insert_update_delete.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/insert_update_delete.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/insert_update_delete.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/insert_update_delete.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,20 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+set hive.mapred.supports.subdirectories=true;
+
+create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc;
+
+insert into table acid_iud select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10;
+
+select a,b from acid_iud order by a;
+
+update acid_iud set b = 'fred';
+
+select a,b from acid_iud order by a;
+
+delete from acid_iud;
+
+select a,b from acid_iud order by a;
+
Added: hive/trunk/ql/src/test/queries/clientpositive/insert_values_dynamic_partitioned.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/insert_values_dynamic_partitioned.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/insert_values_dynamic_partitioned.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/insert_values_dynamic_partitioned.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,16 @@
+set hive.exec.dynamic.partition.mode=nonstrict;
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+set hive.mapred.supports.subdirectories=true;
+
+create table ivdp(i int,
+ de decimal(5,2),
+ vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc;
+
+insert into table ivdp partition (ds) values
+ (1, 109.23, 'and everywhere that mary went', 'today'),
+ (6553, 923.19, 'the lamb was sure to go', 'tomorrow');
+
+select * from ivdp order by ds;
Added: hive/trunk/ql/src/test/queries/clientpositive/insert_values_non_partitioned.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/insert_values_non_partitioned.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/insert_values_non_partitioned.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/insert_values_non_partitioned.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,23 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+create table acid_ivnp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) clustered by (i) into 2 buckets stored as orc;
+
+insert into table acid_ivnp values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue' );
+
+select ti, si, i, bi, f, d, de, t, dt, s, vc, ch from acid_ivnp order by ti;
Added: hive/trunk/ql/src/test/queries/clientpositive/insert_values_orig_table.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/insert_values_orig_table.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/insert_values_orig_table.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/insert_values_orig_table.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,29 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+create table acid_ivot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc;
+
+LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot;
+
+select count(*) from acid_ivot;
+
+insert into table acid_ivot values
+ (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
+ (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true);
+
+select count(*) from acid_ivot;
+
Added: hive/trunk/ql/src/test/queries/clientpositive/insert_values_partitioned.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/insert_values_partitioned.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/insert_values_partitioned.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/insert_values_partitioned.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,24 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+set hive.exec.dynamic.partition.mode=nonstrict;
+
+create table acid_ivp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc;
+
+insert into table acid_ivp partition (ds='today') values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue');
+
+select * from acid_ivp order by i;
Added: hive/trunk/ql/src/test/queries/clientpositive/insert_values_tmp_table.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/insert_values_tmp_table.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/insert_values_tmp_table.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/insert_values_tmp_table.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,12 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc;
+
+insert into table acid_ivtt values
+ (1, 109.23, 'mary had a little lamb'),
+ (429496729, 0.14, 'its fleece was white as snow');
+
+select i, de, vc from acid_ivtt order by i;
Added: hive/trunk/ql/src/test/queries/clientpositive/update_after_multiple_inserts.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_after_multiple_inserts.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_after_multiple_inserts.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_after_multiple_inserts.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,24 @@
+set hive.exec.dynamic.partition.mode=nonstrict;
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+set hive.mapred.supports.subdirectories=true;
+
+create table acid_uami(i int,
+ de decimal(5,2),
+ vc varchar(128)) clustered by (i) into 2 buckets stored as orc;
+
+insert into table acid_uami values
+ (1, 109.23, 'mary had a little lamb'),
+ (6553, 923.19, 'its fleece was white as snow');
+
+insert into table acid_uami values
+ (10, 119.23, 'and everywhere that mary went'),
+ (65530, 823.19, 'the lamb was sure to go');
+
+select * from acid_uami order by de;
+
+update acid_uami set de = 3.14 where de = 109.23 or de = 119.23;
+
+select * from acid_uami order by de;
Added: hive/trunk/ql/src/test/queries/clientpositive/update_all_non_partitioned.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_all_non_partitioned.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_all_non_partitioned.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_all_non_partitioned.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,16 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+create table acid_uanp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc;
+
+insert into table acid_uanp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10;
+
+select a,b from acid_uanp order by a;
+
+update acid_uanp set b = 'fred';
+
+select a,b from acid_uanp order by a;
+
+
Added: hive/trunk/ql/src/test/queries/clientpositive/update_all_partitioned.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_all_partitioned.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_all_partitioned.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_all_partitioned.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,18 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+set hive.mapred.supports.subdirectories=true;
+
+create table acid_uap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc;
+
+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;
+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;
+
+select a,b,ds from acid_uap order by a,b;
+
+update acid_uap set b = 'fred';
+
+select a,b,ds from acid_uap order by a,b;
+
+
Added: hive/trunk/ql/src/test/queries/clientpositive/update_all_types.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_all_types.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_all_types.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_all_types.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,56 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+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;
+
+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;
+
+select * from acid_uat order by i;
+
+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';
+
+select * from acid_uat order by i;
+
+
Added: hive/trunk/ql/src/test/queries/clientpositive/update_orig_table.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_orig_table.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_orig_table.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_orig_table.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,27 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/update_orig_table;
+dfs -copyFromLocal ../../data/files/alltypesorc ${system:test.tmp.dir}/update_orig_table/00000_0;
+
+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,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc location '${system:test.tmp.dir}/update_orig_table';
+
+update acid_uot set cstring1 = 'fred' where cint < -1070551679;
+
+select * from acid_uot where cstring1 = 'fred';
+
+dfs -rmr ${system:test.tmp.dir}/update_orig_table;
Added: hive/trunk/ql/src/test/queries/clientpositive/update_tmp_table.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_tmp_table.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_tmp_table.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_tmp_table.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,16 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+create table acid_utt(a int, b varchar(128)) clustered by (b) into 2 buckets stored as orc;
+
+insert into table acid_utt select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10;
+
+select a,b from acid_utt order by a;
+
+update acid_utt set b = 'fred' where b = '0ruyd6Y50JpdGRf6HqD';
+
+select * from acid_utt order by a;
+
+
Added: hive/trunk/ql/src/test/queries/clientpositive/update_two_cols.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_two_cols.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_two_cols.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_two_cols.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,16 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc;
+
+insert into table acid_utc select cint, cast(cstring1 as varchar(128)), cfloat from alltypesorc where cint < 0 order by cint limit 10;
+
+select * from acid_utc order by a;
+
+update acid_utc set b = 'fred',c = 3.14;
+
+select * from acid_utc order by a;
+
+
Added: hive/trunk/ql/src/test/queries/clientpositive/update_where_no_match.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_where_no_match.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_where_no_match.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_where_no_match.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,16 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+create table acid_wnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc;
+
+insert into table acid_wnm select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10;
+
+select a,b from acid_wnm order by a;
+
+update acid_wnm set b = 'fred' where b = 'nosuchvalue';
+
+select * from acid_wnm order by a;
+
+
Added: hive/trunk/ql/src/test/queries/clientpositive/update_where_non_partitioned.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_where_non_partitioned.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_where_non_partitioned.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_where_non_partitioned.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,16 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+
+create table acid_uwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc;
+
+insert into table acid_uwnp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10;
+
+select a,b from acid_uwnp order by a;
+
+update acid_uwnp set b = 'fred' where b = '0ruyd6Y50JpdGRf6HqD';
+
+select * from acid_uwnp order by a;
+
+
Added: hive/trunk/ql/src/test/queries/clientpositive/update_where_partitioned.q
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/update_where_partitioned.q?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/update_where_partitioned.q (added)
+++ hive/trunk/ql/src/test/queries/clientpositive/update_where_partitioned.q Sat Sep 13 22:09:31 2014
@@ -0,0 +1,18 @@
+set hive.support.concurrency=true;
+set hive.txn.manager=org.apache.hadoop.hive.ql.lockmgr.DbTxnManager;
+set hive.input.format=org.apache.hadoop.hive.ql.io.HiveInputFormat;
+set hive.enforce.bucketing=true;
+set hive.mapred.supports.subdirectories=true;
+
+create table acid_uwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc;
+
+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;
+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;
+
+select a,b,ds from acid_uwp order by a, ds, b;
+
+update acid_uwp set b = 'fred' where b = 'k17Am8uPHWk02cEf1jet';
+
+select * from acid_uwp order by a, ds, b;
+
+
Added: hive/trunk/ql/src/test/results/clientnegative/acid_overwrite.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/acid_overwrite.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/acid_overwrite.q.out (added)
+++ hive/trunk/ql/src/test/results/clientnegative/acid_overwrite.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,19 @@
+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), ]
+FAILED: SemanticException [Error 10295]: INSERT OVERWRITE not allowed on table with OutputFormat that implements AcidOutputFormat while transaction manager that supports ACID is in use
Added: hive/trunk/ql/src/test/results/clientnegative/delete_not_acid.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/delete_not_acid.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/delete_not_acid.q.out (added)
+++ hive/trunk/ql/src/test/results/clientnegative/delete_not_acid.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,9 @@
+PREHOOK: query: create table foo(a int, b varchar(128)) clustered by (a) into 1 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@foo
+POSTHOOK: query: create table foo(a int, b varchar(128)) clustered by (a) into 1 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@foo
+FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.
Modified: hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_1.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_1.q.out?rev=1624788&r1=1624787&r2=1624788&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_1.q.out (original)
+++ hive/trunk/ql/src/test/results/clientnegative/invalid_cast_from_binary_1.q.out Sat Sep 13 22:09:31 2014
@@ -6,4 +6,4 @@ POSTHOOK: query: create table tbl (a bin
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@tbl
-FAILED: SemanticException Line 0:-1 Wrong arguments 'a': No matching method for class org.apache.hadoop.hive.ql.udf.UDFToInteger with (binary). Possible choices: _FUNC_(bigint) _FUNC_(boolean) _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(smallint) _FUNC_(string) _FUNC_(timestamp) _FUNC_(tinyint) _FUNC_(void)
+FAILED: SemanticException Line 0:-1 Wrong arguments 'a': No matching method for class org.apache.hadoop.hive.ql.udf.UDFToInteger with (binary). Possible choices: _FUNC_(bigint) _FUNC_(boolean) _FUNC_(decimal(38,18)) _FUNC_(double) _FUNC_(float) _FUNC_(smallint) _FUNC_(string) _FUNC_(struct<transactionid:bigint,bucketid:int,rowid:bigint>) _FUNC_(timestamp) _FUNC_(tinyint) _FUNC_(void)
Added: hive/trunk/ql/src/test/results/clientnegative/update_not_acid.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/update_not_acid.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/update_not_acid.q.out (added)
+++ hive/trunk/ql/src/test/results/clientnegative/update_not_acid.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,9 @@
+PREHOOK: query: create table foo(a int, b varchar(128)) clustered by (a) into 1 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@foo
+POSTHOOK: query: create table foo(a int, b varchar(128)) clustered by (a) into 1 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@foo
+FAILED: SemanticException [Error 10294]: Attempt to do update or delete using transaction manager that does not support these operations.
Added: hive/trunk/ql/src/test/results/clientnegative/update_partition_col.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/update_partition_col.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientnegative/update_partition_col.q.out (added)
+++ hive/trunk/ql/src/test/results/clientnegative/update_partition_col.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,9 @@
+PREHOOK: query: create table foo(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@foo
+POSTHOOK: query: create table foo(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@foo
+FAILED: SemanticException [Error 10292]: Updating values of partition columns is not supported
Added: hive/trunk/ql/src/test/results/clientpositive/delete_all_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/delete_all_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_all_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_all_non_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,52 @@
+PREHOOK: query: create table acid_danp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_danp
+POSTHOOK: query: create table acid_danp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_danp
+PREHOOK: query: insert into table acid_danp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_danp
+POSTHOOK: query: insert into table acid_danp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_danp
+POSTHOOK: Lineage: acid_danp.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_danp.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_danp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_danp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_danp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_danp
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: delete from acid_danp
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_danp
+PREHOOK: Output: default@acid_danp
+POSTHOOK: query: delete from acid_danp
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_danp
+POSTHOOK: Output: default@acid_danp
+PREHOOK: query: select a,b from acid_danp
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_danp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_danp
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_danp
+#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/delete_all_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/delete_all_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_all_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_all_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,86 @@
+PREHOOK: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dap
+POSTHOOK: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dap
+PREHOOK: query: insert into table acid_dap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dap@ds=today
+POSTHOOK: query: insert into table acid_dap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dap@ds=today
+POSTHOOK: Lineage: acid_dap PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dap PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_dap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 1000 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dap@ds=tomorrow
+POSTHOOK: query: insert into table acid_dap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 1000 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dap@ds=tomorrow
+POSTHOOK: Lineage: acid_dap PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dap PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b,ds from acid_dap order by a,b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dap
+PREHOOK: Input: default@acid_dap@ds=today
+PREHOOK: Input: default@acid_dap@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_dap order by a,b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dap
+POSTHOOK: Input: default@acid_dap@ds=today
+POSTHOOK: Input: default@acid_dap@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073051226 A34p7oRr2WvUJNf today
+-1072910839 0iqrc5 today
+-1072081801 dPkN74F7 today
+-1072076362 2uLyD28144vklju213J1mr today
+-1071480828 aw724t8c5558x2xneC624 today
+-1071363017 Anj0oF today
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070551679 iUR3Q today
+-1069736047 k17Am8uPHWk02cEf1jet today
+6981 NULL tomorrow
+6981 1FNNhmiFLGw425NA13g tomorrow
+6981 4KhrrQ0nJ7bMNTvhSCA tomorrow
+6981 K630vaVf tomorrow
+6981 Y5x3JuI3M8jngv5N tomorrow
+6981 YdG61y00526u5 tomorrow
+6981 a3EhVU6Wuy7ycJ7wY7h2gv tomorrow
+6981 o4lvY20511w0EOX3P3I82p63 tomorrow
+6981 o5mb0QP5Y48Qd4vdB0 tomorrow
+6981 sF2CRfgt2K tomorrow
+PREHOOK: query: delete from acid_dap
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dap
+PREHOOK: Input: default@acid_dap@ds=today
+PREHOOK: Input: default@acid_dap@ds=tomorrow
+PREHOOK: Output: default@acid_dap@ds=today
+PREHOOK: Output: default@acid_dap@ds=tomorrow
+POSTHOOK: query: delete from acid_dap
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dap
+POSTHOOK: Input: default@acid_dap@ds=today
+POSTHOOK: Input: default@acid_dap@ds=tomorrow
+POSTHOOK: Output: default@acid_dap@ds=today
+POSTHOOK: Output: default@acid_dap@ds=tomorrow
+PREHOOK: query: select * from acid_dap
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dap
+PREHOOK: Input: default@acid_dap@ds=today
+PREHOOK: Input: default@acid_dap@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dap
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dap
+POSTHOOK: Input: default@acid_dap@ds=today
+POSTHOOK: Input: default@acid_dap@ds=tomorrow
+#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/delete_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/delete_orig_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_orig_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_orig_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,61 @@
+PREHOOK: query: create table acid_dot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+#### A masked pattern was here ####
+PREHOOK: type: CREATETABLE
+#### A masked pattern was here ####
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dot
+POSTHOOK: query: create table acid_dot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+#### A masked pattern was here ####
+POSTHOOK: type: CREATETABLE
+#### A masked pattern was here ####
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dot
+PREHOOK: query: select count(*) from acid_dot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_dot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dot
+#### A masked pattern was here ####
+12288
+PREHOOK: query: delete from acid_dot where cint < -1070551679
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dot
+PREHOOK: Output: default@acid_dot
+POSTHOOK: query: delete from acid_dot where cint < -1070551679
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dot
+POSTHOOK: Output: default@acid_dot
+PREHOOK: query: select count(*) from acid_dot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_dot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dot
+#### A masked pattern was here ####
+12280
+#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/delete_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/delete_tmp_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_tmp_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_tmp_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,60 @@
+PREHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dtt
+POSTHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dtt
+PREHOOK: query: insert into table acid_dtt select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dtt
+POSTHOOK: query: insert into table acid_dtt select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dtt
+POSTHOOK: Lineage: acid_dtt.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dtt.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_dtt order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dtt
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dtt order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dtt
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: delete from acid_dtt where b = '0ruyd6Y50JpdGRf6HqD' or b = '2uLyD28144vklju213J1mr'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dtt
+PREHOOK: Output: default@acid_dtt
+POSTHOOK: query: delete from acid_dtt where b = '0ruyd6Y50JpdGRf6HqD' or b = '2uLyD28144vklju213J1mr'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dtt
+POSTHOOK: Output: default@acid_dtt
+PREHOOK: query: select a,b from acid_dtt order by b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dtt
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_dtt order by b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dtt
+#### A masked pattern was here ####
+-1072910839 0iqrc5
+-1073051226 A34p7oRr2WvUJNf
+-1071363017 Anj0oF
+-1071480828 aw724t8c5558x2xneC624
+-1072081801 dPkN74F7
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+-1073279343 oj1YrV5Wa
Added: hive/trunk/ql/src/test/results/clientpositive/delete_where_no_match.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/delete_where_no_match.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_where_no_match.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_where_no_match.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,62 @@
+PREHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dwnm
+POSTHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dwnm
+PREHOOK: query: insert into table acid_dwnm select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwnm
+POSTHOOK: query: insert into table acid_dwnm select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwnm
+POSTHOOK: Lineage: acid_dwnm.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwnm.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_dwnm order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnm
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dwnm order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnm
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: delete from acid_dwnm where b = 'nosuchvalue'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnm
+PREHOOK: Output: default@acid_dwnm
+POSTHOOK: query: delete from acid_dwnm where b = 'nosuchvalue'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnm
+POSTHOOK: Output: default@acid_dwnm
+PREHOOK: query: select a,b from acid_dwnm order by b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnm
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_dwnm order by b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnm
+#### A masked pattern was here ####
+-1072910839 0iqrc5
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1072076362 2uLyD28144vklju213J1mr
+-1073051226 A34p7oRr2WvUJNf
+-1071363017 Anj0oF
+-1071480828 aw724t8c5558x2xneC624
+-1072081801 dPkN74F7
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+-1073279343 oj1YrV5Wa
Added: hive/trunk/ql/src/test/results/clientpositive/delete_where_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/delete_where_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_where_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_where_non_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,61 @@
+PREHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dwnp
+POSTHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dwnp
+PREHOOK: query: insert into table acid_dwnp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwnp
+POSTHOOK: query: insert into table acid_dwnp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwnp
+POSTHOOK: Lineage: acid_dwnp.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwnp.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_dwnp order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnp
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dwnp order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnp
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: delete from acid_dwnp where b = '0ruyd6Y50JpdGRf6HqD'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnp
+PREHOOK: Output: default@acid_dwnp
+POSTHOOK: query: delete from acid_dwnp where b = '0ruyd6Y50JpdGRf6HqD'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnp
+POSTHOOK: Output: default@acid_dwnp
+PREHOOK: query: select a,b from acid_dwnp order by b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwnp
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_dwnp order by b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwnp
+#### A masked pattern was here ####
+-1072910839 0iqrc5
+-1072076362 2uLyD28144vklju213J1mr
+-1073051226 A34p7oRr2WvUJNf
+-1071363017 Anj0oF
+-1071480828 aw724t8c5558x2xneC624
+-1072081801 dPkN74F7
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+-1073279343 oj1YrV5Wa
Added: hive/trunk/ql/src/test/results/clientpositive/delete_where_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/delete_where_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_where_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_where_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,105 @@
+PREHOOK: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dwp
+POSTHOOK: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dwp
+PREHOOK: query: insert into table acid_dwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwp@ds=today
+POSTHOOK: query: insert into table acid_dwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwp@ds=today
+POSTHOOK: Lineage: acid_dwp PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwp PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_dwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwp@ds=tomorrow
+POSTHOOK: query: insert into table acid_dwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwp@ds=tomorrow
+POSTHOOK: Lineage: acid_dwp PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwp PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b,ds from acid_dwp order by a, ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwp
+PREHOOK: Input: default@acid_dwp@ds=today
+PREHOOK: Input: default@acid_dwp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_dwp order by a, ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwp
+POSTHOOK: Input: default@acid_dwp@ds=today
+POSTHOOK: Input: default@acid_dwp@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073051226 A34p7oRr2WvUJNf today
+-1072910839 0iqrc5 today
+-1072081801 dPkN74F7 today
+-1072076362 2uLyD28144vklju213J1mr today
+-1071480828 aw724t8c5558x2xneC624 today
+-1071363017 Anj0oF today
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070551679 iUR3Q today
+-1069736047 k17Am8uPHWk02cEf1jet today
+-9676535 MmMPCF2 tomorrow
+-9462165 7WLVW6F4h71Dgk7 tomorrow
+-9329892 e7sC5M0H5K6EgSTf41X tomorrow
+-9175632 UUBET8444iJDvjUlq3en tomorrow
+-9011819 A6CX2HDWN8 tomorrow
+-8987676 FhXANp2KDtMmA2gFd778pA tomorrow
+-8413710 81Rg5rR0IaInWw tomorrow
+-8230445 K6J1LIb5 tomorrow
+-7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow
+-6882225 r6gCtT4Tgo5rG tomorrow
+PREHOOK: query: delete from acid_dwp where a = '-1071363017'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwp
+PREHOOK: Input: default@acid_dwp@ds=today
+PREHOOK: Input: default@acid_dwp@ds=tomorrow
+PREHOOK: Output: default@acid_dwp@ds=today
+PREHOOK: Output: default@acid_dwp@ds=tomorrow
+POSTHOOK: query: delete from acid_dwp where a = '-1071363017'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwp
+POSTHOOK: Input: default@acid_dwp@ds=today
+POSTHOOK: Input: default@acid_dwp@ds=tomorrow
+POSTHOOK: Output: default@acid_dwp@ds=today
+POSTHOOK: Output: default@acid_dwp@ds=tomorrow
+PREHOOK: query: select * from acid_dwp order by a, ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwp
+PREHOOK: Input: default@acid_dwp@ds=today
+PREHOOK: Input: default@acid_dwp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dwp order by a, ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwp
+POSTHOOK: Input: default@acid_dwp@ds=today
+POSTHOOK: Input: default@acid_dwp@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073051226 A34p7oRr2WvUJNf today
+-1072910839 0iqrc5 today
+-1072081801 dPkN74F7 today
+-1072076362 2uLyD28144vklju213J1mr today
+-1071480828 aw724t8c5558x2xneC624 today
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070551679 iUR3Q today
+-1069736047 k17Am8uPHWk02cEf1jet today
+-9676535 MmMPCF2 tomorrow
+-9462165 7WLVW6F4h71Dgk7 tomorrow
+-9329892 e7sC5M0H5K6EgSTf41X tomorrow
+-9175632 UUBET8444iJDvjUlq3en tomorrow
+-9011819 A6CX2HDWN8 tomorrow
+-8987676 FhXANp2KDtMmA2gFd778pA tomorrow
+-8413710 81Rg5rR0IaInWw tomorrow
+-8230445 K6J1LIb5 tomorrow
+-7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow
+-6882225 r6gCtT4Tgo5rG tomorrow
Added: hive/trunk/ql/src/test/results/clientpositive/delete_whole_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/delete_whole_partition.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_whole_partition.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_whole_partition.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,92 @@
+PREHOOK: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dwhp
+POSTHOOK: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dwhp
+PREHOOK: query: insert into table acid_dwhp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwhp@ds=today
+POSTHOOK: query: insert into table acid_dwhp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwhp@ds=today
+POSTHOOK: Lineage: acid_dwhp PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwhp PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: insert into table acid_dwhp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dwhp@ds=tomorrow
+POSTHOOK: query: insert into table acid_dwhp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dwhp@ds=tomorrow
+POSTHOOK: Lineage: acid_dwhp PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dwhp PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b,ds from acid_dwhp order by a, ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwhp
+PREHOOK: Input: default@acid_dwhp@ds=today
+PREHOOK: Input: default@acid_dwhp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b,ds from acid_dwhp order by a, ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwhp
+POSTHOOK: Input: default@acid_dwhp@ds=today
+POSTHOOK: Input: default@acid_dwhp@ds=tomorrow
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa today
+-1073051226 A34p7oRr2WvUJNf today
+-1072910839 0iqrc5 today
+-1072081801 dPkN74F7 today
+-1072076362 2uLyD28144vklju213J1mr today
+-1071480828 aw724t8c5558x2xneC624 today
+-1071363017 Anj0oF today
+-1070883071 0ruyd6Y50JpdGRf6HqD today
+-1070551679 iUR3Q today
+-1069736047 k17Am8uPHWk02cEf1jet today
+-9676535 MmMPCF2 tomorrow
+-9462165 7WLVW6F4h71Dgk7 tomorrow
+-9329892 e7sC5M0H5K6EgSTf41X tomorrow
+-9175632 UUBET8444iJDvjUlq3en tomorrow
+-9011819 A6CX2HDWN8 tomorrow
+-8987676 FhXANp2KDtMmA2gFd778pA tomorrow
+-8413710 81Rg5rR0IaInWw tomorrow
+-8230445 K6J1LIb5 tomorrow
+-7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow
+-6882225 r6gCtT4Tgo5rG tomorrow
+PREHOOK: query: delete from acid_dwhp where ds = 'today'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwhp
+PREHOOK: Input: default@acid_dwhp@ds=today
+PREHOOK: Output: default@acid_dwhp@ds=today
+POSTHOOK: query: delete from acid_dwhp where ds = 'today'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwhp
+POSTHOOK: Input: default@acid_dwhp@ds=today
+POSTHOOK: Output: default@acid_dwhp@ds=today
+PREHOOK: query: select * from acid_dwhp order by a, ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dwhp
+PREHOOK: Input: default@acid_dwhp@ds=today
+PREHOOK: Input: default@acid_dwhp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dwhp order by a, ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dwhp
+POSTHOOK: Input: default@acid_dwhp@ds=today
+POSTHOOK: Input: default@acid_dwhp@ds=tomorrow
+#### A masked pattern was here ####
+-9676535 MmMPCF2 tomorrow
+-9462165 7WLVW6F4h71Dgk7 tomorrow
+-9329892 e7sC5M0H5K6EgSTf41X tomorrow
+-9175632 UUBET8444iJDvjUlq3en tomorrow
+-9011819 A6CX2HDWN8 tomorrow
+-8987676 FhXANp2KDtMmA2gFd778pA tomorrow
+-8413710 81Rg5rR0IaInWw tomorrow
+-8230445 K6J1LIb5 tomorrow
+-7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow
+-6882225 r6gCtT4Tgo5rG tomorrow
Added: hive/trunk/ql/src/test/results/clientpositive/insert_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_orig_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_orig_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_orig_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,80 @@
+PREHOOK: query: create table acid_iot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_iot
+POSTHOOK: query: create table acid_iot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_iot
+PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_iot
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@acid_iot
+POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_iot
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@acid_iot
+PREHOOK: query: select count(*) from acid_iot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_iot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iot
+#### A masked pattern was here ####
+12288
+PREHOOK: query: insert into table acid_iot select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2,
+ cboolean1, cboolean2 from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_iot
+POSTHOOK: query: insert into table acid_iot select ctinyint, csmallint, cint, cbigint, cfloat, cdouble, cstring1, cstring2, ctimestamp1, ctimestamp2,
+ cboolean1, cboolean2 from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_iot
+POSTHOOK: Lineage: acid_iot.cbigint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cbigint, type:bigint, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cboolean1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cboolean1, type:boolean, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cboolean2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cboolean2, type:boolean, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cdouble SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cdouble, type:double, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cfloat SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cfloat, type:float, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_iot.csmallint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:csmallint, type:smallint, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cstring1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_iot.cstring2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cstring2, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_iot.ctimestamp1 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp1, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: acid_iot.ctimestamp2 SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctimestamp2, type:timestamp, comment:null), ]
+POSTHOOK: Lineage: acid_iot.ctinyint SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:ctinyint, type:tinyint, comment:null), ]
+PREHOOK: query: select count(*) from acid_iot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_iot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iot
+#### A masked pattern was here ####
+12298
Added: hive/trunk/ql/src/test/results/clientpositive/insert_update_delete.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_update_delete.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_update_delete.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_update_delete.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,78 @@
+PREHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_iud
+POSTHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_iud
+PREHOOK: query: insert into table acid_iud select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_iud
+POSTHOOK: query: insert into table acid_iud select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_iud
+POSTHOOK: Lineage: acid_iud.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_iud.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select a,b from acid_iud order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_iud order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa
+-1073051226 A34p7oRr2WvUJNf
+-1072910839 0iqrc5
+-1072081801 dPkN74F7
+-1072076362 2uLyD28144vklju213J1mr
+-1071480828 aw724t8c5558x2xneC624
+-1071363017 Anj0oF
+-1070883071 0ruyd6Y50JpdGRf6HqD
+-1070551679 iUR3Q
+-1069736047 k17Am8uPHWk02cEf1jet
+PREHOOK: query: update acid_iud set b = 'fred'
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+PREHOOK: Output: default@acid_iud
+POSTHOOK: query: update acid_iud set b = 'fred'
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+POSTHOOK: Output: default@acid_iud
+PREHOOK: query: select a,b from acid_iud order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_iud order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+-1073279343 fred
+-1073051226 fred
+-1072910839 fred
+-1072081801 fred
+-1072076362 fred
+-1071480828 fred
+-1071363017 fred
+-1070883071 fred
+-1070551679 fred
+-1069736047 fred
+PREHOOK: query: delete from acid_iud
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+PREHOOK: Output: default@acid_iud
+POSTHOOK: query: delete from acid_iud
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+POSTHOOK: Output: default@acid_iud
+PREHOOK: query: select a,b from acid_iud order by a
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
+POSTHOOK: query: select a,b from acid_iud order by a
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_iud
+#### A masked pattern was here ####
Added: hive/trunk/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,45 @@
+PREHOOK: query: create table ivdp(i int,
+ de decimal(5,2),
+ vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ivdp
+POSTHOOK: query: create table ivdp(i int,
+ de decimal(5,2),
+ vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@ivdp
+PREHOOK: query: insert into table ivdp partition (ds) values
+ (1, 109.23, 'and everywhere that mary went', 'today'),
+ (6553, 923.19, 'the lamb was sure to go', 'tomorrow')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@ivdp
+POSTHOOK: query: insert into table ivdp partition (ds) values
+ (1, 109.23, 'and everywhere that mary went', 'today'),
+ (6553, 923.19, 'the lamb was sure to go', 'tomorrow')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@ivdp@ds=today
+POSTHOOK: Output: default@ivdp@ds=tomorrow
+POSTHOOK: Lineage: ivdp PARTITION(ds=today).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=today).i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=today).vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=tomorrow).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=tomorrow).i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: ivdp PARTITION(ds=tomorrow).vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+PREHOOK: query: select * from ivdp order by ds
+PREHOOK: type: QUERY
+PREHOOK: Input: default@ivdp
+PREHOOK: Input: default@ivdp@ds=today
+PREHOOK: Input: default@ivdp@ds=tomorrow
+#### A masked pattern was here ####
+POSTHOOK: query: select * from ivdp order by ds
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@ivdp
+POSTHOOK: Input: default@ivdp@ds=today
+POSTHOOK: Input: default@ivdp@ds=tomorrow
+#### A masked pattern was here ####
+1 109.23 and everywhere that mary went today
+6553 923.19 the lamb was sure to go tomorrow
Added: hive/trunk/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,64 @@
+PREHOOK: query: create table acid_ivnp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) clustered by (i) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_ivnp
+POSTHOOK: query: create table acid_ivnp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) clustered by (i) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_ivnp
+PREHOOK: query: insert into table acid_ivnp values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_ivnp
+POSTHOOK: query: insert into table acid_ivnp values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue' )
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_ivnp
+POSTHOOK: Lineage: acid_ivnp.bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.d EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.f EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.si EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.t EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.ti EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivnp.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
+PREHOOK: query: select ti, si, i, bi, f, d, de, t, dt, s, vc, ch from acid_ivnp order by ti
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivnp
+#### A masked pattern was here ####
+POSTHOOK: query: select ti, si, i, bi, f, d, de, t, dt, s, vc, ch from acid_ivnp order by ti
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivnp
+#### A masked pattern was here ####
+1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 mary had a little lamb ring around the rosie red
+3 25 6553 429496729 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 its fleece was white as snow a pocket full of posies blue
Added: hive/trunk/ql/src/test/results/clientpositive/insert_values_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_values_orig_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_orig_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_orig_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,82 @@
+PREHOOK: query: create table acid_ivot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_ivot
+POSTHOOK: query: create table acid_ivot(
+ ctinyint TINYINT,
+ csmallint SMALLINT,
+ cint INT,
+ cbigint BIGINT,
+ cfloat FLOAT,
+ cdouble DOUBLE,
+ cstring1 STRING,
+ cstring2 STRING,
+ ctimestamp1 TIMESTAMP,
+ ctimestamp2 TIMESTAMP,
+ cboolean1 BOOLEAN,
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_ivot
+PREHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot
+PREHOOK: type: LOAD
+#### A masked pattern was here ####
+PREHOOK: Output: default@acid_ivot
+POSTHOOK: query: LOAD DATA LOCAL INPATH "../../data/files/alltypesorc" into table acid_ivot
+POSTHOOK: type: LOAD
+#### A masked pattern was here ####
+POSTHOOK: Output: default@acid_ivot
+PREHOOK: query: select count(*) from acid_ivot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_ivot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivot
+#### A masked pattern was here ####
+12288
+PREHOOK: query: insert into table acid_ivot values
+ (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
+ (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_ivot
+POSTHOOK: query: insert into table acid_ivot values
+ (1, 2, 3, 4, 3.14, 2.34, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true),
+ (111, 222, 3333, 444, 13.14, 10239302.34239320, 'fred', 'bob', '2014-09-01 10:34:23.111', '1944-06-06 06:00:00', true, true)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_ivot
+POSTHOOK: Lineage: acid_ivot.cbigint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cboolean1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cboolean2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cdouble EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cfloat EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.csmallint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cstring1 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.cstring2 SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.ctimestamp1 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.ctimestamp2 EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivot.ctinyint EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+PREHOOK: query: select count(*) from acid_ivot
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivot
+#### A masked pattern was here ####
+POSTHOOK: query: select count(*) from acid_ivot
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivot
+#### A masked pattern was here ####
+12290
Added: hive/trunk/ql/src/test/results/clientpositive/insert_values_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_values_partitioned.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_partitioned.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_partitioned.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,66 @@
+PREHOOK: query: create table acid_ivp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_ivp
+POSTHOOK: query: create table acid_ivp(ti tinyint,
+ si smallint,
+ i int,
+ bi bigint,
+ f float,
+ d double,
+ de decimal(5,2),
+ t timestamp,
+ dt date,
+ s string,
+ vc varchar(128),
+ ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_ivp
+PREHOOK: query: insert into table acid_ivp partition (ds='today') values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_ivp@ds=today
+POSTHOOK: query: insert into table acid_ivp partition (ds='today') values
+ (1, 257, 65537, 4294967297, 3.14, 3.141592654, 109.23, '2014-08-25 17:21:30.0', '2014-08-25', 'mary had a little lamb', 'ring around the rosie', 'red'),
+ (3, 25, 6553, 429496729, 0.14, 1923.141592654, 1.2301, '2014-08-24 17:21:30.0', '2014-08-26', 'its fleece was white as snow', 'a pocket full of posies', 'blue')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_ivp@ds=today
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).bi EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).ch EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col12, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).d EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col6, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col7, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).dt EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col9, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).f EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col5, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).s SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col10, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).si EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).t EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col8, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).ti EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivp PARTITION(ds=today).vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col11, type:string, comment:), ]
+PREHOOK: query: select * from acid_ivp order by i
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivp
+PREHOOK: Input: default@acid_ivp@ds=today
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_ivp order by i
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivp
+POSTHOOK: Input: default@acid_ivp@ds=today
+#### A masked pattern was here ####
+3 25 6553 429496729 0.14 1923.141592654 1.23 2014-08-24 17:21:30 2014-08-26 its fleece was white as snow a pocket full of posies blue today
+1 257 65537 4294967297 3.14 3.141592654 109.23 2014-08-25 17:21:30 2014-08-25 mary had a little lamb ring around the rosie red today
Added: hive/trunk/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out?rev=1624788&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out Sat Sep 13 22:09:31 2014
@@ -0,0 +1,33 @@
+PREHOOK: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_ivtt
+POSTHOOK: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_ivtt
+PREHOOK: query: insert into table acid_ivtt values
+ (1, 109.23, 'mary had a little lamb'),
+ (429496729, 0.14, 'its fleece was white as snow')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_ivtt
+POSTHOOK: query: insert into table acid_ivtt values
+ (1, 109.23, 'mary had a little lamb'),
+ (429496729, 0.14, 'its fleece was white as snow')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_ivtt
+POSTHOOK: Lineage: acid_ivtt.de EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivtt.i EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_ivtt.vc EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ]
+PREHOOK: query: select i, de, vc from acid_ivtt order by i
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_ivtt
+#### A masked pattern was here ####
+POSTHOOK: query: select i, de, vc from acid_ivtt order by i
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_ivtt
+#### A masked pattern was here ####
+1 109.23 mary had a little lamb
+429496729 0.14 its fleece was white as snow