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.
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