http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out
----------------------------------------------------------------------
diff --git 
a/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out 
b/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out
index 180bcc6..3e3b08c 100644
--- a/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out
+++ b/ql/src/test/results/clientpositive/tez/tez_join_result_complex.q.out
@@ -148,271 +148,6 @@ inner join
 service_request_clean b
 on a.contact_event_id = b.cnctevn_id
 POSTHOOK: type: CREATETABLE_AS_SELECT
-ABSTRACT SYNTAX TREE:
-  
-TOK_CREATETABLE
-   TOK_TABNAME
-      ct_events1_test
-   TOK_LIKETABLE
-   TOK_QUERY
-      TOK_FROM
-         TOK_JOIN
-            TOK_SUBQUERY
-               TOK_QUERY
-                  TOK_FROM
-                     TOK_TABREF
-                        TOK_TABNAME
-                           default
-                           ct_events_clean
-                        a
-                  TOK_INSERT
-                     TOK_DESTINATION
-                        TOK_DIR
-                           TOK_TMP_FILE
-                     TOK_SELECT
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              contact_event_id
-                           contact_event_id
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              ce_create_dt
-                           ce_create_dt
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              ce_end_dt
-                           ce_end_dt
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              contact_type
-                           contact_type
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              cnctevs_cd
-                           cnctevs_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              contact_mode
-                           contact_mode
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              cntvnst_stts_cd
-                           cntvnst_stts_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              total_transfers
-                           total_transfers
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              ce_notes
-                           ce_notes
-                     TOK_WHERE
-                        TOK_FUNCTION
-                           TOK_ISNOTNULL
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              contact_event_id
-               $hdt$_0
-            TOK_SUBQUERY
-               TOK_QUERY
-                  TOK_FROM
-                     TOK_TABREF
-                        TOK_TABNAME
-                           default
-                           service_request_clean
-                        b
-                  TOK_INSERT
-                     TOK_DESTINATION
-                        TOK_DIR
-                           TOK_TMP_FILE
-                     TOK_SELECT
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              cnctevn_id
-                           cnctevn_id
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              svcrqst_id
-                           svcrqst_id
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              cnctmd_cd
-                           cnctmd_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              svcrtyp_cd
-                           svcrtyp_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              cmpltyp_cd
-                           cmpltyp_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              sum_reason_cd
-                           sum_reason_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              svcrqct_cds
-                           svcrqct_cds
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              notes
-                           notes
-                     TOK_WHERE
-                        TOK_FUNCTION
-                           TOK_ISNOTNULL
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              cnctevn_id
-               $hdt$_1
-            =
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  contact_event_id
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  cnctevn_id
-      TOK_INSERT
-         TOK_DESTINATION
-            TOK_DIR
-               TOK_TMP_FILE
-         TOK_SELECT
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  contact_event_id
-               a.contact_event_id
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  ce_create_dt
-               a.ce_create_dt
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  ce_end_dt
-               a.ce_end_dt
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  contact_type
-               a.contact_type
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  cnctevs_cd
-               a.cnctevs_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  contact_mode
-               a.contact_mode
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  cntvnst_stts_cd
-               a.cntvnst_stts_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  total_transfers
-               a.total_transfers
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  ce_notes
-               a.ce_notes
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  svcrqst_id
-               b.svcrqst_id
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  svcrqct_cds
-               b.svcrqct_cds
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  svcrtyp_cd
-               b.svcrtyp_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  cmpltyp_cd
-               b.cmpltyp_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  sum_reason_cd
-               src
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  cnctmd_cd
-               b.cnctmd_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  notes
-               b.notes
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -1385,271 +1120,6 @@ inner join
 service_request_clean b
 on a.contact_event_id = b.cnctevn_id
 POSTHOOK: type: CREATETABLE_AS_SELECT
-ABSTRACT SYNTAX TREE:
-  
-TOK_CREATETABLE
-   TOK_TABNAME
-      ct_events1_test
-   TOK_LIKETABLE
-   TOK_QUERY
-      TOK_FROM
-         TOK_JOIN
-            TOK_SUBQUERY
-               TOK_QUERY
-                  TOK_FROM
-                     TOK_TABREF
-                        TOK_TABNAME
-                           default
-                           ct_events_clean
-                        a
-                  TOK_INSERT
-                     TOK_DESTINATION
-                        TOK_DIR
-                           TOK_TMP_FILE
-                     TOK_SELECT
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              contact_event_id
-                           contact_event_id
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              ce_create_dt
-                           ce_create_dt
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              ce_end_dt
-                           ce_end_dt
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              contact_type
-                           contact_type
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              cnctevs_cd
-                           cnctevs_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              contact_mode
-                           contact_mode
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              cntvnst_stts_cd
-                           cntvnst_stts_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              total_transfers
-                           total_transfers
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              ce_notes
-                           ce_notes
-                     TOK_WHERE
-                        TOK_FUNCTION
-                           TOK_ISNOTNULL
-                           .
-                              TOK_TABLE_OR_COL
-                                 a
-                              contact_event_id
-               $hdt$_0
-            TOK_SUBQUERY
-               TOK_QUERY
-                  TOK_FROM
-                     TOK_TABREF
-                        TOK_TABNAME
-                           default
-                           service_request_clean
-                        b
-                  TOK_INSERT
-                     TOK_DESTINATION
-                        TOK_DIR
-                           TOK_TMP_FILE
-                     TOK_SELECT
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              cnctevn_id
-                           cnctevn_id
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              svcrqst_id
-                           svcrqst_id
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              cnctmd_cd
-                           cnctmd_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              svcrtyp_cd
-                           svcrtyp_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              cmpltyp_cd
-                           cmpltyp_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              sum_reason_cd
-                           sum_reason_cd
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              svcrqct_cds
-                           svcrqct_cds
-                        TOK_SELEXPR
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              notes
-                           notes
-                     TOK_WHERE
-                        TOK_FUNCTION
-                           TOK_ISNOTNULL
-                           .
-                              TOK_TABLE_OR_COL
-                                 b
-                              cnctevn_id
-               $hdt$_1
-            =
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  contact_event_id
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  cnctevn_id
-      TOK_INSERT
-         TOK_DESTINATION
-            TOK_DIR
-               TOK_TMP_FILE
-         TOK_SELECT
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  contact_event_id
-               a.contact_event_id
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  ce_create_dt
-               a.ce_create_dt
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  ce_end_dt
-               a.ce_end_dt
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  contact_type
-               a.contact_type
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  cnctevs_cd
-               a.cnctevs_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  contact_mode
-               a.contact_mode
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  cntvnst_stts_cd
-               a.cntvnst_stts_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  total_transfers
-               a.total_transfers
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_0
-                  ce_notes
-               a.ce_notes
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  svcrqst_id
-               b.svcrqst_id
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  svcrqct_cds
-               b.svcrqct_cds
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  svcrtyp_cd
-               b.svcrtyp_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  cmpltyp_cd
-               b.cmpltyp_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  sum_reason_cd
-               src
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  cnctmd_cd
-               b.cnctmd_cd
-            TOK_SELEXPR
-               .
-                  TOK_TABLE_OR_COL
-                     $hdt$_1
-                  notes
-               b.notes
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1

http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/tez/transform_ppr1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/transform_ppr1.q.out 
b/ql/src/test/results/clientpositive/tez/transform_ppr1.q.out
index 92d1f4c..5d7374f 100644
--- a/ql/src/test/results/clientpositive/tez/transform_ppr1.q.out
+++ b/ql/src/test/results/clientpositive/tez/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/tez/transform_ppr2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/transform_ppr2.q.out 
b/ql/src/test/results/clientpositive/tez/transform_ppr2.q.out
index c131bbe..4d74124 100644
--- a/ql/src/test/results/clientpositive/tez/transform_ppr2.q.out
+++ b/ql/src/test/results/clientpositive/tez/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/tez/unionDistinct_1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out 
b/ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out
index bef2365..ee33086 100644
--- a/ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out
+++ b/ql/src/test/results/clientpositive/tez/unionDistinct_1.q.out
@@ -6456,157 +6456,6 @@ where a.k1 > 20
 )
 subq
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_SUBQUERY
-         TOK_QUERY
-            TOK_FROM
-               TOK_SUBQUERY
-                  TOK_UNIONALL
-                     TOK_QUERY
-                        TOK_FROM
-                           TOK_TABREF
-                              TOK_TABNAME
-                                 dst_union22_delta
-                        TOK_INSERT
-                           TOK_DESTINATION
-                              TOK_DIR
-                                 TOK_TMP_FILE
-                           TOK_SELECT
-                              TOK_SELEXPR
-                                 TOK_TABLE_OR_COL
-                                    k1
-                                 k1
-                              TOK_SELEXPR
-                                 TOK_TABLE_OR_COL
-                                    k2
-                                 k2
-                              TOK_SELEXPR
-                                 TOK_TABLE_OR_COL
-                                    k3
-                                 k3
-                              TOK_SELEXPR
-                                 TOK_TABLE_OR_COL
-                                    k4
-                                 k4
-                           TOK_WHERE
-                              and
-                                 =
-                                    TOK_TABLE_OR_COL
-                                       ds
-                                    '1'
-                                 <=
-                                    TOK_TABLE_OR_COL
-                                       k0
-                                    50
-                     TOK_QUERY
-                        TOK_FROM
-                           TOK_LEFTOUTERJOIN
-                              TOK_TABREF
-                                 TOK_TABNAME
-                                    dst_union22
-                                 a
-                              TOK_SUBQUERY
-                                 TOK_QUERY
-                                    TOK_FROM
-                                       TOK_TABREF
-                                          TOK_TABNAME
-                                             dst_union22_delta
-                                    TOK_INSERT
-                                       TOK_DESTINATION
-                                          TOK_DIR
-                                             TOK_TMP_FILE
-                                       TOK_SELECT
-                                          TOK_SELEXPR
-                                             TOK_ALLCOLREF
-                                       TOK_WHERE
-                                          and
-                                             =
-                                                TOK_TABLE_OR_COL
-                                                   ds
-                                                '1'
-                                             >
-                                                TOK_TABLE_OR_COL
-                                                   k0
-                                                50
-                                 b
-                              and
-                                 =
-                                    .
-                                       TOK_TABLE_OR_COL
-                                          a
-                                       k1
-                                    .
-                                       TOK_TABLE_OR_COL
-                                          b
-                                       k1
-                                 =
-                                    .
-                                       TOK_TABLE_OR_COL
-                                          a
-                                       ds
-                                    '1'
-                        TOK_INSERT
-                           TOK_DESTINATION
-                              TOK_DIR
-                                 TOK_TMP_FILE
-                           TOK_SELECT
-                              TOK_SELEXPR
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       a
-                                    k1
-                                 k1
-                              TOK_SELEXPR
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       a
-                                    k2
-                                 k2
-                              TOK_SELEXPR
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       b
-                                    k3
-                                 k3
-                              TOK_SELEXPR
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       b
-                                    k4
-                                 k4
-                           TOK_WHERE
-                              >
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       a
-                                    k1
-                                 20
-                  _u1
-            TOK_INSERT
-               TOK_DESTINATION
-                  TOK_DIR
-                     TOK_TMP_FILE
-               TOK_SELECTDI
-                  TOK_SELEXPR
-                     TOK_ALLCOLREF
-         subq
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_TAB
-            TOK_TABNAME
-               dst_union22
-            TOK_PARTSPEC
-               TOK_PARTVAL
-                  ds
-                  '2'
-      TOK_SELECT
-         TOK_SELEXPR
-            TOK_ALLCOLREF
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-2 depends on stages: Stage-1
@@ -7838,154 +7687,6 @@ select s.key, s.count from (
   select key, count(1) as count from src5 where key < 10 group by key
 )s
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_SUBQUERY
-         TOK_QUERY
-            TOK_FROM
-               TOK_SUBQUERY
-                  TOK_UNIONALL
-                     TOK_QUERY
-                        TOK_FROM
-                           TOK_SUBQUERY
-                              TOK_UNIONALL
-                                 TOK_QUERY
-                                    TOK_FROM
-                                       TOK_SUBQUERY
-                                          TOK_UNIONALL
-                                             TOK_QUERY
-                                                TOK_FROM
-                                                   TOK_TABREF
-                                                      TOK_TABNAME
-                                                         src2
-                                                TOK_INSERT
-                                                   TOK_DESTINATION
-                                                      TOK_DIR
-                                                         TOK_TMP_FILE
-                                                   TOK_SELECT
-                                                      TOK_SELEXPR
-                                                         TOK_TABLE_OR_COL
-                                                            key
-                                                      TOK_SELEXPR
-                                                         TOK_TABLE_OR_COL
-                                                            count
-                                                   TOK_WHERE
-                                                      <
-                                                         TOK_TABLE_OR_COL
-                                                            key
-                                                         10
-                                             TOK_QUERY
-                                                TOK_FROM
-                                                   TOK_TABREF
-                                                      TOK_TABNAME
-                                                         src3
-                                                TOK_INSERT
-                                                   TOK_DESTINATION
-                                                      TOK_DIR
-                                                         TOK_TMP_FILE
-                                                   TOK_SELECT
-                                                      TOK_SELEXPR
-                                                         TOK_TABLE_OR_COL
-                                                            key
-                                                      TOK_SELEXPR
-                                                         TOK_TABLE_OR_COL
-                                                            count
-                                                   TOK_WHERE
-                                                      <
-                                                         TOK_TABLE_OR_COL
-                                                            key
-                                                         10
-                                          _u1
-                                    TOK_INSERT
-                                       TOK_DESTINATION
-                                          TOK_DIR
-                                             TOK_TMP_FILE
-                                       TOK_SELECTDI
-                                          TOK_SELEXPR
-                                             TOK_ALLCOLREF
-                                 TOK_QUERY
-                                    TOK_FROM
-                                       TOK_TABREF
-                                          TOK_TABNAME
-                                             src4
-                                    TOK_INSERT
-                                       TOK_DESTINATION
-                                          TOK_DIR
-                                             TOK_TMP_FILE
-                                       TOK_SELECT
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                key
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                count
-                                       TOK_WHERE
-                                          <
-                                             TOK_TABLE_OR_COL
-                                                key
-                                             10
-                              _u2
-                        TOK_INSERT
-                           TOK_DESTINATION
-                              TOK_DIR
-                                 TOK_TMP_FILE
-                           TOK_SELECTDI
-                              TOK_SELEXPR
-                                 TOK_ALLCOLREF
-                     TOK_QUERY
-                        TOK_FROM
-                           TOK_TABREF
-                              TOK_TABNAME
-                                 src5
-                        TOK_INSERT
-                           TOK_DESTINATION
-                              TOK_DIR
-                                 TOK_TMP_FILE
-                           TOK_SELECT
-                              TOK_SELEXPR
-                                 TOK_TABLE_OR_COL
-                                    key
-                              TOK_SELEXPR
-                                 TOK_FUNCTION
-                                    count
-                                    1
-                                 count
-                           TOK_WHERE
-                              <
-                                 TOK_TABLE_OR_COL
-                                    key
-                                 10
-                           TOK_GROUPBY
-                              TOK_TABLE_OR_COL
-                                 key
-                  _u3
-            TOK_INSERT
-               TOK_DESTINATION
-                  TOK_DIR
-                     TOK_TMP_FILE
-               TOK_SELECTDI
-                  TOK_SELEXPR
-                     TOK_ALLCOLREF
-         s
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  s
-               key
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  s
-               count
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-0 depends on stages: Stage-1
@@ -8473,139 +8174,6 @@ select s.key, s.count from (
   select a.key as key, b.count as count from src4 a join src5 b on a.key=b.key 
where a.key < 10
 )s
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_SUBQUERY
-         TOK_QUERY
-            TOK_FROM
-               TOK_SUBQUERY
-                  TOK_UNIONALL
-                     TOK_QUERY
-                        TOK_FROM
-                           TOK_SUBQUERY
-                              TOK_UNIONALL
-                                 TOK_QUERY
-                                    TOK_FROM
-                                       TOK_TABREF
-                                          TOK_TABNAME
-                                             src2
-                                    TOK_INSERT
-                                       TOK_DESTINATION
-                                          TOK_DIR
-                                             TOK_TMP_FILE
-                                       TOK_SELECT
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                key
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                count
-                                       TOK_WHERE
-                                          <
-                                             TOK_TABLE_OR_COL
-                                                key
-                                             10
-                                 TOK_QUERY
-                                    TOK_FROM
-                                       TOK_TABREF
-                                          TOK_TABNAME
-                                             src3
-                                    TOK_INSERT
-                                       TOK_DESTINATION
-                                          TOK_DIR
-                                             TOK_TMP_FILE
-                                       TOK_SELECT
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                key
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                count
-                                       TOK_WHERE
-                                          <
-                                             TOK_TABLE_OR_COL
-                                                key
-                                             10
-                              _u1
-                        TOK_INSERT
-                           TOK_DESTINATION
-                              TOK_DIR
-                                 TOK_TMP_FILE
-                           TOK_SELECTDI
-                              TOK_SELEXPR
-                                 TOK_ALLCOLREF
-                     TOK_QUERY
-                        TOK_FROM
-                           TOK_JOIN
-                              TOK_TABREF
-                                 TOK_TABNAME
-                                    src4
-                                 a
-                              TOK_TABREF
-                                 TOK_TABNAME
-                                    src5
-                                 b
-                              =
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       a
-                                    key
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       b
-                                    key
-                        TOK_INSERT
-                           TOK_DESTINATION
-                              TOK_DIR
-                                 TOK_TMP_FILE
-                           TOK_SELECT
-                              TOK_SELEXPR
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       a
-                                    key
-                                 key
-                              TOK_SELEXPR
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       b
-                                    count
-                                 count
-                           TOK_WHERE
-                              <
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       a
-                                    key
-                                 10
-                  _u2
-            TOK_INSERT
-               TOK_DESTINATION
-                  TOK_DIR
-                     TOK_TMP_FILE
-               TOK_SELECTDI
-                  TOK_SELEXPR
-                     TOK_ALLCOLREF
-         s
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  s
-               key
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  s
-               count
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-0 depends on stages: Stage-1
@@ -9051,143 +8619,6 @@ select s.key, s.count from (
   select a.key as key, count(1) as count from src4 a join src5 b on 
a.key=b.key where a.key < 10 group by a.key
 )s
 POSTHOOK: type: QUERY
-ABSTRACT SYNTAX TREE:
-  
-TOK_QUERY
-   TOK_FROM
-      TOK_SUBQUERY
-         TOK_QUERY
-            TOK_FROM
-               TOK_SUBQUERY
-                  TOK_UNIONALL
-                     TOK_QUERY
-                        TOK_FROM
-                           TOK_SUBQUERY
-                              TOK_UNIONALL
-                                 TOK_QUERY
-                                    TOK_FROM
-                                       TOK_TABREF
-                                          TOK_TABNAME
-                                             src2
-                                    TOK_INSERT
-                                       TOK_DESTINATION
-                                          TOK_DIR
-                                             TOK_TMP_FILE
-                                       TOK_SELECT
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                key
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                count
-                                       TOK_WHERE
-                                          <
-                                             TOK_TABLE_OR_COL
-                                                key
-                                             10
-                                 TOK_QUERY
-                                    TOK_FROM
-                                       TOK_TABREF
-                                          TOK_TABNAME
-                                             src3
-                                    TOK_INSERT
-                                       TOK_DESTINATION
-                                          TOK_DIR
-                                             TOK_TMP_FILE
-                                       TOK_SELECT
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                key
-                                          TOK_SELEXPR
-                                             TOK_TABLE_OR_COL
-                                                count
-                                       TOK_WHERE
-                                          <
-                                             TOK_TABLE_OR_COL
-                                                key
-                                             10
-                              _u1
-                        TOK_INSERT
-                           TOK_DESTINATION
-                              TOK_DIR
-                                 TOK_TMP_FILE
-                           TOK_SELECTDI
-                              TOK_SELEXPR
-                                 TOK_ALLCOLREF
-                     TOK_QUERY
-                        TOK_FROM
-                           TOK_JOIN
-                              TOK_TABREF
-                                 TOK_TABNAME
-                                    src4
-                                 a
-                              TOK_TABREF
-                                 TOK_TABNAME
-                                    src5
-                                 b
-                              =
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       a
-                                    key
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       b
-                                    key
-                        TOK_INSERT
-                           TOK_DESTINATION
-                              TOK_DIR
-                                 TOK_TMP_FILE
-                           TOK_SELECT
-                              TOK_SELEXPR
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       a
-                                    key
-                                 key
-                              TOK_SELEXPR
-                                 TOK_FUNCTION
-                                    count
-                                    1
-                                 count
-                           TOK_WHERE
-                              <
-                                 .
-                                    TOK_TABLE_OR_COL
-                                       a
-                                    key
-                                 10
-                           TOK_GROUPBY
-                              .
-                                 TOK_TABLE_OR_COL
-                                    a
-                                 key
-                  _u2
-            TOK_INSERT
-               TOK_DESTINATION
-                  TOK_DIR
-                     TOK_TMP_FILE
-               TOK_SELECTDI
-                  TOK_SELEXPR
-                     TOK_ALLCOLREF
-         s
-   TOK_INSERT
-      TOK_DESTINATION
-         TOK_DIR
-            TOK_TMP_FILE
-      TOK_SELECT
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  s
-               key
-         TOK_SELEXPR
-            .
-               TOK_TABLE_OR_COL
-                  s
-               count
-
-
 STAGE DEPENDENCIES:
   Stage-1 is a root stage
   Stage-0 depends on stages: Stage-1

Reply via email to