Return-Path: X-Original-To: apmail-drill-issues-archive@minotaur.apache.org Delivered-To: apmail-drill-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 7226618D8A for ; Thu, 8 Oct 2015 17:47:01 +0000 (UTC) Received: (qmail 60076 invoked by uid 500); 8 Oct 2015 17:46:27 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 60052 invoked by uid 500); 8 Oct 2015 17:46:27 -0000 Mailing-List: contact issues-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@drill.apache.org Delivered-To: mailing list issues@drill.apache.org Received: (qmail 60041 invoked by uid 99); 8 Oct 2015 17:46:27 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 08 Oct 2015 17:46:27 +0000 Date: Thu, 8 Oct 2015 17:46:27 +0000 (UTC) From: "Khurram Faraaz (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (DRILL-3805) Empty JSON on LHS UNION non empty JSON on RHS must return 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/DRILL-3805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3805: ---------------------------------- Assignee: Sean Hsuan-Yi Chu > Empty JSON on LHS UNION non empty JSON on RHS must return results > ----------------------------------------------------------------- > > Key: DRILL-3805 > URL: https://issues.apache.org/jira/browse/DRILL-3805 > Project: Apache Drill > Issue Type: Improvement > Components: Execution - Relational Operators > Affects Versions: 1.2.0 > Reporter: Khurram Faraaz > Assignee: Sean Hsuan-Yi Chu > Priority: Minor > Fix For: 1.3.0 > > > When the input on LHS of UNION operator is empty and there is non empty input on RHS of Union, we need to return the data from the RHS. Currently we return SchemaChangeException. > {code} > 0: jdbc:drill:schema=dfs.tmp> select key1 from `empty.json` UNION select key1 from `fewRows.json`; > Error: SYSTEM ERROR: SchemaChangeException: The left input of Union-All should not come from an empty data source > Fragment 0:0 > [Error Id: f0fcff87-f470-46a8-9733-316b7da1a87f on centos-02.qa.lab:31010] (state=,code=0) > {code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)