[DRILL-2935] Casting varchar to varbinary fails

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Fix Version/s: 1.2.0
• Component/s: Execution - Data Types
• Assignee: Rahul Kumar Challapalli
• Reporter: Rahul Kumar Challapalli
• Created: 01/May/15 20:30
• Updated: 02/Jul/15 05:04
• Resolved: 02/Jul/15 05:04

Description

git.commit.id.abbrev=5fbd274

The below query fails :

select concat(cast(cast('apache ' as varchar(7)) as varbinary(20)), 'drill') from `dummy.json`;
Query failed: PARSE ERROR: From line 1, column 15 to line 1, column 66: Cast function cannot convert value of type VARCHAR(7) to type VARBINARY(20)


[4b5916d1-6b96-42a0-9afa-80706f2bd263 on qa-node191.qa.lab:31010]
Error: exception while executing query: Failure while executing query. (state=,code=0)

I attached the error log.