[jira] [Updated] (DRILL-6974) SET option command

["Arina Ielchiieva (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-6974?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Arina Ielchiieva updated DRILL-6974:
------------------------------------
    Summary: SET option command  (was: SET/SHOW)

> SET option command
> ------------------
>
>                 Key: DRILL-6974
>                 URL: https://issues.apache.org/jira/browse/DRILL-6974
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: SQL Parser
>    Affects Versions: 1.15.0
>            Reporter: benj
>            Priority: Major
>
> It's currently possible to define options with the SQL command SET
> {code:java}
> ALTER SESSION SET `drill.exec.hashagg.fallback.enabled` = true;
> {code}
> But it's not possible to simply visualize the current value of one option with SHOW, we have to query like
> {code:java}
> SELECT * FROM sys.options WHERE `name` = 'drill.exec.hashagg.fallback.enabled';
> {code}
> Why not allow a simple
> {code:java}
> SHOW 'drill.exec.hashagg.fallback.enabled';
> {code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)