Paul Rogers created DRILL-6759:
----------------------------------
Summary: 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
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)
