[
https://issues.apache.org/jira/browse/DRILL-1284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14093699#comment-14093699
]
Jacques Nadeau commented on DRILL-1284:
---------------------------------------
Slight updates:
(1) we should support a single record over many lines. The record separator is
}\W{
(3) This should work fine and shouldn't need to be documented. If it does not,
this is a bug. [~sollala_drill], can you please verify this?
> Better documentation describing the accepted JSON data input
> ------------------------------------------------------------
>
> Key: DRILL-1284
> URL: https://issues.apache.org/jira/browse/DRILL-1284
> Project: Apache Drill
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 0.4.0
> Reporter: Luca Morandini
>
> Since JSON data input can be very diversified, and Drill, so far, accepts
> only tuples defined in one mongimport format, it would be useful to have this
> clearly spelled out in the documentation.
> This improvement to the documentation should stress:
> # The accepted JSON input format (single Objects describeing tuples, every
> one of them in a single line, with no separator between lines);
> # The homogeneous Arrays constraint: only elements of the same type are
> accepted in a JSON array in Drill;
> # The need to address a single element of a JSON array in a Drill SQL query:
> {{SELECT foo\[2\] FROM bar.json}} is accepted, {{SELECT foo FROM bar.json}}
> is not
--
This message was sent by Atlassian JIRA
(v6.2#6252)
