You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@drill.apache.org by "benj (JIRA)" <ji...@apache.org> on 2019/01/14 10:29:00 UTC

[jira] [Created] (DRILL-6974) SET/SHOW

benj created DRILL-6974:
---------------------------

             Summary: SET/SHOW
                 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


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)