Boaz Ben-Zvi created DRILL-4954: ----------------------------------- Summary: allTextMode in the MapRDB plugin always return nulls Key: DRILL-4954 URL: https://issues.apache.org/jira/browse/DRILL-4954 Project: Apache Drill Issue Type: Bug Components: Storage - MapRDB Affects Versions: 1.8.0 Environment: MapRDB Reporter: Boaz Ben-Zvi Assignee: Smidth Panchamia Fix For: 1.9.0
Setting the "allTextMode" option to "true" in the MapR fs plugin, like: "formats": { "maprdb": { "type": "maprdb", "allTextMode": true } makes the returned results null. Here’s an example: << default plugin, unchanged >> 0: jdbc:drill:> use mfs.tpch_sf1_maprdb_json; +-------+--------------------------------------------------------+ | ok | summary | +-------+--------------------------------------------------------+ | true | Default schema changed to [mfs1.tpch_sf1_maprdb_json] | +-------+--------------------------------------------------------+ 1 row selected (0.153 seconds) 0: jdbc:drill:> select typeof(N_REGIONKEY) from nation limit 1; +---------+ | EXPR$0 | +---------+ | BIGINT | +---------+ 1 row selected (0.206 seconds) 0: jdbc:drill:> select N_REGIONKEY from nation limit 2; +--------------+ | N_REGIONKEY | +--------------+ | 0 | | 2 | +--------------+ 2 rows selected (0.254 seconds) << plugin changed to all text mode (as shown above) >> 0: jdbc:drill:> select typeof(N_REGIONKEY) from nation limit 1; +---------+ | EXPR$0 | +---------+ | NULL | +---------+ 1 row selected (0.321 seconds) 0: jdbc:drill:> select N_REGIONKEY from nation limit 2; +--------------+ | N_REGIONKEY | +--------------+ | null | | null | +--------------+ 2 rows selected (0.25 seconds) -- This message was sent by Atlassian JIRA (v6.3.4#6332)