[DRILL-4954] allTextMode in the MapRDB plugin always return nulls

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.8.0
• Fix Version/s: 1.9.0
• Component/s: Storage - MapRDB

Environment

MapRDB

• Assignee: Smidth Panchamia
• Reporter: Boaz Ben-Zvi
• Reviewer: Abhishek Girish
• Created: 20/Oct/16 17:50
• Updated: 19/Apr/17 17:20
• Resolved: 25/Oct/16 01:20

Description

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)

Issue Links

• links to: GitHub Pull Request #624