You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2016/04/25 17:05:25 UTC
[03/18] hive git commit: HIVE-13533: Remove AST dump (Jesus Camacho
Rodriguez, reviewed by Ashutosh Chauhan)
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out b/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
index 3d1f22f..1365626 100644
--- a/ql/src/test/results/clientpositive/tez/vectorized_ptf.q.out
+++ b/ql/src/test/results/clientpositive/tez/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
@@ -472,94 +390,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
@@ -883,40 +713,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
@@ -1112,89 +908,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
@@ -1449,93 +1162,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
@@ -1793,100 +1419,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
@@ -2146,50 +1678,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
@@ -2473,50 +1961,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
@@ -2804,62 +2248,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
@@ -3107,88 +2495,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
@@ -3455,88 +2761,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
@@ -3789,96 +3013,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
@@ -4201,107 +3335,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
@@ -4558,182 +3591,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
@@ -5093,40 +3950,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
@@ -5356,65 +4179,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
@@ -5709,212 +4473,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
@@ -6439,115 +4997,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
@@ -6899,118 +5348,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
@@ -7358,105 +5695,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
@@ -7780,115 +6018,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
@@ -8255,151 +6384,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
@@ -8736,118 +6720,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/transform_ppr1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/transform_ppr1.q.out b/ql/src/test/results/clientpositive/transform_ppr1.q.out
index a5c5dbe..8c58139 100644
--- a/ql/src/test/results/clientpositive/transform_ppr1.q.out
+++ b/ql/src/test/results/clientpositive/transform_ppr1.q.out
@@ -20,81 +20,6 @@ FROM (
) tmap
SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100 AND tmap.ds = '2008-04-08'
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcpart
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TRANSFORM
- TOK_EXPLIST
- .
- TOK_TABLE_OR_COL
- src
- ds
- .
- TOK_TABLE_OR_COL
- src
- key
- .
- TOK_TABLE_OR_COL
- src
- value
- TOK_SERDE
- TOK_RECORDWRITER
- 'cat'
- TOK_SERDE
- TOK_RECORDREADER
- TOK_ALIASLIST
- ds
- tkey
- tvalue
- TOK_CLUSTERBY
- TOK_TABLE_OR_COL
- tkey
- tmap
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- tmap
- tkey
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- tmap
- tvalue
- TOK_WHERE
- AND
- <
- .
- TOK_TABLE_OR_COL
- tmap
- tkey
- 100
- =
- .
- TOK_TABLE_OR_COL
- tmap
- ds
- '2008-04-08'
-
-
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/transform_ppr2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/transform_ppr2.q.out b/ql/src/test/results/clientpositive/transform_ppr2.q.out
index 5224787..8e36abd 100644
--- a/ql/src/test/results/clientpositive/transform_ppr2.q.out
+++ b/ql/src/test/results/clientpositive/transform_ppr2.q.out
@@ -22,81 +22,6 @@ FROM (
) tmap
SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- srcpart
- src
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_TRANSFORM
- TOK_EXPLIST
- .
- TOK_TABLE_OR_COL
- src
- ds
- .
- TOK_TABLE_OR_COL
- src
- key
- .
- TOK_TABLE_OR_COL
- src
- value
- TOK_SERDE
- TOK_RECORDWRITER
- 'cat'
- TOK_SERDE
- TOK_RECORDREADER
- TOK_ALIASLIST
- ds
- tkey
- tvalue
- TOK_WHERE
- =
- .
- TOK_TABLE_OR_COL
- src
- ds
- '2008-04-08'
- TOK_CLUSTERBY
- TOK_TABLE_OR_COL
- tkey
- tmap
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- tmap
- tkey
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- tmap
- tvalue
- TOK_WHERE
- <
- .
- TOK_TABLE_OR_COL
- tmap
- tkey
- 100
-
-
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/truncate_column_list_bucket.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out b/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out
index 1fa437b..39ffc6c 100644
--- a/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out
+++ b/ql/src/test/results/clientpositive/truncate_column_list_bucket.q.out
@@ -67,32 +67,6 @@ POSTHOOK: query: -- In the following select statements the list bucketing optimi
EXPLAIN EXTENDED SELECT * FROM test_tab WHERE part = '1' AND key = '484'
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- test_tab
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- AND
- =
- TOK_TABLE_OR_COL
- part
- '1'
- =
- TOK_TABLE_OR_COL
- key
- '484'
-
-
STAGE DEPENDENCIES:
Stage-0 is a root stage
@@ -171,32 +145,6 @@ PREHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_tab WHERE part = '1' AND key
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT * FROM test_tab WHERE part = '1' AND key = '0'
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- test_tab
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_ALLCOLREF
- TOK_WHERE
- AND
- =
- TOK_TABLE_OR_COL
- part
- '1'
- =
- TOK_TABLE_OR_COL
- key
- '0'
-
-
STAGE DEPENDENCIES:
Stage-0 is a root stage
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/udf_explode.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_explode.q.out b/ql/src/test/results/clientpositive/udf_explode.q.out
index 91b9bbe..8db4375 100644
--- a/ql/src/test/results/clientpositive/udf_explode.q.out
+++ b/ql/src/test/results/clientpositive/udf_explode.q.out
@@ -12,32 +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 tablesample (1 rows)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_TABLESPLITSAMPLE
- TOK_ROWCOUNT
- 1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- explode
- TOK_FUNCTION
- array
- 1
- 2
- 3
- myCol
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -140,55 +114,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 tablesample (1 rows)) 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_TABLESPLITSAMPLE
- TOK_ROWCOUNT
- 1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- explode
- TOK_FUNCTION
- array
- 1
- 2
- 3
- myCol
- 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-0 depends on stages: Stage-1
@@ -347,36 +272,6 @@ PREHOOK: query: EXPLAIN EXTENDED SELECT explode(map(1,'one',2,'two',3,'three'))
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_TABLESPLITSAMPLE
- TOK_ROWCOUNT
- 1
- 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'
- key
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
@@ -479,68 +374,6 @@ PREHOOK: query: EXPLAIN EXTENDED SELECT a.key, a.val, count(1) FROM (SELECT expl
PREHOOK: type: QUERY
POSTHOOK: query: EXPLAIN EXTENDED SELECT a.key, a.val, count(1) FROM (SELECT explode(map(1,'one',2,'two',3,'three')) AS (key,val) FROM src tablesample (1 rows)) a GROUP BY a.key, a.val
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_SUBQUERY
- TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_TABLESPLITSAMPLE
- TOK_ROWCOUNT
- 1
- 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'
- key
- val
- a
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- key
- TOK_SELEXPR
- .
- TOK_TABLE_OR_COL
- a
- val
- TOK_SELEXPR
- TOK_FUNCTION
- count
- 1
- TOK_GROUPBY
- .
- TOK_TABLE_OR_COL
- a
- key
- .
- TOK_TABLE_OR_COL
- a
- val
-
-
STAGE DEPENDENCIES:
Stage-1 is a root stage
Stage-0 depends on stages: Stage-1
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/udf_java_method.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_java_method.q.out b/ql/src/test/results/clientpositive/udf_java_method.q.out
index 2d2a57d..2c66a8f 100644
--- a/ql/src/test/results/clientpositive/udf_java_method.q.out
+++ b/ql/src/test/results/clientpositive/udf_java_method.q.out
@@ -35,69 +35,6 @@ SELECT java_method("java.lang.String", "valueOf", 1),
java_method("java.lang.Math", "floor", 1.9)
FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_TABLESPLITSAMPLE
- TOK_ROWCOUNT
- 1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- java_method
- "java.lang.String"
- "valueOf"
- 1
- TOK_SELEXPR
- TOK_FUNCTION
- java_method
- "java.lang.String"
- "isEmpty"
- TOK_SELEXPR
- TOK_FUNCTION
- java_method
- "java.lang.Math"
- "max"
- 2
- 3
- TOK_SELEXPR
- TOK_FUNCTION
- java_method
- "java.lang.Math"
- "min"
- 2
- 3
- TOK_SELEXPR
- TOK_FUNCTION
- java_method
- "java.lang.Math"
- "round"
- 2.5
- TOK_SELEXPR
- TOK_FUNCTION
- round
- TOK_FUNCTION
- java_method
- "java.lang.Math"
- "exp"
- 1.0
- 6
- TOK_SELEXPR
- TOK_FUNCTION
- java_method
- "java.lang.Math"
- "floor"
- 1.9
-
-
STAGE DEPENDENCIES:
Stage-0 is a root stage
http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/udf_reflect.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/udf_reflect.q.out b/ql/src/test/results/clientpositive/udf_reflect.q.out
index b65d1cd..4c31977 100644
--- a/ql/src/test/results/clientpositive/udf_reflect.q.out
+++ b/ql/src/test/results/clientpositive/udf_reflect.q.out
@@ -33,77 +33,6 @@ SELECT reflect("java.lang.String", "valueOf", 1),
reflect("java.lang.Integer", "valueOf", key, 16)
FROM src tablesample (1 rows)
POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-
-TOK_QUERY
- TOK_FROM
- TOK_TABREF
- TOK_TABNAME
- src
- TOK_TABLESPLITSAMPLE
- TOK_ROWCOUNT
- 1
- TOK_INSERT
- TOK_DESTINATION
- TOK_DIR
- TOK_TMP_FILE
- TOK_SELECT
- TOK_SELEXPR
- TOK_FUNCTION
- reflect
- "java.lang.String"
- "valueOf"
- 1
- TOK_SELEXPR
- TOK_FUNCTION
- reflect
- "java.lang.String"
- "isEmpty"
- TOK_SELEXPR
- TOK_FUNCTION
- reflect
- "java.lang.Math"
- "max"
- 2
- 3
- TOK_SELEXPR
- TOK_FUNCTION
- reflect
- "java.lang.Math"
- "min"
- 2
- 3
- TOK_SELEXPR
- TOK_FUNCTION
- reflect
- "java.lang.Math"
- "round"
- 2.5
- TOK_SELEXPR
- TOK_FUNCTION
- round
- TOK_FUNCTION
- reflect
- "java.lang.Math"
- "exp"
- 1.0
- 6
- TOK_SELEXPR
- TOK_FUNCTION
- reflect
- "java.lang.Math"
- "floor"
- 1.9
- TOK_SELEXPR
- TOK_FUNCTION
- reflect
- "java.lang.Integer"
- "valueOf"
- TOK_TABLE_OR_COL
- key
- 16
-
-
STAGE DEPENDENCIES:
Stage-0 is a root stage