[ https://issues.apache.org/jira/browse/DRILL-4954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kunal Khatua updated DRILL-4954: -------------------------------- Reviewer: Abhishek Girish (was: Boaz Ben-Zvi) [~agirish] Please verify and close. > 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)