[DRILL-720] LENGTH(string bytea, encoding name) function fails to execute

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.1.0-m1
• Fix Version/s: 0.4.0
• Component/s: Functions - Drill
• Assignee: DrillCommitter
• Reporter: Krystal
• Created: 13/May/14 22:49
• Updated: 19/Jun/14 18:18
• Resolved: 12/Jun/14 16:47

Description

The LENGTH(string bytea, encoding name) function fails with the following error:

select length('\x6170706c65','UTF8') from voter where voter_id=10;

Query failed: org.apache.drill.exec.rpc.RpcException: [error_id: "92a9be62-c2a6-44aa-a0f6-c0185abde201"
endpoint {
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: [lengthUtf8(VARCHAR-REQUIRED)]. Full expression: --UNKNOWN EXPRESSION-.. ]"