[jira] [Closed] (DRILL-7381) Query to a map field returns nulls with hive native reader

["Anton Gozhiy (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-7381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Anton Gozhiy closed DRILL-7381.
-------------------------------

Verified with Drill 1.17-SNAPSHOT (commit d2645c7638a88a4afd162bc3f1e2d65353ca3a67).

> Query to a map field returns nulls with hive native reader
> ----------------------------------------------------------
>
>                 Key: DRILL-7381
>                 URL: https://issues.apache.org/jira/browse/DRILL-7381
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.17.0
>            Reporter: Anton Gozhiy
>            Assignee: Igor Guzenko
>            Priority: Major
>              Labels: ready-to-commit
>         Attachments: customer_complex.zip
>
>
> *Query:*
> {code:sql}
> select t.c_nation.n_region.r_name from hive.customer_complex t limit 5
> {code}
> *Expected results:*
> {noformat}
> AFRICA
> MIDDLE EAST
> AMERICA
> MIDDLE EAST
> AMERICA
> {noformat}
> *Actual results:*
> {noformat}
> null
> null
> null
> null
> null
> {noformat}
> *Workaround:*
> {code:sql}
> set store.hive.optimize_scan_with_native_readers = false;
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)