You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2016/04/25 17:05:26 UTC
[04/18] hive git commit: HIVE-13533: Remove AST dump (Jesus Camacho
Rodriguez, reviewed by Ashutosh Chauhan)
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