Repository: hive Updated Branches: refs/heads/master 37db169a8 -> 6908198df
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
