http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/udf_reflect2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_reflect2.q.out b/ql/src/test/results/clientpositive/udf_reflect2.q.out
index 6c22657..a862990 100644
--- a/ql/src/test/results/clientpositive/udf_reflect2.q.out
+++ b/ql/src/test/results/clientpositive/udf_reflect2.q.out
@@ -78,235 +78,6 @@ SELECT key,
reflect2(ts, "getTime")
FROM (select cast(key as int) key, value, cast('2013-02-15 19:41:20' as timestamp) ts from src) a LIMIT 5
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- TOK_INT
- TOK_TABLE_OR_COL
- key
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- value
- TOK_SELEXPR
- TOK_FUNCTION
- TOK_TIMESTAMP
- '2013-02-15 19:41:20'
- ts
- a
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- key
- "byteValue"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- key
- "shortValue"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- key
- "intValue"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- key
- "longValue"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- key
- "floatValue"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- key
- "doubleValue"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- key
- "toString"
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- value
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "concat"
- "_concat"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "contains"
- "86"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "startsWith"
- "v"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "endsWith"
- "6"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "equals"
- "val_86"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "equalsIgnoreCase"
- "VAL_86"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "getBytes"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "indexOf"
- "1"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "lastIndexOf"
- "1"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "replace"
- "val"
- "VALUE"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "substring"
- 1
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "substring"
- 1
- 5
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "toUpperCase"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- value
- "trim"
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- ts
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- ts
- "getYear"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- ts
- "getMonth"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- ts
- "getDay"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- ts
- "getHours"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- ts
- "getMinutes"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- ts
- "getSeconds"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect2
- TOK_TABLE_OR_COL
- ts
- "getTime"
- TOK_LIMIT
- 5
-
-
STAGE DEPENDENCIES:
Stage-0 is a root stage
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/udtf_explode.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udtf_explode.q.out b/ql/src/test/results/clientpositive/udtf_explode.q.out
index 62d8e9f..3304109 100644
--- a/ql/src/test/results/clientpositive/udtf_explode.q.out
+++ b/ql/src/test/results/clientpositive/udtf_explode.q.out
@@ -12,31 +12,6 @@ PREHOOK: query: EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- explode
- TOK_FUNCTION
- array
- 1
- 2
- 3
- myCol
- TOK_LIMIT
- 3
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -141,54 +116,6 @@ PREHOOK: query: EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(a
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT a.myCol, count(1) FROM (SELECT explode(array(1,2,3)) AS myCol FROM src LIMIT 3) a GROUP BY a.myCol
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- explode
- TOK_FUNCTION
- array
- 1
- 2
- 3
- myCol
- TOK_LIMIT
- 3
- a
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- myCol
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- .
- TOK_TABLE_OR_COL
- a
- myCol
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1
@@ -453,67 +380,6 @@ PREHOOK: query: EXPLAIN EXTENDED SELECT a.myKey, a.myVal, count(1) FROM (SELECT
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT a.myKey, a.myVal, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) as (myKey,myVal) FROM src LIMIT 3) a GROUP BY a.myKey, a.myVal
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- explode
- TOK_FUNCTION
- map
- 1
- 'one'
- 2
- 'two'
- 3
- 'three'
- myKey
- myVal
- TOK_LIMIT
- 3
- a
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- myKey
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- myVal
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- .
- TOK_TABLE_OR_COL
- a
- myKey
- .
- TOK_TABLE_OR_COL
- a
- myVal
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/union22.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union22.q.out b/ql/src/test/results/clientpositive/union22.q.out
index 5309c71..f075148 100644
--- a/ql/src/test/results/clientpositive/union22.q.out
+++ b/ql/src/test/results/clientpositive/union22.q.out
@@ -78,146 +78,6 @@ where a.k1 > 20
)
subq
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- dst_union22_delta
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k1
- k1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k2
- k2
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k3
- k3
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k4
- k4
- TOK_WHERE
- and
- =
- TOK_TABLE_OR_COL
- ds
- '1'
- <=
- TOK_TABLE_OR_COL
- k0
- 50
- TOK_QUERY
- TOK_FROM
- TOK_LEFTOUTERJOIN
- TOK_TABREF
- TOK_TABNAME
- dst_union22
- a
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- dst_union22_delta
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- =
- TOK_TABLE_OR_COL
- ds
- '1'
- >
- TOK_TABLE_OR_COL
- k0
- 50
- b
- and
- =
- .
- TOK_TABLE_OR_COL
- a
- k1
- .
- TOK_TABLE_OR_COL
- b
- k1
- =
- .
- TOK_TABLE_OR_COL
- a
- ds
- '1'
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- k1
- k1
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- k2
- k2
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- b
- k3
- k3
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- b
- k4
- k4
- TOK_WHERE
- >
- .
- TOK_TABLE_OR_COL
- a
- k1
- 20
- subq
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dst_union22
- TOK_PARTSPEC
- TOK_PARTVAL
- ds
- '2'
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
-
-
STAGE DEPENDENCIES:
Stage-7 is a root stage , consists of Stage-8, Stage-4
Stage-8 has a backup stage: Stage-4
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/union24.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union24.q.out b/ql/src/test/results/clientpositive/union24.q.out
index 993b838..91b582f 100644
--- a/ql/src/test/results/clientpositive/union24.q.out
+++ b/ql/src/test/results/clientpositive/union24.q.out
@@ -72,121 +72,6 @@ select s.key, s.count from (
select key, count(1) as count from src5 where key < 10 group by key
)s
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_UNIONALL
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src3
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src4
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src5
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- s
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- count
-
-
STAGE DEPENDENCIES:
Stage-5 is a root stage
Stage-2 depends on stages: Stage-5
@@ -674,117 +559,6 @@ select s.key, s.count from (
select a.key as key, b.count as count from src4 a join src5 b on a.key=b.key where a.key < 10
)s
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src3
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src4
- a
- TOK_TABREF
- TOK_TABNAME
- src5
- b
- =
- .
- TOK_TABLE_OR_COL
- a
- key
- .
- TOK_TABLE_OR_COL
- b
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- key
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- b
- count
- count
- TOK_WHERE
- <
- .
- TOK_TABLE_OR_COL
- a
- key
- 10
- s
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- count
-
-
STAGE DEPENDENCIES:
Stage-4 is a root stage
Stage-2 depends on stages: Stage-4
@@ -1246,121 +1020,6 @@ select s.key, s.count from (
select a.key as key, count(1) as count from src4 a join src5 b on a.key=b.key where a.key < 10 group by a.key
)s
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src3
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src4
- a
- TOK_TABREF
- TOK_TABNAME
- src5
- b
- =
- .
- TOK_TABLE_OR_COL
- a
- key
- .
- TOK_TABLE_OR_COL
- b
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- key
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- count
- TOK_WHERE
- <
- .
- TOK_TABLE_OR_COL
- a
- key
- 10
- TOK_GROUPBY
- .
- TOK_TABLE_OR_COL
- a
- key
- s
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- count
-
-
STAGE DEPENDENCIES:
Stage-4 is a root stage
Stage-5 depends on stages: Stage-4
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/unionDistinct_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/unionDistinct_1.q.out b/ql/src/test/results/clientpositive/unionDistinct_1.q.out
index 61bfa74..0330133 100644
--- a/ql/src/test/results/clientpositive/unionDistinct_1.q.out
+++ b/ql/src/test/results/clientpositive/unionDistinct_1.q.out
@@ -6815,157 +6815,6 @@ where a.k1 > 20
)
subq
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- dst_union22_delta
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k1
- k1
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k2
- k2
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k3
- k3
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- k4
- k4
- TOK_WHERE
- and
- =
- TOK_TABLE_OR_COL
- ds
- '1'
- <=
- TOK_TABLE_OR_COL
- k0
- 50
- TOK_QUERY
- TOK_FROM
- TOK_LEFTOUTERJOIN
- TOK_TABREF
- TOK_TABNAME
- dst_union22
- a
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- dst_union22_delta
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- and
- =
- TOK_TABLE_OR_COL
- ds
- '1'
- >
- TOK_TABLE_OR_COL
- k0
- 50
- b
- and
- =
- .
- TOK_TABLE_OR_COL
- a
- k1
- .
- TOK_TABLE_OR_COL
- b
- k1
- =
- .
- TOK_TABLE_OR_COL
- a
- ds
- '1'
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- k1
- k1
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- k2
- k2
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- b
- k3
- k3
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- b
- k4
- k4
- TOK_WHERE
- >
- .
- TOK_TABLE_OR_COL
- a
- k1
- 20
- _u1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECTDI
- TOK_SELEXPR
- TOK_ALLCOLREF
- subq
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- dst_union22
- TOK_PARTSPEC
- TOK_PARTVAL
- ds
- '2'
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
-
-
STAGE DEPENDENCIES:
Stage-7 is a root stage , consists of Stage-8, Stage-4
Stage-8 has a backup stage: Stage-4
@@ -8460,154 +8309,6 @@ select s.key, s.count from (
select key, count(1) as count from src5 where key < 10 group by key
)s
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src3
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- _u1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECTDI
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src4
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- _u2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECTDI
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src5
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- key
- _u3
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECTDI
- TOK_SELEXPR
- TOK_ALLCOLREF
- s
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- count
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1
@@ -9213,139 +8914,6 @@ select s.key, s.count from (
select a.key as key, b.count as count from src4 a join src5 b on a.key=b.key where a.key < 10
)s
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src3
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- _u1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECTDI
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src4
- a
- TOK_TABREF
- TOK_TABNAME
- src5
- b
- =
- .
- TOK_TABLE_OR_COL
- a
- key
- .
- TOK_TABLE_OR_COL
- b
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- key
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- b
- count
- count
- TOK_WHERE
- <
- .
- TOK_TABLE_OR_COL
- a
- key
- 10
- _u2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECTDI
- TOK_SELEXPR
- TOK_ALLCOLREF
- s
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- count
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-7 depends on stages: Stage-1
@@ -9817,143 +9385,6 @@ select s.key, s.count from (
select a.key as key, count(1) as count from src4 a join src5 b on a.key=b.key where a.key < 10 group by a.key
)s
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src3
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- key
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- count
- TOK_WHERE
- <
- TOK_TABLE_OR_COL
- key
- 10
- _u1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECTDI
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- src4
- a
- TOK_TABREF
- TOK_TABNAME
- src5
- b
- =
- .
- TOK_TABLE_OR_COL
- a
- key
- .
- TOK_TABLE_OR_COL
- b
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- key
- key
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- count
- TOK_WHERE
- <
- .
- TOK_TABLE_OR_COL
- a
- key
- 10
- TOK_GROUPBY
- .
- TOK_TABLE_OR_COL
- a
- key
- _u2
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECTDI
- TOK_SELEXPR
- TOK_ALLCOLREF
- s
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- s
- count
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-2 depends on stages: Stage-1, Stage-5
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/union_ppr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/union_ppr.q.out b/ql/src/test/results/clientpositive/union_ppr.q.out
index 11c6dce..c5b1193 100644
--- a/ql/src/test/results/clientpositive/union_ppr.q.out
+++ b/ql/src/test/results/clientpositive/union_ppr.q.out
@@ -20,98 +20,6 @@ SELECT * FROM (
WHERE A.ds = '2008-04-08'
SORT BY A.key, A.value, A.ds, A.hr
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_UNIONALL
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- SRCPART
- X
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_TABNAME
- X
- TOK_WHERE
- <
- .
- TOK_TABLE_OR_COL
- X
- key
- 100
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- SRCPART
- Y
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_TABNAME
- Y
- TOK_WHERE
- <
- .
- TOK_TABLE_OR_COL
- Y
- key
- 100
- A
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- =
- .
- TOK_TABLE_OR_COL
- A
- ds
- '2008-04-08'
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- A
- key
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- A
- value
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- A
- ds
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- A
- hr
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1