http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/vectorized_ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vectorized_ptf.q.out
b/ql/src/test/results/clientpositive/vectorized_ptf.q.out
index 3b17591..fc4351d 100644
--- a/ql/src/test/results/clientpositive/vectorized_ptf.q.out
+++ b/ql/src/test/results/clientpositive/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-2 depends on stages: Stage-1
@@ -512,94 +430,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-2 depends on stages: Stage-1
@@ -956,40 +786,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
@@ -1178,89 +974,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-2 depends on stages: Stage-1
@@ -1555,93 +1268,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-2 depends on stages: Stage-1
@@ -1939,100 +1565,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-2 depends on stages: Stage-1
@@ -2332,50 +1864,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-2 depends on stages: Stage-1
@@ -2691,50 +2179,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-2 is a root stage
Stage-1 depends on stages: Stage-2
@@ -3054,62 +2498,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-2 depends on stages: Stage-1
@@ -3397,88 +2785,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-2 depends on stages: Stage-1
@@ -3785,88 +3091,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-2 depends on stages: Stage-1
@@ -4159,96 +3383,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-2 depends on stages: Stage-1
@@ -4658,107 +3792,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-2 depends on stages: Stage-1
@@ -5055,182 +4088,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-2 depends on stages: Stage-1
@@ -5669,40 +4526,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-2 depends on stages: Stage-1
@@ -5971,65 +4794,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-2 depends on stages: Stage-1
@@ -6364,212 +5128,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-3 depends on stages: Stage-2
@@ -7224,115 +5782,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-2 depends on stages: Stage-1
@@ -7771,118 +6220,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-2 depends on stages: Stage-1
@@ -8364,105 +6701,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-2 depends on stages: Stage-1
@@ -8873,115 +7111,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-2 depends on stages: Stage-1
@@ -9482,151 +7611,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-2 depends on stages: Stage-1
@@ -10050,118 +8034,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-2 depends on stages: Stage-1
