Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

When running the hive query getting the execption: ORC does not support type conversion from VARCHAR to CHAR

When running the hive query getting the execption: ORC does not support type conversion from VARCHAR to CHAR

New Contributor

Hi,

I am executing a hive query where i am joining two tables. But on running the query i am getting the exception as :

ORC does not support type conversion from VARCHAR to CHAR

PFB the query:

select count(*) from table1,table2 where colTable1=colTable2;

Any help would be appreciated.

Regards,

Akshay

1 REPLY 1
Highlighted

Re: When running the hive query getting the execption: ORC does not support type conversion from VARCHAR to CHAR

Mentor

Can you try casting a field in tbl1 with varchar datatypes with char field in tbl2. In general, varchar is not an efficient data type, you might want to at least convert to char. For anything else, please paste DDL of your tables

Don't have an account?
Coming from Hortonworks? Activate your account here