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