[jira] [Commented] (DRILL-302) Column name in parquet is case-sensitive

["Julian Hyde (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13826792#comment-13826792 ] 

Julian Hyde commented on DRILL-302:
-----------------------------------

> which is different from SQL where query is case-insensitive.

FYI, Optiq is case-sensitive. See https://groups.google.com/forum/#!topic/optiq-dev/VF8f8HWP-9g

> Column name in parquet is case-sensitive 
> -----------------------------------------
>
>                 Key: DRILL-302
>                 URL: https://issues.apache.org/jira/browse/DRILL-302
>             Project: Apache Drill
>          Issue Type: Wish
>            Reporter: Jinfeng Ni
>            Priority: Minor
>
> Currently, column name in parquet is case-sensitive, which is different from SQL where query is case-insensitive.
> For instance,  the following query will fail on drill: 
> Select  _MAP['n_name'] AS N_NAME from "nation";
> The following query is fine:
> Select  _MAP['N_NAME'] AS N_NAME from "nation";
> If we want to follow SQL, then it would be nice to make parquet column name case-insensitive as well.
>  



--
This message was sent by Atlassian JIRA
(v6.1#6144)