[DRILL-1284] Better documentation describing the accepted JSON data input

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.4.0
• Fix Version/s: 0.8.0
• Component/s: Documentation
• Assignee: Ramana Inukonda Nagaraj
• Reporter: Luca Morandini
• Created: 11/Aug/14 22:22
• Updated: 11/Sep/15 18:40
• Resolved: 04/Jan/15 21:26

Description

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:

1. The accepted JSON input format (single Objects describeing tuples, every one of them in a single line, with no separator between lines);
2. The homogeneous Arrays constraint: only elements of the same type are accepted in a JSON array in Drill;
3. 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