Igor Guzenko created DRILL-6944: ----------------------------------- Summary: UnsupportedOperationException thrown for view over MapR-DB binary table Key: DRILL-6944 URL: https://issues.apache.org/jira/browse/DRILL-6944 Project: Apache Drill Issue Type: Bug Components: Execution - Data Types, Storage - MapRDB Affects Versions: 1.15.0 Reporter: Igor Guzenko Assignee: Igor Guzenko Fix For: 1.16.0
1. Create MapR-DB binary table and put some data using HBase shell: {code:none} 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' {code} 2. Drill config: ensure that dfs storage plugin has "connection": "maprfs:///" and contains format: {code:java} "maprdb": { "type": "maprdb", "allTextMode": true, "enablePushdown": false, "disableCountOptimization": true } {code} 3. Check that table can be selected from Drill : {code:java} select * from dfs.`/tmp/bintable`; {code} 4. Create Drill view {code:java} create view dfs.tmp.`testview` as select * from dfs.`/tmp/bintable`; {code} 5. Query the view results into exception: {code:java} 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) {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)