hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jd...@apache.org
Subject [12/50] [abbrv] hive git commit: HIVE-13533: Remove AST dump (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
Date Tue, 26 Apr 2016 17:53:35 GMT
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
 


Mime
View raw message