[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive

["Jason Altekruse (JIRA)" <ji...@apache.org>]

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

Jason Altekruse commented on DRILL-2304:
----------------------------------------

do we also need to make the option names lower case when we register them? We have only used lower case so far, but we should probably either complain when we try to register something with capitalization or just automatically lowercase everything.

In other parts of drill we have the idea that we are 'case-preserving but case-insensitive' to allow for pushdown into case-sensitive systems like Hbase.

I don't think this property has any reason to need to be held for the option values, maybe you should just throw something on the dev list to ask about it quickly

> Case sensitivity - system and session options are case sensitive
> ----------------------------------------------------------------
>
>                 Key: DRILL-2304
>                 URL: https://issues.apache.org/jira/browse/DRILL-2304
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - Information Schema
>    Affects Versions: 0.8.0
>            Reporter: Ramana Inukonda Nagaraj
>            Assignee: Jason Altekruse
>            Priority: Minor
>             Fix For: 1.0.0
>
>         Attachments: DRILL-2304.1.patch.txt
>
>
> TBH I am not sure if this is a bug. 
> When trying to set a session option and I specify the name in a different case the alter command fails. Considering the way we store session options this might be an invalid bug but considering how typical Database hints and options work this is a bug.
> {code}
> 0: jdbc:drill:> alter SESSION  set `STORE.PARQUET.COMPRESSION`='GZIP';
> Query failed: SetOptionException: Unknown option: STORE.PARQUET.COMPRESSION
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)