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

Posted to issues@drill.apache.org by "Ronald (JIRA)" <ji...@apache.org> on 2015/10/31 20:54:27 UTC

[jira] [Updated] (DRILL-3999) Provide an option in CTAS command to generate the JSON output as an array instead of normal JSON objects which are currently without commas.

     [ https://issues.apache.org/jira/browse/DRILL-3999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ronald updated DRILL-3999:
--------------------------
    Description: 
I am generating a JSON output from hundreds of CSV files. However, the JSON output doesn't have an array format. Instead, it just generates the sequence of objects. I am unable to use this generated file in other libraries like CrossFilter, D3 etc to manipulate the data or generate charts since all those libraries expect JSON to be in a comma separated, array styled file.

I have attached the sample JSON which was generated. I want to add comma after each object and also a single square bracket which would denote it as a single array. Please let me know if there are any ways which are already available to do this using CTAS.

> Provide an option in CTAS command to generate the JSON output as an array instead of normal JSON objects which are currently without commas.
> --------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-3999
>                 URL: https://issues.apache.org/jira/browse/DRILL-3999
>             Project: Apache Drill
>          Issue Type: Wish
>            Reporter: Ronald
>            Priority: Minor
>
> I am generating a JSON output from hundreds of CSV files. However, the JSON output doesn't have an array format. Instead, it just generates the sequence of objects. I am unable to use this generated file in other libraries like CrossFilter, D3 etc to manipulate the data or generate charts since all those libraries expect JSON to be in a comma separated, array styled file.
> I have attached the sample JSON which was generated. I want to add comma after each object and also a single square bracket which would denote it as a single array. Please let me know if there are any ways which are already available to do this using CTAS.



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