[DRILL-6684] Swap sys.options and sys.options_val tables

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.14.0
• Fix Version/s: 1.15.0
• Component/s: Storage - Information Schema
• Labels: doc-complete ready-to-commit
• Assignee: Kunal Khatua
• Reporter: Kunal Khatua
• Reviewer: Arina Ielchiieva
• Created: 13/Aug/18 22:46
• Updated: 10/Dec/18 23:11
• Resolved: 05/Sep/18 18:37

Description

The current sys.options table has a verbose layout, because of which sys.options_internal was introduced. The latter will also support descriptions, which means it makes sense to have that table as the new `sys.options`. The recommendation is to deprecate the old format, so that any dependencies continue to make use of it as long as required.

Issue Links

• is related to: DRILL-3988 Create a sys.functions table to expose available Drill functions
• relates to: DRILL-5735 UI options grouping and filtering & Metrics hints
• links to: GitHub Pull Request #1454