You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2016/04/25 17:05:31 UTC
[09/18] hive git commit: HIVE-13533: Remove AST dump (Jesus Camacho
Rodriguez, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/ctas.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/ctas.q.out b/ql/src/test/results/clientpositive/spark/ctas.q.out
index 086ad73..5396ada 100644
--- a/ql/src/test/results/clientpositive/spark/ctas.q.out
+++ b/ql/src/test/results/clientpositive/spark/ctas.q.out
@@ -678,49 +678,6 @@ PREHOOK: query: explain extended create table nzhang_ctas5 row format delimited
PREHOOK: type: CREATETABLE_AS_SELECT
POSTHOOK: query: explain extended create table nzhang_ctas5 row format delimited fields terminated by ',' lines terminated by '\012' stored as textfile as select key, value from src sort by key, value limit 10
POSTHOOK: type: CREATETABLE_AS_SELECT
-ABSTRACT SYNTAX TREE:
-
-TOK_CREATETABLE
- TOK_TABNAME
- nzhang_ctas5
- TOK_LIKETABLE
- TOK_TABLEROWFORMAT
- TOK_SERDEPROPS
- TOK_TABLEROWFORMATFIELD
- ','
- TOK_TABLEROWFORMATLINES
- '\012'
- TOK_FILEFORMAT_GENERIC
- textfile
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- value
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- key
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- value
- TOK_LIMIT
- 10
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out b/ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out
index fc2ff7b..e21b1b1 100644
--- a/ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out
+++ b/ql/src/test/results/clientpositive/spark/disable_merge_for_bucketing.q.out
@@ -14,23 +14,6 @@ POSTHOOK: query: explain extended
insert overwrite table bucket2_1
select * from src
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- bucket2_1
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out b/ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out
index c5f16ed..0bfdf5b 100644
--- a/ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out
+++ b/ql/src/test/results/clientpositive/spark/filter_join_breaktask.q.out
@@ -32,108 +32,6 @@ SELECT f.key, g.value
FROM filter_join_breaktask f JOIN filter_join_breaktask m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' AND f.key is not null)
JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !='')
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- filter_join_breaktask
- f
- TOK_TABREF
- TOK_TABNAME
- filter_join_breaktask
- m
- AND
- AND
- AND
- =
- .
- TOK_TABLE_OR_COL
- f
- key
- .
- TOK_TABLE_OR_COL
- m
- key
- =
- .
- TOK_TABLE_OR_COL
- f
- ds
- '2008-04-08'
- =
- .
- TOK_TABLE_OR_COL
- m
- ds
- '2008-04-08'
- TOK_FUNCTION
- TOK_ISNOTNULL
- .
- TOK_TABLE_OR_COL
- f
- key
- TOK_TABREF
- TOK_TABNAME
- filter_join_breaktask
- g
- AND
- AND
- AND
- AND
- =
- .
- TOK_TABLE_OR_COL
- g
- value
- .
- TOK_TABLE_OR_COL
- m
- value
- =
- .
- TOK_TABLE_OR_COL
- g
- ds
- '2008-04-08'
- =
- .
- TOK_TABLE_OR_COL
- m
- ds
- '2008-04-08'
- TOK_FUNCTION
- TOK_ISNOTNULL
- .
- TOK_TABLE_OR_COL
- m
- value
- !=
- .
- TOK_TABLE_OR_COL
- m
- value
- ''
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- f
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- g
- value
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out b/ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out
index b5eae57..7660305 100644
--- a/ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out
+++ b/ql/src/test/results/clientpositive/spark/groupby_map_ppr.q.out
@@ -24,77 +24,6 @@ SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(s
WHERE src.ds = '2008-04-08'
GROUP BY substr(src.key,1,1)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcpart
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest1
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
- TOK_SELEXPR
- TOK_FUNCTIONDI
- count
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_SELEXPR
- TOK_FUNCTION
- concat
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
- TOK_FUNCTION
- sum
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_WHERE
- =
- .
- TOK_TABLE_OR_COL
- src
- ds
- '2008-04-08'
- TOK_GROUPBY
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out b/ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out
index ada2f91..0608adc 100644
--- a/ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out
+++ b/ql/src/test/results/clientpositive/spark/groupby_map_ppr_multi_distinct.q.out
@@ -24,94 +24,6 @@ SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(s
WHERE src.ds = '2008-04-08'
GROUP BY substr(src.key,1,1)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcpart
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest1
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
- TOK_SELEXPR
- TOK_FUNCTIONDI
- count
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_SELEXPR
- TOK_FUNCTION
- concat
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
- TOK_FUNCTION
- sum
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_SELEXPR
- TOK_FUNCTIONDI
- sum
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_SELEXPR
- TOK_FUNCTIONDI
- count
- .
- TOK_TABLE_OR_COL
- src
- value
- TOK_WHERE
- =
- .
- TOK_TABLE_OR_COL
- src
- ds
- '2008-04-08'
- TOK_GROUPBY
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/groupby_ppr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/groupby_ppr.q.out b/ql/src/test/results/clientpositive/spark/groupby_ppr.q.out
index 97a9a6d..6abeb5d 100644
--- a/ql/src/test/results/clientpositive/spark/groupby_ppr.q.out
+++ b/ql/src/test/results/clientpositive/spark/groupby_ppr.q.out
@@ -24,77 +24,6 @@ SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(s
WHERE src.ds = '2008-04-08'
GROUP BY substr(src.key,1,1)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcpart
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest1
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
- TOK_SELEXPR
- TOK_FUNCTIONDI
- count
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_SELEXPR
- TOK_FUNCTION
- concat
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
- TOK_FUNCTION
- sum
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_WHERE
- =
- .
- TOK_TABLE_OR_COL
- src
- ds
- '2008-04-08'
- TOK_GROUPBY
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/groupby_ppr_multi_distinct.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/groupby_ppr_multi_distinct.q.out b/ql/src/test/results/clientpositive/spark/groupby_ppr_multi_distinct.q.out
index a8724f5..66d6cb6 100644
--- a/ql/src/test/results/clientpositive/spark/groupby_ppr_multi_distinct.q.out
+++ b/ql/src/test/results/clientpositive/spark/groupby_ppr_multi_distinct.q.out
@@ -24,94 +24,6 @@ SELECT substr(src.key,1,1), count(DISTINCT substr(src.value,5)), concat(substr(s
WHERE src.ds = '2008-04-08'
GROUP BY substr(src.key,1,1)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcpart
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest1
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
- TOK_SELEXPR
- TOK_FUNCTIONDI
- count
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_SELEXPR
- TOK_FUNCTION
- concat
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
- TOK_FUNCTION
- sum
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_SELEXPR
- TOK_FUNCTIONDI
- sum
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- value
- 5
- TOK_SELEXPR
- TOK_FUNCTIONDI
- count
- .
- TOK_TABLE_OR_COL
- src
- value
- TOK_WHERE
- =
- .
- TOK_TABLE_OR_COL
- src
- ds
- '2008-04-08'
- TOK_GROUPBY
- TOK_FUNCTION
- substr
- .
- TOK_TABLE_OR_COL
- src
- key
- 1
- 1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out b/ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out
index 4e7e72e..1b4822e 100644
--- a/ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out
+++ b/ql/src/test/results/clientpositive/spark/groupby_sort_1_23.q.out
@@ -54,31 +54,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1
SELECT key, count(1) FROM T1 GROUP BY key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -258,36 +233,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl2
SELECT key, val, count(1) FROM T1 GROUP BY key, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl2
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -481,46 +426,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1
SELECT key, count(1) FROM (SELECT key, val FROM T1) subq1 GROUP BY key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -702,48 +607,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1
SELECT k, count(1) FROM (SELECT key as k, val as v FROM T1) subq1 GROUP BY k
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- k
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- v
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- k
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -935,34 +798,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl3
SELECT 1, key, count(1) FROM T1 GROUP BY 1, key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl3
- TOK_SELECT
- TOK_SELEXPR
- 1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- 1
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1143,39 +978,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl4
SELECT key, 1, val, count(1) FROM T1 GROUP BY key, 1, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl4
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- 1
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1370,40 +1172,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl3
SELECT key, key + 1, count(1) FROM T1 GROUP BY key, key + 1
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl3
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- +
- TOK_TABLE_OR_COL
- key
- 1
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- +
- TOK_TABLE_OR_COL
- key
- 1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1616,58 +1384,6 @@ SELECT key + key, sum(cnt) from
(SELECT key, count(1) as cnt FROM T1 GROUP BY key) subq1
group by key + key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- cnt
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- +
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- cnt
- TOK_GROUPBY
- +
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1891,63 +1607,6 @@ SELECT key, count(1) FROM T1 GROUP BY key
SELECT key, count(1) FROM T1 GROUP BY key
) subq1
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -2254,70 +1913,6 @@ SELECT key, count(1) FROM T1 GROUP BY key
SELECT key + key as key, count(1) FROM T1 GROUP BY key + key
) subq1
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- +
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- key
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- +
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -2648,89 +2243,6 @@ JOIN
(SELECT key, count(1) as cnt FROM T1 GROUP BY key) subq2
ON subq1.key = subq2.key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- cnt
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- cnt
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq2
- =
- .
- TOK_TABLE_OR_COL
- subq1
- key
- .
- TOK_TABLE_OR_COL
- subq2
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- subq1
- key
- TOK_SELEXPR
- +
- .
- TOK_TABLE_OR_COL
- subq1
- cnt
- .
- TOK_TABLE_OR_COL
- subq2
- cnt
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -3034,78 +2546,6 @@ JOIN
(SELECT key, val, count(1) FROM T1 GROUP BY key, val) subq2
ON subq1.key = subq2.key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- val
- subq2
- =
- .
- TOK_TABLE_OR_COL
- subq1
- key
- .
- TOK_TABLE_OR_COL
- subq2
- key
- 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
@@ -3372,31 +2812,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1
SELECT key, count(1) FROM T2 GROUP BY key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -3601,39 +3016,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl4
SELECT key, 1, val, count(1) FROM T2 GROUP BY key, 1, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl4
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- 1
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -3828,42 +3210,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl5
SELECT key, 1, val, 2, count(1) FROM T2 GROUP BY key, 1, val, 2
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl5
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- 2
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- 1
- TOK_TABLE_OR_COL
- val
- 2
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -4045,59 +3391,6 @@ SELECT key, constant, val, count(1) from
(SELECT key, 1 as constant, val from T2)subq
group by key, constant, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- constant
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- subq
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl4
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- constant
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- constant
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -4296,81 +3589,6 @@ SELECT key, constant as constant2, val, 2 as constant3 from
)subq2
group by key, constant3, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- constant
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- subq
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- constant
- constant2
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- 2
- constant3
- subq2
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl4
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- constant3
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- constant3
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out b/ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out
index b8f1bbd..0956771 100644
--- a/ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out
+++ b/ql/src/test/results/clientpositive/spark/groupby_sort_skew_1_23.q.out
@@ -54,31 +54,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1
SELECT key, count(1) FROM T1 GROUP BY key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -258,36 +233,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl2
SELECT key, val, count(1) FROM T1 GROUP BY key, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl2
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -500,46 +445,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1
SELECT key, count(1) FROM (SELECT key, val FROM T1) subq1 GROUP BY key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -721,48 +626,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1
SELECT k, count(1) FROM (SELECT key as k, val as v FROM T1) subq1 GROUP BY k
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- k
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- v
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- k
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -954,34 +817,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl3
SELECT 1, key, count(1) FROM T1 GROUP BY 1, key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl3
- TOK_SELECT
- TOK_SELEXPR
- 1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- 1
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1162,39 +997,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl4
SELECT key, 1, val, count(1) FROM T1 GROUP BY key, 1, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl4
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- 1
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1408,40 +1210,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl3
SELECT key, key + 1, count(1) FROM T1 GROUP BY key, key + 1
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl3
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- +
- TOK_TABLE_OR_COL
- key
- 1
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- +
- TOK_TABLE_OR_COL
- key
- 1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1673,58 +1441,6 @@ SELECT key + key, sum(cnt) from
(SELECT key, count(1) as cnt FROM T1 GROUP BY key) subq1
group by key + key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- cnt
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- +
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- cnt
- TOK_GROUPBY
- +
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1967,63 +1683,6 @@ SELECT key, count(1) FROM T1 GROUP BY key
SELECT key, count(1) FROM T1 GROUP BY key
) subq1
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -2330,70 +1989,6 @@ SELECT key, count(1) FROM T1 GROUP BY key
SELECT key + key as key, count(1) FROM T1 GROUP BY key + key
) subq1
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- +
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- key
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- +
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -2743,89 +2338,6 @@ JOIN
(SELECT key, count(1) as cnt FROM T1 GROUP BY key) subq2
ON subq1.key = subq2.key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- cnt
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- cnt
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq2
- =
- .
- TOK_TABLE_OR_COL
- subq1
- key
- .
- TOK_TABLE_OR_COL
- subq2
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- subq1
- key
- TOK_SELEXPR
- +
- .
- TOK_TABLE_OR_COL
- subq1
- cnt
- .
- TOK_TABLE_OR_COL
- subq2
- cnt
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -3129,78 +2641,6 @@ JOIN
(SELECT key, val, count(1) FROM T1 GROUP BY key, val) subq2
ON subq1.key = subq2.key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- subq1
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- val
- subq2
- =
- .
- TOK_TABLE_OR_COL
- subq1
- key
- .
- TOK_TABLE_OR_COL
- subq2
- key
- 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
@@ -3486,31 +2926,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl1
SELECT key, count(1) FROM T2 GROUP BY key
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl1
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -3734,39 +3149,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl4
SELECT key, 1, val, count(1) FROM T2 GROUP BY key, 1, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl4
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- 1
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -3961,42 +3343,6 @@ EXPLAIN EXTENDED
INSERT OVERWRITE TABLE outputTbl5
SELECT key, 1, val, 2, count(1) FROM T2 GROUP BY key, 1, val, 2
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl5
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- 2
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- 1
- TOK_TABLE_OR_COL
- val
- 2
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -4178,59 +3524,6 @@ SELECT key, constant, val, count(1) from
(SELECT key, 1 as constant, val from T2)subq
group by key, constant, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- constant
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- subq
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl4
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- constant
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- constant
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -4429,81 +3722,6 @@ SELECT key, constant as constant2, val, 2 as constant3 from
)subq2
group by key, constant3, val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- T2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- 1
- constant
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- subq
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- constant
- constant2
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- 2
- constant3
- subq2
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- outputTbl4
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- constant3
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- TOK_TABLE_OR_COL
- constant3
- TOK_TABLE_OR_COL
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/input_part2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/input_part2.q.out b/ql/src/test/results/clientpositive/spark/input_part2.q.out
index 6129b1c..73a3679 100644
--- a/ql/src/test/results/clientpositive/spark/input_part2.q.out
+++ b/ql/src/test/results/clientpositive/spark/input_part2.q.out
@@ -28,109 +28,6 @@ FROM srcpart
INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
INSERT OVERWRITE TABLE dest2 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-09' and srcpart.hr = '12'
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcpart
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest1
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- srcpart
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- srcpart
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- srcpart
- hr
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- srcpart
- ds
- TOK_WHERE
- and
- and
- <
- .
- TOK_TABLE_OR_COL
- srcpart
- key
- 100
- =
- .
- TOK_TABLE_OR_COL
- srcpart
- ds
- '2008-04-08'
- =
- .
- TOK_TABLE_OR_COL
- srcpart
- hr
- '12'
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest2
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- srcpart
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- srcpart
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- srcpart
- hr
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- srcpart
- ds
- TOK_WHERE
- and
- and
- <
- .
- TOK_TABLE_OR_COL
- srcpart
- key
- 100
- =
- .
- TOK_TABLE_OR_COL
- srcpart
- ds
- '2008-04-09'
- =
- .
- TOK_TABLE_OR_COL
- srcpart
- hr
- '12'
-
-
STAGE DEPENDENCIES:
Stage-2 is a root stage
Stage-0 depends on stages: Stage-2
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/join17.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/join17.q.out b/ql/src/test/results/clientpositive/spark/join17.q.out
index 026bf1a..0d92441 100644
--- a/ql/src/test/results/clientpositive/spark/join17.q.out
+++ b/ql/src/test/results/clientpositive/spark/join17.q.out
@@ -18,44 +18,6 @@ POSTHOOK: query: EXPLAIN EXTENDED
FROM src src1 JOIN src src2 ON (src1.key = src2.key)
INSERT OVERWRITE TABLE dest1 SELECT src1.*, src2.*
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src
- src1
- TOK_TABREF
- TOK_TABNAME
- src
- src2
- =
- .
- TOK_TABLE_OR_COL
- src1
- key
- .
- TOK_TABLE_OR_COL
- src2
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest1
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_TABNAME
- src1
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_TABNAME
- src2
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/join26.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/join26.q.out b/ql/src/test/results/clientpositive/spark/join26.q.out
index b0449f6..c700b87 100644
--- a/ql/src/test/results/clientpositive/spark/join26.q.out
+++ b/ql/src/test/results/clientpositive/spark/join26.q.out
@@ -22,85 +22,6 @@ SELECT /*+ MAPJOIN(x,y) */ x.key, z.value, y.value
FROM src1 x JOIN src y ON (x.key = y.key)
JOIN srcpart z ON (x.key = z.key and z.ds='2008-04-08' and z.hr=11)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src1
- x
- TOK_TABREF
- TOK_TABNAME
- src
- y
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- y
- key
- TOK_TABREF
- TOK_TABNAME
- srcpart
- z
- and
- and
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- z
- key
- =
- .
- TOK_TABLE_OR_COL
- z
- ds
- '2008-04-08'
- =
- .
- TOK_TABLE_OR_COL
- z
- hr
- 11
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest_j1
- TOK_SELECT
- TOK_HINTLIST
- TOK_HINT
- TOK_MAPJOIN
- TOK_HINTARGLIST
- x
- y
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- z
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- y
- value
-
-
STAGE DEPENDENCIES:
Stage-3 is a root stage
Stage-1 depends on stages: Stage-3
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/join32.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/join32.q.out b/ql/src/test/results/clientpositive/spark/join32.q.out
index 3771217..fc3dcc2 100644
--- a/ql/src/test/results/clientpositive/spark/join32.q.out
+++ b/ql/src/test/results/clientpositive/spark/join32.q.out
@@ -26,79 +26,6 @@ SELECT x.key, z.value, y.value
FROM src1 x JOIN src y ON (x.key = y.key)
JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src1
- x
- TOK_TABREF
- TOK_TABNAME
- src
- y
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- y
- key
- TOK_TABREF
- TOK_TABNAME
- srcpart
- z
- and
- and
- =
- .
- TOK_TABLE_OR_COL
- x
- value
- .
- TOK_TABLE_OR_COL
- z
- value
- =
- .
- TOK_TABLE_OR_COL
- z
- ds
- '2008-04-08'
- =
- .
- TOK_TABLE_OR_COL
- z
- hr
- 11
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest_j1
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- z
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- y
- value
-
-
STAGE DEPENDENCIES:
Stage-3 is a root stage
Stage-1 depends on stages: Stage-3
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/join32_lessSize.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/join32_lessSize.q.out b/ql/src/test/results/clientpositive/spark/join32_lessSize.q.out
index c4ac2dd..4d5110f 100644
--- a/ql/src/test/results/clientpositive/spark/join32_lessSize.q.out
+++ b/ql/src/test/results/clientpositive/spark/join32_lessSize.q.out
@@ -34,79 +34,6 @@ SELECT x.key, z.value, y.value
FROM src1 x JOIN src y ON (x.key = y.key)
JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src1
- x
- TOK_TABREF
- TOK_TABNAME
- src
- y
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- y
- key
- TOK_TABREF
- TOK_TABNAME
- srcpart
- z
- and
- and
- =
- .
- TOK_TABLE_OR_COL
- x
- value
- .
- TOK_TABLE_OR_COL
- z
- value
- =
- .
- TOK_TABLE_OR_COL
- z
- ds
- '2008-04-08'
- =
- .
- TOK_TABLE_OR_COL
- z
- hr
- 11
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest_j1
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- z
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- y
- value
-
-
STAGE DEPENDENCIES:
Stage-3 is a root stage
Stage-1 depends on stages: Stage-3
@@ -539,79 +466,6 @@ FROM src w JOIN src1 x ON (x.value = w.value)
JOIN src y ON (x.key = y.key)
JOIN src1 z ON (x.key = z.key)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_JOIN
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src
- w
- TOK_TABREF
- TOK_TABNAME
- src1
- x
- =
- .
- TOK_TABLE_OR_COL
- x
- value
- .
- TOK_TABLE_OR_COL
- w
- value
- TOK_TABREF
- TOK_TABNAME
- src
- y
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- y
- key
- TOK_TABREF
- TOK_TABNAME
- src1
- z
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- z
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest_j1
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- z
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- y
- value
-
-
STAGE DEPENDENCIES:
Stage-4 is a root stage
Stage-3 depends on stages: Stage-4
@@ -1135,98 +989,6 @@ SELECT res.key, z.value, res.value
FROM (select x.key, x.value from src1 x JOIN src y ON (x.key = y.key)) res
JOIN srcpart z ON (res.value = z.value and z.ds='2008-04-08' and z.hr=11)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src1
- x
- TOK_TABREF
- TOK_TABNAME
- src
- y
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- y
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- value
- res
- TOK_TABREF
- TOK_TABNAME
- srcpart
- z
- and
- and
- =
- .
- TOK_TABLE_OR_COL
- res
- value
- .
- TOK_TABLE_OR_COL
- z
- value
- =
- .
- TOK_TABLE_OR_COL
- z
- ds
- '2008-04-08'
- =
- .
- TOK_TABLE_OR_COL
- z
- hr
- 11
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest_j2
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- res
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- z
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- res
- value
-
-
STAGE DEPENDENCIES:
Stage-3 is a root stage
Stage-1 depends on stages: Stage-3
@@ -1661,98 +1423,6 @@ SELECT res.key, z.value, res.value
FROM (select x.key, x.value from src1 x LEFT OUTER JOIN src y ON (x.key = y.key)) res
JOIN srcpart z ON (res.value = z.value and z.ds='2008-04-08' and z.hr=11)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_LEFTOUTERJOIN
- TOK_TABREF
- TOK_TABNAME
- src1
- x
- TOK_TABREF
- TOK_TABNAME
- src
- y
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- y
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- value
- res
- TOK_TABREF
- TOK_TABNAME
- srcpart
- z
- and
- and
- =
- .
- TOK_TABLE_OR_COL
- res
- value
- .
- TOK_TABLE_OR_COL
- z
- value
- =
- .
- TOK_TABLE_OR_COL
- z
- ds
- '2008-04-08'
- =
- .
- TOK_TABLE_OR_COL
- z
- hr
- 11
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest_j2
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- res
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- z
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- res
- value
-
-
STAGE DEPENDENCIES:
Stage-3 is a root stage
Stage-1 depends on stages: Stage-3
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/join33.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/join33.q.out b/ql/src/test/results/clientpositive/spark/join33.q.out
index 3771217..fc3dcc2 100644
--- a/ql/src/test/results/clientpositive/spark/join33.q.out
+++ b/ql/src/test/results/clientpositive/spark/join33.q.out
@@ -26,79 +26,6 @@ SELECT x.key, z.value, y.value
FROM src1 x JOIN src y ON (x.key = y.key)
JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src1
- x
- TOK_TABREF
- TOK_TABNAME
- src
- y
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- y
- key
- TOK_TABREF
- TOK_TABNAME
- srcpart
- z
- and
- and
- =
- .
- TOK_TABLE_OR_COL
- x
- value
- .
- TOK_TABLE_OR_COL
- z
- value
- =
- .
- TOK_TABLE_OR_COL
- z
- ds
- '2008-04-08'
- =
- .
- TOK_TABLE_OR_COL
- z
- hr
- 11
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest_j1
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- z
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- y
- value
-
-
STAGE DEPENDENCIES:
Stage-3 is a root stage
Stage-1 depends on stages: Stage-3
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/join34.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/join34.q.out b/ql/src/test/results/clientpositive/spark/join34.q.out
index bb55191..8d0b649 100644
--- a/ql/src/test/results/clientpositive/spark/join34.q.out
+++ b/ql/src/test/results/clientpositive/spark/join34.q.out
@@ -34,110 +34,6 @@ FROM
) subq1
JOIN src1 x ON (x.key = subq1.key)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- x
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- key
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- value
- value
- TOK_WHERE
- <
- .
- TOK_TABLE_OR_COL
- x
- key
- 20
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- x1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x1
- key
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x1
- value
- value
- TOK_WHERE
- >
- .
- TOK_TABLE_OR_COL
- x1
- key
- 100
- subq1
- TOK_TABREF
- TOK_TABNAME
- src1
- x
- =
- .
- TOK_TABLE_OR_COL
- x
- key
- .
- TOK_TABLE_OR_COL
- subq1
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dest_j1
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- x
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- subq1
- value
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1