[
https://issues.apache.org/jira/browse/DRILL-6759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16635723#comment-16635723
]
ASF GitHub Bot commented on DRILL-6759:
---------------------------------------
arina-ielchiieva opened a new pull request #1485: DRILL-6759: Make columns
array name for csv data case insensitive
URL: https://github.com/apache/drill/pull/1485
Details in [DRILL-6759](https://issues.apache.org/jira/browse/DRILL-6759).
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> CSV 'columns' array is incorrectly case sensitive
> -------------------------------------------------
>
> Key: DRILL-6759
> URL: https://issues.apache.org/jira/browse/DRILL-6759
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.14.0
> Reporter: Paul Rogers
> Assignee: Arina Ielchiieva
> Priority: Minor
> Fix For: 1.15.0
>
>
> Perform the following query on a CSV file without column headers:
> {noformat}
> SELECT columns[0] FROM `yourFile.csv`
> {noformat}
> In Drill, column names are supposed to be case insensitive. So, let's try
> upper case:
> {noformat}
> SELECT COLUMNS[0] FROM `yourFile.csv`;
> Error: DATA_READ ERROR: Selected column 'COLUMNS' must have name 'columns' or
> must be plain '*'
> {noformat}
> Expected {{`columns`}} to be case insensitive like other CSV columns and SQL
> keywords.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
