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] [Created] (DRILL-4954) allTextMode in the MapRDB plugin always return nulls
Date Thu, 20 Oct 2016 17:50:58 GMT
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)

Mime
View raw message