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 64D18200CFC for ; Thu, 14 Sep 2017 00:14:11 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 63A021609CB; Wed, 13 Sep 2017 22:14:11 +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 A86BD1609CA for ; Thu, 14 Sep 2017 00:14:10 +0200 (CEST) Received: (qmail 14945 invoked by uid 500); 13 Sep 2017 22:14:08 -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 14934 invoked by uid 99); 13 Sep 2017 22:14:08 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Sep 2017 22:14:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id A4B6F1A5573; Wed, 13 Sep 2017 22:14:07 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 3 X-Spam-Level: *** X-Spam-Status: No, score=3 tagged_above=-999 required=6.31 tests=[HEADER_FROM_DIFFERENT_DOMAINS=0.001, 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 (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id Da4XChAdU40u; Wed, 13 Sep 2017 22:14:06 +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 0D6A85F29A; Wed, 13 Sep 2017 22:14:06 +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 A2543E0026; Wed, 13 Sep 2017 22:14:05 +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 2AFABC4166B; Wed, 13 Sep 2017 22:14:04 +0000 (UTC) Content-Type: multipart/alternative; boundary="===============9154607301452351617==" MIME-Version: 1.0 Subject: Review Request 62309: HIVE-17465 Fix filters cardinality for AND predicates From: Vineet Garg To: Ashutosh Chauhan Cc: hive , Vineet Garg Date: Wed, 13 Sep 2017 22:14:03 -0000 Message-ID: <20170913221403.50246.84173@reviews-vm2.apache.org> X-ReviewBoard-URL: https://reviews.apache.org/ Auto-Submitted: auto-generated Sender: Vineet Garg X-ReviewGroup: hive X-Auto-Response-Suppress: DR, RN, OOF, AutoReply X-ReviewRequest-URL: https://reviews.apache.org/r/62309/ X-Sender: Vineet Garg X-ReviewBoard-Diff-For: ql/src/test/queries/clientpositive/filter_cardinality.q X-ReviewBoard-Diff-For: data/files/filterCard.txt X-ReviewBoard-Diff-For: ql/src/test/results/clientpositive/filter_cardinality.q.out Reply-To: Vineet Garg X-ReviewRequest-Repository: hive-git archived-at: Wed, 13 Sep 2017 22:14:11 -0000 --===============9154607301452351617== MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit ----------------------------------------------------------- This is an automatically generated e-mail. To reply, visit: https://reviews.apache.org/r/62309/ ----------------------------------------------------------- Review request for hive and Ashutosh Chauhan. Bugs: HIVE-17465 https://issues.apache.org/jira/browse/HIVE-17465 Repository: hive-git Description ------- This patch fixes estimation of cardinality for filter with AND predicates. Diffs ----- data/files/filterCard.txt PRE-CREATION ql/src/java/org/apache/hadoop/hive/ql/optimizer/stats/annotation/StatsRulesProcFactory.java 423913b56b ql/src/test/queries/clientpositive/filter_cardinality.q PRE-CREATION ql/src/test/results/clientpositive/annotate_stats_deep_filters.q.out 6e2975e671 ql/src/test/results/clientpositive/annotate_stats_join_pkfk.q.out e04c1c6bc5 ql/src/test/results/clientpositive/filter_cardinality.q.out PRE-CREATION ql/src/test/results/clientpositive/join47.q.out 20dce5d3bb ql/src/test/results/clientpositive/llap/explainuser_1.q.out 48c02a24ad ql/src/test/results/clientpositive/llap/vector_decimal_cast.q.out c45210e562 ql/src/test/results/clientpositive/llap/vector_if_expr.q.out 32d100180d ql/src/test/results/clientpositive/llap/vectorization_0.q.out db76eaaf1b ql/src/test/results/clientpositive/llap/vectorization_10.q.out f06c2dbcc6 ql/src/test/results/clientpositive/llap/vectorization_17.q.out 1c07962d83 ql/src/test/results/clientpositive/llap/vectorization_7.q.out 6c32ccf42d ql/src/test/results/clientpositive/llap/vectorization_short_regress.q.out 66764cf42b ql/src/test/results/clientpositive/llap/vectorized_nested_mapjoin.q.out 2a95065203 ql/src/test/results/clientpositive/mapjoin47.q.out 2904b68813 ql/src/test/results/clientpositive/perf/query23.q.out dde707d0ea ql/src/test/results/clientpositive/smb_mapjoin_47.q.out 074600ef02 ql/src/test/results/clientpositive/spark/vectorization_10.q.out 1f953575e3 ql/src/test/results/clientpositive/spark/vectorization_12.q.out 4e26314499 ql/src/test/results/clientpositive/spark/vectorization_17.q.out b43c506c6f ql/src/test/results/clientpositive/vectorization_10.q.out d2d9bf644b ql/src/test/results/clientpositive/vectorization_12.q.out 63ea984a33 ql/src/test/results/clientpositive/vectorization_17.q.out c0186082df ql/src/test/results/clientpositive/vectorization_7.q.out 218d307915 Diff: https://reviews.apache.org/r/62309/diff/1/ Testing ------- * Added new tests * Updated existing tests Thanks, Vineet Garg --===============9154607301452351617==--