[DRILL-6944] UnsupportedOperationException thrown for view over MapR-DB binary table

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.15.0
• Fix Version/s: 1.16.0
• Component/s: Execution - Data Types, Storage - MapRDB
• Labels: ready-to-commit
• Assignee: Igor Guzenko
• Reporter: Igor Guzenko
• Reviewer: Vitalii Diravka
• Created: 03/Jan/19 11:50
• Updated: 18/Jan/19 18:28
• Resolved: 18/Jan/19 18:25

Description

1. Create MapR-DB binary table and put some data using HBase shell:

hbase shell
create '/tmp/bintable','name','address'
put '/tmp/bintable','100','name:first_name','john'
put '/tmp/bintable','100','name:last_name','doe'
put '/tmp/bintable','100','address:city','Newark'
put '/tmp/bintable','100','address:state','nj'
scan '/tmp/bintable'

2. Drill config: ensure that dfs storage plugin has "connection": "maprfs:///" and contains format: 

"maprdb": {
"type": "maprdb",
"allTextMode": true,
"enablePushdown": false,
"disableCountOptimization": true
}

3. Check that table can be selected from Drill : 

select * from dfs.`/tmp/bintable`;

4. Create Drill view 

create view dfs.tmp.`testview` as select * from dfs.`/tmp/bintable`;

5. Query the view results into exception:

0: jdbc:drill:> select * from dfs.tmp.`testview`;
Error: SYSTEM ERROR: UnsupportedOperationException: Unable to convert cast expression CastExpression [input=`address`, type=minor_type: MAP
mode: REQUIRED
] into string.


Please, refer to logs for more information.

[Error Id: 109acd00-7456-4a74-8a17-485f8999000f on node1.cluster.com:31010] (state=,code=0)

UPDATE

This issue may be reproduced also when avro files with map columns are queried using Drill. Appropriate test was added to PR commit. 

 

Issue Links

• links to: GitHub Pull Request #1602