From issues-return-143763-archive-asf-public=cust-asf.ponee.io@hive.apache.org Tue Nov 27 23:51:05 2018 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 [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id CCC4A180670 for ; Tue, 27 Nov 2018 23:51:04 +0100 (CET) Received: (qmail 27856 invoked by uid 500); 27 Nov 2018 22:51:03 -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 27847 invoked by uid 99); 27 Nov 2018 22:51:03 -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; Tue, 27 Nov 2018 22:51:03 +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 8A8B5C0188 for ; Tue, 27 Nov 2018 22:51:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -109.501 X-Spam-Level: X-Spam-Status: No, score=-109.501 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id FgjEyYV6TvTY for ; Tue, 27 Nov 2018 22:51:02 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id B59E160D9A for ; Tue, 27 Nov 2018 22:51:01 +0000 (UTC) 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 D7263E25B0 for ; Tue, 27 Nov 2018 22:51: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 5F46C27768 for ; Tue, 27 Nov 2018 22:51:00 +0000 (UTC) Date: Tue, 27 Nov 2018 22:51:00 +0000 (UTC) From: "Jesus Camacho Rodriguez (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (HIVE-20976) JDBC queries containing joins gives wrong results 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-20976?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jesus Camacho Rodriguez updated HIVE-20976: ------------------------------------------- Component/s: (was: Druid integration) StorageHandler JDBC > JDBC queries containing joins gives wrong results > ------------------------------------------------- > > Key: HIVE-20976 > URL: https://issues.apache.org/jira/browse/HIVE-20976 > Project: Hive > Issue Type: Bug > Components: JDBC, StorageHandler > Reporter: Nishant Bangarwa > Assignee: Nishant Bangarwa > Priority: Major > > Druid queries that have joins against self table gives wrong results. > e.g. > {code} > SELECT > username AS `username`, > SUM(double1) AS `sum_double1` > FROM > druid_table_with_nulls `tbl1` > JOIN ( > SELECT > username AS `username`, > SUM(double1) AS `sum_double2` > FROM druid_table_with_nulls > GROUP BY `username` > ORDER BY `sum_double2` > DESC LIMIT 10 > ) > `tbl2` > ON (`tbl1`.`username` = `tbl2`.`username`) > GROUP BY `tbl1`.`username`; > {code} > In this case one of the queries is a druid scan query and other is groupBy query. > During planning, the properties of these queries are set to the tableDesc and serdeInfo, while setting the map work, we overwrite the properties from the properties present in serdeInfo, this causes the scan query results to be deserialized using wrong column names and results in Null values. -- This message was sent by Atlassian JIRA (v7.6.3#76005)