You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Chun Chang (JIRA)" <ji...@apache.org> on 2014/05/22 01:26:38 UTC

[jira] [Commented] (DRILL-807) convert function from varchar to UTF16 failed

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