[
https://issues.apache.org/jira/browse/DRILL-6944?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Igor Guzenko updated DRILL-6944:
--------------------------------
Description:
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}
*UPDATE*
This issue may be reproduced also when avro files with map columns are queried
using Drill. Appropriate test was added to PR commit.
was:
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}
> 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}
> *UPDATE*
> This issue may be reproduced also when avro files with map columns are
> queried using Drill. Appropriate test was added to PR commit.
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
