Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id F1055200C4D for ; Wed, 5 Apr 2017 17:37:52 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id EFCA3160B94; Wed, 5 Apr 2017 15:37:52 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 3EFA7160B91 for ; Wed, 5 Apr 2017 17:37:52 +0200 (CEST) Received: (qmail 13817 invoked by uid 500); 5 Apr 2017 15:37:51 -0000 Mailing-List: contact dev-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 dev@hive.apache.org Received: (qmail 13802 invoked by uid 99); 5 Apr 2017 15:37:50 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 05 Apr 2017 15:37:50 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 52F0BC0115; Wed, 5 Apr 2017 15:37:50 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.999 X-Spam-Level: ** X-Spam-Status: No, score=2.999 tagged_above=-999 required=6.31 tests=[HTML_MESSAGE=2, KAM_LAZY_DOMAIN_SECURITY=1, RP_MATCHES_RCVD=-0.001] autolearn=disabled Received: from mx1-lw-us.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id 0XffackHGfTg; Wed, 5 Apr 2017 15:37:49 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-us.apache.org (ASF Mail Server at mx1-lw-us.apache.org) with ESMTP id 1E13A5F1A0; Wed, 5 Apr 2017 15:37:49 +0000 (UTC) Received: from reviews.apache.org (unknown [10.41.0.12]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id B7D58E00B4; Wed, 5 Apr 2017 15:37:48 +0000 (UTC) Received: from reviews-vm2.apache.org (localhost [IPv6:::1]) by reviews.apache.org (ASF Mail Server at reviews-vm2.apache.org) with ESMTP id A9887C402D8; Wed, 5 Apr 2017 15:37:48 +0000 (UTC) Content-Type: multipart/alternative; boundary="===============7050774886154699641==" MIME-Version: 1.0 Subject: Re: Review Request 58181: HIVE-15986 Support for 'is [NOT] distinct from' From: Ashutosh Chauhan To: Ashutosh Chauhan , =?utf-8?q?Jes=C3=BAs_Camacho_Rodr=C3=ADguez?= Cc: hive , Vineet Garg Date: Wed, 05 Apr 2017 15:37:48 -0000 Message-ID: <20170405153748.56252.46552@reviews-vm2.apache.org> X-ReviewBoard-URL: https://reviews.apache.org/ Auto-Submitted: auto-generated Sender: Ashutosh Chauhan X-ReviewGroup: hive X-Auto-Response-Suppress: DR, RN, OOF, AutoReply X-ReviewRequest-URL: https://reviews.apache.org/r/58181/ X-Sender: Ashutosh Chauhan References: <20170404230522.22168.83818@reviews-vm2.apache.org> In-Reply-To: <20170404230522.22168.83818@reviews-vm2.apache.org> X-ReviewBoard-Diff-For: ql/src/test/queries/clientpositive/is_distinct_from.q X-ReviewBoard-Diff-For: ql/src/test/results/clientpositive/llap/is_distinct_from.q.out Reply-To: Ashutosh Chauhan X-ReviewRequest-Repository: hive-git archived-at: Wed, 05 Apr 2017 15:37:53 -0000 --===============7050774886154699641== MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 8bit ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/58181/#review171125 ----------------------------------------------------------- ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g Lines 590-592 (patched) It will be good to not add extra tokens in grammar as it increases the size of state machine. How about: KW_IS (a=KW_NOT)? KW_DISTINCT KW_FROM -> {$a !=null}? ^(EQUAL_NS) -> ^(KW_NOT EQUAL_NS) - Ashutosh Chauhan On April 4, 2017, 11:05 p.m., Vineet Garg wrote: > > ----------------------------------------------------------- > This is an automatically generated e-mail. To reply, visit: > https://reviews.apache.org/r/58181/ > ----------------------------------------------------------- > > (Updated April 4, 2017, 11:05 p.m.) > > > Review request for hive, Ashutosh Chauhan and Jesús Camacho Rodríguez. > > > Bugs: HIVE-15986 > https://issues.apache.org/jira/browse/HIVE-15986 > > > Repository: hive-git > > > Description > ------- > > This patch adds support for 'is distinct from' and 'is not distinct from'. > > > Diffs > ----- > > itests/src/test/resources/testconfiguration.properties 7a70c9c > ql/src/java/org/apache/hadoop/hive/ql/exec/FunctionRegistry.java ccfb455 > ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/translator/SqlFunctionConverter.java 85450c9 > ql/src/java/org/apache/hadoop/hive/ql/parse/HiveParser.g d98a663 > ql/src/java/org/apache/hadoop/hive/ql/parse/IdentifiersParser.g 8c4ee8a > ql/src/test/queries/clientpositive/is_distinct_from.q PRE-CREATION > ql/src/test/results/clientpositive/llap/is_distinct_from.q.out PRE-CREATION > > > Diff: https://reviews.apache.org/r/58181/diff/2/ > > > Testing > ------- > > Added new tests > Pre-commit testing > > > Thanks, > > Vineet Garg > > --===============7050774886154699641==--