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

Query of a field inside of an array of structs returns null

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.17.0
    • None
    • None

    Description

      Query:

      select t.c_orders[0].o_orderstatus from hive.customer_complex t limit 10;
      

      Expected results (given from Hive):

      OK
      O
      F
      NULL
      O
      O
      NULL
      O
      O
      NULL
      F
      

      Actual results:

      null
      null
      null
      null
      null
      null
      null
      null
      null
      null
      

      Attachments

        1. customer_complex.zip
          2.56 MB
          Anton Gozhiy

        Issue Links

          Activity

            People

              ihuzenko Igor Guzenko
              angozhiy Anton Gozhiy
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: