Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Who agreed with this topic

Does impala support 'binary' data type ?

avatar
Explorer

Hi ,

 

I am new to imapala ,my hive table is having one binary type column ( in which I stored an image ).When I tryto query that table in impala  I am getting the following error " ERROR: AnalysisException: Unsupported type 'BINARY' in 'photo_col'."  But the same query is working in Hive .What mistake I am doing please let me know .

 

I thought that

 * there is no BINARY data type in impala unlike hive.

If I am correct , then how to query the hive table's binary column in impala ?

 

Thanks in Advance...

 

 

 

 

Who agreed with this topic