Apache Drill
  1. Apache Drill
  2. DRILL-1284

Better documentation describing the accepted JSON data input

    Details

    • Type: Improvement Improvement
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.4.0
    • Fix Version/s: 0.8.0
    • Component/s: Documentation
    • Labels:
      None

      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

        Activity

        Hide
        Bob Rumsby added a comment -

        I will update the documentation for the 0.5 release.

        Show
        Bob Rumsby added a comment - I will update the documentation for the 0.5 release.
        Hide
        Jacques Nadeau added a comment -

        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. Suresh Ollala, can you please verify this?

        Show
        Jacques Nadeau added a comment - 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. Suresh Ollala , can you please verify this?
        Hide
        Suresh Ollala added a comment -

        Ramana, can you please verify the behavior?

        Show
        Suresh Ollala added a comment - Ramana, can you please verify the behavior?
        Hide
        Bob Rumsby added a comment -

        Why is this assigned to Ramana? See previous comments.

        Bob

        On Sun, Aug 31, 2014 at 10:40 AM, Jacques Nadeau (JIRA) <jira@apache.org>

        Show
        Bob Rumsby added a comment - Why is this assigned to Ramana? See previous comments. Bob On Sun, Aug 31, 2014 at 10:40 AM, Jacques Nadeau (JIRA) <jira@apache.org>
        Hide
        Kristine Hahn added a comment -

        A request for this topic has surfaced in the doc plan for the next release. I think the request came from Product Management. Jacques, ok to describe the accepted JSON data input?
        cc: Jason Altekruse

        Show
        Kristine Hahn added a comment - A request for this topic has surfaced in the doc plan for the next release. I think the request came from Product Management. Jacques , ok to describe the accepted JSON data input? cc: Jason Altekruse

          People

          • Assignee:
            Ramana Inukonda Nagaraj
            Reporter:
            Luca Morandini
          • Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development