[
https://issues.apache.org/jira/browse/DRILL-4954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kunal Khatua updated DRILL-4954:
--------------------------------
Reviewer: Abhishek Girish (was: Boaz Ben-Zvi)
[~agirish] Please verify and close.
> 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)
