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 270B418145 for ; Thu, 8 Oct 2015 19:00:30 +0000 (UTC) Received: (qmail 33119 invoked by uid 500); 8 Oct 2015 19:00:30 -0000 Delivered-To: apmail-drill-issues-archive@drill.apache.org Received: (qmail 32831 invoked by uid 500); 8 Oct 2015 19:00:29 -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 32818 invoked by uid 99); 8 Oct 2015 19:00:29 -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 19:00:29 +0000 Date: Thu, 8 Oct 2015 19:00:29 +0000 (UTC) From: "Daniel Barclay (Drill) (JIRA)" To: issues@drill.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (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:comment-tabpanel&focusedCommentId=14949163#comment-14949163 ] Daniel Barclay (Drill) commented on DRILL-3805: ----------------------------------------------- Sounds related to DRILL-2288. > 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)