You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by gu...@apache.org on 2014/09/02 21:57:07 UTC
svn commit: r1622108 [24/27] - in /hive/branches/tez: ./
accumulo-handler/src/java/org/apache/hadoop/hive/accumulo/predicate/
beeline/src/java/org/apache/hive/beeline/
beeline/src/test/org/apache/hive/beeline/ bin/ bin/ext/ checkstyle/
common/src/java/...
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/orc_analyze.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/orc_analyze.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/orc_analyze.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/orc_analyze.q.out Tue Sep 2 19:56:56 2014
@@ -105,7 +105,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3042
+ totalSize 3098
#### A masked pattern was here ####
# Storage Information
@@ -195,7 +195,7 @@ Table Parameters:
numFiles 1
numRows 100
rawDataSize 52600
- totalSize 3042
+ totalSize 3098
#### A masked pattern was here ####
# Storage Information
@@ -309,7 +309,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 1962
+ totalSize 2016
#### A masked pattern was here ####
# Storage Information
@@ -354,7 +354,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 1981
+ totalSize 2036
#### A masked pattern was here ####
# Storage Information
@@ -456,7 +456,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 1962
+ totalSize 2016
#### A masked pattern was here ####
# Storage Information
@@ -501,7 +501,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 22050
- totalSize 1981
+ totalSize 2036
#### A masked pattern was here ####
# Storage Information
@@ -621,7 +621,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4746
+ totalSize 4955
#### A masked pattern was here ####
# Storage Information
@@ -666,7 +666,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 4829
+ totalSize 5046
#### A masked pattern was here ####
# Storage Information
@@ -774,7 +774,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 21980
- totalSize 4746
+ totalSize 4955
#### A masked pattern was here ####
# Storage Information
@@ -819,7 +819,7 @@ Partition Parameters:
numFiles 4
numRows 50
rawDataSize 22048
- totalSize 4829
+ totalSize 5046
#### A masked pattern was here ####
# Storage Information
@@ -984,7 +984,7 @@ Partition Parameters:
numFiles 1
numRows 50
rawDataSize 21950
- totalSize 1962
+ totalSize 2016
#### A masked pattern was here ####
# Storage Information
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/ptf.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/ptf.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/ptf.q.out Tue Sep 2 19:56:56 2014
@@ -772,6 +772,8 @@ from part
group by p_mfgr, p_brand
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@part
+PREHOOK: Output: database:default
+PREHOOK: Output: default@mfgr_price_view
POSTHOOK: query: -- 16. testViewAsTableInputToPTF
create view IF NOT EXISTS mfgr_price_view as
select p_mfgr, p_brand,
@@ -780,6 +782,7 @@ from part
group by p_mfgr, p_brand
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@part
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@mfgr_price_view
PREHOOK: query: select p_mfgr, p_brand, s,
sum(s) over w1 as s1
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/stats_counter.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/stats_counter.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/stats_counter.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/stats_counter.q.out Tue Sep 2 19:56:56 2014
@@ -2,10 +2,13 @@ PREHOOK: query: -- by analyze
create table dummy1 as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dummy1
POSTHOOK: query: -- by analyze
create table dummy1 as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dummy1
PREHOOK: query: analyze table dummy1 compute statistics
PREHOOK: type: QUERY
@@ -55,10 +58,13 @@ PREHOOK: query: -- by autogather
create table dummy2 as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dummy2
POSTHOOK: query: -- by autogather
create table dummy2 as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dummy2
PREHOOK: query: desc formatted dummy2
PREHOOK: type: DESCTABLE
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/subquery_exists.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/subquery_exists.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/subquery_exists.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/subquery_exists.q.out Tue Sep 2 19:56:56 2014
@@ -133,6 +133,8 @@ where exists
where b.value = a.value and a.key = b.key and a.value > 'val_9')
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@cv1
POSTHOOK: query: -- view test
create view cv1 as
select *
@@ -143,6 +145,7 @@ where exists
where b.value = a.value and a.key = b.key and a.value > 'val_9')
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@cv1
PREHOOK: query: select * from cv1
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/temp_table.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/temp_table.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/temp_table.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/temp_table.q.out Tue Sep 2 19:56:56 2014
@@ -46,7 +46,7 @@ STAGE PLANS:
#### A masked pattern was here ####
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: foo
+ name: default.foo
isTemporary: true
Stage: Stage-3
@@ -61,9 +61,12 @@ STAGE PLANS:
PREHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM src WHERE key % 2 = 0
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@foo
POSTHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM src WHERE key % 2 = 0
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@foo
PREHOOK: query: EXPLAIN CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1
PREHOOK: type: CREATETABLE_AS_SELECT
@@ -113,7 +116,7 @@ STAGE PLANS:
#### A masked pattern was here ####
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: bar
+ name: default.bar
isTemporary: true
Stage: Stage-3
@@ -128,9 +131,12 @@ STAGE PLANS:
PREHOOK: query: CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@bar
POSTHOOK: query: CREATE TEMPORARY TABLE bar AS SELECT * FROM src WHERE key % 2 = 1
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@bar
PREHOOK: query: DESCRIBE foo
PREHOOK: type: DESCTABLE
@@ -378,9 +384,12 @@ POSTHOOK: type: SHOWTABLES
PREHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM default.foo
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@foo
+PREHOOK: Output: database:two
+PREHOOK: Output: two@foo
POSTHOOK: query: CREATE TEMPORARY TABLE foo AS SELECT * FROM default.foo
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@foo
+POSTHOOK: Output: database:two
POSTHOOK: Output: two@foo
PREHOOK: query: SHOW TABLES
PREHOOK: type: SHOWTABLES
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/tez_dml.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/tez_dml.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/tez_dml.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/tez_dml.q.out Tue Sep 2 19:56:56 2014
@@ -82,7 +82,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: tmp_src
+ name: default.tmp_src
Stage: Stage-3
Stats-Aggr Operator
@@ -96,9 +96,12 @@ STAGE PLANS:
PREHOOK: query: CREATE TABLE tmp_src AS SELECT * FROM (SELECT value, count(value) AS cnt FROM src GROUP BY value) f1 ORDER BY cnt
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tmp_src
POSTHOOK: query: CREATE TABLE tmp_src AS SELECT * FROM (SELECT value, count(value) AS cnt FROM src GROUP BY value) f1 ORDER BY cnt
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmp_src
PREHOOK: query: SELECT * FROM tmp_src
PREHOOK: type: QUERY
@@ -1478,10 +1481,13 @@ PREHOOK: query: -- create empty table
CREATE TABLE empty STORED AS orc AS SELECT * FROM tmp_src_part WHERE d = -1000
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@tmp_src_part
+PREHOOK: Output: database:default
+PREHOOK: Output: default@empty
POSTHOOK: query: -- create empty table
CREATE TABLE empty STORED AS orc AS SELECT * FROM tmp_src_part WHERE d = -1000
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@tmp_src_part
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@empty
PREHOOK: query: SELECT * FROM empty
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/tez_union.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/tez_union.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/tez_union.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/tez_union.q.out Tue Sep 2 19:56:56 2014
@@ -92,12 +92,15 @@ UNION ALL
select s2.key as key, s2.value as value from src s2
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select s1.key as key, s1.value as value from src s1 join src s3 on s1.key=s3.key
UNION ALL
select s2.key as key, s2.value as value from src s2
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by key, value limit 20
PREHOOK: type: QUERY
@@ -268,12 +271,15 @@ select count(*) as cnt from (select u1.k
u as u1 join u as u2 on (u1.key = u2.key)) a
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
with u as (select * from src union all select * from src)
select count(*) as cnt from (select u1.key as k1, u2.key as k2 from
u as u1 join u as u2 on (u1.key = u2.key)) a
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by cnt limit 20
PREHOOK: type: QUERY
@@ -401,12 +407,15 @@ src s1
join (select * from src union all select * from src) u1 on s1.key = u1.key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select s1.key as skey, u1.key as ukey from
src s1
join (select * from src union all select * from src) u1 on s1.key = u1.key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by skey, ukey limit 20
PREHOOK: type: QUERY
@@ -708,6 +717,8 @@ join src s8 on (u1.key = s8.key)
order by lkey
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select s1.key as skey, u1.key as ukey, s8.key as lkey from
src s1
@@ -718,6 +729,7 @@ join src s8 on (u1.key = s8.key)
order by lkey
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by skey, ukey, lkey limit 100
PREHOOK: type: QUERY
@@ -951,11 +963,14 @@ select s2.key as key from src s2 join sr
union all select s4.key from src s4 join src s5 on s4.key = s5.key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select s2.key as key from src s2 join src s3 on s2.key = s3.key
union all select s4.key from src s4 join src s5 on s4.key = s5.key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by key limit 30
PREHOOK: type: QUERY
@@ -1190,12 +1205,15 @@ select u.key as ukey, s.key as skey from
right outer join src s on u.key = s.key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@ut
POSTHOOK: query: create table ut as
select u.key as ukey, s.key as skey from
(select * from src union all select * from src) u
right outer join src s on u.key = s.key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@ut
PREHOOK: query: select * from ut order by ukey, skey limit 20
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/vector_decimal_aggregate.q.out Tue Sep 2 19:56:56 2014
@@ -5,6 +5,8 @@ PREHOOK: query: CREATE TABLE decimal_vgb
FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_vgby
POSTHOOK: query: CREATE TABLE decimal_vgby STORED AS ORC AS
SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1,
CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2,
@@ -12,6 +14,7 @@ POSTHOOK: query: CREATE TABLE decimal_vg
FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_vgby
PREHOOK: query: EXPLAIN SELECT cint,
COUNT(cdecimal1), MAX(cdecimal1), MIN(cdecimal1), SUM(cdecimal1), AVG(cdecimal1), STDDEV_POP(cdecimal1), STDDEV_SAMP(cdecimal1),
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorization_part_project.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorization_part_project.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorization_part_project.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorization_part_project.q.out Tue Sep 2 19:56:56 2014
@@ -65,28 +65,28 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: alltypesorc_part
- Statistics: Num rows: 200 Data size: 4068 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 200 Data size: 41576 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (cdouble + 2) (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 200 Data size: 4068 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 200 Data size: 41576 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: double)
sort order: +
- Statistics: Num rows: 200 Data size: 4068 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 200 Data size: 41576 Basic stats: COMPLETE Column stats: NONE
Execution mode: vectorized
Reducer 2
Reduce Operator Tree:
Select Operator
expressions: KEY.reducesinkkey0 (type: double)
outputColumnNames: _col0
- Statistics: Num rows: 200 Data size: 4068 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 200 Data size: 41576 Basic stats: COMPLETE Column stats: NONE
Limit
Number of rows: 10
- Statistics: Num rows: 10 Data size: 200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 2070 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 10 Data size: 200 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 10 Data size: 2070 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
Files hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out (original) and hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out Tue Sep 2 19:56:56 2014 differ
Modified: hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorized_timestamp_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorized_timestamp_funcs.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorized_timestamp_funcs.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/tez/vectorized_timestamp_funcs.q.out Tue Sep 2 19:56:56 2014
@@ -106,15 +106,15 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: alltypesorc_string
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: to_unix_timestamp(ctimestamp1) (type: bigint), year(ctimestamp1) (type: int), month(ctimestamp1) (type: int), day(ctimestamp1) (type: int), dayofmonth(ctimestamp1) (type: int), weekofyear(ctimestamp1) (type: int), hour(ctimestamp1) (type: int), minute(ctimestamp1) (type: int), second(ctimestamp1) (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: bigint)
sort order: +
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int)
Execution mode: vectorized
Reducer 2
@@ -122,10 +122,10 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -249,15 +249,15 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: alltypesorc_string
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1) (type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1) (type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1) (type: int), second(stimestamp1) (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: bigint)
sort order: +
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int)
Execution mode: vectorized
Reducer 2
@@ -265,10 +265,10 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -392,15 +392,15 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: alltypesorc_string
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: (to_unix_timestamp(ctimestamp1) = to_unix_timestamp(stimestamp1)) (type: boolean), (year(ctimestamp1) = year(stimestamp1)) (type: boolean), (month(ctimestamp1) = month(stimestamp1)) (type: boolean), (day(ctimestamp1) = day(stimestamp1)) (type: boolean), (dayofmonth(ctimestamp1) = dayofmonth(stimestamp1)) (type: boolean), (weekofyear(ctimestamp1) = weekofyear(stimestamp1)) (type: boolean), (hour(ctimestamp1) = hour(stimestamp1)) (type: boolean), (minute(ctimestamp1) = minute(stimestamp1)) (type: boolean), (second(ctimestamp1) = second(stimestamp1)) (type: boolean)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: boolean)
sort order: +
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: boolean), _col2 (type: boolean), _col3 (type: boolean), _col4 (type: boolean), _col5 (type: boolean), _col6 (type: boolean), _col7 (type: boolean), _col8 (type: boolean)
Execution mode: vectorized
Reducer 2
@@ -408,10 +408,10 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: boolean), VALUE._col0 (type: boolean), VALUE._col1 (type: boolean), VALUE._col2 (type: boolean), VALUE._col3 (type: boolean), VALUE._col4 (type: boolean), VALUE._col5 (type: boolean), VALUE._col6 (type: boolean), VALUE._col7 (type: boolean)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 40 Data size: 622 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 40 Data size: 5694 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -539,15 +539,15 @@ STAGE PLANS:
Map Operator Tree:
TableScan
alias: alltypesorc_wrong
- Statistics: Num rows: 1 Data size: 698 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE
Select Operator
expressions: to_unix_timestamp(stimestamp1) (type: bigint), year(stimestamp1) (type: int), month(stimestamp1) (type: int), day(stimestamp1) (type: int), dayofmonth(stimestamp1) (type: int), weekofyear(stimestamp1) (type: int), hour(stimestamp1) (type: int), minute(stimestamp1) (type: int), second(stimestamp1) (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 1 Data size: 698 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE
Reduce Output Operator
key expressions: _col0 (type: bigint)
sort order: +
- Statistics: Num rows: 1 Data size: 698 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE
value expressions: _col1 (type: int), _col2 (type: int), _col3 (type: int), _col4 (type: int), _col5 (type: int), _col6 (type: int), _col7 (type: int), _col8 (type: int)
Execution mode: vectorized
Reducer 2
@@ -555,10 +555,10 @@ STAGE PLANS:
Select Operator
expressions: KEY.reducesinkkey0 (type: bigint), VALUE._col0 (type: int), VALUE._col1 (type: int), VALUE._col2 (type: int), VALUE._col3 (type: int), VALUE._col4 (type: int), VALUE._col5 (type: int), VALUE._col6 (type: int), VALUE._col7 (type: int)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
- Statistics: Num rows: 1 Data size: 698 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE
File Output Operator
compressed: false
- Statistics: Num rows: 1 Data size: 698 Basic stats: COMPLETE Column stats: NONE
+ Statistics: Num rows: 1 Data size: 103 Basic stats: COMPLETE Column stats: NONE
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Modified: hive/branches/tez/ql/src/test/results/clientpositive/touch.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/touch.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/touch.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/touch.q.out Tue Sep 2 19:56:56 2014
@@ -1,89 +1,95 @@
-PREHOOK: query: drop table tstsrc
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tstsrc
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: drop table tstsrcpart
-PREHOOK: type: DROPTABLE
-POSTHOOK: query: drop table tstsrcpart
-POSTHOOK: type: DROPTABLE
-PREHOOK: query: create table tstsrc like src
+PREHOOK: query: create database tc
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:tc
+POSTHOOK: query: create database tc
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:tc
+PREHOOK: query: create table tc.tstsrc like default.src
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: create table tstsrc like src
+PREHOOK: Output: database:tc
+PREHOOK: Output: tc@tstsrc
+POSTHOOK: query: create table tc.tstsrc like default.src
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@tstsrc
-PREHOOK: query: insert overwrite table tstsrc select key, value from src
+POSTHOOK: Output: database:tc
+POSTHOOK: Output: tc@tstsrc
+PREHOOK: query: insert overwrite table tc.tstsrc select key, value from default.src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: insert overwrite table tstsrc select key, value from src
+PREHOOK: Output: tc@tstsrc
+POSTHOOK: query: insert overwrite table tc.tstsrc select key, value from default.src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
-POSTHOOK: Output: default@tstsrc
+POSTHOOK: Output: tc@tstsrc
POSTHOOK: Lineage: tstsrc.key SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrc.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: create table tstsrcpart like srcpart
+PREHOOK: query: create table tc.tstsrcpart like default.srcpart
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@tstsrcpart
-POSTHOOK: query: create table tstsrcpart like srcpart
+PREHOOK: Output: database:tc
+PREHOOK: Output: tc@tstsrcpart
+POSTHOOK: query: create table tc.tstsrcpart like default.srcpart
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@tstsrcpart
-PREHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
-select key, value from srcpart where ds='2008-04-08' and hr='12'
+POSTHOOK: Output: database:tc
+POSTHOOK: Output: tc@tstsrcpart
+PREHOOK: query: insert overwrite table tc.tstsrcpart partition (ds='2008-04-08', hr='12')
+select key, value from default.srcpart where ds='2008-04-08' and hr='12'
PREHOOK: type: QUERY
PREHOOK: Input: default@srcpart
PREHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
-POSTHOOK: query: insert overwrite table tstsrcpart partition (ds='2008-04-08', hr='12')
-select key, value from srcpart where ds='2008-04-08' and hr='12'
+PREHOOK: Output: tc@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: insert overwrite table tc.tstsrcpart partition (ds='2008-04-08', hr='12')
+select key, value from default.srcpart where ds='2008-04-08' and hr='12'
POSTHOOK: type: QUERY
POSTHOOK: Input: default@srcpart
POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Output: tc@tstsrcpart@ds=2008-04-08/hr=12
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).key SIMPLE [(srcpart)srcpart.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: tstsrcpart PARTITION(ds=2008-04-08,hr=12).value SIMPLE [(srcpart)srcpart.FieldSchema(name:value, type:string, comment:default), ]
-PREHOOK: query: ALTER TABLE tstsrc TOUCH
+PREHOOK: query: ALTER TABLE tc.tstsrc TOUCH
PREHOOK: type: ALTERTABLE_TOUCH
-PREHOOK: Input: default@tstsrc
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: ALTER TABLE tstsrc TOUCH
+PREHOOK: Input: tc@tstsrc
+PREHOOK: Output: tc@tstsrc
+POSTHOOK: query: ALTER TABLE tc.tstsrc TOUCH
POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@tstsrc
-POSTHOOK: Output: default@tstsrc
-PREHOOK: query: ALTER TABLE tstsrcpart TOUCH
+POSTHOOK: Input: tc@tstsrc
+POSTHOOK: Output: tc@tstsrc
+PREHOOK: query: ALTER TABLE tc.tstsrcpart TOUCH
PREHOOK: type: ALTERTABLE_TOUCH
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Output: default@tstsrcpart
-POSTHOOK: query: ALTER TABLE tstsrcpart TOUCH
+PREHOOK: Input: tc@tstsrcpart
+PREHOOK: Output: tc@tstsrcpart
+POSTHOOK: query: ALTER TABLE tc.tstsrcpart TOUCH
POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Output: default@tstsrcpart
-PREHOOK: query: ALTER TABLE tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
+POSTHOOK: Input: tc@tstsrcpart
+POSTHOOK: Output: tc@tstsrcpart
+PREHOOK: query: ALTER TABLE tc.tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
PREHOOK: type: ALTERTABLE_TOUCH
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
-POSTHOOK: query: ALTER TABLE tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
+PREHOOK: Input: tc@tstsrcpart
+PREHOOK: Output: tc@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: query: ALTER TABLE tc.tstsrcpart TOUCH PARTITION (ds='2008-04-08', hr='12')
POSTHOOK: type: ALTERTABLE_TOUCH
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Input: default@tstsrcpart@ds=2008-04-08/hr=12
-POSTHOOK: Output: default@tstsrcpart@ds=2008-04-08/hr=12
-PREHOOK: query: drop table tstsrc
+POSTHOOK: Input: tc@tstsrcpart
+POSTHOOK: Input: tc@tstsrcpart@ds=2008-04-08/hr=12
+POSTHOOK: Output: tc@tstsrcpart@ds=2008-04-08/hr=12
+PREHOOK: query: drop table tc.tstsrc
PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@tstsrc
-PREHOOK: Output: default@tstsrc
-POSTHOOK: query: drop table tstsrc
+PREHOOK: Input: tc@tstsrc
+PREHOOK: Output: tc@tstsrc
+POSTHOOK: query: drop table tc.tstsrc
POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@tstsrc
-POSTHOOK: Output: default@tstsrc
-PREHOOK: query: drop table tstsrcpart
+POSTHOOK: Input: tc@tstsrc
+POSTHOOK: Output: tc@tstsrc
+PREHOOK: query: drop table tc.tstsrcpart
PREHOOK: type: DROPTABLE
-PREHOOK: Input: default@tstsrcpart
-PREHOOK: Output: default@tstsrcpart
-POSTHOOK: query: drop table tstsrcpart
+PREHOOK: Input: tc@tstsrcpart
+PREHOOK: Output: tc@tstsrcpart
+POSTHOOK: query: drop table tc.tstsrcpart
POSTHOOK: type: DROPTABLE
-POSTHOOK: Input: default@tstsrcpart
-POSTHOOK: Output: default@tstsrcpart
+POSTHOOK: Input: tc@tstsrcpart
+POSTHOOK: Output: tc@tstsrcpart
+PREHOOK: query: drop database tc
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:tc
+PREHOOK: Output: database:tc
+POSTHOOK: query: drop database tc
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:tc
+POSTHOOK: Output: database:tc
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_case.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_case.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_case.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_case.q.out Tue Sep 2 19:56:56 2014
@@ -2,12 +2,24 @@ PREHOOK: query: DESCRIBE FUNCTION case
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION case
POSTHOOK: type: DESCFUNCTION
-There is no documentation for function 'case'
+CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END - When a = b, returns c; when a = d, return e; else return f
PREHOOK: query: DESCRIBE FUNCTION EXTENDED case
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED case
POSTHOOK: type: DESCFUNCTION
-There is no documentation for function 'case'
+CASE a WHEN b THEN c [WHEN d THEN e]* [ELSE f] END - When a = b, returns c; when a = d, return e; else return f
+Example:
+ SELECT
+ CASE deptno
+ WHEN 1 THEN Engineering
+ WHEN 2 THEN Finance
+ ELSE admin
+ END,
+ CASE zone
+ WHEN 7 THEN Americas
+ ELSE Asia-Pac
+ END
+ FROM emp_details
PREHOOK: query: EXPLAIN
SELECT CASE 1
WHEN 1 THEN 2
Modified: hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/udf_when.q.out Tue Sep 2 19:56:56 2014
@@ -2,12 +2,24 @@ PREHOOK: query: DESCRIBE FUNCTION when
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION when
POSTHOOK: type: DESCFUNCTION
-There is no documentation for function 'when'
+CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END - When a = true, returns b; when c = true, return d; else return e
PREHOOK: query: DESCRIBE FUNCTION EXTENDED when
PREHOOK: type: DESCFUNCTION
POSTHOOK: query: DESCRIBE FUNCTION EXTENDED when
POSTHOOK: type: DESCFUNCTION
-There is no documentation for function 'when'
+CASE WHEN a THEN b [WHEN c THEN d]* [ELSE e] END - When a = true, returns b; when c = true, return d; else return e
+Example:
+ SELECT
+ CASE
+ WHEN deptno=1 THEN Engineering
+ WHEN deptno=2 THEN Finance
+ ELSE admin
+ END,
+ CASE
+ WHEN zone=7 THEN Americas
+ ELSE Asia-Pac
+ END
+ FROM emp_details
PREHOOK: query: EXPLAIN
SELECT CASE
WHEN 1=1 THEN 2
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
Files hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out (original) and hive/branches/tez/ql/src/test/results/clientpositive/union24.q.out Tue Sep 2 19:56:56 2014 differ
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union25.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union25.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union25.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union25.q.out Tue Sep 2 19:56:56 2014
@@ -210,7 +210,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: tmp_unionall
+ name: default.tmp_unionall
Stage: Stage-3
Stats-Aggr Operator
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union27.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union27.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union27.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union27.q.out Tue Sep 2 19:56:56 2014
@@ -2,24 +2,33 @@ PREHOOK: query: -- SORT_BEFORE_DIFF
create table jackson_sev_same as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@jackson_sev_same
POSTHOOK: query: -- SORT_BEFORE_DIFF
create table jackson_sev_same as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@jackson_sev_same
PREHOOK: query: create table dim_pho as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@dim_pho
POSTHOOK: query: create table dim_pho as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@dim_pho
PREHOOK: query: create table jackson_sev_add as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@jackson_sev_add
POSTHOOK: query: create table jackson_sev_add as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@jackson_sev_add
PREHOOK: query: explain select b.* from jackson_sev_same a join (select * from dim_pho union all select * from jackson_sev_add)b on a.key=b.key and b.key=97
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union31.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union31.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union31.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union31.q.out Tue Sep 2 19:56:56 2014
@@ -13,16 +13,22 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table t1 as select * from src where key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: create table t1 as select * from src where key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: create table t2 as select * from src where key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
POSTHOOK: query: create table t2 as select * from src where key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t2
PREHOOK: query: create table t3(key string, cnt int)
PREHOOK: type: CREATETABLE
@@ -598,16 +604,22 @@ POSTHOOK: Output: default@t2
PREHOOK: query: create table t1 as select * from src where key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: create table t1 as select * from src where key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: create table t2 as select key, count(1) as cnt from src where key < 10 group by key
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
POSTHOOK: query: create table t2 as select key, count(1) as cnt from src where key < 10 group by key
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t2
PREHOOK: query: create table t7(c1 string, cnt int)
PREHOOK: type: CREATETABLE
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union32.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union32.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union32.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union32.q.out Tue Sep 2 19:56:56 2014
@@ -6,6 +6,8 @@ PREHOOK: query: -- SORT_QUERY_RESULTS
CREATE TABLE t1 AS SELECT * FROM src WHERE key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t1
POSTHOOK: query: -- SORT_QUERY_RESULTS
-- This tests various union queries which have columns on one side of the query
@@ -14,13 +16,17 @@ POSTHOOK: query: -- SORT_QUERY_RESULTS
CREATE TABLE t1 AS SELECT * FROM src WHERE key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t1
PREHOOK: query: CREATE TABLE t2 AS SELECT * FROM src WHERE key < 10
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@t2
POSTHOOK: query: CREATE TABLE t2 AS SELECT * FROM src WHERE key < 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@t2
PREHOOK: query: -- Test simple union with double
EXPLAIN
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_null.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_null.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_null.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_null.q.out Tue Sep 2 19:56:56 2014
@@ -1,26 +1,26 @@
PREHOOK: query: -- SORT_BEFORE_DIFF
-- HIVE-2901
-select x from (select value as x from src union all select NULL as x from src)a limit 10
+select x from (select value as x from src order by x limit 5 union all select NULL as x from src limit 5) a
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: -- SORT_BEFORE_DIFF
-- HIVE-2901
-select x from (select value as x from src union all select NULL as x from src)a limit 10
+select x from (select value as x from src order by x limit 5 union all select NULL as x from src limit 5) a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-val_238
+val_0
+val_0
+val_0
+val_10
+val_100
NULL
-val_86
NULL
-val_311
NULL
-val_27
NULL
-val_165
NULL
PREHOOK: query: -- HIVE-4837
select * from (select null as N from src1 group by key UNION ALL select null as N from src1 group by key ) a
Modified: hive/branches/tez/ql/src/test/results/clientpositive/union_top_level.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/union_top_level.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/union_top_level.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/union_top_level.q.out Tue Sep 2 19:56:56 2014
@@ -580,7 +580,7 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat
serde name: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: union_top
+ name: default.union_top
Stage: Stage-3
Stats-Aggr Operator
@@ -693,6 +693,8 @@ union all
select key, 2 as value from src where key % 3 == 2 limit 3
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@union_top
POSTHOOK: query: create table union_top as
select key, 0 as value from src where key % 3 == 0 limit 3
union all
@@ -701,6 +703,7 @@ union all
select key, 2 as value from src where key % 3 == 2 limit 3
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_top
PREHOOK: query: select * from union_top
PREHOOK: type: QUERY
@@ -1305,7 +1308,7 @@ union all
select `src`.`key`, 1 as `value` from `default`.`src` where `src`.`key` % 3 == 1 limit 3
union all
select `src`.`key`, 2 as `value` from `default`.`src` where `src`.`key` % 3 == 2 limit 3
- name: union_top_view
+ name: default.union_top_view
original text: select key, 0 as value from src where key % 3 == 0 limit 3
union all
select key, 1 as value from src where key % 3 == 1 limit 3
@@ -1320,6 +1323,8 @@ union all
select key, 2 as value from src where key % 3 == 2 limit 3
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@union_top_view
POSTHOOK: query: create view union_top_view as
select key, 0 as value from src where key % 3 == 0 limit 3
union all
@@ -1328,6 +1333,7 @@ union all
select key, 2 as value from src where key % 3 == 2 limit 3
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@union_top_view
PREHOOK: query: select * from union_top_view
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/unset_table_view_property.q.out Tue Sep 2 19:56:56 2014
@@ -1,29 +1,35 @@
-PREHOOK: query: CREATE TABLE testTable(col1 INT, col2 INT)
+PREHOOK: query: CREATE DATABASE vt
+PREHOOK: type: CREATEDATABASE
+PREHOOK: Output: database:vt
+POSTHOOK: query: CREATE DATABASE vt
+POSTHOOK: type: CREATEDATABASE
+POSTHOOK: Output: database:vt
+PREHOOK: query: CREATE TABLE vt.testTable(col1 INT, col2 INT)
PREHOOK: type: CREATETABLE
-PREHOOK: Output: database:default
-PREHOOK: Output: default@testTable
-POSTHOOK: query: CREATE TABLE testTable(col1 INT, col2 INT)
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@testTable
+POSTHOOK: query: CREATE TABLE vt.testTable(col1 INT, col2 INT)
POSTHOOK: type: CREATETABLE
-POSTHOOK: Output: database:default
-POSTHOOK: Output: default@testTable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Output: database:vt
+POSTHOOK: Output: vt@testTable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
PREHOOK: query: -- UNSET TABLE PROPERTIES
-ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3')
+ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET TABLE PROPERTIES
-ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3')
+ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -35,18 +41,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- UNSET all the properties
-ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'c')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'c')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET all the properties
-ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'c')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'c')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
@@ -55,17 +61,17 @@ numRows -1
rawDataSize -1
totalSize 0
#### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4')
+PREHOOK: query: ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
-POSTHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4')
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
+POSTHOOK: query: ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'c'='3', 'd'='4')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -78,18 +84,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties
-ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'd')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'd')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET a subset of the properties
-ALTER TABLE testTable UNSET TBLPROPERTIES ('a', 'd')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('a', 'd')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
c 3
@@ -100,18 +106,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- the same property being UNSET multiple times
-ALTER TABLE testTable UNSET TBLPROPERTIES ('c', 'c', 'c')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('c', 'c', 'c')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- the same property being UNSET multiple times
-ALTER TABLE testTable UNSET TBLPROPERTIES ('c', 'c', 'c')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES ('c', 'c', 'c')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
#### A masked pattern was here ####
@@ -120,17 +126,17 @@ numRows -1
rawDataSize -1
totalSize 0
#### A masked pattern was here ####
-PREHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4')
+PREHOOK: query: ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
-POSTHOOK: query: ALTER TABLE testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4')
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
+POSTHOOK: query: ALTER TABLE vt.testTable SET TBLPROPERTIES ('a'='1', 'b' = '2', 'c'='3', 'd'='4')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -144,18 +150,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'b', 'f')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -167,18 +173,18 @@ rawDataSize -1
totalSize 0
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z')
PREHOOK: type: ALTERTABLE_PROPERTIES
-PREHOOK: Input: default@testtable
-PREHOOK: Output: default@testtable
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
POSTHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER TABLE testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z')
+ALTER TABLE vt.testTable UNSET TBLPROPERTIES IF EXISTS ('b', 'd', 'c', 'f', 'x', 'y', 'z')
POSTHOOK: type: ALTERTABLE_PROPERTIES
-POSTHOOK: Input: default@testtable
-POSTHOOK: Output: default@testtable
-PREHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
+PREHOOK: query: SHOW TBLPROPERTIES vt.testTable
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testTable
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testTable
POSTHOOK: type: SHOW_TBLPROPERTIES
COLUMN_STATS_ACCURATE false
a 1
@@ -188,57 +194,68 @@ numRows -1
rawDataSize -1
totalSize 0
#### A masked pattern was here ####
+PREHOOK: query: DROP TABLE vt.testTable
+PREHOOK: type: DROPTABLE
+PREHOOK: Input: vt@testtable
+PREHOOK: Output: vt@testtable
+POSTHOOK: query: DROP TABLE vt.testTable
+POSTHOOK: type: DROPTABLE
+POSTHOOK: Input: vt@testtable
+POSTHOOK: Output: vt@testtable
PREHOOK: query: -- UNSET VIEW PROPERTIES
-CREATE VIEW testView AS SELECT value FROM src WHERE key=86
+CREATE VIEW vt.testView AS SELECT value FROM src WHERE key=86
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@src
+PREHOOK: Output: database:vt
+PREHOOK: Output: vt@testView
POSTHOOK: query: -- UNSET VIEW PROPERTIES
-CREATE VIEW testView AS SELECT value FROM src WHERE key=86
+CREATE VIEW vt.testView AS SELECT value FROM src WHERE key=86
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@src
-POSTHOOK: Output: default@testView
-PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
+POSTHOOK: Output: database:vt
+POSTHOOK: Output: vt@testView
+PREHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
-POSTHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
+POSTHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB'='200')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
propB 200
#### A masked pattern was here ####
PREHOOK: query: -- UNSET all the properties
-ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propB')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propB')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- UNSET all the properties
-ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propB')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propB')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
-PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400')
+PREHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
-POSTHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400')
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
+POSTHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propC'='300', 'propD'='400')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
@@ -246,48 +263,48 @@ propC 300
propD 400
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties
-ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propC')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propC')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- UNSET a subset of the properties
-ALTER VIEW testView UNSET TBLPROPERTIES ('propA', 'propC')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propA', 'propC')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propD 400
#### A masked pattern was here ####
PREHOOK: query: -- the same property being UNSET multiple times
-ALTER VIEW testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- the same property being UNSET multiple times
-ALTER VIEW testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES ('propD', 'propD', 'propD')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
-PREHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400')
+PREHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
-POSTHOOK: query: ALTER VIEW testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400')
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
+POSTHOOK: query: ALTER VIEW vt.testView SET TBLPROPERTIES ('propA'='100', 'propB' = '200', 'propC'='300', 'propD'='400')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
@@ -296,37 +313,53 @@ propC 300
propD 400
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propC', 'propD', 'propD', 'propC', 'propZ')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
propB 200
#### A masked pattern was here ####
PREHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF')
PREHOOK: type: ALTERVIEW_PROPERTIES
-PREHOOK: Input: default@testview
-PREHOOK: Output: default@testview
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
POSTHOOK: query: -- UNSET a subset of the properties and some non-existed properties using IF EXISTS
-ALTER VIEW testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF')
+ALTER VIEW vt.testView UNSET TBLPROPERTIES IF EXISTS ('propB', 'propC', 'propD', 'propF')
POSTHOOK: type: ALTERVIEW_PROPERTIES
-POSTHOOK: Input: default@testview
-POSTHOOK: Output: default@testview
-PREHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: SHOW TBLPROPERTIES vt.testView
PREHOOK: type: SHOW_TBLPROPERTIES
-POSTHOOK: query: SHOW TBLPROPERTIES testView
+POSTHOOK: query: SHOW TBLPROPERTIES vt.testView
POSTHOOK: type: SHOW_TBLPROPERTIES
#### A masked pattern was here ####
propA 100
#### A masked pattern was here ####
+PREHOOK: query: DROP VIEW vt.testView
+PREHOOK: type: DROPVIEW
+PREHOOK: Input: vt@testview
+PREHOOK: Output: vt@testview
+POSTHOOK: query: DROP VIEW vt.testView
+POSTHOOK: type: DROPVIEW
+POSTHOOK: Input: vt@testview
+POSTHOOK: Output: vt@testview
+PREHOOK: query: DROP DATABASE vt
+PREHOOK: type: DROPDATABASE
+PREHOOK: Input: database:vt
+PREHOOK: Output: database:vt
+POSTHOOK: query: DROP DATABASE vt
+POSTHOOK: type: DROPDATABASE
+POSTHOOK: Input: database:vt
+POSTHOOK: Output: database:vt
Modified: hive/branches/tez/ql/src/test/results/clientpositive/updateAccessTime.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/updateAccessTime.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/updateAccessTime.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/updateAccessTime.q.out Tue Sep 2 19:56:56 2014
@@ -5,9 +5,12 @@ POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tstsrc as select * from src
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@src
+PREHOOK: Output: database:default
+PREHOOK: Output: default@tstsrc
POSTHOOK: query: create table tstsrc as select * from src
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@tstsrc
PREHOOK: query: desc extended tstsrc
PREHOOK: type: DESCTABLE
Modified: hive/branches/tez/ql/src/test/results/clientpositive/varchar_nested_types.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/varchar_nested_types.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/varchar_nested_types.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/varchar_nested_types.q.out Tue Sep 2 19:56:56 2014
@@ -164,11 +164,14 @@ create table varchar_nested_cta as
select * from varchar_nested_struct
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@varchar_nested_struct
+PREHOOK: Output: database:default
+PREHOOK: Output: default@varchar_nested_cta
POSTHOOK: query: -- nested type with create table as
create table varchar_nested_cta as
select * from varchar_nested_struct
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@varchar_nested_struct
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_nested_cta
PREHOOK: query: describe varchar_nested_cta
PREHOOK: type: DESCTABLE
@@ -191,11 +194,14 @@ create table varchar_nested_view as
select * from varchar_nested_struct
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@varchar_nested_struct
+PREHOOK: Output: database:default
+PREHOOK: Output: default@varchar_nested_view
POSTHOOK: query: -- nested type with view
create table varchar_nested_view as
select * from varchar_nested_struct
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@varchar_nested_struct
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@varchar_nested_view
PREHOOK: query: describe varchar_nested_view
PREHOOK: type: DESCTABLE
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vector_between_in.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vector_between_in.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vector_between_in.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vector_between_in.q.out Tue Sep 2 19:56:56 2014
@@ -1,9 +1,12 @@
PREHOOK: query: CREATE TABLE decimal_date_test STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2, CAST(CAST((CAST(cint AS BIGINT) *ctinyint) AS TIMESTAMP) AS DATE) AS cdate FROM alltypesorc ORDER BY cdate
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_date_test
POSTHOOK: query: CREATE TABLE decimal_date_test STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2, CAST(CAST((CAST(cint AS BIGINT) *ctinyint) AS TIMESTAMP) AS DATE) AS cdate FROM alltypesorc ORDER BY cdate
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_date_test
PREHOOK: query: EXPLAIN SELECT cdate FROM decimal_date_test WHERE cdate IN (CAST("1969-10-26" AS DATE), CAST("1969-07-14" AS DATE)) ORDER BY cdate
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out Tue Sep 2 19:56:56 2014
@@ -5,6 +5,8 @@ PREHOOK: query: CREATE TABLE decimal_vgb
FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_vgby
POSTHOOK: query: CREATE TABLE decimal_vgby STORED AS ORC AS
SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1,
CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2,
@@ -12,6 +14,7 @@ POSTHOOK: query: CREATE TABLE decimal_vg
FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_vgby
PREHOOK: query: EXPLAIN SELECT cint,
COUNT(cdecimal1), MAX(cdecimal1), MIN(cdecimal1), SUM(cdecimal1), AVG(cdecimal1), STDDEV_POP(cdecimal1), STDDEV_SAMP(cdecimal1),
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out Tue Sep 2 19:56:56 2014
@@ -1,9 +1,12 @@
PREHOOK: query: CREATE TABLE decimal_test STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2 FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_test
POSTHOOK: query: CREATE TABLE decimal_test STORED AS ORC AS SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2 FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_test
PREHOOK: query: EXPLAIN SELECT cdecimal1 + cdecimal2, cdecimal1 - (2*cdecimal2), ((cdecimal1+2.34)/cdecimal2), (cdecimal1 * (cdecimal2/3.4)), cdecimal1 % 10, CAST(cdecimal1 AS INT), CAST(cdecimal2 AS SMALLINT), CAST(cdecimal2 AS TINYINT), CAST(cdecimal1 AS BIGINT), CAST (cdecimal1 AS BOOLEAN), CAST(cdecimal2 AS DOUBLE), CAST(cdecimal1 AS FLOAT), CAST(cdecimal2 AS STRING), CAST(cdecimal1 AS TIMESTAMP) FROM decimal_test WHERE cdecimal1 > 0 AND cdecimal1 < 12345.5678 AND cdecimal2 != 0 AND cdecimal2 > 1000 AND cdouble IS NOT NULL LIMIT 10
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out Tue Sep 2 19:56:56 2014
@@ -5,6 +5,8 @@ PREHOOK: query: CREATE TABLE decimal_map
FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_mapjoin
POSTHOOK: query: CREATE TABLE decimal_mapjoin STORED AS ORC AS
SELECT cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1,
CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2,
@@ -12,6 +14,7 @@ POSTHOOK: query: CREATE TABLE decimal_ma
FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_mapjoin
PREHOOK: query: EXPLAIN SELECT l.cint, r.cint, l.cdecimal1, r.cdecimal2
FROM decimal_mapjoin l
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out Tue Sep 2 19:56:56 2014
@@ -1,9 +1,12 @@
PREHOOK: query: CREATE TABLE decimal_test STORED AS ORC AS SELECT cbigint, cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2 FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@decimal_test
POSTHOOK: query: CREATE TABLE decimal_test STORED AS ORC AS SELECT cbigint, cdouble, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal1, CAST (((cdouble*9.3)/13) AS DECIMAL(23,14)) AS cdecimal2 FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@decimal_test
PREHOOK: query: -- Test math functions in vectorized mode to verify they run correctly end-to-end.
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vectorization_decimal_date.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vectorization_decimal_date.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
--- hive/branches/tez/ql/src/test/results/clientpositive/vectorization_decimal_date.q.out (original)
+++ hive/branches/tez/ql/src/test/results/clientpositive/vectorization_decimal_date.q.out Tue Sep 2 19:56:56 2014
@@ -1,9 +1,12 @@
PREHOOK: query: CREATE TABLE date_decimal_test STORED AS ORC AS SELECT cint, cdouble, CAST (CAST (cint AS TIMESTAMP) AS DATE) AS cdate, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal FROM alltypesorc
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@alltypesorc
+PREHOOK: Output: database:default
+PREHOOK: Output: default@date_decimal_test
POSTHOOK: query: CREATE TABLE date_decimal_test STORED AS ORC AS SELECT cint, cdouble, CAST (CAST (cint AS TIMESTAMP) AS DATE) AS cdate, CAST (((cdouble*22.1)/37) AS DECIMAL(20,10)) AS cdecimal FROM alltypesorc
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@alltypesorc
+POSTHOOK: Output: database:default
POSTHOOK: Output: default@date_decimal_test
PREHOOK: query: EXPLAIN SELECT cdate, cdecimal from date_decimal_test where cint IS NOT NULL AND cdouble IS NOT NULL LIMIT 10
PREHOOK: type: QUERY
Modified: hive/branches/tez/ql/src/test/results/clientpositive/vectorized_ptf.q.out
URL: http://svn.apache.org/viewvc/hive/branches/tez/ql/src/test/results/clientpositive/vectorized_ptf.q.out?rev=1622108&r1=1622107&r2=1622108&view=diff
==============================================================================
Files hive/branches/tez/ql/src/test/results/clientpositive/vectorized_ptf.q.out (original) and hive/branches/tez/ql/src/test/results/clientpositive/vectorized_ptf.q.out Tue Sep 2 19:56:56 2014 differ