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

Ronald updated DRILL-3999:
--------------------------
    Attachment: The format I want.json
                Drill-CTAS generated file.json

I have attached the file generated by CTAS and the another file shows the 
format in what I want the output to be generated.

> 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
>         Attachments: Drill-CTAS generated file.json, The format I want.json
>
>
> 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)

Reply via email to