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

Query to a map field returns nulls with hive native reader

    XMLWordPrintableJSON

Details

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

    Description

      Query:

      select t.c_nation.n_region.r_name from hive.customer_complex t limit 5
      

      Expected results:

      AFRICA
      MIDDLE EAST
      AMERICA
      MIDDLE EAST
      AMERICA
      

      Actual results:

      null
      null
      null
      null
      null
      

      Workaround:

      set store.hive.optimize_scan_with_native_readers = false;
      

      Attachments

        1. customer_complex.zip
          2.56 MB
          Anton Gozhiy

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: