drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Boaz Ben-Zvi (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-4954) allTextMode in the MapRDB plugin always return nulls
Date Thu, 20 Oct 2016 17:53:58 GMT

    [ https://issues.apache.org/jira/browse/DRILL-4954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15592496#comment-15592496
] 

Boaz Ben-Zvi commented on DRILL-4954:
-------------------------------------

 PR624 :

Here is my pull request:
https://github.com/apache/drill/pull/624/commits/97d98337b014e1f605b3c01eeebaf27118b1318e

I verified it locally.

--
Smidth


> 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)

Mime
View raw message