[jira] [Created] (DRILL-6944) UnsupportedOperationException thrown for view over MapR-DB binary table

["Igor Guzenko (JIRA)" <ji...@apache.org>]

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)