[
https://issues.apache.org/jira/browse/DRILL-807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14005384#comment-14005384
]
Chun Chang commented on DRILL-807:
----------------------------------
stack trace:
org.apache.drill.exec.exception.SchemaChangeException: Failure while trying to
materialize incoming schema. Errors:
Error in expression at index -1. Error: Missing function implementation:
[castVAR16CHAR(VARBINARY-OPTIONAL, BIGINT-REQUIRED)]. Full expression:
--UNKNOWN EXPRESSION--..
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.setupNewSchema(ProjectRecordBatch.java:198)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.record.AbstractSingleRecordBatch.next(AbstractSingleRecordBatch.java:57)
~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.next(ProjectRecordBatch.java:83)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.validate.IteratorValidatorBatchIterator.next(IteratorValidatorBatchIterator.java:111)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.next(ScreenCreator.java:80)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:104)
[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[na:1.7.0_45]
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[na:1.7.0_45]
java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]
> convert function from varchar to UTF16 failed
> ---------------------------------------------
>
> Key: DRILL-807
> URL: https://issues.apache.org/jira/browse/DRILL-807
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Operators
> Reporter: Chun Chang
> Assignee: Aditya Kishore
>
> convert varchar to/from UTF16 failed with missing function implementation.
> same query convert to/from UTF8 worked.
> 0: jdbc:drill:schema=dfs> select c_row, c_varchar,
> convert_from(convert_to(c_varchar, 'UTF16'), 'UTF16') from data;
> Query failed: org.apache.drill.exec.rpc.RpcException: [error_id:
> "6cb3f087-1abe-4f64-a649-843b7f2a3f79"
> endpoint {
> address: "qa-node117.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Screen received stop request sent. < SchemaChangeException:[
> Failure while trying to materialize incoming schema. Errors:
> Error in expression at index -1. Error: Missing function implementation:
> [castVAR16CHAR(VARBINARY-OPTIONAL, BIGINT-REQUIRED)]. Full expression:
> --UNKNOWN EXPRESSION--.. ]"
> ]
> Error: exception while executing query (state=,code=0)
> UTF8 worked:
> 0: jdbc:drill:schema=dfs> select c_row, cast(c_varchar as varchar(10)),
> convert_from(convert_to(c_varchar, 'UTF8'), 'UTF8') from data;
> +------------+------------+------------+
> | c_row | EXPR$1 | EXPR$2 |
> +------------+------------+------------+
> | 1 | hi, this i | hi, this is a string. |
> | 2 | hi, this i | hi, this is another string. |
--
This message was sent by Atlassian JIRA
(v6.2#6252)
