[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14990482#comment-14990482
]
Sudheesh Katkam commented on DRILL-2304:
Yes, value of `store.parquet.compression` option is case insensitive.
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14731214#comment-14731214
]
ASF GitHub Bot commented on DRILL-2304:
---
Github user asfgit closed the pull request at:
https://github.com/apache/drill/pull/90
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14730992#comment-14730992
]
ASF GitHub Bot commented on DRILL-2304:
---
Github user jaltekruse commented on the pull request:
https://github.com/apache/drill/pull/90#issuecomment-13717
+1
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14730066#comment-14730066
]
ASF GitHub Bot commented on DRILL-2304:
---
Github user sudheeshkatkam commented on the pull request:
https://github.com/apache/drill/pull/90#issuecomment-137604942
Passes all unit and regression tests.
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14729356#comment-14729356
]
ASF GitHub Bot commented on DRILL-2304:
---
Github user jaltekruse commented on the pull request:
https://github.com/apache/drill/pull/90#issuecomment-137505054
@sudheeshkatkam I reviewed this change while I was looking at 3497 in #98.
Other than the few small comments over there this looks good.
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14637997#comment-14637997
]
ASF GitHub Bot commented on DRILL-2304:
---
Github user sudheeshkatkam commented on the pull request:
https://github.com/apache/drill/pull/90#issuecomment-123918173
Addressed review comments mentioned on 313c8e3 f33654c
> 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: Sudheesh Katkam
>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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14627188#comment-14627188
]
ASF GitHub Bot commented on DRILL-2304:
---
GitHub user sudheeshkatkam opened a pull request:
https://github.com/apache/drill/pull/90
DRILL-2304: Case sensitivity - system and session options are case sensitive
@jaltekruse please review.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/sudheeshkatkam/drill DRILL-2304
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/90.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #90
commit 313c8e3632fa71a5ed5f62baf1146e8c20f80065
Author: Sudheesh Katkam
Date: 2015-07-14T18:29:56Z
DRILL-2304: Part 1: Documentation for OptionManagers
+ corrected error message in BaseOptionManager
+ use getAdmin in setOption method
commit f33654c7c539863e56958cc1746eded329b73e61
Author: Sudheesh Katkam
Date: 2015-07-14T21:54:16Z
DRILL-2304: Part 2: Manage options with lowercase names
> 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: Sudheesh Katkam
>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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14533133#comment-14533133
]
Jason Altekruse commented on DRILL-2304:
As this isn't really critical for 1.0, I will retract my +1 and we can just fix
that as well with the JIRA later.
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14531733#comment-14531733
]
Sudheesh Katkam commented on DRILL-2304:
Boot options are not registered. The option name or "config paths" are defined
in multiple places (not just ExecConstants, which is usually the case). AFAIK
the configuration file is not validated (names and values). So yes, a fix need
to be applied for names and values.
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14531582#comment-14531582
]
Jason Altekruse commented on DRILL-2304:
[~sudheeshkatkam] Had another thought while I was going to check this in. Do we
have a place where we register the names of valid boot options? Is this
separate from the system options, and does the same fix need to be applied
there?
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14531545#comment-14531545
]
Jason Altekruse commented on DRILL-2304:
+1
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14514923#comment-14514923
]
Jason Altekruse commented on DRILL-2304:
[~sudheeshkatkam] Without any strong opinions on the discussion thread about
this I think we can safely go ahead and lowercase the names when they are
registered. Might be worth logging a message to say that the name is being
converted to lowercase whenever one is not already, this will keep us from
completely ignoring the new options that are specified in the code with capital
letters in their names.
> 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: Sudheesh Katkam
>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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14361083#comment-14361083
]
Jacques Nadeau commented on DRILL-2304:
---
Names should be case insensitive. Values can be case sensitive.
> 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: 0.9.0
>
>
> 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)
[jira] [Commented] (DRILL-2304) Case sensitivity - system and session options are case sensitive
[
https://issues.apache.org/jira/browse/DRILL-2304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14335804#comment-14335804
]
Ramana Inukonda Nagaraj commented on DRILL-2304:
On second thoughts Option values are case insensitive as shown below. So at
least for consistency this sounds like a genuine bug.
{code}
0: jdbc:drill:> alter SESSION set `store.parquet.compression`='GZIP';
+++
| ok | summary |
+++
| true | store.parquet.compression updated. |
+++
1 row selected (0.028 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
>
> 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)
