[ https://issues.apache.org/jira/browse/DRILL-6944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Arina Ielchiieva updated DRILL-6944: ------------------------------------ Reviewer: Vitalii Diravka > 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 > Priority: Major > 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)