[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14990430#comment-14990430
]
Khurram Faraaz commented on DRILL-2304:
---------------------------------------
Can you please review if this is the expected behavior ?, I see that Jacques
commented that "Names should be case insensitive. Values can be case
sensitive.". In one of the case below value (gzip) is also case insensitive, is
this intended ?
{code}
0: jdbc:drill:schema=dfs.tmp> ALTER SESSION SET
`store.parquet.compression`='gzip';
+-------+-------------------------------------+
| ok | summary |
+-------+-------------------------------------+
| true | store.parquet.compression updated. |
+-------+-------------------------------------+
1 row selected (0.334 seconds)
0: jdbc:drill:schema=dfs.tmp> ALTER SESSION SET
`store.parquet.compression`='GZIP';
+-------+-------------------------------------+
| ok | summary |
+-------+-------------------------------------+
| true | store.parquet.compression updated. |
+-------+-------------------------------------+
1 row selected (0.322 seconds)
0: jdbc:drill:schema=dfs.tmp> ALTER SESSION SET
`STORE.PARQUET.COMPRESSION`='GZIP';
+-------+-------------------------------------+
| ok | summary |
+-------+-------------------------------------+
| true | STORE.PARQUET.COMPRESSION updated. |
+-------+-------------------------------------+
1 row selected (0.287 seconds)
0: jdbc:drill:schema=dfs.tmp> ALTER SESSION SET
`STORE.PARQUET.COMPRESSION`='gzip';
+-------+-------------------------------------+
| ok | summary |
+-------+-------------------------------------+
| true | STORE.PARQUET.COMPRESSION updated. |
+-------+-------------------------------------+
1 row selected (0.274 seconds)
{code}
> 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.2.0
>
> Attachments: DRILL-2304.1.patch.txt, DRILL-2304.2.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)
