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

Drill is not displaying the column when the json has a null value for the column and the file contains a single record

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Minor
    • Resolution: Won't Fix
    • None
    • 0.7.0
    • Storage - JSON
    • None

    Description

      git.commit.id.abbrev=98b208e

      JSON File Used :

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

      Query :

      select * from `temp.json`;
      +------------+
      |     b      |
      +------------+
      | 1          |
      +------------+
      

      However for the below data set it works fine

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

      Query :

      select * from `temp.json`;
      +------------+------------+
      |     b      |     a      |
      +------------+------------+
      | 1          | null       |
      | null       | 1          |
      +------------+------------+
      

      Attachments

        Activity

          People

            Unassigned Unassigned
            rkins Rahul Kumar Challapalli
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: