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/10/01 23:02:20 UTC
svn commit: r1628834 [2/2] - in /hive/trunk:
itests/hive-unit/src/test/java/org/apache/hadoop/hive/ql/security/authorization/plugin/
ql/src/java/org/apache/hadoop/hive/ql/
ql/src/java/org/apache/hadoop/hive/ql/metadata/
ql/src/java/org/apache/hadoop/hi...
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_all_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_all_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dap
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_tmp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_tmp_table.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dtt
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_where_no_match.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_where_no_match.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dwnm
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_where_non_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_where_non_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dwnp
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_where_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_where_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dwp
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/delete_whole_partition.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/delete_whole_partition.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dwhp
Added: hive/trunk/ql/src/test/results/clientpositive/insert_acid_dynamic_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_acid_dynamic_partition.q.out?rev=1628834&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_acid_dynamic_partition.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_acid_dynamic_partition.q.out Wed Oct 1 21:02:18 2014
@@ -0,0 +1,48 @@
+PREHOOK: query: create table acid_dynamic(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dynamic
+POSTHOOK: query: create table acid_dynamic(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dynamic
+PREHOOK: query: insert into table acid_dynamic partition (ds) select cint, cast(cstring1 as varchar(128)), cstring2 from alltypesorc where cint is not null and cint < 0 order by cint limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dynamic
+POSTHOOK: query: insert into table acid_dynamic partition (ds) select cint, cast(cstring1 as varchar(128)), cstring2 from alltypesorc where cint is not null and cint < 0 order by cint limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dynamic@ds=4KWs6gw7lv2WYd66P
+POSTHOOK: Output: default@acid_dynamic@ds=4hA4KQj2vD3fI6gX82220d
+POSTHOOK: Output: default@acid_dynamic@ds=KbaDXiN85adbHRx58v
+POSTHOOK: Output: default@acid_dynamic@ds=P76636jJ6qM17d7DIy
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4KWs6gw7lv2WYd66P).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4KWs6gw7lv2WYd66P).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4hA4KQj2vD3fI6gX82220d).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4hA4KQj2vD3fI6gX82220d).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=KbaDXiN85adbHRx58v).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=KbaDXiN85adbHRx58v).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=P76636jJ6qM17d7DIy).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=P76636jJ6qM17d7DIy).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_dynamic order by a,b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dynamic
+PREHOOK: Input: default@acid_dynamic@ds=4KWs6gw7lv2WYd66P
+PREHOOK: Input: default@acid_dynamic@ds=4hA4KQj2vD3fI6gX82220d
+PREHOOK: Input: default@acid_dynamic@ds=KbaDXiN85adbHRx58v
+PREHOOK: Input: default@acid_dynamic@ds=P76636jJ6qM17d7DIy
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dynamic order by a,b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dynamic
+POSTHOOK: Input: default@acid_dynamic@ds=4KWs6gw7lv2WYd66P
+POSTHOOK: Input: default@acid_dynamic@ds=4hA4KQj2vD3fI6gX82220d
+POSTHOOK: Input: default@acid_dynamic@ds=KbaDXiN85adbHRx58v
+POSTHOOK: Input: default@acid_dynamic@ds=P76636jJ6qM17d7DIy
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa P76636jJ6qM17d7DIy
+-1073051226 A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d
+-1072910839 0iqrc5 KbaDXiN85adbHRx58v
+-1072081801 dPkN74F7 4KWs6gw7lv2WYd66P
+-1072076362 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P
Added: hive/trunk/ql/src/test/results/clientpositive/insert_acid_not_bucketed.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_acid_not_bucketed.q.out?rev=1628834&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_acid_not_bucketed.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_acid_not_bucketed.q.out Wed Oct 1 21:02:18 2014
@@ -0,0 +1,36 @@
+PREHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_notbucketed
+POSTHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_notbucketed
+PREHOOK: query: insert into table acid_notbucketed 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_notbucketed
+POSTHOOK: query: insert into table acid_notbucketed 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_notbucketed
+POSTHOOK: Lineage: acid_notbucketed.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_notbucketed.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_notbucketed
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_notbucketed
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_notbucketed
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_notbucketed
+#### 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
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_orig_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_orig_table.q.out Wed Oct 1 21:02:18 2014
@@ -10,7 +10,7 @@ PREHOOK: query: create table acid_iot(
ctimestamp1 TIMESTAMP,
ctimestamp2 TIMESTAMP,
cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_iot
@@ -26,7 +26,7 @@ POSTHOOK: query: create table acid_iot(
ctimestamp1 TIMESTAMP,
ctimestamp2 TIMESTAMP,
cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_iot
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_update_delete.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_update_delete.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_iud
Added: hive/trunk/ql/src/test/results/clientpositive/insert_values_acid_not_bucketed.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/insert_values_acid_not_bucketed.q.out?rev=1628834&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_acid_not_bucketed.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_acid_not_bucketed.q.out Wed Oct 1 21:02:18 2014
@@ -0,0 +1,28 @@
+PREHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_notbucketed
+POSTHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_notbucketed
+PREHOOK: query: insert into table acid_notbucketed values (1, 'abc'), (2, 'def')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_notbucketed
+POSTHOOK: query: insert into table acid_notbucketed values (1, 'abc'), (2, 'def')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_notbucketed
+POSTHOOK: Lineage: acid_notbucketed.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_notbucketed.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+PREHOOK: query: select * from acid_notbucketed
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_notbucketed
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_notbucketed
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_notbucketed
+#### A masked pattern was here ####
+1 abc
+2 def
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_dynamic_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,12 +1,12 @@
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
+ vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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
+ vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@ivdp
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_non_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -10,7 +10,7 @@ PREHOOK: query: create table acid_ivnp(t
b boolean,
s string,
vc varchar(128),
- ch char(12)) clustered by (i) into 2 buckets stored as orc
+ ch char(12)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_ivnp
@@ -26,7 +26,7 @@ POSTHOOK: query: create table acid_ivnp(
b boolean,
s string,
vc varchar(128),
- ch char(12)) clustered by (i) into 2 buckets stored as orc
+ ch char(12)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivnp
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_orig_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_orig_table.q.out Wed Oct 1 21:02:18 2014
@@ -10,7 +10,7 @@ PREHOOK: query: create table acid_ivot(
ctimestamp1 TIMESTAMP,
ctimestamp2 TIMESTAMP,
cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_ivot
@@ -26,7 +26,7 @@ POSTHOOK: query: create table acid_ivot(
ctimestamp1 TIMESTAMP,
ctimestamp2 TIMESTAMP,
cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivot
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -9,7 +9,7 @@ PREHOOK: query: create table acid_ivp(ti
dt date,
s string,
vc varchar(128),
- ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+ ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_ivp
@@ -24,7 +24,7 @@ POSTHOOK: query: create table acid_ivp(t
dt date,
s string,
vc varchar(128),
- ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+ ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivp
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/insert_values_tmp_table.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivtt
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_danp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_danp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_danp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_danp
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dap
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dtt
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dwnm
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dwnp
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dwp
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_dwhp
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_acid_dynamic_partition.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_acid_dynamic_partition.q.out?rev=1628834&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_acid_dynamic_partition.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_acid_dynamic_partition.q.out Wed Oct 1 21:02:18 2014
@@ -0,0 +1,48 @@
+PREHOOK: query: create table acid_dynamic(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_dynamic
+POSTHOOK: query: create table acid_dynamic(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_dynamic
+PREHOOK: query: insert into table acid_dynamic partition (ds) select cint, cast(cstring1 as varchar(128)), cstring2 from alltypesorc where cint is not null and cint < 0 order by cint limit 5
+PREHOOK: type: QUERY
+PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: default@acid_dynamic
+POSTHOOK: query: insert into table acid_dynamic partition (ds) select cint, cast(cstring1 as varchar(128)), cstring2 from alltypesorc where cint is not null and cint < 0 order by cint limit 5
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: default@acid_dynamic@ds=4KWs6gw7lv2WYd66P
+POSTHOOK: Output: default@acid_dynamic@ds=4hA4KQj2vD3fI6gX82220d
+POSTHOOK: Output: default@acid_dynamic@ds=KbaDXiN85adbHRx58v
+POSTHOOK: Output: default@acid_dynamic@ds=P76636jJ6qM17d7DIy
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4KWs6gw7lv2WYd66P).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4KWs6gw7lv2WYd66P).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4hA4KQj2vD3fI6gX82220d).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4hA4KQj2vD3fI6gX82220d).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=KbaDXiN85adbHRx58v).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=KbaDXiN85adbHRx58v).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=P76636jJ6qM17d7DIy).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_dynamic PARTITION(ds=P76636jJ6qM17d7DIy).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_dynamic order by a,b
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_dynamic
+PREHOOK: Input: default@acid_dynamic@ds=4KWs6gw7lv2WYd66P
+PREHOOK: Input: default@acid_dynamic@ds=4hA4KQj2vD3fI6gX82220d
+PREHOOK: Input: default@acid_dynamic@ds=KbaDXiN85adbHRx58v
+PREHOOK: Input: default@acid_dynamic@ds=P76636jJ6qM17d7DIy
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_dynamic order by a,b
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_dynamic
+POSTHOOK: Input: default@acid_dynamic@ds=4KWs6gw7lv2WYd66P
+POSTHOOK: Input: default@acid_dynamic@ds=4hA4KQj2vD3fI6gX82220d
+POSTHOOK: Input: default@acid_dynamic@ds=KbaDXiN85adbHRx58v
+POSTHOOK: Input: default@acid_dynamic@ds=P76636jJ6qM17d7DIy
+#### A masked pattern was here ####
+-1073279343 oj1YrV5Wa P76636jJ6qM17d7DIy
+-1073051226 A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d
+-1072910839 0iqrc5 KbaDXiN85adbHRx58v
+-1072081801 dPkN74F7 4KWs6gw7lv2WYd66P
+-1072076362 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_acid_not_bucketed.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_acid_not_bucketed.q.out?rev=1628834&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_acid_not_bucketed.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_acid_not_bucketed.q.out Wed Oct 1 21:02:18 2014
@@ -0,0 +1,36 @@
+PREHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_notbucketed
+POSTHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_notbucketed
+PREHOOK: query: insert into table acid_notbucketed 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_notbucketed
+POSTHOOK: query: insert into table acid_notbucketed 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_notbucketed
+POSTHOOK: Lineage: acid_notbucketed.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ]
+POSTHOOK: Lineage: acid_notbucketed.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ]
+PREHOOK: query: select * from acid_notbucketed
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_notbucketed
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_notbucketed
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_notbucketed
+#### 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
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_orig_table.q.out Wed Oct 1 21:02:18 2014
@@ -10,7 +10,7 @@ PREHOOK: query: create table acid_iot(
ctimestamp1 TIMESTAMP,
ctimestamp2 TIMESTAMP,
cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_iot
@@ -26,7 +26,7 @@ POSTHOOK: query: create table acid_iot(
ctimestamp1 TIMESTAMP,
ctimestamp2 TIMESTAMP,
cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_iot
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_update_delete.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_iud(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_iud
Added: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_acid_not_bucketed.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_acid_not_bucketed.q.out?rev=1628834&view=auto
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_acid_not_bucketed.q.out (added)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_acid_not_bucketed.q.out Wed Oct 1 21:02:18 2014
@@ -0,0 +1,28 @@
+PREHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
+PREHOOK: type: CREATETABLE
+PREHOOK: Output: database:default
+PREHOOK: Output: default@acid_notbucketed
+POSTHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc
+POSTHOOK: type: CREATETABLE
+POSTHOOK: Output: database:default
+POSTHOOK: Output: default@acid_notbucketed
+PREHOOK: query: insert into table acid_notbucketed values (1, 'abc'), (2, 'def')
+PREHOOK: type: QUERY
+PREHOOK: Input: default@values__tmp__table__1
+PREHOOK: Output: default@acid_notbucketed
+POSTHOOK: query: insert into table acid_notbucketed values (1, 'abc'), (2, 'def')
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@values__tmp__table__1
+POSTHOOK: Output: default@acid_notbucketed
+POSTHOOK: Lineage: acid_notbucketed.a EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ]
+POSTHOOK: Lineage: acid_notbucketed.b EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ]
+PREHOOK: query: select * from acid_notbucketed
+PREHOOK: type: QUERY
+PREHOOK: Input: default@acid_notbucketed
+#### A masked pattern was here ####
+POSTHOOK: query: select * from acid_notbucketed
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@acid_notbucketed
+#### A masked pattern was here ####
+1 abc
+2 def
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_dynamic_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,12 +1,12 @@
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
+ vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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
+ vc varchar(128)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@ivdp
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_non_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -10,7 +10,7 @@ PREHOOK: query: create table acid_ivnp(t
b boolean,
s string,
vc varchar(128),
- ch char(12)) clustered by (i) into 2 buckets stored as orc
+ ch char(12)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_ivnp
@@ -26,7 +26,7 @@ POSTHOOK: query: create table acid_ivnp(
b boolean,
s string,
vc varchar(128),
- ch char(12)) clustered by (i) into 2 buckets stored as orc
+ ch char(12)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivnp
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_orig_table.q.out Wed Oct 1 21:02:18 2014
@@ -10,7 +10,7 @@ PREHOOK: query: create table acid_ivot(
ctimestamp1 TIMESTAMP,
ctimestamp2 TIMESTAMP,
cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_ivot
@@ -26,7 +26,7 @@ POSTHOOK: query: create table acid_ivot(
ctimestamp1 TIMESTAMP,
ctimestamp2 TIMESTAMP,
cboolean1 BOOLEAN,
- cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc
+ cboolean2 BOOLEAN) clustered by (cint) into 1 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivot
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -9,7 +9,7 @@ PREHOOK: query: create table acid_ivp(ti
dt date,
s string,
vc varchar(128),
- ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+ ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_ivp
@@ -24,7 +24,7 @@ POSTHOOK: query: create table acid_ivp(t
dt date,
s string,
vc varchar(128),
- ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc
+ ch char(12)) partitioned by (ds string) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivp
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/insert_values_tmp_table.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create temporary table acid_ivtt(i int, de decimal(5,2), vc varchar(128)) clustered by (vc) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_ivtt
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/update_after_multiple_inserts.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_after_multiple_inserts.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_after_multiple_inserts.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_after_multiple_inserts.q.out Wed Oct 1 21:02:18 2014
@@ -1,12 +1,12 @@
PREHOOK: query: create table acid_uami(i int,
de decimal(5,2),
- vc varchar(128)) clustered by (i) into 2 buckets stored as orc
+ vc varchar(128)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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
+ vc varchar(128)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uami
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/update_all_non_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_all_non_partitioned.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_all_non_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_all_non_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_uanp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_uanp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_uanp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uanp
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_uap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_uap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uap
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/update_all_types.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_all_types.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_all_types.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_all_types.q.out Wed Oct 1 21:02:18 2014
@@ -10,7 +10,7 @@ PREHOOK: query: create table acid_uat(ti
s string,
vc varchar(128),
ch char(36),
- b boolean) clustered by (i) into 2 buckets stored as orc
+ b boolean) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_uat
@@ -26,7 +26,7 @@ POSTHOOK: query: create table acid_uat(t
s string,
vc varchar(128),
ch char(36),
- b boolean) clustered by (i) into 2 buckets stored as orc
+ b boolean) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uat
Modified: hive/trunk/ql/src/test/results/clientpositive/tez/update_tmp_table.q.out
URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/tez/update_tmp_table.q.out?rev=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_tmp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_tmp_table.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_utt(a int, b varchar(128)) clustered by (b) into 2 buckets stored as orc
+PREHOOK: query: create table acid_utt(a int, b varchar(128)) clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_utt(a int, b varchar(128)) clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_utt
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_two_cols.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_two_cols.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_utc
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_where_no_match.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_where_no_match.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_wnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_wnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_wnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_wnm
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_where_non_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_where_non_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_uwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_uwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_uwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uwnp
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_uwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_uwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uwp
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/update_after_multiple_inserts.q.out Wed Oct 1 21:02:18 2014
@@ -1,12 +1,12 @@
PREHOOK: query: create table acid_uami(i int,
de decimal(5,2),
- vc varchar(128)) clustered by (i) into 2 buckets stored as orc
+ vc varchar(128)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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
+ vc varchar(128)) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uami
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_all_non_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/update_all_non_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_uanp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_uanp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_uanp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uanp
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_all_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/update_all_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_uap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_uap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uap
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_all_types.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/update_all_types.q.out Wed Oct 1 21:02:18 2014
@@ -10,7 +10,7 @@ PREHOOK: query: create table acid_uat(ti
s string,
vc varchar(128),
ch char(36),
- b boolean) clustered by (i) into 2 buckets stored as orc
+ b boolean) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@acid_uat
@@ -26,7 +26,7 @@ POSTHOOK: query: create table acid_uat(t
s string,
vc varchar(128),
ch char(36),
- b boolean) clustered by (i) into 2 buckets stored as orc
+ b boolean) clustered by (i) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uat
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_tmp_table.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/update_tmp_table.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_utt(a int, b varchar(128)) clustered by (b) into 2 buckets stored as orc
+PREHOOK: query: create table acid_utt(a int, b varchar(128)) clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_utt(a int, b varchar(128)) clustered by (b) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_utt
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_two_cols.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/update_two_cols.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_utc(a int, b varchar(128), c float) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_utc
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_where_no_match.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/update_where_no_match.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_wnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_wnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_wnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_wnm
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_where_non_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/update_where_non_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-PREHOOK: query: create table acid_uwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc
+PREHOOK: query: create table acid_uwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_uwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uwnp
Modified: 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=1628834&r1=1628833&r2=1628834&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/update_where_partitioned.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/update_where_partitioned.q.out Wed Oct 1 21:02:18 2014
@@ -1,8 +1,8 @@
-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: query: create table acid_uwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
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: query: create table acid_uwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@acid_uwp