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
