[
https://issues.apache.org/jira/browse/DRILL-6973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16747926#comment-16747926
]
Arina Ielchiieva commented on DRILL-6973:
-----------------------------------------
{quote}
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...
{quote}
Output for DML commands can be controlled via
{{exec.query.return_result_set_for_ddl}} option.
> 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
> Priority: Major
>
> 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)
