Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Mon, 29 May 2017 23:01:04 +0000 (UTC)
From: "Paul Rogers (JIRA)" <jira@apache.org>
To: dev@drill.apache.org
Message-ID: <JIRA.13075716.1496098846000.316733.1496098864067@Atlassian.JIRA>
In-Reply-To: <JIRA.13075716.1496098846000@Atlassian.JIRA>
References: <JIRA.13075716.1496098846000@Atlassian.JIRA> <JIRA.13075716.1496098846359@jira-lw-us.apache.org>
Subject: [jira] [Created] (DRILL-5553) SELECT *, columns produces nonsense
 results
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Mon, 29 May 2017 23:01:08 -0000

Paul Rogers created DRILL-5553:
----------------------------------

             Summary: SELECT *, columns produces nonsense results
                 Key: DRILL-5553
                 URL: https://issues.apache.org/jira/browse/DRILL-5553
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 1.10.0
            Reporter: Paul Rogers
            Priority: Minor


Consider the case discussed in DRILL-5551. Create a slight variation. 

Input file: CSV with headers:

{code}
a,b,c
10,foo,bar
{code}

As in DRILL-5550, CSV plugin is configured to use headers.

Run this (admittedly strange) query:

{code}
SELECT *, columns FROM `dfs.data.example.csv`
{code}

The resulting schema is:

{code}
BatchSchema [fields=[
a(VARCHAR:REQUIRED) [$offsets$(UINT4:REQUIRED)], 
b(VARCHAR:REQUIRED) [$offsets$(UINT4:REQUIRED)], 
c(VARCHAR:REQUIRED) [$offsets$(UINT4:REQUIRED)], 
columns(INT:OPTIONAL) [$bits$(UINT1:REQUIRED), columns(INT:OPTIONAL)]], 
selectionVector=NONE]
{code}

To make it easier to read:

{code}
a(VARCHAR:REQUIRED), 
b(VARCHAR:REQUIRED).
c(VARCHAR:REQUIRED),
columns(INT:OPTIONAL)
{code}

In DRILL-5551, {{columns}} changes meaning from an array of columns to a blank normal column. Here, it changes meaning again to a nullable Int (our normal "placeholder" for missing columns.)

Expected:

1. That, per DRILL-5552, no other column reference can occur with "*".
2. If item 1 is not fixed, that the scanner (or text reader) forbid the use of either "*" or "columns" with other column references.


--
This message was sent by Atlassian JIRA
(v6.3.15#6346)