[
https://issues.apache.org/jira/browse/DRILL-2302?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14335775#comment-14335775
]
Ramana Inukonda Nagaraj commented on DRILL-2302:
------------------------------------------------
Looks like the sys part is case sensitive. Options works fine irrespective of
case.
{code}
0: jdbc:drill:> select * from SYS.options where name like '%parquet%';
Query failed: SqlValidatorException: Table 'SYS.options' not found
0: jdbc:drill:> select * from sys.OPTIons where name like '%parquet%';
+------------+------------+------------+------------+------------+------------+------------+
| name | kind | type | num_val | string_val | bool_val |
float_val |
+------------+------------+------------+------------+------------+------------+------------+
| store.parquet.compression | STRING | SYSTEM | null | snappy
| null | null |
| store.parquet.vector_fill_threshold | LONG | SYSTEM | 85 |
null | null | null |
| store.parquet.use_new_reader | BOOLEAN | SYSTEM | null | null
| false | null |
| store.parquet.block-size | LONG | SYSTEM | 536870912 | null
| null | null |
| store.parquet.vector_fill_check_threshold | LONG | SYSTEM | 10
| null | null | null |
| store.parquet.enable_dictionary_encoding | BOOLEAN | SYSTEM | null
| null | true | null |
| store.parquet.enable_dictionary_encoding | BOOLEAN | SESSION | null
| null | false | null |
| store.parquet.compression | STRING | SESSION | null | GZIP
| null | null |
| store.parquet.use_new_reader | BOOLEAN | SESSION | null | null
| false | null |
+------------+------------+------------+------------+------------+------------+------------+
9 rows selected (0.065 seconds)
{code}
> Case sensitivity - System tables names are case sensitive
> ---------------------------------------------------------
>
> Key: DRILL-2302
> URL: https://issues.apache.org/jira/browse/DRILL-2302
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Information Schema
> Affects Versions: 0.8.0
> Reporter: Ramana Inukonda Nagaraj
> Assignee: Jason Altekruse
> Priority: Minor
>
> {code}
> 0: jdbc:drill:> select * from sys.options where NAME like '%parquet%';
> 0: jdbc:drill:> select * from SYS.OPTIONS where NAME like '%parquet%';
> Query failed: SqlValidatorException: Table 'SYS.OPTIONS' not found
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
