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

        Luca Morandini created issue -
        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?
        Jacques Nadeau made changes -
        Field Original Value New Value
        Assignee Suresh Ollala [ sollala_drill ]
        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?
        Suresh Ollala made changes -
        Assignee Suresh Ollala [ sollala_drill ] Ramana Inukonda Nagaraj [ inramana ]
        Jacques Nadeau made changes -
        Fix Version/s 0.5.0 [ 12324880 ]
        Jacques Nadeau made changes -
        Fix Version/s 0.6.0 [ 12327472 ]
        Fix Version/s 0.5.0 [ 12324880 ]
        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>
        Jacques Nadeau made changes -
        Fix Version/s 0.7.0 [ 12327473 ]
        Fix Version/s 0.6.0 [ 12327472 ]
        Jacques Nadeau made changes -
        Fix Version/s 0.8.0 [ 12328812 ]
        Fix Version/s 0.7.0 [ 12327473 ]
        Jacques Nadeau made changes -
        Status Open [ 1 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        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
        Tony Stevenson made changes -
        Workflow no-reopen-closed, patch-avail, testing [ 12881967 ] Drill workflow [ 12935128 ]

          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