You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2015/01/23 20:59:24 UTC
svn commit: r1654355 [23/27] - in /hive/branches/llap: ./
beeline/src/java/org/apache/hive/beeline/
cli/src/java/org/apache/hadoop/hive/cli/
common/src/java/org/apache/hadoop/hive/common/
common/src/java/org/apache/hadoop/hive/conf/ data/conf/ data/con...
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ppd_join4.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ppd_join4.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ppd_join4.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ppd_join4.q.out Fri Jan 23 19:59:11 2015
@@ -82,7 +82,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 'a' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: 'a' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
TableScan
alias: t3
@@ -93,7 +93,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 'a' (type: string)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: 'a' (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ppd_join_filter.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ppd_join_filter.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ppd_join_filter.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ppd_join_filter.q.out Fri Jan 23 19:59:11 2015
@@ -202,7 +202,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a]
+ /src [$hdt$_1:$hdt$_1:$hdt$_1:a]
Needs Tagging: false
Reduce Operator Tree:
Group By Operator
@@ -345,7 +345,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_0:a]
+ /src [$hdt$_0:a]
#### A masked pattern was here ####
Needs Tagging: true
Reduce Operator Tree:
@@ -627,7 +627,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a]
+ /src [$hdt$_1:$hdt$_1:$hdt$_1:a]
Needs Tagging: false
Reduce Operator Tree:
Group By Operator
@@ -762,7 +762,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_0:a]
+ /src [$hdt$_0:a]
#### A masked pattern was here ####
Needs Tagging: true
Reduce Operator Tree:
@@ -1040,7 +1040,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a]
+ /src [$hdt$_1:$hdt$_1:$hdt$_1:a]
Needs Tagging: false
Reduce Operator Tree:
Group By Operator
@@ -1179,7 +1179,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_0:a]
+ /src [$hdt$_0:a]
#### A masked pattern was here ####
Needs Tagging: true
Reduce Operator Tree:
@@ -1461,7 +1461,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_1:$hdt$_1:$hdt$_1:a]
+ /src [$hdt$_1:$hdt$_1:$hdt$_1:a]
Needs Tagging: false
Reduce Operator Tree:
Group By Operator
@@ -1596,7 +1596,7 @@ STAGE PLANS:
name: default.src
name: default.src
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_0:a]
+ /src [$hdt$_0:a]
#### A masked pattern was here ####
Needs Tagging: true
Reduce Operator Tree:
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ppd_outer_join5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ppd_outer_join5.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ppd_outer_join5.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ppd_outer_join5.q.out Fri Jan 23 19:59:11 2015
@@ -73,9 +73,9 @@ STAGE PLANS:
predicate: (id = 20) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
- key expressions: 20 (type: int)
+ key expressions: id (type: int)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: id (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
Reduce Operator Tree:
@@ -126,9 +126,9 @@ STAGE PLANS:
predicate: (id = 20) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
- key expressions: 20 (type: int)
+ key expressions: id (type: int)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: id (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
TableScan
@@ -138,9 +138,9 @@ STAGE PLANS:
predicate: (id = 20) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
- key expressions: 20 (type: int)
+ key expressions: id (type: int)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: id (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
TableScan
@@ -164,10 +164,10 @@ STAGE PLANS:
0 id (type: int)
1 id (type: int)
2 id (type: int)
- outputColumnNames: _col1, _col2, _col7, _col8, _col12, _col13, _col14
+ outputColumnNames: _col0, _col1, _col2, _col7, _col8, _col12, _col13, _col14
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: 20 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col7 (type: string), _col8 (type: string), _col12 (type: int), _col13 (type: string), _col14 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col7 (type: string), _col8 (type: string), _col12 (type: int), _col13 (type: string), _col14 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
@@ -203,9 +203,9 @@ STAGE PLANS:
predicate: (id = 20) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
- key expressions: 20 (type: int)
+ key expressions: id (type: int)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: id (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
TableScan
@@ -215,9 +215,9 @@ STAGE PLANS:
predicate: (id = 20) (type: boolean)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Reduce Output Operator
- key expressions: 20 (type: int)
+ key expressions: id (type: int)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: id (type: int)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
value expressions: key (type: string), value (type: string)
TableScan
@@ -241,10 +241,10 @@ STAGE PLANS:
0 id (type: int)
1 id (type: int)
2 id (type: int)
- outputColumnNames: _col1, _col2, _col7, _col8, _col12, _col13, _col14
+ outputColumnNames: _col0, _col1, _col2, _col7, _col8, _col12, _col13, _col14
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: 20 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col7 (type: string), _col8 (type: string), _col12 (type: int), _col13 (type: string), _col14 (type: string)
+ expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col7 (type: string), _col8 (type: string), _col12 (type: int), _col13 (type: string), _col14 (type: string)
outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ppd_transform.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ppd_transform.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ppd_transform.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ppd_transform.q.out Fri Jan 23 19:59:11 2015
@@ -1,4 +1,6 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM (
FROM src
SELECT TRANSFORM(src.key, src.value)
@@ -7,7 +9,9 @@ FROM (
) tmap
SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
FROM (
FROM src
SELECT TRANSFORM(src.key, src.value)
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ppd_union_view.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ppd_union_view.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ppd_union_view.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ppd_union_view.q.out Fri Jan 23 19:59:11 2015
@@ -179,7 +179,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: keymap (type: string), '2011-10-13' (type: string)
sort order: ++
- Map-reduce partition columns: keymap (type: string)
+ Map-reduce partition columns: keymap (type: string), '2011-10-13' (type: string)
Statistics: Num rows: 1 Data size: 14 Basic stats: COMPLETE Column stats: NONE
tag: 0
value expressions: value (type: string)
@@ -195,7 +195,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: keymap (type: string), '2011-10-13' (type: string)
sort order: ++
- Map-reduce partition columns: keymap (type: string)
+ Map-reduce partition columns: keymap (type: string), '2011-10-13' (type: string)
Statistics: Num rows: 1 Data size: 12 Basic stats: COMPLETE Column stats: NONE
tag: 1
value expressions: key (type: string)
@@ -476,8 +476,8 @@ STAGE PLANS:
outputColumnNames: _col1, _col3
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Select Operator
- expressions: _col3 (type: string), _col1 (type: string)
- outputColumnNames: _col0, _col1
+ expressions: _col3 (type: string), _col1 (type: string), '2011-10-15' (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
File Output Operator
compressed: false
@@ -488,8 +488,8 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns _col0,_col1
- columns.types string,string
+ columns _col0,_col1,_col2
+ columns.types string,string,string
escape.delim \
serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
@@ -505,13 +505,13 @@ STAGE PLANS:
Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE Column stats: NONE
GatherStats: false
Select Operator
- expressions: key (type: string), value (type: string)
- outputColumnNames: _col0, _col1
+ expressions: key (type: string), value (type: string), '2011-10-15' (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE Column stats: NONE
Union
Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), '2011-10-15' (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -540,7 +540,7 @@ STAGE PLANS:
Union
Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE Column stats: NONE
Select Operator
- expressions: _col0 (type: string), _col1 (type: string), '2011-10-15' (type: string)
+ expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 1 Data size: 11 Basic stats: COMPLETE Column stats: NONE
File Output Operator
@@ -573,8 +573,8 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns _col0,_col1
- columns.types string,string
+ columns _col0,_col1,_col2
+ columns.types string,string,string
escape.delim \
serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
@@ -582,8 +582,8 @@ STAGE PLANS:
input format: org.apache.hadoop.mapred.SequenceFileInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
properties:
- columns _col0,_col1
- columns.types string,string
+ columns _col0,_col1,_col2
+ columns.types string,string,string
escape.delim \
serialization.lib org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ppd_vc.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ppd_vc.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ppd_vc.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ppd_vc.q.out Fri Jan 23 19:59:11 2015
@@ -679,11 +679,11 @@ STAGE PLANS:
name: default.srcpart
name: default.srcpart
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_0:a]
- /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:$hdt$_1:$hdt$_1:srcpart]
- /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:$hdt$_1:$hdt$_1:srcpart]
- /srcpart/ds=2008-04-09/hr=11 [$hdt$_0:$hdt$_1:$hdt$_1:srcpart]
- /srcpart/ds=2008-04-09/hr=12 [$hdt$_0:$hdt$_1:$hdt$_1:srcpart]
+ /src [$hdt$_0:a]
+ /srcpart/ds=2008-04-08/hr=11 [$hdt$_1:$hdt$_1:srcpart]
+ /srcpart/ds=2008-04-08/hr=12 [$hdt$_1:$hdt$_1:srcpart]
+ /srcpart/ds=2008-04-09/hr=11 [$hdt$_1:$hdt$_1:srcpart]
+ /srcpart/ds=2008-04-09/hr=12 [$hdt$_1:$hdt$_1:srcpart]
Needs Tagging: true
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ptf_matchpath.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ptf_matchpath.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ptf_matchpath.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ptf_matchpath.q.out Fri Jan 23 19:59:11 2015
@@ -34,7 +34,9 @@ POSTHOOK: query: LOAD DATA LOCAL INPATH
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@flights_tiny
-PREHOOK: query: -- 1. basic Matchpath test
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- 1. basic Matchpath test
select origin_city_name, fl_num, year, month, day_of_month, sz, tpath
from matchpath(on
flights_tiny
@@ -47,7 +49,9 @@ from matchpath(on
PREHOOK: type: QUERY
PREHOOK: Input: default@flights_tiny
#### A masked pattern was here ####
-POSTHOOK: query: -- 1. basic Matchpath test
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- 1. basic Matchpath test
select origin_city_name, fl_num, year, month, day_of_month, sz, tpath
from matchpath(on
flights_tiny
@@ -65,17 +69,17 @@ Baltimore 1142 2010 10 21 5 21
Baltimore 1142 2010 10 22 4 22
Baltimore 1142 2010 10 25 3 25
Baltimore 1142 2010 10 26 2 26
-Chicago 1531 2010 10 21 2 21
-Chicago 1531 2010 10 25 3 25
-Chicago 1531 2010 10 26 2 26
Baltimore 1599 2010 10 21 2 21
Baltimore 1599 2010 10 25 3 25
Baltimore 1599 2010 10 26 2 26
+Chicago 1531 2010 10 21 2 21
+Chicago 1531 2010 10 25 3 25
+Chicago 1531 2010 10 26 2 26
Chicago 361 2010 10 20 2 20
-Washington 7291 2010 10 27 2 27
Chicago 897 2010 10 20 4 20
Chicago 897 2010 10 21 3 21
Chicago 897 2010 10 22 2 22
+Washington 7291 2010 10 27 2 27
PREHOOK: query: -- 2. Matchpath on 1 partition
select origin_city_name, fl_num, year, month, day_of_month, sz, tpath
from matchpath(on
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ptf_rcfile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ptf_rcfile.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ptf_rcfile.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ptf_rcfile.q.out Fri Jan 23 19:59:11 2015
@@ -38,7 +38,9 @@ POSTHOOK: query: LOAD DATA LOCAL INPATH
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@part_rc
-PREHOOK: query: -- testWindowingPTFWithPartRC
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- testWindowingPTFWithPartRC
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
dense_rank() over (partition by p_mfgr order by p_name) as dr,
@@ -49,7 +51,9 @@ order by p_name)
PREHOOK: type: QUERY
PREHOOK: Input: default@part_rc
#### A masked pattern was here ####
-POSTHOOK: query: -- testWindowingPTFWithPartRC
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- testWindowingPTFWithPartRC
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
dense_rank() over (partition by p_mfgr order by p_name) as dr,
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ptf_register_tblfn.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ptf_register_tblfn.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ptf_register_tblfn.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ptf_register_tblfn.q.out Fri Jan 23 19:59:11 2015
@@ -40,7 +40,9 @@ PREHOOK: Output: matchpathtest
POSTHOOK: query: create temporary function matchpathtest as 'org.apache.hadoop.hive.ql.udf.ptf.MatchPath$MatchPathResolver'
POSTHOOK: type: CREATEFUNCTION
POSTHOOK: Output: matchpathtest
-PREHOOK: query: -- 1. basic Matchpath test
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- 1. basic Matchpath test
select origin_city_name, fl_num, year, month, day_of_month, sz, tpath
from matchpathtest(on
flights_tiny
@@ -53,7 +55,9 @@ from matchpathtest(on
PREHOOK: type: QUERY
PREHOOK: Input: default@flights_tiny
#### A masked pattern was here ####
-POSTHOOK: query: -- 1. basic Matchpath test
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- 1. basic Matchpath test
select origin_city_name, fl_num, year, month, day_of_month, sz, tpath
from matchpathtest(on
flights_tiny
@@ -71,17 +75,17 @@ Baltimore 1142 2010 10 21 5 21
Baltimore 1142 2010 10 22 4 22
Baltimore 1142 2010 10 25 3 25
Baltimore 1142 2010 10 26 2 26
-Chicago 1531 2010 10 21 2 21
-Chicago 1531 2010 10 25 3 25
-Chicago 1531 2010 10 26 2 26
Baltimore 1599 2010 10 21 2 21
Baltimore 1599 2010 10 25 3 25
Baltimore 1599 2010 10 26 2 26
+Chicago 1531 2010 10 21 2 21
+Chicago 1531 2010 10 25 3 25
+Chicago 1531 2010 10 26 2 26
Chicago 361 2010 10 20 2 20
-Washington 7291 2010 10 27 2 27
Chicago 897 2010 10 20 4 20
Chicago 897 2010 10 21 3 21
Chicago 897 2010 10 22 2 22
+Washington 7291 2010 10 27 2 27
PREHOOK: query: drop temporary function matchpathtest
PREHOOK: type: DROPFUNCTION
PREHOOK: Output: matchpathtest
Modified: hive/branches/llap/ql/src/test/results/clientpositive/ptf_seqfile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/ptf_seqfile.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/ptf_seqfile.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/ptf_seqfile.q.out Fri Jan 23 19:59:11 2015
@@ -38,7 +38,9 @@ POSTHOOK: query: LOAD DATA LOCAL INPATH
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@part_seq
-PREHOOK: query: -- testWindowingPTFWithPartSeqFile
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- testWindowingPTFWithPartSeqFile
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
dense_rank() over (partition by p_mfgr order by p_name) as dr,
@@ -49,7 +51,9 @@ order by p_name)
PREHOOK: type: QUERY
PREHOOK: Input: default@part_seq
#### A masked pattern was here ####
-POSTHOOK: query: -- testWindowingPTFWithPartSeqFile
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- testWindowingPTFWithPartSeqFile
select p_mfgr, p_name, p_size,
rank() over (partition by p_mfgr order by p_name) as r,
dense_rank() over (partition by p_mfgr order by p_name) as dr,
Modified: hive/branches/llap/ql/src/test/results/clientpositive/quotedid_basic.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/quotedid_basic.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/quotedid_basic.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/quotedid_basic.q.out Fri Jan 23 19:59:11 2015
@@ -195,9 +195,11 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ value expressions: _col0 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey0 (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
PTF Operator
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
@@ -278,9 +280,11 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col2 (type: string)
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string)
+ value expressions: _col0 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey0 (type: string)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
PTF Operator
Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
Modified: hive/branches/llap/ql/src/test/results/clientpositive/regex_col.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/regex_col.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/regex_col.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/regex_col.q.out Fri Jan 23 19:59:11 2015
@@ -174,7 +174,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '103' (type: string), _col2 (type: string), _col1 (type: string)
sort order: +++
- Map-reduce partition columns: _col2 (type: string), _col1 (type: string)
+ Map-reduce partition columns: '103' (type: string), _col2 (type: string), _col1 (type: string)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: a
@@ -189,7 +189,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: '103' (type: string), _col2 (type: string), _col1 (type: string)
sort order: +++
- Map-reduce partition columns: _col2 (type: string), _col1 (type: string)
+ Map-reduce partition columns: '103' (type: string), _col2 (type: string), _col1 (type: string)
Statistics: Num rows: 1000 Data size: 10624 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/router_join_ppr.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/router_join_ppr.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/router_join_ppr.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/router_join_ppr.q.out Fri Jan 23 19:59:11 2015
@@ -772,9 +772,9 @@ STAGE PLANS:
name: default.srcpart
name: default.srcpart
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_1:b]
- /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:$hdt$_0:$hdt$_0:a]
- /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:$hdt$_0:$hdt$_0:a]
+ /src [$hdt$_1:b]
+ /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:$hdt$_0:a]
+ /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:$hdt$_0:a]
Needs Tagging: true
Reduce Operator Tree:
Join Operator
@@ -1526,9 +1526,9 @@ STAGE PLANS:
name: default.srcpart
name: default.srcpart
Truncated Path -> Alias:
- /src [$hdt$_0:$hdt$_1:$hdt$_1:b]
- /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:$hdt$_0:$hdt$_0:a]
- /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:$hdt$_0:$hdt$_0:a]
+ /src [$hdt$_1:$hdt$_1:b]
+ /srcpart/ds=2008-04-08/hr=11 [$hdt$_0:$hdt$_0:a]
+ /srcpart/ds=2008-04-08/hr=12 [$hdt$_0:$hdt$_0:a]
Needs Tagging: true
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/sample3.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/sample3.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/sample3.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/sample3.q.out Fri Jan 23 19:59:11 2015
@@ -1,9 +1,13 @@
-PREHOOK: query: -- no input pruning, sample filter
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- no input pruning, sample filter
EXPLAIN
SELECT s.key
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
PREHOOK: type: QUERY
-POSTHOOK: query: -- no input pruning, sample filter
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- no input pruning, sample filter
EXPLAIN
SELECT s.key
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
@@ -55,48 +59,8 @@ POSTHOOK: Input: default@srcbucket
0
0
0
-5
-5
-5
-5
10
10
-15
-15
-15
-15
-20
-20
-20
-30
-30
-35
-35
-35
-35
-35
-35
-40
-40
-50
-60
-65
-65
-65
-70
-70
-70
-70
-75
-80
-80
-85
-85
-90
-90
-90
-95
-95
100
100
100
@@ -116,6 +80,10 @@ POSTHOOK: Input: default@srcbucket
135
140
145
+15
+15
+15
+15
150
155
160
@@ -134,6 +102,9 @@ POSTHOOK: Input: default@srcbucket
190
195
195
+20
+20
+20
200
200
205
@@ -167,6 +138,8 @@ POSTHOOK: Input: default@srcbucket
285
295
295
+30
+30
300
300
305
@@ -184,6 +157,12 @@ POSTHOOK: Input: default@srcbucket
335
340
345
+35
+35
+35
+35
+35
+35
355
355
360
@@ -204,6 +183,8 @@ POSTHOOK: Input: default@srcbucket
395
395
395
+40
+40
400
405
410
@@ -239,3 +220,26 @@ POSTHOOK: Input: default@srcbucket
490
495
495
+5
+5
+5
+5
+50
+60
+65
+65
+65
+70
+70
+70
+70
+75
+80
+80
+85
+85
+90
+90
+90
+95
+95
Modified: hive/branches/llap/ql/src/test/results/clientpositive/sample5.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/sample5.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/sample5.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/sample5.q.out Fri Jan 23 19:59:11 2015
@@ -6,12 +6,16 @@ POSTHOOK: query: CREATE TABLE dest1(key
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@dest1
-PREHOOK: query: -- no input pruning, sample filter
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- no input pruning, sample filter
EXPLAIN EXTENDED
INSERT OVERWRITE TABLE dest1 SELECT s.* -- here's another test
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
PREHOOK: type: QUERY
-POSTHOOK: query: -- no input pruning, sample filter
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- no input pruning, sample filter
EXPLAIN EXTENDED
INSERT OVERWRITE TABLE dest1 SELECT s.* -- here's another test
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s
@@ -349,48 +353,8 @@ POSTHOOK: Input: default@dest1
0 val_0
0 val_1
0 val_1
-5 val_5
-5 val_5
-5 val_5
-5 val_6
10 val_10
10 val_11
-15 val_15
-15 val_15
-15 val_16
-15 val_16
-20 val_20
-20 val_21
-20 val_21
-30 val_30
-30 val_31
-35 val_35
-35 val_35
-35 val_35
-35 val_36
-35 val_36
-35 val_36
-40 val_41
-40 val_41
-50 val_51
-60 val_61
-65 val_65
-65 val_66
-65 val_66
-70 val_70
-70 val_70
-70 val_70
-70 val_71
-75 val_76
-80 val_80
-80 val_81
-85 val_85
-85 val_86
-90 val_90
-90 val_90
-90 val_90
-95 val_95
-95 val_95
100 val_100
100 val_100
100 val_101
@@ -410,6 +374,10 @@ POSTHOOK: Input: default@dest1
135 val_136
140 val_141
145 val_145
+15 val_15
+15 val_15
+15 val_16
+15 val_16
150 val_150
155 val_155
160 val_160
@@ -428,6 +396,9 @@ POSTHOOK: Input: default@dest1
190 val_190
195 val_195
195 val_195
+20 val_20
+20 val_21
+20 val_21
200 val_200
200 val_200
205 val_205
@@ -461,6 +432,8 @@ POSTHOOK: Input: default@dest1
285 val_286
295 val_296
295 val_296
+30 val_30
+30 val_31
300 val_301
300 val_301
305 val_305
@@ -478,6 +451,12 @@ POSTHOOK: Input: default@dest1
335 val_336
340 val_341
345 val_345
+35 val_35
+35 val_35
+35 val_35
+35 val_36
+35 val_36
+35 val_36
355 val_356
355 val_356
360 val_360
@@ -498,6 +477,8 @@ POSTHOOK: Input: default@dest1
395 val_395
395 val_396
395 val_396
+40 val_41
+40 val_41
400 val_400
405 val_406
410 val_411
@@ -533,3 +514,26 @@ POSTHOOK: Input: default@dest1
490 val_491
495 val_495
495 val_496
+5 val_5
+5 val_5
+5 val_5
+5 val_6
+50 val_51
+60 val_61
+65 val_65
+65 val_66
+65 val_66
+70 val_70
+70 val_70
+70 val_70
+70 val_71
+75 val_76
+80 val_80
+80 val_81
+85 val_85
+85 val_86
+90 val_90
+90 val_90
+90 val_90
+95 val_95
+95 val_95
Modified: hive/branches/llap/ql/src/test/results/clientpositive/scriptfile1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/scriptfile1.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/scriptfile1.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/scriptfile1.q.out Fri Jan 23 19:59:11 2015
@@ -1,9 +1,13 @@
-PREHOOK: query: -- EXCLUDE_OS_WINDOWS
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+-- EXCLUDE_OS_WINDOWS
CREATE TABLE dest1(key INT, value STRING)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@dest1
-POSTHOOK: query: -- EXCLUDE_OS_WINDOWS
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+-- EXCLUDE_OS_WINDOWS
CREATE TABLE dest1(key INT, value STRING)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
Modified: hive/branches/llap/ql/src/test/results/clientpositive/semijoin.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/semijoin.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/semijoin.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/semijoin.q.out Fri Jan 23 19:59:11 2015
@@ -1,9 +1,13 @@
-PREHOOK: query: create table t1 as select cast(key as int) key, value from src where key <= 10
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table t1 as select cast(key as int) key, value 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 cast(key as int) key, value from src where key <= 10
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table t1 as select cast(key as int) key, value from src where key <= 10
POSTHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: Input: default@src
POSTHOOK: Output: database:default
@@ -19,6 +23,7 @@ POSTHOOK: Input: default@t1
0 val_0
0 val_0
0 val_0
+10 val_10
2 val_2
4 val_4
5 val_5
@@ -26,7 +31,6 @@ POSTHOOK: Input: default@t1
5 val_5
8 val_8
9 val_9
-10 val_10
PREHOOK: query: create table t2 as select cast(2*key as int) key, value from t1
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@t1
@@ -48,14 +52,14 @@ POSTHOOK: Input: default@t2
0 val_0
0 val_0
0 val_0
-4 val_2
-8 val_4
10 val_5
10 val_5
10 val_5
16 val_8
18 val_9
20 val_10
+4 val_2
+8 val_4
PREHOOK: query: create table t3 as select * from (select * from t1 union all select * from t2) b
PREHOOK: type: CREATETABLE_AS_SELECT
PREHOOK: Input: default@t1
@@ -82,7 +86,14 @@ POSTHOOK: Input: default@t3
0 val_0
0 val_0
0 val_0
+10 val_10
+10 val_5
+10 val_5
+10 val_5
+16 val_8
+18 val_9
2 val_2
+20 val_10
4 val_2
4 val_4
5 val_5
@@ -91,13 +102,6 @@ POSTHOOK: Input: default@t3
8 val_4
8 val_8
9 val_9
-10 val_10
-10 val_5
-10 val_5
-10 val_5
-16 val_8
-18 val_9
-20 val_10
PREHOOK: query: create table t4 (key int, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
@@ -215,9 +219,9 @@ POSTHOOK: Input: default@t2
0 val_0
0 val_0
0 val_0
+10 val_10
4 val_4
8 val_8
-10 val_10
PREHOOK: query: explain select * from t2 a left semi join t1 b on b.key=a.key sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t2 a left semi join t1 b on b.key=a.key sort by a.key, a.value
@@ -319,11 +323,11 @@ POSTHOOK: Input: default@t2
0 val_0
0 val_0
0 val_0
-4 val_2
-8 val_4
10 val_5
10 val_5
10 val_5
+4 val_2
+8 val_4
PREHOOK: query: explain select * from t1 a left semi join t4 b on b.key=a.key sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t1 a left semi join t4 b on b.key=a.key sort by a.key, a.value
@@ -937,11 +941,11 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
#### A masked pattern was here ####
-4 val_2
-8 val_4
10 val_5
10 val_5
10 val_5
+4 val_2
+8 val_4
PREHOOK: query: explain select /*+ mapjoin(b) */ a.key from t3 a left semi join t1 b on a.key = b.key sort by a.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ mapjoin(b) */ a.key from t3 a left semi join t1 b on a.key = b.key sort by a.key
@@ -1038,6 +1042,10 @@ POSTHOOK: Input: default@t3
0
0
0
+10
+10
+10
+10
2
4
4
@@ -1047,10 +1055,6 @@ POSTHOOK: Input: default@t3
8
8
9
-10
-10
-10
-10
PREHOOK: query: explain select * from t1 a left semi join t2 b on a.key = 2*b.key sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t1 a left semi join t2 b on a.key = 2*b.key sort by a.key, a.value
@@ -1281,11 +1285,11 @@ POSTHOOK: Input: default@t3
0 val_0 0 val_0
0 val_0 0 val_0
0 val_0 0 val_0
-4 val_4 4 val_2
-8 val_8 8 val_4
10 val_10 10 val_5
10 val_10 10 val_5
10 val_10 10 val_5
+4 val_4 4 val_2
+8 val_8 8 val_4
PREHOOK: query: explain select * from t3 a left semi join t1 b on a.key = b.key and a.value=b.value sort by a.key, a.value
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from t3 a left semi join t1 b on a.key = b.key and a.value=b.value sort by a.key, a.value
@@ -1389,6 +1393,7 @@ POSTHOOK: Input: default@t3
0 val_0
0 val_0
0 val_0
+10 val_10
2 val_2
4 val_4
5 val_5
@@ -1396,7 +1401,6 @@ POSTHOOK: Input: default@t3
5 val_5
8 val_8
9 val_9
-10 val_10
PREHOOK: query: explain select /*+ mapjoin(b, c) */ a.key from t3 a left semi join t1 b on a.key = b.key left semi join t2 c on a.key = c.key sort by a.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select /*+ mapjoin(b, c) */ a.key from t3 a left semi join t1 b on a.key = b.key left semi join t2 c on a.key = c.key sort by a.key
@@ -1522,14 +1526,14 @@ POSTHOOK: Input: default@t3
0
0
0
-4
-4
-8
-8
10
10
10
10
+4
+4
+8
+8
PREHOOK: query: explain select a.key from t3 a left outer join t1 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.key from t3 a left outer join t1 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
@@ -1651,14 +1655,14 @@ POSTHOOK: Input: default@t3
0
0
0
-4
-4
-8
-8
10
10
10
10
+4
+4
+8
+8
PREHOOK: query: explain select a.key from t1 a right outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.key from t1 a right outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
@@ -1762,9 +1766,6 @@ POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
-NULL
-NULL
-NULL
0
0
0
@@ -1783,14 +1784,17 @@ NULL
0
0
0
-4
-4
-8
-8
10
10
10
10
+4
+4
+8
+8
+NULL
+NULL
+NULL
PREHOOK: query: explain select a.key from t1 a full outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.key from t1 a full outer join t3 b on a.key = b.key left semi join t2 c on b.key = c.key sort by a.key
@@ -1894,9 +1898,6 @@ POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
-NULL
-NULL
-NULL
0
0
0
@@ -1915,14 +1916,17 @@ NULL
0
0
0
-4
-4
-8
-8
10
10
10
10
+4
+4
+8
+8
+NULL
+NULL
+NULL
PREHOOK: query: explain select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.key = c.key sort by a.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.key = c.key sort by a.key
@@ -2044,10 +2048,6 @@ POSTHOOK: Input: default@t3
0
0
0
-4
-4
-8
-8
10
10
10
@@ -2055,6 +2055,10 @@ POSTHOOK: Input: default@t3
16
18
20
+4
+4
+8
+8
PREHOOK: query: explain select a.key from t3 a left semi join t2 b on a.key = b.key right outer join t1 c on a.key = c.key sort by a.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.key from t3 a left semi join t2 b on a.key = b.key right outer join t1 c on a.key = c.key sort by a.key
@@ -2158,11 +2162,6 @@ POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
-NULL
-NULL
-NULL
-NULL
-NULL
0
0
0
@@ -2181,14 +2180,19 @@ NULL
0
0
0
-4
-4
-8
-8
10
10
10
10
+4
+4
+8
+8
+NULL
+NULL
+NULL
+NULL
+NULL
PREHOOK: query: explain select a.key from t3 a left semi join t1 b on a.key = b.key full outer join t2 c on a.key = c.key sort by a.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.key from t3 a left semi join t1 b on a.key = b.key full outer join t2 c on a.key = c.key sort by a.key
@@ -2292,9 +2296,6 @@ POSTHOOK: Input: default@t1
POSTHOOK: Input: default@t2
POSTHOOK: Input: default@t3
#### A masked pattern was here ####
-NULL
-NULL
-NULL
0
0
0
@@ -2313,15 +2314,6 @@ NULL
0
0
0
-2
-4
-4
-5
-5
-5
-8
-8
-9
10
10
10
@@ -2334,6 +2326,18 @@ NULL
10
10
10
+2
+4
+4
+5
+5
+5
+8
+8
+9
+NULL
+NULL
+NULL
PREHOOK: query: explain select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.value = c.value sort by a.key
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.key from t3 a left semi join t2 b on a.key = b.key left outer join t1 c on a.value = c.value sort by a.key
@@ -2487,10 +2491,6 @@ POSTHOOK: Input: default@t3
0
0
0
-4
-4
-8
-8
10
10
10
@@ -2504,6 +2504,10 @@ POSTHOOK: Input: default@t3
16
18
20
+4
+4
+8
+8
PREHOOK: query: explain select a.key from t3 a left semi join t2 b on a.value = b.value where a.key > 100
PREHOOK: type: QUERY
POSTHOOK: query: explain select a.key from t3 a left semi join t2 b on a.value = b.value where a.key > 100
Modified: hive/branches/llap/ql/src/test/results/clientpositive/show_functions.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/show_functions.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/show_functions.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/show_functions.q.out Fri Jan 23 19:59:11 2015
@@ -21,6 +21,7 @@ POSTHOOK: type: SHOWFUNCTIONS
^
abs
acos
+add_months
and
array
array_contains
@@ -86,6 +87,7 @@ if
in
in_file
index
+initcap
inline
instr
isnotnull
@@ -93,6 +95,7 @@ isnull
java_method
json_tuple
lag
+last_day
last_value
lcase
lead
Modified: hive/branches/llap/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/smb_mapjoin_11.q.out Fri Jan 23 19:59:11 2015
@@ -277,6 +277,1959 @@ POSTHOOK: Input: default@test_table2@ds=
POSTHOOK: Output: default@test_table3@ds=1
POSTHOOK: Lineage: test_table3 PARTITION(ds=1).key SIMPLE [(test_table1)a.FieldSchema(name:key, type:int, comment:null), ]
POSTHOOK: Lineage: test_table3 PARTITION(ds=1).value SIMPLE [(test_table2)b.FieldSchema(name:value, type:string, comment:null), ]
+PREHOOK: query: SELECT * FROM test_table1 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@test_table1
+PREHOOK: Input: default@test_table1@ds=1
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM test_table1 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@test_table1
+POSTHOOK: Input: default@test_table1@ds=1
+#### A masked pattern was here ####
+0 val_0 1
+0 val_0 1
+0 val_0 1
+2 val_2 1
+4 val_4 1
+5 val_5 1
+5 val_5 1
+5 val_5 1
+8 val_8 1
+9 val_9 1
+10 val_10 1
+11 val_11 1
+12 val_12 1
+12 val_12 1
+15 val_15 1
+15 val_15 1
+17 val_17 1
+18 val_18 1
+18 val_18 1
+19 val_19 1
+20 val_20 1
+24 val_24 1
+24 val_24 1
+26 val_26 1
+26 val_26 1
+27 val_27 1
+28 val_28 1
+30 val_30 1
+33 val_33 1
+34 val_34 1
+35 val_35 1
+35 val_35 1
+35 val_35 1
+37 val_37 1
+37 val_37 1
+41 val_41 1
+42 val_42 1
+42 val_42 1
+43 val_43 1
+44 val_44 1
+47 val_47 1
+51 val_51 1
+51 val_51 1
+53 val_53 1
+54 val_54 1
+57 val_57 1
+58 val_58 1
+58 val_58 1
+64 val_64 1
+65 val_65 1
+66 val_66 1
+67 val_67 1
+67 val_67 1
+69 val_69 1
+70 val_70 1
+70 val_70 1
+70 val_70 1
+72 val_72 1
+72 val_72 1
+74 val_74 1
+76 val_76 1
+76 val_76 1
+77 val_77 1
+78 val_78 1
+80 val_80 1
+82 val_82 1
+83 val_83 1
+83 val_83 1
+84 val_84 1
+84 val_84 1
+85 val_85 1
+86 val_86 1
+87 val_87 1
+90 val_90 1
+90 val_90 1
+90 val_90 1
+92 val_92 1
+95 val_95 1
+95 val_95 1
+96 val_96 1
+97 val_97 1
+97 val_97 1
+98 val_98 1
+98 val_98 1
+100 val_100 1
+100 val_100 1
+103 val_103 1
+103 val_103 1
+104 val_104 1
+104 val_104 1
+105 val_105 1
+111 val_111 1
+113 val_113 1
+113 val_113 1
+114 val_114 1
+116 val_116 1
+118 val_118 1
+118 val_118 1
+119 val_119 1
+119 val_119 1
+119 val_119 1
+120 val_120 1
+120 val_120 1
+125 val_125 1
+125 val_125 1
+126 val_126 1
+128 val_128 1
+128 val_128 1
+128 val_128 1
+129 val_129 1
+129 val_129 1
+131 val_131 1
+133 val_133 1
+134 val_134 1
+134 val_134 1
+136 val_136 1
+137 val_137 1
+137 val_137 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+143 val_143 1
+145 val_145 1
+146 val_146 1
+146 val_146 1
+149 val_149 1
+149 val_149 1
+150 val_150 1
+152 val_152 1
+152 val_152 1
+153 val_153 1
+155 val_155 1
+156 val_156 1
+157 val_157 1
+158 val_158 1
+160 val_160 1
+162 val_162 1
+163 val_163 1
+164 val_164 1
+164 val_164 1
+165 val_165 1
+165 val_165 1
+166 val_166 1
+167 val_167 1
+167 val_167 1
+167 val_167 1
+168 val_168 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+170 val_170 1
+172 val_172 1
+172 val_172 1
+174 val_174 1
+174 val_174 1
+175 val_175 1
+175 val_175 1
+176 val_176 1
+176 val_176 1
+177 val_177 1
+178 val_178 1
+179 val_179 1
+179 val_179 1
+180 val_180 1
+181 val_181 1
+183 val_183 1
+186 val_186 1
+187 val_187 1
+187 val_187 1
+187 val_187 1
+189 val_189 1
+190 val_190 1
+191 val_191 1
+191 val_191 1
+192 val_192 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+194 val_194 1
+195 val_195 1
+195 val_195 1
+196 val_196 1
+197 val_197 1
+197 val_197 1
+199 val_199 1
+199 val_199 1
+199 val_199 1
+200 val_200 1
+200 val_200 1
+201 val_201 1
+202 val_202 1
+203 val_203 1
+203 val_203 1
+205 val_205 1
+205 val_205 1
+207 val_207 1
+207 val_207 1
+208 val_208 1
+208 val_208 1
+208 val_208 1
+209 val_209 1
+209 val_209 1
+213 val_213 1
+213 val_213 1
+214 val_214 1
+216 val_216 1
+216 val_216 1
+217 val_217 1
+217 val_217 1
+218 val_218 1
+219 val_219 1
+219 val_219 1
+221 val_221 1
+221 val_221 1
+222 val_222 1
+223 val_223 1
+223 val_223 1
+224 val_224 1
+224 val_224 1
+226 val_226 1
+228 val_228 1
+229 val_229 1
+229 val_229 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+233 val_233 1
+233 val_233 1
+235 val_235 1
+237 val_237 1
+237 val_237 1
+238 val_238 1
+238 val_238 1
+239 val_239 1
+239 val_239 1
+241 val_241 1
+242 val_242 1
+242 val_242 1
+244 val_244 1
+247 val_247 1
+248 val_248 1
+249 val_249 1
+252 val_252 1
+255 val_255 1
+255 val_255 1
+256 val_256 1
+256 val_256 1
+257 val_257 1
+258 val_258 1
+260 val_260 1
+262 val_262 1
+263 val_263 1
+265 val_265 1
+265 val_265 1
+266 val_266 1
+272 val_272 1
+272 val_272 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+274 val_274 1
+275 val_275 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+278 val_278 1
+278 val_278 1
+280 val_280 1
+280 val_280 1
+281 val_281 1
+281 val_281 1
+282 val_282 1
+282 val_282 1
+283 val_283 1
+284 val_284 1
+285 val_285 1
+286 val_286 1
+287 val_287 1
+288 val_288 1
+288 val_288 1
+289 val_289 1
+291 val_291 1
+292 val_292 1
+296 val_296 1
+298 val_298 1
+298 val_298 1
+298 val_298 1
+302 val_302 1
+305 val_305 1
+306 val_306 1
+307 val_307 1
+307 val_307 1
+308 val_308 1
+309 val_309 1
+309 val_309 1
+310 val_310 1
+311 val_311 1
+311 val_311 1
+311 val_311 1
+315 val_315 1
+316 val_316 1
+316 val_316 1
+316 val_316 1
+317 val_317 1
+317 val_317 1
+318 val_318 1
+318 val_318 1
+318 val_318 1
+321 val_321 1
+321 val_321 1
+322 val_322 1
+322 val_322 1
+323 val_323 1
+325 val_325 1
+325 val_325 1
+327 val_327 1
+327 val_327 1
+327 val_327 1
+331 val_331 1
+331 val_331 1
+332 val_332 1
+333 val_333 1
+333 val_333 1
+335 val_335 1
+336 val_336 1
+338 val_338 1
+339 val_339 1
+341 val_341 1
+342 val_342 1
+342 val_342 1
+344 val_344 1
+344 val_344 1
+345 val_345 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+351 val_351 1
+353 val_353 1
+353 val_353 1
+356 val_356 1
+360 val_360 1
+362 val_362 1
+364 val_364 1
+365 val_365 1
+366 val_366 1
+367 val_367 1
+367 val_367 1
+368 val_368 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+373 val_373 1
+374 val_374 1
+375 val_375 1
+377 val_377 1
+378 val_378 1
+379 val_379 1
+382 val_382 1
+382 val_382 1
+384 val_384 1
+384 val_384 1
+384 val_384 1
+386 val_386 1
+389 val_389 1
+392 val_392 1
+393 val_393 1
+394 val_394 1
+395 val_395 1
+395 val_395 1
+396 val_396 1
+396 val_396 1
+396 val_396 1
+397 val_397 1
+397 val_397 1
+399 val_399 1
+399 val_399 1
+400 val_400 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+402 val_402 1
+403 val_403 1
+403 val_403 1
+403 val_403 1
+404 val_404 1
+404 val_404 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+407 val_407 1
+409 val_409 1
+409 val_409 1
+409 val_409 1
+411 val_411 1
+413 val_413 1
+413 val_413 1
+414 val_414 1
+414 val_414 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+418 val_418 1
+419 val_419 1
+421 val_421 1
+424 val_424 1
+424 val_424 1
+427 val_427 1
+429 val_429 1
+429 val_429 1
+430 val_430 1
+430 val_430 1
+430 val_430 1
+431 val_431 1
+431 val_431 1
+431 val_431 1
+432 val_432 1
+435 val_435 1
+436 val_436 1
+437 val_437 1
+438 val_438 1
+438 val_438 1
+438 val_438 1
+439 val_439 1
+439 val_439 1
+443 val_443 1
+444 val_444 1
+446 val_446 1
+448 val_448 1
+449 val_449 1
+452 val_452 1
+453 val_453 1
+454 val_454 1
+454 val_454 1
+454 val_454 1
+455 val_455 1
+457 val_457 1
+458 val_458 1
+458 val_458 1
+459 val_459 1
+459 val_459 1
+460 val_460 1
+462 val_462 1
+462 val_462 1
+463 val_463 1
+463 val_463 1
+466 val_466 1
+466 val_466 1
+466 val_466 1
+467 val_467 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+470 val_470 1
+472 val_472 1
+475 val_475 1
+477 val_477 1
+478 val_478 1
+478 val_478 1
+479 val_479 1
+480 val_480 1
+480 val_480 1
+480 val_480 1
+481 val_481 1
+482 val_482 1
+483 val_483 1
+484 val_484 1
+485 val_485 1
+487 val_487 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+490 val_490 1
+491 val_491 1
+492 val_492 1
+492 val_492 1
+493 val_493 1
+494 val_494 1
+495 val_495 1
+496 val_496 1
+497 val_497 1
+498 val_498 1
+498 val_498 1
+498 val_498 1
+PREHOOK: query: SELECT * FROM test_table3 ORDER BY key
+PREHOOK: type: QUERY
+PREHOOK: Input: default@test_table3
+PREHOOK: Input: default@test_table3@ds=1
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM test_table3 ORDER BY key
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@test_table3
+POSTHOOK: Input: default@test_table3@ds=1
+#### A masked pattern was here ####
+0 val_0 1
+0 val_0 1
+0 val_0 1
+0 val_0 1
+0 val_0 1
+0 val_0 1
+0 val_0 1
+0 val_0 1
+0 val_0 1
+2 val_2 1
+4 val_4 1
+5 val_5 1
+5 val_5 1
+5 val_5 1
+5 val_5 1
+5 val_5 1
+5 val_5 1
+5 val_5 1
+5 val_5 1
+5 val_5 1
+8 val_8 1
+9 val_9 1
+10 val_10 1
+11 val_11 1
+12 val_12 1
+12 val_12 1
+12 val_12 1
+12 val_12 1
+15 val_15 1
+15 val_15 1
+15 val_15 1
+15 val_15 1
+17 val_17 1
+18 val_18 1
+18 val_18 1
+18 val_18 1
+18 val_18 1
+19 val_19 1
+20 val_20 1
+24 val_24 1
+24 val_24 1
+24 val_24 1
+24 val_24 1
+26 val_26 1
+26 val_26 1
+26 val_26 1
+26 val_26 1
+27 val_27 1
+28 val_28 1
+30 val_30 1
+33 val_33 1
+34 val_34 1
+35 val_35 1
+35 val_35 1
+35 val_35 1
+35 val_35 1
+35 val_35 1
+35 val_35 1
+35 val_35 1
+35 val_35 1
+35 val_35 1
+37 val_37 1
+37 val_37 1
+37 val_37 1
+37 val_37 1
+41 val_41 1
+42 val_42 1
+42 val_42 1
+42 val_42 1
+42 val_42 1
+43 val_43 1
+44 val_44 1
+47 val_47 1
+51 val_51 1
+51 val_51 1
+51 val_51 1
+51 val_51 1
+53 val_53 1
+54 val_54 1
+57 val_57 1
+58 val_58 1
+58 val_58 1
+58 val_58 1
+58 val_58 1
+64 val_64 1
+65 val_65 1
+66 val_66 1
+67 val_67 1
+67 val_67 1
+67 val_67 1
+67 val_67 1
+69 val_69 1
+70 val_70 1
+70 val_70 1
+70 val_70 1
+70 val_70 1
+70 val_70 1
+70 val_70 1
+70 val_70 1
+70 val_70 1
+70 val_70 1
+72 val_72 1
+72 val_72 1
+72 val_72 1
+72 val_72 1
+74 val_74 1
+76 val_76 1
+76 val_76 1
+76 val_76 1
+76 val_76 1
+77 val_77 1
+78 val_78 1
+80 val_80 1
+82 val_82 1
+83 val_83 1
+83 val_83 1
+83 val_83 1
+83 val_83 1
+84 val_84 1
+84 val_84 1
+84 val_84 1
+84 val_84 1
+85 val_85 1
+86 val_86 1
+87 val_87 1
+90 val_90 1
+90 val_90 1
+90 val_90 1
+90 val_90 1
+90 val_90 1
+90 val_90 1
+90 val_90 1
+90 val_90 1
+90 val_90 1
+92 val_92 1
+95 val_95 1
+95 val_95 1
+95 val_95 1
+95 val_95 1
+96 val_96 1
+97 val_97 1
+97 val_97 1
+97 val_97 1
+97 val_97 1
+98 val_98 1
+98 val_98 1
+98 val_98 1
+98 val_98 1
+100 val_100 1
+100 val_100 1
+100 val_100 1
+100 val_100 1
+103 val_103 1
+103 val_103 1
+103 val_103 1
+103 val_103 1
+104 val_104 1
+104 val_104 1
+104 val_104 1
+104 val_104 1
+105 val_105 1
+111 val_111 1
+113 val_113 1
+113 val_113 1
+113 val_113 1
+113 val_113 1
+114 val_114 1
+116 val_116 1
+118 val_118 1
+118 val_118 1
+118 val_118 1
+118 val_118 1
+119 val_119 1
+119 val_119 1
+119 val_119 1
+119 val_119 1
+119 val_119 1
+119 val_119 1
+119 val_119 1
+119 val_119 1
+119 val_119 1
+120 val_120 1
+120 val_120 1
+120 val_120 1
+120 val_120 1
+125 val_125 1
+125 val_125 1
+125 val_125 1
+125 val_125 1
+126 val_126 1
+128 val_128 1
+128 val_128 1
+128 val_128 1
+128 val_128 1
+128 val_128 1
+128 val_128 1
+128 val_128 1
+128 val_128 1
+128 val_128 1
+129 val_129 1
+129 val_129 1
+129 val_129 1
+129 val_129 1
+131 val_131 1
+133 val_133 1
+134 val_134 1
+134 val_134 1
+134 val_134 1
+134 val_134 1
+136 val_136 1
+137 val_137 1
+137 val_137 1
+137 val_137 1
+137 val_137 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+138 val_138 1
+143 val_143 1
+145 val_145 1
+146 val_146 1
+146 val_146 1
+146 val_146 1
+146 val_146 1
+149 val_149 1
+149 val_149 1
+149 val_149 1
+149 val_149 1
+150 val_150 1
+152 val_152 1
+152 val_152 1
+152 val_152 1
+152 val_152 1
+153 val_153 1
+155 val_155 1
+156 val_156 1
+157 val_157 1
+158 val_158 1
+160 val_160 1
+162 val_162 1
+163 val_163 1
+164 val_164 1
+164 val_164 1
+164 val_164 1
+164 val_164 1
+165 val_165 1
+165 val_165 1
+165 val_165 1
+165 val_165 1
+166 val_166 1
+167 val_167 1
+167 val_167 1
+167 val_167 1
+167 val_167 1
+167 val_167 1
+167 val_167 1
+167 val_167 1
+167 val_167 1
+167 val_167 1
+168 val_168 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+169 val_169 1
+170 val_170 1
+172 val_172 1
+172 val_172 1
+172 val_172 1
+172 val_172 1
+174 val_174 1
+174 val_174 1
+174 val_174 1
+174 val_174 1
+175 val_175 1
+175 val_175 1
+175 val_175 1
+175 val_175 1
+176 val_176 1
+176 val_176 1
+176 val_176 1
+176 val_176 1
+177 val_177 1
+178 val_178 1
+179 val_179 1
+179 val_179 1
+179 val_179 1
+179 val_179 1
+180 val_180 1
+181 val_181 1
+183 val_183 1
+186 val_186 1
+187 val_187 1
+187 val_187 1
+187 val_187 1
+187 val_187 1
+187 val_187 1
+187 val_187 1
+187 val_187 1
+187 val_187 1
+187 val_187 1
+189 val_189 1
+190 val_190 1
+191 val_191 1
+191 val_191 1
+191 val_191 1
+191 val_191 1
+192 val_192 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+194 val_194 1
+195 val_195 1
+195 val_195 1
+195 val_195 1
+195 val_195 1
+196 val_196 1
+197 val_197 1
+197 val_197 1
+197 val_197 1
+197 val_197 1
+199 val_199 1
+199 val_199 1
+199 val_199 1
+199 val_199 1
+199 val_199 1
+199 val_199 1
+199 val_199 1
+199 val_199 1
+199 val_199 1
+200 val_200 1
+200 val_200 1
+200 val_200 1
+200 val_200 1
+201 val_201 1
+202 val_202 1
+203 val_203 1
+203 val_203 1
+203 val_203 1
+203 val_203 1
+205 val_205 1
+205 val_205 1
+205 val_205 1
+205 val_205 1
+207 val_207 1
+207 val_207 1
+207 val_207 1
+207 val_207 1
+208 val_208 1
+208 val_208 1
+208 val_208 1
+208 val_208 1
+208 val_208 1
+208 val_208 1
+208 val_208 1
+208 val_208 1
+208 val_208 1
+209 val_209 1
+209 val_209 1
+209 val_209 1
+209 val_209 1
+213 val_213 1
+213 val_213 1
+213 val_213 1
+213 val_213 1
+214 val_214 1
+216 val_216 1
+216 val_216 1
+216 val_216 1
+216 val_216 1
+217 val_217 1
+217 val_217 1
+217 val_217 1
+217 val_217 1
+218 val_218 1
+219 val_219 1
+219 val_219 1
+219 val_219 1
+219 val_219 1
+221 val_221 1
+221 val_221 1
+221 val_221 1
+221 val_221 1
+222 val_222 1
+223 val_223 1
+223 val_223 1
+223 val_223 1
+223 val_223 1
+224 val_224 1
+224 val_224 1
+224 val_224 1
+224 val_224 1
+226 val_226 1
+228 val_228 1
+229 val_229 1
+229 val_229 1
+229 val_229 1
+229 val_229 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+230 val_230 1
+233 val_233 1
+233 val_233 1
+233 val_233 1
+233 val_233 1
+235 val_235 1
+237 val_237 1
+237 val_237 1
+237 val_237 1
+237 val_237 1
+238 val_238 1
+238 val_238 1
+238 val_238 1
+238 val_238 1
+239 val_239 1
+239 val_239 1
+239 val_239 1
+239 val_239 1
+241 val_241 1
+242 val_242 1
+242 val_242 1
+242 val_242 1
+242 val_242 1
+244 val_244 1
+247 val_247 1
+248 val_248 1
+249 val_249 1
+252 val_252 1
+255 val_255 1
+255 val_255 1
+255 val_255 1
+255 val_255 1
+256 val_256 1
+256 val_256 1
+256 val_256 1
+256 val_256 1
+257 val_257 1
+258 val_258 1
+260 val_260 1
+262 val_262 1
+263 val_263 1
+265 val_265 1
+265 val_265 1
+265 val_265 1
+265 val_265 1
+266 val_266 1
+272 val_272 1
+272 val_272 1
+272 val_272 1
+272 val_272 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+274 val_274 1
+275 val_275 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+277 val_277 1
+278 val_278 1
+278 val_278 1
+278 val_278 1
+278 val_278 1
+280 val_280 1
+280 val_280 1
+280 val_280 1
+280 val_280 1
+281 val_281 1
+281 val_281 1
+281 val_281 1
+281 val_281 1
+282 val_282 1
+282 val_282 1
+282 val_282 1
+282 val_282 1
+283 val_283 1
+284 val_284 1
+285 val_285 1
+286 val_286 1
+287 val_287 1
+288 val_288 1
+288 val_288 1
+288 val_288 1
+288 val_288 1
+289 val_289 1
+291 val_291 1
+292 val_292 1
+296 val_296 1
+298 val_298 1
+298 val_298 1
+298 val_298 1
+298 val_298 1
+298 val_298 1
+298 val_298 1
+298 val_298 1
+298 val_298 1
+298 val_298 1
+302 val_302 1
+305 val_305 1
+306 val_306 1
+307 val_307 1
+307 val_307 1
+307 val_307 1
+307 val_307 1
+308 val_308 1
+309 val_309 1
+309 val_309 1
+309 val_309 1
+309 val_309 1
+310 val_310 1
+311 val_311 1
+311 val_311 1
+311 val_311 1
+311 val_311 1
+311 val_311 1
+311 val_311 1
+311 val_311 1
+311 val_311 1
+311 val_311 1
+315 val_315 1
+316 val_316 1
+316 val_316 1
+316 val_316 1
+316 val_316 1
+316 val_316 1
+316 val_316 1
+316 val_316 1
+316 val_316 1
+316 val_316 1
+317 val_317 1
+317 val_317 1
+317 val_317 1
+317 val_317 1
+318 val_318 1
+318 val_318 1
+318 val_318 1
+318 val_318 1
+318 val_318 1
+318 val_318 1
+318 val_318 1
+318 val_318 1
+318 val_318 1
+321 val_321 1
+321 val_321 1
+321 val_321 1
+321 val_321 1
+322 val_322 1
+322 val_322 1
+322 val_322 1
+322 val_322 1
+323 val_323 1
+325 val_325 1
+325 val_325 1
+325 val_325 1
+325 val_325 1
+327 val_327 1
+327 val_327 1
+327 val_327 1
+327 val_327 1
+327 val_327 1
+327 val_327 1
+327 val_327 1
+327 val_327 1
+327 val_327 1
+331 val_331 1
+331 val_331 1
+331 val_331 1
+331 val_331 1
+332 val_332 1
+333 val_333 1
+333 val_333 1
+333 val_333 1
+333 val_333 1
+335 val_335 1
+336 val_336 1
+338 val_338 1
+339 val_339 1
+341 val_341 1
+342 val_342 1
+342 val_342 1
+342 val_342 1
+342 val_342 1
+344 val_344 1
+344 val_344 1
+344 val_344 1
+344 val_344 1
+345 val_345 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+348 val_348 1
+351 val_351 1
+353 val_353 1
+353 val_353 1
+353 val_353 1
+353 val_353 1
+356 val_356 1
+360 val_360 1
+362 val_362 1
+364 val_364 1
+365 val_365 1
+366 val_366 1
+367 val_367 1
+367 val_367 1
+367 val_367 1
+367 val_367 1
+368 val_368 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+373 val_373 1
+374 val_374 1
+375 val_375 1
+377 val_377 1
+378 val_378 1
+379 val_379 1
+382 val_382 1
+382 val_382 1
+382 val_382 1
+382 val_382 1
+384 val_384 1
+384 val_384 1
+384 val_384 1
+384 val_384 1
+384 val_384 1
+384 val_384 1
+384 val_384 1
+384 val_384 1
+384 val_384 1
+386 val_386 1
+389 val_389 1
+392 val_392 1
+393 val_393 1
+394 val_394 1
+395 val_395 1
+395 val_395 1
+395 val_395 1
+395 val_395 1
+396 val_396 1
+396 val_396 1
+396 val_396 1
+396 val_396 1
+396 val_396 1
+396 val_396 1
+396 val_396 1
+396 val_396 1
+396 val_396 1
+397 val_397 1
+397 val_397 1
+397 val_397 1
+397 val_397 1
+399 val_399 1
+399 val_399 1
+399 val_399 1
+399 val_399 1
+400 val_400 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+402 val_402 1
+403 val_403 1
+403 val_403 1
+403 val_403 1
+403 val_403 1
+403 val_403 1
+403 val_403 1
+403 val_403 1
+403 val_403 1
+403 val_403 1
+404 val_404 1
+404 val_404 1
+404 val_404 1
+404 val_404 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+406 val_406 1
+407 val_407 1
+409 val_409 1
+409 val_409 1
+409 val_409 1
+409 val_409 1
+409 val_409 1
+409 val_409 1
+409 val_409 1
+409 val_409 1
+409 val_409 1
+411 val_411 1
+413 val_413 1
+413 val_413 1
+413 val_413 1
+413 val_413 1
+414 val_414 1
+414 val_414 1
+414 val_414 1
+414 val_414 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+418 val_418 1
+419 val_419 1
+421 val_421 1
+424 val_424 1
+424 val_424 1
+424 val_424 1
+424 val_424 1
+427 val_427 1
+429 val_429 1
+429 val_429 1
+429 val_429 1
+429 val_429 1
+430 val_430 1
+430 val_430 1
+430 val_430 1
+430 val_430 1
+430 val_430 1
+430 val_430 1
+430 val_430 1
+430 val_430 1
+430 val_430 1
+431 val_431 1
+431 val_431 1
+431 val_431 1
+431 val_431 1
+431 val_431 1
+431 val_431 1
+431 val_431 1
+431 val_431 1
+431 val_431 1
+432 val_432 1
+435 val_435 1
+436 val_436 1
+437 val_437 1
+438 val_438 1
+438 val_438 1
+438 val_438 1
+438 val_438 1
+438 val_438 1
+438 val_438 1
+438 val_438 1
+438 val_438 1
+438 val_438 1
+439 val_439 1
+439 val_439 1
+439 val_439 1
+439 val_439 1
+443 val_443 1
+444 val_444 1
+446 val_446 1
+448 val_448 1
+449 val_449 1
+452 val_452 1
+453 val_453 1
+454 val_454 1
+454 val_454 1
+454 val_454 1
+454 val_454 1
+454 val_454 1
+454 val_454 1
+454 val_454 1
+454 val_454 1
+454 val_454 1
+455 val_455 1
+457 val_457 1
+458 val_458 1
+458 val_458 1
+458 val_458 1
+458 val_458 1
+459 val_459 1
+459 val_459 1
+459 val_459 1
+459 val_459 1
+460 val_460 1
+462 val_462 1
+462 val_462 1
+462 val_462 1
+462 val_462 1
+463 val_463 1
+463 val_463 1
+463 val_463 1
+463 val_463 1
+466 val_466 1
+466 val_466 1
+466 val_466 1
+466 val_466 1
+466 val_466 1
+466 val_466 1
+466 val_466 1
+466 val_466 1
+466 val_466 1
+467 val_467 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+468 val_468 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+469 val_469 1
+470 val_470 1
+472 val_472 1
+475 val_475 1
+477 val_477 1
+478 val_478 1
+478 val_478 1
+478 val_478 1
+478 val_478 1
+479 val_479 1
+480 val_480 1
+480 val_480 1
+480 val_480 1
+480 val_480 1
+480 val_480 1
+480 val_480 1
+480 val_480 1
+480 val_480 1
+480 val_480 1
+481 val_481 1
+482 val_482 1
+483 val_483 1
+484 val_484 1
+485 val_485 1
+487 val_487 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+489 val_489 1
+490 val_490 1
+491 val_491 1
+492 val_492 1
+492 val_492 1
+492 val_492 1
+492 val_492 1
+493 val_493 1
+494 val_494 1
+495 val_495 1
+496 val_496 1
+497 val_497 1
+498 val_498 1
+498 val_498 1
+498 val_498 1
+498 val_498 1
+498 val_498 1
+498 val_498 1
+498 val_498 1
+498 val_498 1
+498 val_498 1
+PREHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+
+TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ test_table1
+ TOK_TABLEBUCKETSAMPLE
+ 2
+ 16
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_ALLCOLREF
+
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: test_table1
+ Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE
+ GatherStats: false
+ Filter Operator
+ isSamplingPred: true
+ predicate: (((hash(key) & 2147483647) % 16) = 1) (type: boolean)
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: int), value (type: string), ds (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+ Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ columns _col0,_col1,_col2
+ columns.types int:string:string
+ escape.delim \
+ hive.serialization.extend.nesting.levels true
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ TotalFiles: 1
+ GatherStats: false
+ MultiFileSpray: false
+ Path -> Alias:
+#### A masked pattern was here ####
+ Path -> Partition:
+#### A masked pattern was here ####
+ Partition
+ base file name: 000001_0
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ partition values:
+ ds 1
+ properties:
+ COLUMN_STATS_ACCURATE true
+ bucket_count 16
+ bucket_field_name key
+ columns key,value
+ columns.comments
+ columns.types int:string
+#### A masked pattern was here ####
+ name default.test_table1
+ numFiles 16
+ numRows 500
+ partition_columns ds
+ partition_columns.types string
+ rawDataSize 5312
+ serialization.ddl struct test_table1 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ totalSize 5812
+#### A masked pattern was here ####
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ SORTBUCKETCOLSPREFIX TRUE
+ bucket_count 16
+ bucket_field_name key
+ columns key,value
+ columns.comments
+ columns.types int:string
+#### A masked pattern was here ####
+ name default.test_table1
+ partition_columns ds
+ partition_columns.types string
+ serialization.ddl struct test_table1 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+#### A masked pattern was here ####
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.test_table1
+ name: default.test_table1
+ Truncated Path -> Alias:
+ /test_table1/ds=1/000001_0 [test_table1]
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
+PREHOOK: type: QUERY
+POSTHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
+POSTHOOK: type: QUERY
+ABSTRACT SYNTAX TREE:
+
+TOK_QUERY
+ TOK_FROM
+ TOK_TABREF
+ TOK_TABNAME
+ test_table3
+ TOK_TABLEBUCKETSAMPLE
+ 2
+ 16
+ TOK_INSERT
+ TOK_DESTINATION
+ TOK_DIR
+ TOK_TMP_FILE
+ TOK_SELECT
+ TOK_SELEXPR
+ TOK_ALLCOLREF
+
+
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Map Reduce
+ Map Operator Tree:
+ TableScan
+ alias: test_table3
+ Statistics: Num rows: 1028 Data size: 10968 Basic stats: COMPLETE Column stats: NONE
+ GatherStats: false
+ Filter Operator
+ isSamplingPred: true
+ predicate: (((hash(key) & 2147483647) % 16) = 1) (type: boolean)
+ Statistics: Num rows: 514 Data size: 5484 Basic stats: COMPLETE Column stats: NONE
+ Select Operator
+ expressions: key (type: int), value (type: string), ds (type: string)
+ outputColumnNames: _col0, _col1, _col2
+ Statistics: Num rows: 514 Data size: 5484 Basic stats: COMPLETE Column stats: NONE
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+ Statistics: Num rows: 514 Data size: 5484 Basic stats: COMPLETE Column stats: NONE
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ columns _col0,_col1,_col2
+ columns.types int:string:string
+ escape.delim \
+ hive.serialization.extend.nesting.levels true
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ TotalFiles: 1
+ GatherStats: false
+ MultiFileSpray: false
+ Path -> Alias:
+#### A masked pattern was here ####
+ Path -> Partition:
+#### A masked pattern was here ####
+ Partition
+ base file name: (ds%3D1)000001_0
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ partition values:
+ ds 1
+ properties:
+ COLUMN_STATS_ACCURATE true
+ bucket_count 16
+ bucket_field_name key
+ columns key,value
+ columns.comments
+ columns.types int:string
+#### A masked pattern was here ####
+ name default.test_table3
+ numFiles 16
+ numRows 1028
+ partition_columns ds
+ partition_columns.types string
+ rawDataSize 10968
+ serialization.ddl struct test_table3 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ totalSize 11996
+#### A masked pattern was here ####
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ bucket_count 16
+ bucket_field_name key
+ columns key,value
+ columns.comments
+ columns.types int:string
+#### A masked pattern was here ####
+ name default.test_table3
+ partition_columns ds
+ partition_columns.types string
+ serialization.ddl struct test_table3 { i32 key, string value}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+#### A masked pattern was here ####
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.test_table3
+ name: default.test_table3
+ Truncated Path -> Alias:
+ /test_table3/ds=1/(ds%3D1)000001_0 [test_table3]
+
+ Stage: Stage-0
+ Fetch Operator
+ limit: -1
+ Processor Tree:
+ ListSink
+
+PREHOOK: query: SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@test_table1
+PREHOOK: Input: default@test_table1@ds=1
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@test_table1
+POSTHOOK: Input: default@test_table1@ds=1
+#### A masked pattern was here ####
+17 val_17 1
+33 val_33 1
+65 val_65 1
+97 val_97 1
+97 val_97 1
+113 val_113 1
+113 val_113 1
+129 val_129 1
+129 val_129 1
+145 val_145 1
+177 val_177 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+209 val_209 1
+209 val_209 1
+241 val_241 1
+257 val_257 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+289 val_289 1
+305 val_305 1
+321 val_321 1
+321 val_321 1
+353 val_353 1
+353 val_353 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+449 val_449 1
+481 val_481 1
+497 val_497 1
+PREHOOK: query: SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
+PREHOOK: type: QUERY
+PREHOOK: Input: default@test_table3
+PREHOOK: Input: default@test_table3@ds=1
+#### A masked pattern was here ####
+POSTHOOK: query: SELECT * FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16)
+POSTHOOK: type: QUERY
+POSTHOOK: Input: default@test_table3
+POSTHOOK: Input: default@test_table3@ds=1
+#### A masked pattern was here ####
+17 val_17 1
+33 val_33 1
+65 val_65 1
+97 val_97 1
+97 val_97 1
+97 val_97 1
+97 val_97 1
+113 val_113 1
+113 val_113 1
+113 val_113 1
+113 val_113 1
+129 val_129 1
+129 val_129 1
+129 val_129 1
+129 val_129 1
+145 val_145 1
+177 val_177 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+193 val_193 1
+209 val_209 1
+209 val_209 1
+209 val_209 1
+209 val_209 1
+241 val_241 1
+257 val_257 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+273 val_273 1
+289 val_289 1
+305 val_305 1
+321 val_321 1
+321 val_321 1
+321 val_321 1
+321 val_321 1
+353 val_353 1
+353 val_353 1
+353 val_353 1
+353 val_353 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+369 val_369 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+401 val_401 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+417 val_417 1
+449 val_449 1
+481 val_481 1
+497 val_497 1
PREHOOK: query: -- Join data from a sampled bucket to verify the data is bucketed
SELECT COUNT(*) FROM test_table3 TABLESAMPLE(BUCKET 2 OUT OF 16) a JOIN test_table1 TABLESAMPLE(BUCKET 2 OUT OF 16) b ON a.key = b.key AND a.ds = '1' AND b.ds='1'
PREHOOK: type: QUERY
Modified: hive/branches/llap/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out Fri Jan 23 19:59:11 2015
@@ -71,7 +71,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 5 (type: int)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: 5 (type: int)
Statistics: Num rows: 26 Data size: 104 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: b
@@ -82,7 +82,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 5 (type: int)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: 5 (type: int)
Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
@@ -154,7 +154,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 5 (type: int)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: 5 (type: int)
Statistics: Num rows: 25 Data size: 100 Basic stats: COMPLETE Column stats: NONE
TableScan
alias: d
@@ -165,7 +165,7 @@ STAGE PLANS:
Reduce Output Operator
key expressions: 5 (type: int)
sort order: +
- Map-reduce partition columns: '' (type: string)
+ Map-reduce partition columns: 5 (type: int)
Statistics: Num rows: 27 Data size: 108 Basic stats: COMPLETE Column stats: NONE
Reduce Operator Tree:
Join Operator
Modified: hive/branches/llap/ql/src/test/results/clientpositive/sort.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/sort.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/sort.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/sort.q.out Fri Jan 23 19:59:11 2015
@@ -1,7 +1,11 @@
-PREHOOK: query: EXPLAIN
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT x.* FROM SRC x SORT BY key
PREHOOK: type: QUERY
-POSTHOOK: query: EXPLAIN
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+EXPLAIN
SELECT x.* FROM SRC x SORT BY key
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
Modified: hive/branches/llap/ql/src/test/results/clientpositive/stats1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/stats1.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/stats1.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/stats1.q.out Fri Jan 23 19:59:11 2015
@@ -1,8 +1,12 @@
-PREHOOK: query: create table tmptable(key string, value string)
+PREHOOK: query: -- SORT_QUERY_RESULTS
+
+create table tmptable(key string, value string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@tmptable
-POSTHOOK: query: create table tmptable(key string, value string)
+POSTHOOK: query: -- SORT_QUERY_RESULTS
+
+create table tmptable(key string, value string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@tmptable
Modified: hive/branches/llap/ql/src/test/results/clientpositive/subquery_in.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/subquery_in.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/subquery_in.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/subquery_in.q.out Fri Jan 23 19:59:11 2015
@@ -271,9 +271,10 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: int)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: int)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
@@ -439,9 +440,10 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col0 (type: string)
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: int)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: int)
+ outputColumnNames: _col0, _col1
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Statistics: Num rows: 26 Data size: 3147 Basic stats: COMPLETE Column stats: NONE
Modified: hive/branches/llap/ql/src/test/results/clientpositive/subquery_in_having.q.out
URL: http://svn.apache.org/viewvc/hive/branches/llap/ql/src/test/results/clientpositive/subquery_in_having.q.out?rev=1654355&r1=1654354&r2=1654355&view=diff
==============================================================================
--- hive/branches/llap/ql/src/test/results/clientpositive/subquery_in_having.q.out (original)
+++ hive/branches/llap/ql/src/test/results/clientpositive/subquery_in_having.q.out Fri Jan 23 19:59:11 2015
@@ -1379,9 +1379,11 @@ STAGE PLANS:
sort order: ++
Map-reduce partition columns: _col1 (type: string)
Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
- value expressions: _col0 (type: string), _col1 (type: string), _col2 (type: int)
+ value expressions: _col0 (type: string)
Reduce Operator Tree:
- Extract
+ Select Operator
+ expressions: VALUE._col0 (type: string), KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: int)
+ outputColumnNames: _col0, _col1, _col2
Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE
PTF Operator
Statistics: Num rows: 15 Data size: 3173 Basic stats: COMPLETE Column stats: NONE