[jira] [Created] (DRILL-7604) Cannot set session options using REST API / Web UI

["Dobes Vandermeer (Jira)" <ji...@apache.org>]

Dobes Vandermeer created DRILL-7604:
---------------------------------------

             Summary: Cannot set session options using REST API / Web UI
                 Key: DRILL-7604
                 URL: https://issues.apache.org/jira/browse/DRILL-7604
             Project: Apache Drill
          Issue Type: Improvement
          Components: Web Server
    Affects Versions: 1.17.0
            Reporter: Dobes Vandermeer
            Assignee: Dobes Vandermeer


Some commands are configured using session options that you set using the `SET` command.  However, the `SET` command is not useful in the Web UI and REST API because the options you set are not preserved in the next request.  For example, when using CREATE TABLE AS you must `SET store.format csv` to set the output format to comma-separated value, but this is not possible via the REST API.

I propose that the API be updated to support options that are normally provided using SET:
 # The JSON API accepts an object "options" whose keys are options and values are option values.  The values should have an appropriate type for the given option, e.g. JSON boolean if the option type is boolean
 # The form-based API used by the Web UI scans any provided form fields that match a valid session option and sets those options, parsing strings according to the type of option

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)