Return-Path: X-Original-To: apmail-hive-commits-archive@www.apache.org Delivered-To: apmail-hive-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 71F25190CD for ; Tue, 26 Apr 2016 17:53:30 +0000 (UTC) Received: (qmail 46993 invoked by uid 500); 26 Apr 2016 17:53:26 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 46777 invoked by uid 500); 26 Apr 2016 17:53:26 -0000 Mailing-List: contact commits-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: hive-dev@hive.apache.org Delivered-To: mailing list commits@hive.apache.org Received: (qmail 44977 invoked by uid 99); 26 Apr 2016 17:53:25 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 26 Apr 2016 17:53:25 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id C3D5CEAB69; Tue, 26 Apr 2016 17:53:24 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: jdere@apache.org To: commits@hive.apache.org Date: Tue, 26 Apr 2016 17:53:45 -0000 Message-Id: <42bc06a3da5d4779a605a937047f234e@git.apache.org> In-Reply-To: <4f875a4f822f48cda09f9fc6c04c18b6@git.apache.org> References: <4f875a4f822f48cda09f9fc6c04c18b6@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [22/50] [abbrv] 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/llap/tez_join_result_complex.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out b/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out index 440466c..6ca9ea6 100644 --- a/ql/src/test/results/clientpositive/llap/tez_join_result_complex.q.out +++ b/ql/src/test/results/clientpositive/llap/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 @@ -1389,271 +1124,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/load_dyn_part8.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/load_dyn_part8.q.out b/ql/src/test/results/clientpositive/load_dyn_part8.q.out index 84ccb75..757e7dd 100644 --- a/ql/src/test/results/clientpositive/load_dyn_part8.q.out +++ b/ql/src/test/results/clientpositive/load_dyn_part8.q.out @@ -48,69 +48,6 @@ from srcpart insert overwrite table nzhang_part8 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08' insert overwrite table nzhang_part8 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08' POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_TAB - TOK_TABNAME - nzhang_part8 - TOK_PARTSPEC - TOK_PARTVAL - ds - TOK_PARTVAL - hr - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - key - TOK_SELEXPR - TOK_TABLE_OR_COL - value - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_WHERE - <= - TOK_TABLE_OR_COL - ds - '2008-04-08' - TOK_INSERT - TOK_DESTINATION - TOK_TAB - TOK_TABNAME - nzhang_part8 - TOK_PARTSPEC - TOK_PARTVAL - ds - '2008-12-31' - TOK_PARTVAL - hr - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - key - TOK_SELEXPR - TOK_TABLE_OR_COL - value - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_WHERE - > - TOK_TABLE_OR_COL - ds - '2008-04-08' - - STAGE DEPENDENCIES: Stage-2 is a root stage Stage-0 depends on stages: Stage-2 http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/louter_join_ppr.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/louter_join_ppr.q.out b/ql/src/test/results/clientpositive/louter_join_ppr.q.out index d994b95..fd127ec 100644 --- a/ql/src/test/results/clientpositive/louter_join_ppr.q.out +++ b/ql/src/test/results/clientpositive/louter_join_ppr.q.out @@ -20,90 +20,6 @@ EXPLAIN EXTENDED SELECT a.key, a.value, b.key, b.value WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_LEFTOUTERJOIN - TOK_TABREF - TOK_TABNAME - src - a - TOK_TABREF - TOK_TABNAME - srcpart - b - AND - = - . - TOK_TABLE_OR_COL - a - key - . - TOK_TABLE_OR_COL - b - key - = - . - TOK_TABLE_OR_COL - b - ds - '2008-04-08' - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - a - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - a - value - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - value - TOK_WHERE - AND - AND - AND - > - . - TOK_TABLE_OR_COL - a - key - 10 - < - . - TOK_TABLE_OR_COL - a - key - 20 - > - . - TOK_TABLE_OR_COL - b - key - 15 - < - . - TOK_TABLE_OR_COL - b - key - 25 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -396,90 +312,6 @@ POSTHOOK: query: EXPLAIN EXTENDED SELECT a.key, a.value, b.key, b.value WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_LEFTOUTERJOIN - TOK_TABREF - TOK_TABNAME - srcpart - a - TOK_TABREF - TOK_TABNAME - src - b - AND - = - . - TOK_TABLE_OR_COL - a - key - . - TOK_TABLE_OR_COL - b - key - = - . - TOK_TABLE_OR_COL - a - ds - '2008-04-08' - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - a - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - a - value - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - value - TOK_WHERE - AND - AND - AND - > - . - TOK_TABLE_OR_COL - a - key - 10 - < - . - TOK_TABLE_OR_COL - a - key - 20 - > - . - TOK_TABLE_OR_COL - b - key - 15 - < - . - TOK_TABLE_OR_COL - b - key - 25 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -879,90 +711,6 @@ POSTHOOK: query: EXPLAIN EXTENDED SELECT a.key, a.value, b.key, b.value WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08' POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_LEFTOUTERJOIN - TOK_TABREF - TOK_TABNAME - src - a - TOK_TABREF - TOK_TABNAME - srcpart - 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 - TOK_SELEXPR - . - TOK_TABLE_OR_COL - a - value - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - value - TOK_WHERE - AND - AND - AND - AND - > - . - TOK_TABLE_OR_COL - a - key - 10 - < - . - TOK_TABLE_OR_COL - a - key - 20 - > - . - TOK_TABLE_OR_COL - b - key - 15 - < - . - TOK_TABLE_OR_COL - b - key - 25 - = - . - TOK_TABLE_OR_COL - b - ds - '2008-04-08' - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1251,90 +999,6 @@ POSTHOOK: query: EXPLAIN EXTENDED SELECT a.key, a.value, b.key, b.value WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND a.ds = '2008-04-08' POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_LEFTOUTERJOIN - TOK_TABREF - TOK_TABNAME - srcpart - a - TOK_TABREF - TOK_TABNAME - src - 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 - TOK_SELEXPR - . - TOK_TABLE_OR_COL - a - value - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - value - TOK_WHERE - AND - AND - AND - AND - > - . - TOK_TABLE_OR_COL - a - key - 10 - < - . - TOK_TABLE_OR_COL - a - key - 20 - > - . - TOK_TABLE_OR_COL - b - key - 15 - < - . - TOK_TABLE_OR_COL - b - key - 25 - = - . - TOK_TABLE_OR_COL - a - 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/macro.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/macro.q.out b/ql/src/test/results/clientpositive/macro.q.out index 76ea250..35e03ca 100644 --- a/ql/src/test/results/clientpositive/macro.q.out +++ b/ql/src/test/results/clientpositive/macro.q.out @@ -41,26 +41,6 @@ PREHOOK: query: EXPLAIN EXTENDED SELECT SIGMOID(2) FROM src LIMIT 1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT SIGMOID(2) FROM src LIMIT 1 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - SIGMOID - 2 - TOK_LIMIT - 1 - - STAGE DEPENDENCIES: Stage-0 is a root stage @@ -131,27 +111,6 @@ PREHOOK: query: EXPLAIN EXTENDED SELECT FIXED_NUMBER() + 1 FROM src LIMIT 1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT FIXED_NUMBER() + 1 FROM src LIMIT 1 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - + - TOK_FUNCTION - FIXED_NUMBER - 1 - TOK_LIMIT - 1 - - STAGE DEPENDENCIES: Stage-0 is a root stage @@ -249,27 +208,6 @@ PREHOOK: query: EXPLAIN EXTENDED SELECT SIMPLE_ADD(1, 9) FROM src LIMIT 1 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT SIMPLE_ADD(1, 9) FROM src LIMIT 1 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - SIMPLE_ADD - 1 - 9 - TOK_LIMIT - 1 - - STAGE DEPENDENCIES: Stage-0 is a root stage http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out b/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out index a32986c..85bd14b 100644 --- a/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out +++ b/ql/src/test/results/clientpositive/mapjoin_mapjoin.q.out @@ -10,51 +10,6 @@ POSTHOOK: query: -- Since the inputs are small, it should be automatically conve explain extended select srcpart.key from srcpart join src on (srcpart.value=src.value) join src1 on (srcpart.key=src1.key) POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_JOIN - TOK_JOIN - TOK_TABREF - TOK_TABNAME - srcpart - TOK_TABREF - TOK_TABNAME - src - = - . - TOK_TABLE_OR_COL - srcpart - value - . - TOK_TABLE_OR_COL - src - value - TOK_TABREF - TOK_TABNAME - src1 - = - . - TOK_TABLE_OR_COL - srcpart - key - . - TOK_TABLE_OR_COL - src1 - key - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - srcpart - key - - STAGE DEPENDENCIES: Stage-7 is a root stage Stage-5 depends on stages: Stage-7 http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/merge3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/merge3.q.out b/ql/src/test/results/clientpositive/merge3.q.out index 5b581db..7f879db 100644 --- a/ql/src/test/results/clientpositive/merge3.q.out +++ b/ql/src/test/results/clientpositive/merge3.q.out @@ -61,38 +61,6 @@ POSTHOOK: query: explain extended create table merge_src2 as select key, value from merge_src POSTHOOK: type: CREATETABLE_AS_SELECT -ABSTRACT SYNTAX TREE: - -TOK_CREATETABLE - TOK_TABNAME - merge_src2 - TOK_LIKETABLE - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - default - merge_src - merge_src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - merge_src - key - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - merge_src - value - value - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5 @@ -2404,38 +2372,6 @@ insert overwrite table merge_src_part2 partition(ds) select key, value, ds from merge_src_part where ds is not null POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - merge_src_part - TOK_INSERT - TOK_DESTINATION - TOK_TAB - TOK_TABNAME - merge_src_part2 - TOK_PARTSPEC - TOK_PARTVAL - ds - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - key - TOK_SELEXPR - TOK_TABLE_OR_COL - value - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_WHERE - TOK_FUNCTION - TOK_ISNOTNULL - TOK_TABLE_OR_COL - ds - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5 @@ -4845,52 +4781,6 @@ from (select * from merge_src_part where ds is not null distribute by ds) s insert overwrite table merge_src_part2 partition(ds) select key, value, ds POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_SUBQUERY - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - merge_src_part - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_ALLCOLREF - TOK_WHERE - TOK_FUNCTION - TOK_ISNOTNULL - TOK_TABLE_OR_COL - ds - TOK_DISTRIBUTEBY - TOK_TABLE_OR_COL - ds - s - TOK_INSERT - TOK_DESTINATION - TOK_TAB - TOK_TABNAME - merge_src_part2 - TOK_PARTSPEC - TOK_PARTVAL - ds - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - key - TOK_SELEXPR - TOK_TABLE_OR_COL - value - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-7 depends on stages: Stage-1 , consists of Stage-4, Stage-3, Stage-5 http://git-wip-us.apache.org/repos/asf/hive/blob/6908198d/ql/src/test/results/clientpositive/metadataonly1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/metadataonly1.q.out b/ql/src/test/results/clientpositive/metadataonly1.q.out index d6d86bb..0281407 100644 --- a/ql/src/test/results/clientpositive/metadataonly1.q.out +++ b/ql/src/test/results/clientpositive/metadataonly1.q.out @@ -10,25 +10,6 @@ PREHOOK: query: explain extended select max(ds) from TEST1 PREHOOK: type: QUERY POSTHOOK: query: explain extended select max(ds) from TEST1 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - TEST1 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - max - TOK_TABLE_OR_COL - ds - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -113,25 +94,6 @@ PREHOOK: query: explain extended select max(ds) from TEST1 PREHOOK: type: QUERY POSTHOOK: query: explain extended select max(ds) from TEST1 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - TEST1 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - max - TOK_TABLE_OR_COL - ds - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -255,25 +217,6 @@ PREHOOK: query: explain extended select count(distinct ds) from TEST1 PREHOOK: type: QUERY POSTHOOK: query: explain extended select count(distinct ds) from TEST1 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - TEST1 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTIONDI - count - TOK_TABLE_OR_COL - ds - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -398,25 +341,6 @@ PREHOOK: query: explain extended select count(ds) from TEST1 PREHOOK: type: QUERY POSTHOOK: query: explain extended select count(ds) from TEST1 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - TEST1 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - count - TOK_TABLE_OR_COL - ds - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -550,52 +474,6 @@ PREHOOK: type: QUERY POSTHOOK: query: explain extended select count(*) from TEST1 a2 join (select max(ds) m from TEST1) b on a2.ds=b.m POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_JOIN - TOK_TABREF - TOK_TABNAME - TEST1 - a2 - TOK_SUBQUERY - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - TEST1 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - max - TOK_TABLE_OR_COL - ds - m - b - = - . - TOK_TABLE_OR_COL - a2 - ds - . - TOK_TABLE_OR_COL - b - m - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTIONSTAR - count - - STAGE DEPENDENCIES: Stage-3 is a root stage Stage-1 depends on stages: Stage-3 @@ -1027,31 +905,6 @@ PREHOOK: query: explain extended select ds, count(distinct hr) from TEST2 group PREHOOK: type: QUERY POSTHOOK: query: explain extended select ds, count(distinct hr) from TEST2 group by ds POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - TEST2 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_FUNCTIONDI - count - TOK_TABLE_OR_COL - hr - TOK_GROUPBY - TOK_TABLE_OR_COL - ds - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1267,31 +1120,6 @@ PREHOOK: query: explain extended select ds, count(hr) from TEST2 group by ds PREHOOK: type: QUERY POSTHOOK: query: explain extended select ds, count(hr) from TEST2 group by ds POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - TEST2 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_FUNCTION - count - TOK_TABLE_OR_COL - hr - TOK_GROUPBY - TOK_TABLE_OR_COL - ds - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1508,25 +1336,6 @@ PREHOOK: query: explain extended select max(ds) from TEST1 PREHOOK: type: QUERY POSTHOOK: query: explain extended select max(ds) from TEST1 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - TEST1 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - max - TOK_TABLE_OR_COL - ds - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1744,31 +1553,6 @@ PREHOOK: query: explain extended select ds, count(distinct hr) from TEST2 group PREHOOK: type: QUERY POSTHOOK: query: explain extended select ds, count(distinct hr) from TEST2 group by ds POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - TEST2 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_FUNCTIONDI - count - TOK_TABLE_OR_COL - hr - TOK_GROUPBY - TOK_TABLE_OR_COL - ds - - 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/offset_limit_global_optimizer.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/offset_limit_global_optimizer.q.out b/ql/src/test/results/clientpositive/offset_limit_global_optimizer.q.out index 0cd5c82..7d8655f 100644 --- a/ql/src/test/results/clientpositive/offset_limit_global_optimizer.q.out +++ b/ql/src/test/results/clientpositive/offset_limit_global_optimizer.q.out @@ -4,42 +4,6 @@ PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 400,10 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - srcpart - key - TOK_SELEXPR - TOK_FUNCTION - substr - . - TOK_TABLE_OR_COL - srcpart - value - 5 - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_LIMIT - 400 - 10 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -172,42 +136,6 @@ PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,10 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - srcpart - key - TOK_SELEXPR - TOK_FUNCTION - substr - . - TOK_TABLE_OR_COL - srcpart - value - 5 - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_LIMIT - 490 - 10 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -481,42 +409,6 @@ PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,20 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - srcpart - key - TOK_SELEXPR - TOK_FUNCTION - substr - . - TOK_TABLE_OR_COL - srcpart - value - 5 - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_LIMIT - 490 - 20 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -800,42 +692,6 @@ PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,600 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - srcpart - key - TOK_SELEXPR - TOK_FUNCTION - substr - . - TOK_TABLE_OR_COL - srcpart - value - 5 - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_LIMIT - 490 - 600 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1699,42 +1555,6 @@ PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 400,10 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - srcpart - key - TOK_SELEXPR - TOK_FUNCTION - substr - . - TOK_TABLE_OR_COL - srcpart - value - 5 - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_LIMIT - 400 - 10 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -1867,42 +1687,6 @@ PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,10 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - srcpart - key - TOK_SELEXPR - TOK_FUNCTION - substr - . - TOK_TABLE_OR_COL - srcpart - value - 5 - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_LIMIT - 490 - 10 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2176,42 +1960,6 @@ PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,20 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - srcpart - key - TOK_SELEXPR - TOK_FUNCTION - substr - . - TOK_TABLE_OR_COL - srcpart - value - 5 - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_LIMIT - 490 - 20 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2495,42 +2243,6 @@ PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN EXTENDED SELECT srcpart.key, substr(srcpart.value,5), ds, hr FROM srcpart LIMIT 490,600 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - srcpart - key - TOK_SELEXPR - TOK_FUNCTION - substr - . - TOK_TABLE_OR_COL - srcpart - value - 5 - TOK_SELEXPR - TOK_TABLE_OR_COL - ds - TOK_SELEXPR - TOK_TABLE_OR_COL - hr - TOK_LIMIT - 490 - 600 - - 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/optimize_nullscan.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/optimize_nullscan.q.out b/ql/src/test/results/clientpositive/optimize_nullscan.q.out index 023b71b..4a693d6 100644 --- a/ql/src/test/results/clientpositive/optimize_nullscan.q.out +++ b/ql/src/test/results/clientpositive/optimize_nullscan.q.out @@ -14,25 +14,6 @@ POSTHOOK: query: -- SORT_QUERY_RESULTS explain extended select key from src where false POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - key - TOK_WHERE - false - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -144,32 +125,6 @@ PREHOOK: type: QUERY POSTHOOK: query: explain extended select count(key) from srcpart where 1=2 group by key POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - count - TOK_TABLE_OR_COL - key - TOK_WHERE - = - 1 - 2 - TOK_GROUPBY - TOK_TABLE_OR_COL - key - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -256,63 +211,6 @@ PREHOOK: type: QUERY POSTHOOK: query: explain extended select * from (select key from src where false) a left outer join (select key from srcpart limit 0) b on a.key=b.key POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_LEFTOUTERJOIN - TOK_SUBQUERY - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - key - TOK_WHERE - false - a - TOK_SUBQUERY - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - key - TOK_LIMIT - 0 - 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_ALLCOLREF - - STAGE DEPENDENCIES: Stage-2 is a root stage Stage-1 depends on stages: Stage-2 @@ -724,54 +622,6 @@ PREHOOK: type: QUERY POSTHOOK: query: explain extended select count(key) from src where false union all select count(key) from srcpart POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_SUBQUERY - TOK_UNIONALL - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - count - TOK_TABLE_OR_COL - key - TOK_WHERE - false - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - count - TOK_TABLE_OR_COL - key - _u1 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_ALLCOLREF - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-2 depends on stages: Stage-1, Stage-3 @@ -1249,54 +1099,6 @@ PREHOOK: type: QUERY POSTHOOK: query: explain extended select * from (select key from src where false) a left outer join (select value from srcpart limit 0) b POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_LEFTOUTERJOIN - TOK_SUBQUERY - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - key - TOK_WHERE - false - a - TOK_SUBQUERY - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - srcpart - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - value - TOK_LIMIT - 0 - b - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_ALLCOLREF - - STAGE DEPENDENCIES: Stage-2 is a root stage Stage-1 depends on stages: Stage-2 @@ -1707,65 +1509,6 @@ PREHOOK: type: QUERY POSTHOOK: query: explain extended select * from (select key from src union all select src.key from src left outer join srcpart on src.key = srcpart.key) a where false POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_SUBQUERY - TOK_UNIONALL - TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_TABLE_OR_COL - key - TOK_QUERY - TOK_FROM - TOK_LEFTOUTERJOIN - TOK_TABREF - TOK_TABNAME - src - TOK_TABREF - TOK_TABNAME - srcpart - = - . - TOK_TABLE_OR_COL - src - key - . - TOK_TABLE_OR_COL - srcpart - key - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - src - key - a - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_ALLCOLREF - TOK_WHERE - false - - STAGE DEPENDENCIES: Stage-3 is a root stage Stage-2 depends on stages: Stage-3 @@ -2041,40 +1784,6 @@ PREHOOK: type: QUERY POSTHOOK: query: explain extended select * from src s1, src s2 where false and s1.value = s2.value POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_JOIN - TOK_TABREF - TOK_TABNAME - src - s1 - TOK_TABREF - TOK_TABNAME - src - s2 - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_ALLCOLREF - TOK_WHERE - and - false - = - . - TOK_TABLE_OR_COL - s1 - value - . - TOK_TABLE_OR_COL - s2 - value - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -2222,28 +1931,6 @@ PREHOOK: type: QUERY POSTHOOK: query: explain extended select count(1) from src where null = 1 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_TABREF - TOK_TABNAME - src - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - TOK_FUNCTION - count - 1 - TOK_WHERE - = - TOK_NULL - 1 - - 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/outer_join_ppr.q.java1.7.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/outer_join_ppr.q.java1.7.out b/ql/src/test/results/clientpositive/outer_join_ppr.q.java1.7.out index c471301..1312e53 100644 --- a/ql/src/test/results/clientpositive/outer_join_ppr.q.java1.7.out +++ b/ql/src/test/results/clientpositive/outer_join_ppr.q.java1.7.out @@ -22,90 +22,6 @@ EXPLAIN EXTENDED SELECT a.key, a.value, b.key, b.value WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_FULLOUTERJOIN - TOK_TABREF - TOK_TABNAME - src - a - TOK_TABREF - TOK_TABNAME - srcpart - b - AND - = - . - TOK_TABLE_OR_COL - a - key - . - TOK_TABLE_OR_COL - b - key - = - . - TOK_TABLE_OR_COL - b - ds - '2008-04-08' - TOK_INSERT - TOK_DESTINATION - TOK_DIR - TOK_TMP_FILE - TOK_SELECT - TOK_SELEXPR - . - TOK_TABLE_OR_COL - a - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - a - value - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - value - TOK_WHERE - AND - AND - AND - > - . - TOK_TABLE_OR_COL - a - key - 10 - < - . - TOK_TABLE_OR_COL - a - key - 20 - > - . - TOK_TABLE_OR_COL - b - key - 15 - < - . - TOK_TABLE_OR_COL - b - key - 25 - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 @@ -493,90 +409,6 @@ POSTHOOK: query: EXPLAIN EXTENDED SELECT a.key, a.value, b.key, b.value WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08' POSTHOOK: type: QUERY -ABSTRACT SYNTAX TREE: - -TOK_QUERY - TOK_FROM - TOK_FULLOUTERJOIN - TOK_TABREF - TOK_TABNAME - src - a - TOK_TABREF - TOK_TABNAME - srcpart - 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 - TOK_SELEXPR - . - TOK_TABLE_OR_COL - a - value - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - key - TOK_SELEXPR - . - TOK_TABLE_OR_COL - b - value - TOK_WHERE - AND - AND - AND - AND - > - . - TOK_TABLE_OR_COL - a - key - 10 - < - . - TOK_TABLE_OR_COL - a - key - 20 - > - . - TOK_TABLE_OR_COL - b - key - 15 - < - . - TOK_TABLE_OR_COL - b - key - 25 - = - . - TOK_TABLE_OR_COL - b - ds - '2008-04-08' - - STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1