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

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.17.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:

      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

            • Assignee:
              IhorHuzenko Igor Guzenko
              Reporter:
              angozhiy Anton Gozhiy
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: