You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Jason Altekruse (JIRA)" <ji...@apache.org> on 2015/06/30 02:31:06 UTC

[jira] [Comment Edited] (DRILL-3421) Add new outputformat=json

    [ https://issues.apache.org/jira/browse/DRILL-3421?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14606732#comment-14606732 ] 

Jason Altekruse edited comment on DRILL-3421 at 6/30/15 12:30 AM:
------------------------------------------------------------------

I don't know if this is something we want to encourage users to do. We have CREATE TABLE AS, which can be configured to output JSON (by setting `store.format` = 'json'). It is not efficient to use the terminal output to produce any volume of output, especially if you want to save it to a file. There are additional complications that we truncate long values when they are displayed on the command line, which would cause this output to look incorrect. Is there a particular reason why users would need to produce this kind of output from sqlline?


was (Author: jaltekruse):
I don't know if this is something we want to encourage users to do. We have CREATE TABLE AS, which can be configured to output JSON (by setting `store.format` = 'json'). It is not efficient to use the terminal output to produce any volume of output, especially if you want to save it to a file. There are additional complications that we truncate long values when they are displayed on the command line, which would cause this output to look incorrect. Is there a particular version why users would need to produce this kind of output from sqlline?

> Add new outputformat=json
> -------------------------
>
>                 Key: DRILL-3421
>                 URL: https://issues.apache.org/jira/browse/DRILL-3421
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Client - CLI
>    Affects Versions: 1.0.0
>            Reporter: Jim Scott
>            Assignee: Daniel Barclay (Drill)
>
> ouputformat=vertical is nearly a json output format. Adding a json format option here, where the field names are quoted etc.. would make it dead simple to generate json output from query results. 



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