drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aditya Kishore (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-807) convert function from varchar to UTF16 failed
Date Fri, 23 May 2014 06:51:01 GMT

    [ https://issues.apache.org/jira/browse/DRILL-807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14006923#comment-14006923
] 

Aditya Kishore commented on DRILL-807:
--------------------------------------

Please close this bug as invalid.

> 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)

Mime
View raw message