You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jd...@apache.org on 2016/04/26 19:53:38 UTC
[15/50] [abbrv] 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/union24.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union24.q.out b/ql/src/test/results/clientpositive/spark/union24.q.out
index 3bdc503..5032630 100644
--- a/ql/src/test/results/clientpositive/spark/union24.q.out
+++ b/ql/src/test/results/clientpositive/spark/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-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -641,117 +526,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-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1179,121 +953,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-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/union_ppr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/union_ppr.q.out b/ql/src/test/results/clientpositive/spark/union_ppr.q.out
index 1d2120a..8f7b1f2 100644
--- a/ql/src/test/results/clientpositive/spark/union_ppr.q.out
+++ b/ql/src/test/results/clientpositive/spark/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
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out b/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out
index f0a4444..7b56585 100644
--- a/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out
+++ b/ql/src/test/results/clientpositive/spark/vectorized_ptf.q.out
@@ -142,88 +142,6 @@ from noop(on part_orc
order by p_name
)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_retailprice
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -471,94 +389,6 @@ from noop (on (select p1.* from part_orc p1 join part_orc p2 on p1.p_partkey = p
distribute by j.p_mfgr
sort by j.p_name)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- part_orc
- p1
- TOK_TABREF
- TOK_TABNAME
- part_orc
- p2
- =
- .
- TOK_TABLE_OR_COL
- p1
- p_partkey
- .
- TOK_TABLE_OR_COL
- p2
- p_partkey
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_TABNAME
- p1
- j
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- .
- TOK_TABLE_OR_COL
- j
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- j
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- -
- TOK_TABLE_OR_COL
- p_size
- TOK_FUNCTION
- lag
- TOK_TABLE_OR_COL
- p_size
- 1
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- deltaSz
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -880,40 +710,6 @@ from noop(on part_orc
partition by p_mfgr
order by p_name)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1108,89 +904,6 @@ from noop(on part_orc
order by p_name
) abc
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- abc
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_retailprice
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1444,93 +1157,6 @@ from noop(on part_orc
order by p_name
)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- -
- TOK_TABLE_OR_COL
- p_size
- TOK_FUNCTION
- lag
- TOK_TABLE_OR_COL
- p_size
- 1
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- deltaSz
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1787,100 +1413,6 @@ from noop(on part_orc
)
group by p_mfgr, p_name, p_size
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- -
- TOK_TABLE_OR_COL
- p_size
- TOK_FUNCTION
- lag
- TOK_TABLE_OR_COL
- p_size
- 1
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- deltaSz
- TOK_GROUPBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_TABLE_OR_COL
- p_size
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -2139,50 +1671,6 @@ partition by p_mfgr
order by p_name
) abc join part_orc p1 on abc.p_partkey = p1.p_partkey
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_PTBLFUNCTION
- noop
- abc
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_TABREF
- TOK_TABNAME
- part_orc
- p1
- =
- .
- TOK_TABLE_OR_COL
- abc
- p_partkey
- .
- TOK_TABLE_OR_COL
- p1
- p_partkey
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_TABNAME
- abc
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -2464,50 +1952,6 @@ partition by p_mfgr
order by p_name
) abc on abc.p_partkey = p1.p_partkey
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- part_orc
- p1
- TOK_PTBLFUNCTION
- noop
- abc
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- =
- .
- TOK_TABLE_OR_COL
- abc
- p_partkey
- .
- TOK_TABLE_OR_COL
- p1
- p_partkey
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_TABNAME
- abc
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -2793,62 +2237,6 @@ from noopwithmap(on part_orc
partition by p_mfgr
order by p_name, p_size desc)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noopwithmap
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_TABSORTCOLNAMEDESC
- TOK_NULLS_LAST
- TOK_TABLE_OR_COL
- p_size
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_TABSORTCOLNAMEDESC
- TOK_NULLS_LAST
- TOK_TABLE_OR_COL
- p_size
- r
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -3095,88 +2483,6 @@ from noopwithmap(on part_orc
partition by p_mfgr
order by p_name)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noopwithmap
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_retailprice
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -3442,88 +2748,6 @@ from noop(on part_orc
partition by p_mfgr
order by p_name)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_retailprice
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -3775,96 +2999,6 @@ partition by p_mfgr
order by p_mfgr, p_name
)))
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noopwithmap
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_retailprice
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -4186,107 +3320,6 @@ order by p_name)
window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following)
) sub1
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_FUNCTION
- count
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- cd
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_retailprice
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_retailprice
- TOK_WINDOWSPEC
- w1
- s1
- window
- TOK_WINDOWDEF
- w1
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- 2
- following
- 2
- sub1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- sub1
- cd
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- sub1
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -4542,182 +3575,6 @@ partition by p_mfgr
order by p_name
) abc join part_orc p1 on abc.p_partkey = p1.p_partkey
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_PTBLFUNCTION
- noop
- abc
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_TABREF
- TOK_TABNAME
- part_orc
- p1
- =
- .
- TOK_TABLE_OR_COL
- abc
- p_partkey
- .
- TOK_TABLE_OR_COL
- p1
- p_partkey
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- abc
- p_mfgr
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- abc
- p_name
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- .
- TOK_TABLE_OR_COL
- abc
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- abc
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- .
- TOK_TABLE_OR_COL
- abc
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- abc
- p_name
- dr
- TOK_SELEXPR
- TOK_FUNCTION
- count
- .
- TOK_TABLE_OR_COL
- abc
- p_name
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- .
- TOK_TABLE_OR_COL
- abc
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- abc
- p_name
- cd
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- abc
- p_retailprice
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- .
- TOK_TABLE_OR_COL
- abc
- p_retailprice
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- .
- TOK_TABLE_OR_COL
- abc
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- abc
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- abc
- p_size
- TOK_SELEXPR
- -
- .
- TOK_TABLE_OR_COL
- abc
- p_size
- TOK_FUNCTION
- lag
- .
- TOK_TABLE_OR_COL
- abc
- p_size
- 1
- .
- TOK_TABLE_OR_COL
- abc
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- .
- TOK_TABLE_OR_COL
- abc
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- .
- TOK_TABLE_OR_COL
- abc
- p_name
- deltaSz
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -5075,40 +3932,6 @@ from noop(on part_orc
partition by p_mfgr
order by p_name)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECTDI
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -5337,65 +4160,6 @@ partition by p_mfgr
order by p_mfgr)
window w1 as ( partition by p_mfgr order by p_brand rows between 2 preceding and current row)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- mfgr_price_view
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_brand
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- s
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- s
- TOK_WINDOWSPEC
- w1
- s1
- window
- TOK_WINDOWDEF
- w1
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_brand
- TOK_WINDOWRANGE
- preceding
- 2
- current
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -5689,212 +4453,6 @@ cume_dist() over (distribute by p_mfgr sort by p_mfgr, p_name) as cud,
first_value(p_size, true) over w1 as fv1
window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- part_4
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_retailprice
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- part_5
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- round
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWVALUES
- preceding
- 5
- current
- 1
- s2
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_FUNCTION
- cume_dist
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- cud
- TOK_SELEXPR
- TOK_FUNCTION
- first_value
- TOK_TABLE_OR_COL
- p_size
- true
- TOK_WINDOWSPEC
- w1
- fv1
- window
- TOK_WINDOWDEF
- w1
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SORTBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- 2
- following
- 2
-
-
STAGE DEPENDENCIES:
Stage-2 is a root stage
Stage-0 depends on stages: Stage-2
@@ -6432,115 +4990,6 @@ from noop(on
partition by p_mfgr,p_name
order by p_mfgr,p_name)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noopwithmap
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -6891,118 +5340,6 @@ from noop(on
partition by p_mfgr
order by p_mfgr )
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -7349,105 +5686,6 @@ from noop(on
partition by p_mfgr
order by p_mfgr))
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -7770,115 +6008,6 @@ from noopwithmap(on
partition by p_mfgr,p_name
order by p_mfgr,p_name)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noopwithmap
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -8244,151 +6373,6 @@ from noop(on
order by p_mfgr
))
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noopwithmap
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s1
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWRANGE
- preceding
- unbounded
- current
- s2
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -8724,118 +6708,6 @@ from noopwithmap(on
order by p_mfgr, p_name)
))
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_PTBLFUNCTION
- noopwithmap
- TOK_PTBLFUNCTION
- noop
- TOK_PTBLFUNCTION
- noop
- TOK_TABREF
- TOK_TABNAME
- part_orc
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABLE_OR_COL
- p_name
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_name
- TOK_SELEXPR
- TOK_FUNCTION
- rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- r
- TOK_SELEXPR
- TOK_FUNCTION
- dense_rank
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- dr
- TOK_SELEXPR
- TOK_TABLE_OR_COL
- p_size
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWVALUES
- preceding
- unbounded
- current
- s1
- TOK_SELEXPR
- TOK_FUNCTION
- sum
- TOK_TABLE_OR_COL
- p_size
- TOK_WINDOWSPEC
- TOK_PARTITIONINGSPEC
- TOK_DISTRIBUTEBY
- TOK_TABLE_OR_COL
- p_mfgr
- TOK_ORDERBY
- TOK_TABSORTCOLNAMEASC
- TOK_NULLS_FIRST
- TOK_TABLE_OR_COL
- p_name
- TOK_WINDOWVALUES
- preceding
- unbounded
- current
- s2
-
-
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/stats0.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats0.q.out b/ql/src/test/results/clientpositive/stats0.q.out
index 99326fc..90a9a70 100644
--- a/ql/src/test/results/clientpositive/stats0.q.out
+++ b/ql/src/test/results/clientpositive/stats0.q.out
@@ -14,23 +14,6 @@ POSTHOOK: query: explain extended
insert overwrite table stats_non_partitioned
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
- stats_non_partitioned
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -1329,23 +1312,6 @@ POSTHOOK: query: explain extended
insert overwrite table stats_non_partitioned
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
- stats_non_partitioned
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/stats11.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/stats11.q.out b/ql/src/test/results/clientpositive/stats11.q.out
index 7598dc0..8ca5b27 100644
--- a/ql/src/test/results/clientpositive/stats11.q.out
+++ b/ql/src/test/results/clientpositive/stats11.q.out
@@ -294,63 +294,6 @@ select /*+mapjoin(b)*/ a.key, a.value, b.value
from srcbucket_mapjoin a join srcbucket_mapjoin_part b
on a.key=b.key where b.ds="2008-04-08"
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- srcbucket_mapjoin
- a
- TOK_TABREF
- TOK_TABNAME
- srcbucket_mapjoin_part
- b
- =
- .
- TOK_TABLE_OR_COL
- a
- key
- .
- TOK_TABLE_OR_COL
- b
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- bucketmapjoin_tmp_result
- TOK_SELECT
- TOK_HINTLIST
- TOK_HINT
- TOK_MAPJOIN
- TOK_HINTARGLIST
- b
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- b
- value
- TOK_WHERE
- =
- .
- TOK_TABLE_OR_COL
- b
- ds
- "2008-04-08"
-
-
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9
@@ -826,63 +769,6 @@ select /*+mapjoin(a)*/ a.key, a.value, b.value
from srcbucket_mapjoin a join srcbucket_mapjoin_part b
on a.key=b.key where b.ds="2008-04-08"
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_JOIN
- TOK_TABREF
- TOK_TABNAME
- srcbucket_mapjoin
- a
- TOK_TABREF
- TOK_TABNAME
- srcbucket_mapjoin_part
- b
- =
- .
- TOK_TABLE_OR_COL
- a
- key
- .
- TOK_TABLE_OR_COL
- b
- key
- TOK_INSERT
- TOK_DESTINATION
- TOK_TAB
- TOK_TABNAME
- bucketmapjoin_tmp_result
- TOK_SELECT
- TOK_HINTLIST
- TOK_HINT
- TOK_MAPJOIN
- TOK_HINTARGLIST
- a
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- value
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- b
- value
- TOK_WHERE
- =
- .
- TOK_TABLE_OR_COL
- b
- ds
- "2008-04-08"
-
-
STAGE DEPENDENCIES:
Stage-9 is a root stage
Stage-1 depends on stages: Stage-9