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)
