You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sudheesh Katkam (JIRA)" <ji...@apache.org> on 2016/10/25 01:21:58 UTC
[jira] [Resolved] (DRILL-4954) allTextMode in the MapRDB plugin
always return nulls
[ https://issues.apache.org/jira/browse/DRILL-4954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Sudheesh Katkam resolved DRILL-4954.
------------------------------------
Resolution: Fixed
Fixed in [4efc9f2|https://github.com/apache/drill/commit/4efc9f248ef7ef4b86660a1a73a9f44662c082ba]
> 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)