[DRILL-2623] Expose only "productized" system/session configuration parameters

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: Future
• Component/s: Execution - Flow
• Assignee: Unassigned
• Reporter: Victoria Markman
• Created: 30/Mar/15 16:16
• Updated: 01/Oct/15 16:37

Description

This is an enhancement request to expose only well tested and useful parameters to the end user.
For example, we don't want to allow all users to change internal configuration parameters, like exec.min_hash_table_size or enable features that are not ready for prime time ( store.parquet.enable_dictionary_encoding for example).
However, sometimes in order to achieve optimal performace some configuration fiddling will be absolutely necessary. We can allow different users with different privileges have an ability to change settings.

One of the proposals to achieve this is to create a view on top of sys.options that will be created on drills start up and have privileged access
a) to the information in the view - show only things that particular user is allowed to see
b) have privileged access to "ALTER SYSTEM/SESSION" commands.

Issue Links

• relates to: DRILL-3622 With user authentication enabled, only admin users should be able to change system options