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

Projection drops column in select * query with json files containing nulls

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 0.7.0
    • Future
    • Client - CLI
    • None

    Description

      With the following data -

      st_1.json -

      {"a":"xyzzy", "b":null}

      st_2.json -

      {"a":"xyzzy", "b":"You are inside a building, a well house for a large spring."}

      select a,b from st_*.json - returns both a and b.

      select * from st_*.json - returns only column a.

      Attachments

        1. st_2.json
          0.1 kB
          Parth Chandra
        2. st_1.json
          0.0 kB
          Parth Chandra

        Activity

          People

            Unassigned Unassigned
            parthc Parth Chandra
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: