[
https://issues.apache.org/jira/browse/DRILL-807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14005419#comment-14005419
]
Aditya Kishore commented on DRILL-807:
--------------------------------------
Is the data in UTF16 format? From the error message it does not seem so.
> 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)
