hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jcama...@apache.org
Subject [01/18] hive git commit: HIVE-13533: Remove AST dump (Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
Date Mon, 25 Apr 2016 15:05:23 GMT
Repository: hive
Updated Branches:
  refs/heads/master 37db169a8 -> 6908198df


http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/vectorized_ptf.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/vectorized_ptf.q.out b/ql/src/test/results/clientpositive/vectorized_ptf.q.out
index 3b17591..fc4351d 100644
--- a/ql/src/test/results/clientpositive/vectorized_ptf.q.out
+++ b/ql/src/test/results/clientpositive/vectorized_ptf.q.out
@@ -142,88 +142,6 @@ from noop(on part_orc
   order by p_name
   )
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_retailprice
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -512,94 +430,6 @@ from noop (on (select p1.* from part_orc p1 join part_orc p2 on p1.p_partkey = p
 distribute by j.p_mfgr
 sort by j.p_name)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_SUBQUERY
-            TOK_QUERY
-               TOK_FROM
-                  TOK_JOIN
-                     TOK_TABREF
-                        TOK_TABNAME
-                           part_orc
-                        p1
-                     TOK_TABREF
-                        TOK_TABNAME
-                           part_orc
-                        p2
-                     =
-                        .
-                           TOK_TABLE_OR_COL
-                              p1
-                           p_partkey
-                        .
-                           TOK_TABLE_OR_COL
-                              p2
-                           p_partkey
-               TOK_INSERT
-                  TOK_DESTINATION
-                     TOK_DIR
-                        TOK_TMP_FILE
-                  TOK_SELECT
-                     TOK_SELEXPR
-                        TOK_ALLCOLREF
-                           TOK_TABNAME
-                              p1
-            j
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               .
-                  TOK_TABLE_OR_COL
-                     j
-                  p_mfgr
-            TOK_SORTBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     .
-                        TOK_TABLE_OR_COL
-                           j
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            -
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_FUNCTION
-                  lag
-                  TOK_TABLE_OR_COL
-                     p_size
-                  1
-                  TOK_TABLE_OR_COL
-                     p_size
-                  TOK_WINDOWSPEC
-                     TOK_PARTITIONINGSPEC
-                        TOK_DISTRIBUTEBY
-                           TOK_TABLE_OR_COL
-                              p_mfgr
-                        TOK_ORDERBY
-                           TOK_TABSORTCOLNAMEASC
-                              TOK_NULLS_FIRST
-                                 TOK_TABLE_OR_COL
-                                    p_name
-            deltaSz
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -956,40 +786,6 @@ from noop(on part_orc
 partition by p_mfgr
 order by p_name)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-0 depends on stages: Stage-1
@@ -1178,89 +974,6 @@ from noop(on part_orc
   order by p_name
   ) abc
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         abc
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_retailprice
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -1555,93 +1268,6 @@ from noop(on part_orc
           order by p_name 
           )
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            -
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_FUNCTION
-                  lag
-                  TOK_TABLE_OR_COL
-                     p_size
-                  1
-                  TOK_TABLE_OR_COL
-                     p_size
-                  TOK_WINDOWSPEC
-                     TOK_PARTITIONINGSPEC
-                        TOK_DISTRIBUTEBY
-                           TOK_TABLE_OR_COL
-                              p_mfgr
-                        TOK_ORDERBY
-                           TOK_TABSORTCOLNAMEASC
-                              TOK_NULLS_FIRST
-                                 TOK_TABLE_OR_COL
-                                    p_name
-            deltaSz
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -1939,100 +1565,6 @@ from noop(on part_orc
           ) 
 group by p_mfgr, p_name, p_size
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            -
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_FUNCTION
-                  lag
-                  TOK_TABLE_OR_COL
-                     p_size
-                  1
-                  TOK_TABLE_OR_COL
-                     p_size
-                  TOK_WINDOWSPEC
-                     TOK_PARTITIONINGSPEC
-                        TOK_DISTRIBUTEBY
-                           TOK_TABLE_OR_COL
-                              p_mfgr
-                        TOK_ORDERBY
-                           TOK_TABSORTCOLNAMEASC
-                              TOK_NULLS_FIRST
-                                 TOK_TABLE_OR_COL
-                                    p_name
-            deltaSz
-      TOK_GROUPBY
-         TOK_TABLE_OR_COL
-            p_mfgr
-         TOK_TABLE_OR_COL
-            p_name
-         TOK_TABLE_OR_COL
-            p_size
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -2332,50 +1864,6 @@ partition by p_mfgr
 order by p_name 
 ) abc join part_orc p1 on abc.p_partkey = p1.p_partkey
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_JOIN
-         TOK_PTBLFUNCTION
-            noop
-            abc
-            TOK_TABREF
-               TOK_TABNAME
-                  part_orc
-            TOK_PARTITIONINGSPEC
-               TOK_DISTRIBUTEBY
-                  TOK_TABLE_OR_COL
-                     p_mfgr
-               TOK_ORDERBY
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_name
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-            p1
-         =
-            .
-               TOK_TABLE_OR_COL
-                  abc
-               p_partkey
-            .
-               TOK_TABLE_OR_COL
-                  p1
-               p_partkey
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_ALLCOLREF
-               TOK_TABNAME
-                  abc
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -2691,50 +2179,6 @@ partition by p_mfgr
 order by p_name 
 ) abc on abc.p_partkey = p1.p_partkey
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_JOIN
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-            p1
-         TOK_PTBLFUNCTION
-            noop
-            abc
-            TOK_TABREF
-               TOK_TABNAME
-                  part_orc
-            TOK_PARTITIONINGSPEC
-               TOK_DISTRIBUTEBY
-                  TOK_TABLE_OR_COL
-                     p_mfgr
-               TOK_ORDERBY
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_name
-         =
-            .
-               TOK_TABLE_OR_COL
-                  abc
-               p_partkey
-            .
-               TOK_TABLE_OR_COL
-                  p1
-               p_partkey
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_ALLCOLREF
-               TOK_TABNAME
-                  abc
-
-
 STAGE DEPENDENCIES:
   Stage-2 is a root stage
   Stage-1 depends on stages: Stage-2
@@ -3054,62 +2498,6 @@ from noopwithmap(on part_orc
 partition by p_mfgr
 order by p_name, p_size desc)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noopwithmap
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-               TOK_TABSORTCOLNAMEDESC
-                  TOK_NULLS_LAST
-                     TOK_TABLE_OR_COL
-                        p_size
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                        TOK_TABSORTCOLNAMEDESC
-                           TOK_NULLS_LAST
-                              TOK_TABLE_OR_COL
-                                 p_size
-            r
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -3397,88 +2785,6 @@ from noopwithmap(on part_orc
   partition by p_mfgr
   order by p_name)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noopwithmap
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_retailprice
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -3785,88 +3091,6 @@ from noop(on part_orc
 partition by p_mfgr
 order by p_name)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_retailprice
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -4159,96 +3383,6 @@ partition by p_mfgr
 order by p_mfgr, p_name
 )))
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_PTBLFUNCTION
-            noopwithmap
-            TOK_PTBLFUNCTION
-               noop
-               TOK_TABREF
-                  TOK_TABNAME
-                     part_orc
-               TOK_PARTITIONINGSPEC
-                  TOK_DISTRIBUTEBY
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-                  TOK_ORDERBY
-                     TOK_TABSORTCOLNAMEASC
-                        TOK_NULLS_FIRST
-                           TOK_TABLE_OR_COL
-                              p_mfgr
-                     TOK_TABSORTCOLNAMEASC
-                        TOK_NULLS_FIRST
-                           TOK_TABLE_OR_COL
-                              p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_retailprice
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -4658,107 +3792,6 @@ order by p_name)
 window w1 as (partition by p_mfgr order by p_name rows between 2 preceding and 2 following) 
 ) sub1
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_SUBQUERY
-         TOK_QUERY
-            TOK_FROM
-               TOK_PTBLFUNCTION
-                  noop
-                  TOK_TABREF
-                     TOK_TABNAME
-                        part_orc
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            TOK_INSERT
-               TOK_DESTINATION
-                  TOK_DIR
-                     TOK_TMP_FILE
-               TOK_SELECT
-                  TOK_SELEXPR
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-                  TOK_SELEXPR
-                     TOK_TABLE_OR_COL
-                        p_name
-                  TOK_SELEXPR
-                     TOK_FUNCTION
-                        count
-                        TOK_TABLE_OR_COL
-                           p_size
-                        TOK_WINDOWSPEC
-                           TOK_PARTITIONINGSPEC
-                              TOK_DISTRIBUTEBY
-                                 TOK_TABLE_OR_COL
-                                    p_mfgr
-                              TOK_ORDERBY
-                                 TOK_TABSORTCOLNAMEASC
-                                    TOK_NULLS_FIRST
-                                       TOK_TABLE_OR_COL
-                                          p_name
-                     cd
-                  TOK_SELEXPR
-                     TOK_TABLE_OR_COL
-                        p_retailprice
-                  TOK_SELEXPR
-                     TOK_FUNCTION
-                        sum
-                        TOK_TABLE_OR_COL
-                           p_retailprice
-                        TOK_WINDOWSPEC
-                           w1
-                     s1
-               window
-                  TOK_WINDOWDEF
-                     w1
-                     TOK_WINDOWSPEC
-                        TOK_PARTITIONINGSPEC
-                           TOK_DISTRIBUTEBY
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                           TOK_ORDERBY
-                              TOK_TABSORTCOLNAMEASC
-                                 TOK_NULLS_FIRST
-                                    TOK_TABLE_OR_COL
-                                       p_name
-                        TOK_WINDOWRANGE
-                           preceding
-                              2
-                           following
-                              2
-         sub1
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  sub1
-               cd
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  sub1
-               s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -5055,182 +4088,6 @@ partition by p_mfgr
 order by p_name 
 ) abc join part_orc p1 on abc.p_partkey = p1.p_partkey
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_JOIN
-         TOK_PTBLFUNCTION
-            noop
-            abc
-            TOK_TABREF
-               TOK_TABNAME
-                  part_orc
-            TOK_PARTITIONINGSPEC
-               TOK_DISTRIBUTEBY
-                  TOK_TABLE_OR_COL
-                     p_mfgr
-               TOK_ORDERBY
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_name
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-            p1
-         =
-            .
-               TOK_TABLE_OR_COL
-                  abc
-               p_partkey
-            .
-               TOK_TABLE_OR_COL
-                  p1
-               p_partkey
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  abc
-               p_mfgr
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  abc
-               p_name
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        .
-                           TOK_TABLE_OR_COL
-                              abc
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              .
-                                 TOK_TABLE_OR_COL
-                                    abc
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        .
-                           TOK_TABLE_OR_COL
-                              abc
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              .
-                                 TOK_TABLE_OR_COL
-                                    abc
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_FUNCTION
-               count
-               .
-                  TOK_TABLE_OR_COL
-                     abc
-                  p_name
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        .
-                           TOK_TABLE_OR_COL
-                              abc
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              .
-                                 TOK_TABLE_OR_COL
-                                    abc
-                                 p_name
-            cd
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  abc
-               p_retailprice
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               .
-                  TOK_TABLE_OR_COL
-                     abc
-                  p_retailprice
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        .
-                           TOK_TABLE_OR_COL
-                              abc
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              .
-                                 TOK_TABLE_OR_COL
-                                    abc
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  abc
-               p_size
-         TOK_SELEXPR
-            -
-               .
-                  TOK_TABLE_OR_COL
-                     abc
-                  p_size
-               TOK_FUNCTION
-                  lag
-                  .
-                     TOK_TABLE_OR_COL
-                        abc
-                     p_size
-                  1
-                  .
-                     TOK_TABLE_OR_COL
-                        abc
-                     p_size
-                  TOK_WINDOWSPEC
-                     TOK_PARTITIONINGSPEC
-                        TOK_DISTRIBUTEBY
-                           .
-                              TOK_TABLE_OR_COL
-                                 abc
-                              p_mfgr
-                        TOK_SORTBY
-                           TOK_TABSORTCOLNAMEASC
-                              TOK_NULLS_FIRST
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       abc
-                                    p_name
-            deltaSz
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -5669,40 +4526,6 @@ from noop(on part_orc
 partition by p_mfgr 
 order by p_name)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECTDI
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -5971,65 +4794,6 @@ partition by p_mfgr
 order by p_mfgr)  
 window w1 as ( partition by p_mfgr order by p_brand rows between 2 preceding and current row)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_TABREF
-            TOK_TABNAME
-               mfgr_price_view
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_brand
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               s
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  s
-               TOK_WINDOWSPEC
-                  w1
-            s1
-      window
-         TOK_WINDOWDEF
-            w1
-            TOK_WINDOWSPEC
-               TOK_PARTITIONINGSPEC
-                  TOK_DISTRIBUTEBY
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-                  TOK_ORDERBY
-                     TOK_TABSORTCOLNAMEASC
-                        TOK_NULLS_FIRST
-                           TOK_TABLE_OR_COL
-                              p_brand
-               TOK_WINDOWRANGE
-                  preceding
-                     2
-                  current
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -6364,212 +5128,6 @@ cume_dist() over (distribute by p_mfgr sort by p_mfgr, p_name) as cud,
 first_value(p_size, true) over w1  as fv1
 window w1 as (distribute by p_mfgr sort by p_mfgr, p_name rows between 2 preceding and 2 following)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_TABREF
-            TOK_TABNAME
-               part_orc
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_TAB
-            TOK_TABNAME
-               part_4
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_retailprice
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_TAB
-            TOK_TABNAME
-               part_5
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               round
-               TOK_FUNCTION
-                  sum
-                  TOK_TABLE_OR_COL
-                     p_size
-                  TOK_WINDOWSPEC
-                     TOK_PARTITIONINGSPEC
-                        TOK_DISTRIBUTEBY
-                           TOK_TABLE_OR_COL
-                              p_mfgr
-                        TOK_SORTBY
-                           TOK_TABSORTCOLNAMEASC
-                              TOK_NULLS_FIRST
-                                 TOK_TABLE_OR_COL
-                                    p_size
-                     TOK_WINDOWVALUES
-                        preceding
-                           5
-                        current
-               1
-            s2
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_FUNCTION
-               cume_dist
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_SORTBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            cud
-         TOK_SELEXPR
-            TOK_FUNCTION
-               first_value
-               TOK_TABLE_OR_COL
-                  p_size
-               true
-               TOK_WINDOWSPEC
-                  w1
-            fv1
-      window
-         TOK_WINDOWDEF
-            w1
-            TOK_WINDOWSPEC
-               TOK_PARTITIONINGSPEC
-                  TOK_DISTRIBUTEBY
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-                  TOK_SORTBY
-                     TOK_TABSORTCOLNAMEASC
-                        TOK_NULLS_FIRST
-                           TOK_TABLE_OR_COL
-                              p_mfgr
-                     TOK_TABSORTCOLNAMEASC
-                        TOK_NULLS_FIRST
-                           TOK_TABLE_OR_COL
-                              p_name
-               TOK_WINDOWRANGE
-                  preceding
-                     2
-                  following
-                     2
-
-
 STAGE DEPENDENCIES:
   Stage-2 is a root stage
   Stage-3 depends on stages: Stage-2
@@ -7224,115 +5782,6 @@ from noop(on
         partition by p_mfgr,p_name  
         order by p_mfgr,p_name)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_PTBLFUNCTION
-            noopwithmap
-            TOK_PTBLFUNCTION
-               noop
-               TOK_PTBLFUNCTION
-                  noop
-                  TOK_TABREF
-                     TOK_TABNAME
-                        part_orc
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-            TOK_PARTITIONINGSPEC
-               TOK_DISTRIBUTEBY
-                  TOK_TABLE_OR_COL
-                     p_mfgr
-                  TOK_TABLE_OR_COL
-                     p_name
-               TOK_ORDERBY
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_name
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-               TOK_TABLE_OR_COL
-                  p_name
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-            dr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -7771,118 +6220,6 @@ from noop(on
         partition by p_mfgr  
         order by p_mfgr )
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_PTBLFUNCTION
-            noop
-            TOK_PTBLFUNCTION
-               noop
-               TOK_PTBLFUNCTION
-                  noop
-                  TOK_TABREF
-                     TOK_TABNAME
-                        part_orc
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-            TOK_PARTITIONINGSPEC
-               TOK_DISTRIBUTEBY
-                  TOK_TABLE_OR_COL
-                     p_mfgr
-                  TOK_TABLE_OR_COL
-                     p_name
-               TOK_ORDERBY
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_name
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -8364,105 +6701,6 @@ from noop(on
           partition by p_mfgr 
           order by p_mfgr))
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_PTBLFUNCTION
-            noop
-            TOK_PTBLFUNCTION
-               noop
-               TOK_PTBLFUNCTION
-                  noop
-                  TOK_TABREF
-                     TOK_TABNAME
-                        part_orc
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            TOK_PARTITIONINGSPEC
-               TOK_DISTRIBUTEBY
-                  TOK_TABLE_OR_COL
-                     p_mfgr
-               TOK_ORDERBY
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -8873,115 +7111,6 @@ from noopwithmap(on
           partition by p_mfgr,p_name 
           order by p_mfgr,p_name)
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noopwithmap
-         TOK_PTBLFUNCTION
-            noop
-            TOK_PTBLFUNCTION
-               noop
-               TOK_PTBLFUNCTION
-                  noop
-                  TOK_TABREF
-                     TOK_TABNAME
-                        part_orc
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            TOK_PARTITIONINGSPEC
-               TOK_DISTRIBUTEBY
-                  TOK_TABLE_OR_COL
-                     p_mfgr
-               TOK_ORDERBY
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-         TOK_PARTITIONINGSPEC
-            TOK_DISTRIBUTEBY
-               TOK_TABLE_OR_COL
-                  p_mfgr
-               TOK_TABLE_OR_COL
-                  p_name
-            TOK_ORDERBY
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-               TOK_TABSORTCOLNAMEASC
-                  TOK_NULLS_FIRST
-                     TOK_TABLE_OR_COL
-                        p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-            dr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -9482,151 +7611,6 @@ from noop(on
           order by p_mfgr
           ))
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noop
-         TOK_PTBLFUNCTION
-            noopwithmap
-            TOK_PTBLFUNCTION
-               noop
-               TOK_TABREF
-                  TOK_TABNAME
-                     part_orc
-               TOK_PARTITIONINGSPEC
-                  TOK_DISTRIBUTEBY
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-                     TOK_TABLE_OR_COL
-                        p_name
-                  TOK_ORDERBY
-                     TOK_TABSORTCOLNAMEASC
-                        TOK_NULLS_FIRST
-                           TOK_TABLE_OR_COL
-                              p_mfgr
-                     TOK_TABSORTCOLNAMEASC
-                        TOK_NULLS_FIRST
-                           TOK_TABLE_OR_COL
-                              p_name
-            TOK_PARTITIONINGSPEC
-               TOK_DISTRIBUTEBY
-                  TOK_TABLE_OR_COL
-                     p_mfgr
-               TOK_ORDERBY
-                  TOK_TABSORTCOLNAMEASC
-                     TOK_NULLS_FIRST
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s1
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                        TOK_TABLE_OR_COL
-                           p_name
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_mfgr
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWRANGE
-                     preceding
-                        unbounded
-                     current
-            s2
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -10050,118 +8034,6 @@ from noopwithmap(on
               order by p_mfgr, p_name) 
           ))
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_PTBLFUNCTION
-         noopwithmap
-         TOK_PTBLFUNCTION
-            noop
-            TOK_PTBLFUNCTION
-               noop
-               TOK_TABREF
-                  TOK_TABNAME
-                     part_orc
-               TOK_PARTITIONINGSPEC
-                  TOK_DISTRIBUTEBY
-                     TOK_TABLE_OR_COL
-                        p_mfgr
-                     TOK_TABLE_OR_COL
-                        p_name
-                  TOK_ORDERBY
-                     TOK_TABSORTCOLNAMEASC
-                        TOK_NULLS_FIRST
-                           TOK_TABLE_OR_COL
-                              p_mfgr
-                     TOK_TABSORTCOLNAMEASC
-                        TOK_NULLS_FIRST
-                           TOK_TABLE_OR_COL
-                              p_name
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_mfgr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_name
-         TOK_SELEXPR
-            TOK_FUNCTION
-               rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            r
-         TOK_SELEXPR
-            TOK_FUNCTION
-               dense_rank
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-            dr
-         TOK_SELEXPR
-            TOK_TABLE_OR_COL
-               p_size
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWVALUES
-                     preceding
-                        unbounded
-                     current
-            s1
-         TOK_SELEXPR
-            TOK_FUNCTION
-               sum
-               TOK_TABLE_OR_COL
-                  p_size
-               TOK_WINDOWSPEC
-                  TOK_PARTITIONINGSPEC
-                     TOK_DISTRIBUTEBY
-                        TOK_TABLE_OR_COL
-                           p_mfgr
-                     TOK_ORDERBY
-                        TOK_TABSORTCOLNAMEASC
-                           TOK_NULLS_FIRST
-                              TOK_TABLE_OR_COL
-                                 p_name
-                  TOK_WINDOWVALUES
-                     preceding
-                        unbounded
-                     current
-            s2
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1


Mime
View raw message