[
https://issues.apache.org/jira/browse/DRILL-1438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14140675#comment-14140675
]
Krystal commented on DRILL-1438:
--------------------------------
0: jdbc:drill:schema=M7> select substr(convert_from(t.onecf.name, 'UTF8'), 5,
8) from m7voter t where t.twocf.age < 20;
Query failed: Failure due to uncaught exception Encountered an illegal char on
line 1, column 28: '' [a0dbc5f0-3fbc-46ec-a246-d848f0759cdd]
0: jdbc:drill:schema=M7> explain plan for select
substr(convert_from(t.onecf.name, 'UTF8'), 5, 8) from m7voter t where
t.twocf.age < 20;
+------------+------------+
| text | json |
+------------+------------+
| 00-00 Screen
00-01 UnionExchange
01-01 Project(EXPR$0=[SUBSTR(CONVERT_FROM($0, 'UTF8'), 5, 8)])
01-02 SelectionVectorRemover
01-03 Filter(condition=[<($1, 20)])
01-04 Project(ITEM=[ITEM($1, 'name')], ITEM1=[ITEM($0, 'age')])
01-05 ProducerConsumer
01-06 Scan(groupscan=[HBaseGroupScan
[HBaseScanSpec=HBaseScanSpec [tableName=m7voter, startRow=null, stopRow=null,
filter=null], columns=[SchemaPath [`onecf`.`name`], SchemaPath
[`twocf`.`age`]]]])
| {
"head" : {
"version" : 1,
"generator" : {
"type" : "ExplainHandler",
"info" : ""
},
"type" : "APACHE_DRILL_PHYSICAL",
"options" : [ ],
"queue" : 0,
"resultMode" : "EXEC"
},
"graph" : [ {
"pop" : "hbase-scan",
"@id" : 65542,
"hbaseScanSpec" : {
"tableName" : "m7voter",
"startRow" : "",
"stopRow" : "",
"serializedFilter" : null
},
"storage" : {
"type" : "hbase",
"config" : {
"hbase.table.namespace.mappings" : "*:/test/tables"
},
"size.calculator.enabled" : false,
"enabled" : true
},
"columns" : [ "`onecf`.`name`", "`twocf`.`age`" ],
"cost" : 1.048576E7
}, {
"pop" : "producer-consumer",
"@id" : 65541,
"child" : 65542,
"size" : 10,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 1.048576E7
}, {
"pop" : "project",
"@id" : 65540,
"exprs" : [ {
"ref" : "`ITEM`",
"expr" : "`onecf`.`name`"
}, {
"ref" : "`ITEM1`",
"expr" : "`twocf`.`age`"
} ],
"child" : 65541,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 1.048576E7
}, {
"pop" : "filter",
"@id" : 65539,
"child" : 65540,
"expr" : "less_than(`ITEM1`, 20) ",
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 5242880.0
}, {
"pop" : "selection-vector-remover",
"@id" : 65538,
"child" : 65539,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 5242880.0
}, {
"pop" : "project",
"@id" : 65537,
"exprs" : [ {
"ref" : "`EXPR$0`",
"expr" : "substr(convert_from(`ITEM`, \"UTF8\"), 5, 8) "
} ],
"child" : 65538,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 5242880.0
}, {
"pop" : "union-exchange",
"@id" : 1,
"child" : 65537,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 5242880.0
}, {
"pop" : "screen",
"@id" : 0,
"child" : 1,
"initialAllocation" : 1000000,
"maxAllocation" : 10000000000,
"cost" : 5242880.0
} ]
} |
> hbase queries fail with illegal char error
> ------------------------------------------
>
> Key: DRILL-1438
> URL: https://issues.apache.org/jira/browse/DRILL-1438
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - HBase
> Reporter: Krystal
> Attachments: server.log
>
>
> git.commit.id.abbrev=f8d38b6
> The following queries failed:
> 0: jdbc:drill:schema=M7> select substr(convert_from(onecf['name'], 'UTF8'),
> 5, 8) from m7voter where twocf['age'] < 20;
> Query failed: Failure due to uncaught exception Encountered an illegal char
> on line 1, column 28: '' [d613298d-f3c5-4b8a-b939-689ec599fafd]
> 0: jdbc:drill:schema=M7> select concat(cast(twocf['age'] as
> integer),convert_from(onecf['name'], 'UTF8'),cast(twocf['registration'] as
> varchar(20)),cast(threecf['contributions'] as decimal(6,2))) from m7voter
> where row_key=102;
> Query failed: Failure due to uncaught exception Encountered an illegal char
> on line 1, column 69: '' [a165aa5b-b454-4085-8f62-95e190e99f21]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
