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)
