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

Query on complex json is returning nulls

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Invalid
    • None
    • 0.6.0
    • None
    • None

    Description

      The query
      select `trans_id`, `date`, `time`, `user_info.cust_id`, `user_info.device`, `trans_info.prod_id` from dfs.`mobile-small.json`

      returns null for the columns that are part of complex data.

      The query
      select `trans_id`, `date`, `time`, `user_info`, `trans_info` from dfs.`mobile-small.json`

      returns data correctly.

      Attachments

        1. mobile-small.json
          4.65 MB
          Parth Chandra

        Activity

          People

            jaltekruse Jason Altekruse
            parthc Parth Chandra
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: