[
https://issues.apache.org/jira/browse/DRILL-6684?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16599060#comment-16599060
]
ASF GitHub Bot commented on DRILL-6684:
---------------------------------------
kkhatua commented on issue #1454: DRILL-6684: Swap sys.options and
sys.options_val tables
URL: https://github.com/apache/drill/pull/1454#issuecomment-417736737
@kfaraaz
The existing `sys.options` table is very verbose because of multiple
'datatype_val' columns (all except one will be alway null). Injecting a
descriptions column breaks the visual formatting within SQLLine.
The existing `sys.options_val` is better representative of the options. For
usability sake, we are renaming the latter table as `sys.options` , while the
old table becomes `sys.options_old`. So, both tables will still be available.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
> Swap sys.options and sys.options_val tables
> -------------------------------------------
>
> Key: DRILL-6684
> URL: https://issues.apache.org/jira/browse/DRILL-6684
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Information Schema
> Affects Versions: 1.14.0
> Reporter: Kunal Khatua
> Assignee: Kunal Khatua
> Priority: Minor
> Fix For: 1.15.0
>
>
> The current sys.options table has a verbose layout, because of which
> sys.options_internal was introduced. The latter will also support
> descriptions, which means it makes sense to have that table as the new
> `sys.options`. The recommendation is to deprecate the old format, so that any
> dependencies continue to make use of it as long as required.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
