benj created DRILL-6973:
---------------------------
Summary: Improve --run (ability to run query and get result in a
good format from command line)
Key: DRILL-6973
URL: https://issues.apache.org/jira/browse/DRILL-6973
Project: Apache Drill
Issue Type: Wish
Affects Versions: 1.15.0
Reporter: benj
For a more flexible and minimalist use of DRILL, it would be useful/practical
to have more "options" on the --run part.
* The formatting of the output : the vertical/csv/json/table/xml... are cool
but not simple enough to be simply piped in a shell
* The possibility to display only the last query in the output, or at least
the possibility to not display the output of command like ALTER
SESSION/SYSTEM...
* The formatting of the csv should allow NO QuoteCharacter (in
--csvQuoteCharacter) and why not a possibility to allow QuoteCharacter in terms
of the type or even of the data itself
{noformat}
Currently :
'1','foo','Drill,baby,drill'
Still currently (we can change the QuoteCharacter)
@1@,@foo@,@Drill,baby,drill@
NEW option 1 - With not quote
1,foo,Drill,baby,drill => Ok the third field is problematic here a problem but
it's the responsibility of the user and he can use this option when it's
appropriate
NEW option 2 - function of the type
1,'foo','Drill,baby,drill'
NEW option 3 - function of the data
1,foo,'Drill,baby,drill' => (foo doesn't need quote because it does not contain
a separator or endofline, but the third field contain separator)
{noformat}
* Maybe some other ideas could be taken up from tools like psql
Few improvements of the --run would allow more practical use case in a simple
way
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
