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 770F1116E1 for ; Wed, 6 Aug 2014 06:44:38 +0000 (UTC) Received: (qmail 41931 invoked by uid 500); 6 Aug 2014 06:44:38 -0000 Delivered-To: apmail-hive-commits-archive@hive.apache.org Received: (qmail 41891 invoked by uid 500); 6 Aug 2014 06:44:38 -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 41880 invoked by uid 99); 6 Aug 2014 06:44:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Aug 2014 06:44:38 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO eris.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 06 Aug 2014 06:44:36 +0000 Received: from eris.apache.org (localhost [127.0.0.1]) by eris.apache.org (Postfix) with ESMTP id A1F4F23891CC; Wed, 6 Aug 2014 06:44:16 +0000 (UTC) Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Subject: svn commit: r1616108 - in /hive/branches/cbo/ql/src/test: queries/clientpositive/cbo_correctness.q results/clientpositive/cbo_correctness.q.out Date: Wed, 06 Aug 2014 06:44:16 -0000 To: commits@hive.apache.org From: hashutosh@apache.org X-Mailer: svnmailer-1.0.9 Message-Id: <20140806064416.A1F4F23891CC@eris.apache.org> X-Virus-Checked: Checked by ClamAV on apache.org Author: hashutosh Date: Wed Aug 6 06:44:16 2014 New Revision: 1616108 URL: http://svn.apache.org/r1616108 Log: HIVE-7621 : Add tests for cte with cbo (Ashutosh Chauhan) Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out Modified: hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q?rev=1616108&r1=1616107&r2=1616108&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q (original) +++ hive/branches/cbo/ql/src/test/queries/clientpositive/cbo_correctness.q Wed Aug 6 06:44:16 2014 @@ -192,4 +192,22 @@ select count(v1.c_int) from v1 join v2 create view v3 as select v1.value from v1 join t1 on v1.c_boolean = t1.c_boolean; select * from v3 limit 3; +with q1 as ( select key from t1 where key = '1') +select * +from q1 +; + +with q1 as ( select value from v1 where c_boolean = false) +select * +from q1 ; + +create view v4 as +with q1 as ( select key from t1 where key = '1') +select * from q1 +; + +with q1 as ( select c_int from q2 where c_boolean = false), +q2 as ( select c_int,c_boolean from v1 where value = '1') +select * from (select c_int from q1) a; + Modified: hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out?rev=1616108&r1=1616107&r2=1616108&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/cbo_correctness.q.out Wed Aug 6 06:44:16 2014 @@ -16037,3 +16037,70 @@ POSTHOOK: Input: default@v3 1 1 1 +PREHOOK: query: with q1 as ( select key from t1 where key = '1') +select * +from q1 +PREHOOK: type: QUERY +PREHOOK: Input: default@t1 +#### A masked pattern was here #### +POSTHOOK: query: with q1 as ( select key from t1 where key = '1') +select * +from q1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1 +#### A masked pattern was here #### +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +1 +PREHOOK: query: with q1 as ( select value from v1 where c_boolean = false) +select * +from q1 +PREHOOK: type: QUERY +PREHOOK: Input: default@t1 +PREHOOK: Input: default@v1 +#### A masked pattern was here #### +POSTHOOK: query: with q1 as ( select value from v1 where c_boolean = false) +select * +from q1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1 +POSTHOOK: Input: default@v1 +#### A masked pattern was here #### +1 +1 +PREHOOK: query: create view v4 as +with q1 as ( select key from t1 where key = '1') +select * from q1 +PREHOOK: type: CREATEVIEW +PREHOOK: Input: default@t1 +POSTHOOK: query: create view v4 as +with q1 as ( select key from t1 where key = '1') +select * from q1 +POSTHOOK: type: CREATEVIEW +POSTHOOK: Input: default@t1 +POSTHOOK: Output: default@v4 +PREHOOK: query: with q1 as ( select c_int from q2 where c_boolean = false), +q2 as ( select c_int,c_boolean from v1 where value = '1') +select * from (select c_int from q1) a +PREHOOK: type: QUERY +PREHOOK: Input: default@t1 +PREHOOK: Input: default@v1 +#### A masked pattern was here #### +POSTHOOK: query: with q1 as ( select c_int from q2 where c_boolean = false), +q2 as ( select c_int,c_boolean from v1 where value = '1') +select * from (select c_int from q1) a +POSTHOOK: type: QUERY +POSTHOOK: Input: default@t1 +POSTHOOK: Input: default@v1 +#### A masked pattern was here #### +1 +1