From issues-return-157150-archive-asf-public=cust-asf.ponee.io@hive.apache.org Mon May 6 18:11:02 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 4718D18060F for ; Mon, 6 May 2019 20:11:02 +0200 (CEST) Received: (qmail 42131 invoked by uid 500); 6 May 2019 18:11:01 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 42122 invoked by uid 99); 6 May 2019 18:11:01 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 May 2019 18:11:01 +0000 Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id D78E4E0F50 for ; Mon, 6 May 2019 18:11:00 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 4A2A625813 for ; Mon, 6 May 2019 18:11:00 +0000 (UTC) Date: Mon, 6 May 2019 18:11:00 +0000 (UTC) From: "ASF GitHub Bot (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Work logged] (HIVE-13582) E061-07 and E061-12: Quantified Comparison Predicates MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-13582?focusedWorklogId=237978&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-237978 ] ASF GitHub Bot logged work on HIVE-13582: ----------------------------------------- Author: ASF GitHub Bot Created on: 06/May/19 18:10 Start Date: 06/May/19 18:10 Worklog Time Spent: 10m Work Description: jcamachor commented on pull request #612: HIVE-13582: Support for Quantified predicates for non-correlated queries URL: https://github.com/apache/hive/pull/612#discussion_r281295724 ########## File path: ql/src/test/results/clientpositive/llap/subquery_ALL.q.out ########## @@ -0,0 +1,542 @@ +PREHOOK: query: create table tempty(i int, j int) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@tempty +POSTHOOK: query: create table tempty(i int, j int) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@tempty +PREHOOK: query: CREATE TABLE part_null_n0 as select * from part +PREHOOK: type: CREATETABLE_AS_SELECT +PREHOOK: Input: default@part +PREHOOK: Output: database:default +PREHOOK: Output: default@part_null_n0 +POSTHOOK: query: CREATE TABLE part_null_n0 as select * from part +POSTHOOK: type: CREATETABLE_AS_SELECT +POSTHOOK: Input: default@part +POSTHOOK: Output: database:default +POSTHOOK: Output: default@part_null_n0 +POSTHOOK: Lineage: part_null_n0.p_brand SIMPLE [(part)part.FieldSchema(name:p_brand, type:string, comment:null), ] +POSTHOOK: Lineage: part_null_n0.p_comment SIMPLE [(part)part.FieldSchema(name:p_comment, type:string, comment:null), ] +POSTHOOK: Lineage: part_null_n0.p_container SIMPLE [(part)part.FieldSchema(name:p_container, type:string, comment:null), ] +POSTHOOK: Lineage: part_null_n0.p_mfgr SIMPLE [(part)part.FieldSchema(name:p_mfgr, type:string, comment:null), ] +POSTHOOK: Lineage: part_null_n0.p_name SIMPLE [(part)part.FieldSchema(name:p_name, type:string, comment:null), ] +POSTHOOK: Lineage: part_null_n0.p_partkey SIMPLE [(part)part.FieldSchema(name:p_partkey, type:int, comment:null), ] +POSTHOOK: Lineage: part_null_n0.p_retailprice SIMPLE [(part)part.FieldSchema(name:p_retailprice, type:double, comment:null), ] +POSTHOOK: Lineage: part_null_n0.p_size SIMPLE [(part)part.FieldSchema(name:p_size, type:int, comment:null), ] +POSTHOOK: Lineage: part_null_n0.p_type SIMPLE [(part)part.FieldSchema(name:p_type, type:string, comment:null), ] +PREHOOK: query: insert into part_null_n0 values(NULL,NULL,NULL,NULL,NULL, NULL, NULL,NULL,NULL) +PREHOOK: type: QUERY +PREHOOK: Input: _dummy_database@_dummy_table +PREHOOK: Output: default@part_null_n0 +POSTHOOK: query: insert into part_null_n0 values(NULL,NULL,NULL,NULL,NULL, NULL, NULL,NULL,NULL) +POSTHOOK: type: QUERY +POSTHOOK: Input: _dummy_database@_dummy_table +POSTHOOK: Output: default@part_null_n0 +POSTHOOK: Lineage: part_null_n0.p_brand EXPRESSION [] +POSTHOOK: Lineage: part_null_n0.p_comment EXPRESSION [] +POSTHOOK: Lineage: part_null_n0.p_container EXPRESSION [] +POSTHOOK: Lineage: part_null_n0.p_mfgr EXPRESSION [] +POSTHOOK: Lineage: part_null_n0.p_name EXPRESSION [] +POSTHOOK: Lineage: part_null_n0.p_partkey EXPRESSION [] +POSTHOOK: Lineage: part_null_n0.p_retailprice EXPRESSION [] +POSTHOOK: Lineage: part_null_n0.p_size EXPRESSION [] +POSTHOOK: Lineage: part_null_n0.p_type EXPRESSION [] +Warning: Shuffle Join MERGEJOIN[37][tables = [$hdt$_0, $hdt$_1, $hdt$_2]] in Stage 'Reducer 3' is a cross product +PREHOOK: query: explain cbo select count(*) from part where p_partkey <> ALL (select p_partkey from part) +PREHOOK: type: QUERY +PREHOOK: Input: default@part +#### A masked pattern was here #### +POSTHOOK: query: explain cbo select count(*) from part where p_partkey <> ALL (select p_partkey from part) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@part +#### A masked pattern was here #### +CBO PLAN: +HiveAggregate(group=[{}], agg#0=[count()]) + HiveFilter(condition=[AND(OR(IS NULL($4), =($1, 0)), OR(IS NOT NULL($0), =($1, 0), IS NOT NULL($4)), OR(>=($2, $1), =($1, 0), IS NOT NULL($4), IS NULL($0)))]) Review comment: `HiveFilterJoinRule` should be the rule responsible to push filters into join conditions. ---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: users@infra.apache.org Issue Time Tracking ------------------- Worklog Id: (was: 237978) Time Spent: 1h 40m (was: 1.5h) > E061-07 and E061-12: Quantified Comparison Predicates > ----------------------------------------------------- > > Key: HIVE-13582 > URL: https://issues.apache.org/jira/browse/HIVE-13582 > Project: Hive > Issue Type: Sub-task > Reporter: Carter Shanklin > Assignee: Vineet Garg > Priority: Major > Labels: pull-request-available > Attachments: HIVE-13582.1.patch, HIVE-13582.2.patch, HIVE-13582.3.patch, HIVE-13582.4.patch, HIVE-13582.5.patch, HIVE-13582.6.patch > > Time Spent: 1h 40m > Remaining Estimate: 0h > > This is a part of the SQL:2011 Analytics Complete Umbrella JIRA HIVE-13554. Quantified comparison predicates (ANY/SOME/ALL) are mandatory in the SQL standard. Hive should support the predicates (E061-07) and you should be able to use these with subqueries (E061-12) -- This message was sent by Atlassian JIRA (v7.6.3#76005)