[DRILL-1065] Provide a reset command to reset an option to its default value

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.3.0
• Component/s: Execution - Flow
• Assignee: Sudheesh Katkam
• Reporter: Aman Sinha
• Created: 24/Jun/14 22:50
• Updated: 04/Nov/15 18:45
• Resolved: 09/Oct/15 22:15

Description

Within a session, currently we set configuration options and it would be very useful to have a 'reset' command to reset the value of an option to its default system value:
ALTER SESSION RESET <option name>

If we don't want to add a new keyword for RESET, we could potentially overload the SET command and allow the user to set to the 'default' value.

Issue Links

• depends upon: CALCITE-823 Parser support to reset an option