You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Paul Rogers (JIRA)" <ji...@apache.org> on 2017/05/30 00:25:04 UTC
[jira] [Commented] (DRILL-5556) Drill allows "SELECT *, *" query
[ https://issues.apache.org/jira/browse/DRILL-5556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16028676#comment-16028676 ]
Paul Rogers commented on DRILL-5556:
------------------------------------
Do the same query on a CSV file with headers. The entire column list is repeated.
File:
{code}
a,b,c
10,foo,bar
{code}
Query:
{code}
SELECT *, * FROM `dfs.data`.`headers.csv`
{code}
Results:
{code}
1 row(s):
a,b,c,a0,b0,c0
10,foo,bar,10,foo,bar
{code}
Again, expected an error.
> Drill allows "SELECT *, *" query
> --------------------------------
>
> Key: DRILL-5556
> URL: https://issues.apache.org/jira/browse/DRILL-5556
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.10.0
> Reporter: Paul Rogers
> Priority: Minor
>
> Configure the CSV storage plugin to not read the header row. Create a simple CSV file:
> {code}
> 10,foo,bar
> {code}
> Issue the following nonsensical query:
> {code}
> SELECT *, * FROM `dfs.data`.`example.csv`
> {code}
> Get the following results:
> {code}
> columns,columns0
> ["10","foo","bar"],["10","foo","bar"]
> {code}
> Expected an error as using two unqualified *'s is not valid SQL.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)