drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2434) Drill Web UI must support configuring formats for writing data
Date Wed, 11 Mar 2015 20:48:38 GMT
Abhishek Girish created DRILL-2434:
--------------------------------------

             Summary: Drill Web UI must support configuring formats for writing data
                 Key: DRILL-2434
                 URL: https://issues.apache.org/jira/browse/DRILL-2434
             Project: Apache Drill
          Issue Type: Improvement
          Components: Client - HTTP
    Affects Versions: 0.8.0
            Reporter: Abhishek Girish
            Assignee: Jason Altekruse
            Priority: Minor


Currently the Storage section on the Drill web user interface provides a way to configure
file formats which Drill can support reading from and also configure workspaces with a defaultInputFormat.


Example:
{code}
...
"workspaces": {
    ...
    "tmp": {
      "location": "/tmp",
      "writable": true,
      "defaultInputFormat": "csv"
    }
    ...
,
  "formats": {
    ...
    "parquet": {
      "type": "parquet"
    },
    "json": {
      "type": "json"
    }
    ...
{code}

Drill must also provide a way to configure the default storage formats per workspace for writing
data (using CTAS statements). Possibly via an optional field "defaultOutputFormat":

{code}
"customer": {
      "location": "/data/customer",
      "writable": true,
      "defaultInputFormat": "json", 
      "defaultOutputFormat": "json"
    }
{code}

This would make it convenient and also clear as to what the CTAS command would write into.

 
At present the only way to do this is via altering system options using Sqlline as follows:
{code}
alter session set `store.format` = 'json|parquet|...'
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message