Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-5033

Query on JSON that has null as value for each key

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 1.9.0
    • Fix Version/s: None
    • Component/s: Storage - JSON
    • Labels:
      None

      Description

      Drill 1.9.0 git commit ID : 83513daf

      Drill returns same result with or without `store.json.all_text_mode`=true

      Note that each key in the JSON has null as its value.
      [root@cent01 null_eq_joins]# cat right_all_nulls.json
      {
      "intKey" : null,
      "bgintKey": null,
      "strKey": null,
      "boolKey": null,
      "fltKey": null,
      "dblKey": null,
      "timKey": null,
      "dtKey": null,
      "tmstmpKey": null,
      "intrvldyKey": null,
      "intrvlyrKey": null
      }
      [root@cent01 null_eq_joins]#

      Querying the above JSON file results in null as query result.

      • We should see each of the keys in the JSON as a column in query result.
      • And in each column the value should be a null value.
        Current behavior does not look right.
      0: jdbc:drill:schema=dfs.tmp> select * from `right_all_nulls.json`;
      +-------+
      |   *   |
      +-------+
      | null  |
      +-------+
      1 row selected (0.313 seconds)
      

      Adding comment from Julian Hyde

      IMHO it is similar but not the same as DRILL-1256. Worth logging an issue and let Jacques Nadeau (or someone) put on the record what should be the behavior of an empty record (empty JSON map) when it is top-level (as in this case) or in a collection.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                khfaraaz Khurram Faraaz
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: