drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Semenov (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-6974) SET option command
Date Tue, 14 May 2019 17:01:00 GMT

    [ https://issues.apache.org/jira/browse/DRILL-6974?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16839620#comment-16839620
] 

Pavel Semenov commented on DRILL-6974:
--------------------------------------

*Check List*
1) Check  set `drill.exec.hashagg.fallback.enabled` -> shows current value
2) Check set `drill.exec.hashagg.fallback.enabled` = true/false -> updates property value
3) Check show `drill.exec.hashagg.fallback.enabled` ->  should not work
4) Check that it works with different properties 
5) Check ALTER SESSION / SYSTEM options

Verified in master branch on v 1.17.0 . *All cases passed successfully*

> 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
>            Assignee: Dmytriy Grinchenko
>            Priority: Major
>              Labels: doc-impacting, ready-to-commit
>             Fix For: 1.17.0
>
>
> 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}
> SET `drill.exec.hashagg.fallback.enabled`;
> {code}



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

Mime
View raw message