[DRILL-3328] Cannot cast hive binary to varchar

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Functions - Drill, Storage - Hive
• Assignee: Venki Korukanti
• Reporter: Rahul Kumar Challapalli
• Created: 20/Jun/15 01:08
• Updated: 26/Jun/15 00:34
• Resolved: 26/Jun/15 00:34

Description

git.commit.id.abbrev=710f829

The below query fails with a fragment initialization error

select cast(col1 as varchar(10)) from hive.temp_bin;
Error: PARSE ERROR: From line 1, column 8 to line 1, column 32: Cast function cannot convert value of type BINARY(1) to type VARCHAR(10)


[Error Id: e7937c82-a249-4596-895f-eae2c54cfd45 on qa-node191.qa.lab:31010] (state=,code=0)

Data creation steps :

create table temp_bin (col1 BINARY) STORED AS TEXTFILE;
insert overwrite table temp_bin select encode('abc', 'UTF-8') from temp limit 1;

I attached the error logs.