[DRILL-6974] SET option command

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.17.0
• Component/s: SQL Parser
• Labels: doc-impacting ready-to-commit
• Assignee: Dmytriy Grinchenko
• Reporter: benj
• Reviewer: Vova Vysotskyi
• Created: 14/Jan/19 10:28
• Updated: 14/May/19 17:18
• Resolved: 03/May/19 22:48

Description

It's currently possible to define options with the SQL command SET

ALTER SESSION SET `drill.exec.hashagg.fallback.enabled` = true;

But it's not possible to simply visualize the current value of one option with SHOW, we have to query like

SELECT * FROM sys.options WHERE `name` = 'drill.exec.hashagg.fallback.enabled';

Why not allow a simple

SET `drill.exec.hashagg.fallback.enabled`;

Issue Links

• links to: GitHub Pull Request #1763