Created on 02-05-2015 03:26 AM - edited 09-16-2022 02:20 AM
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...
Created 02-12-2015 09:40 AM
As you're correctly pointed out Impala currently does not support the BINARY data type, so querying a tablw with that type does not work in Impala.
An idea: You could try altering the column type from BINARY to STRING, and try querying the table with Impala. But beware, I hav enot tried this myself, so no guarantees it will work.
Created 09-11-2017 08:17 AM
It has been a long time since this question was answered.
Has there been further recommendation by Cloudera on this ? Does cloudera support STRING data type to be used to store BINARY data ? or its something that works today and may stop working tomorrow ?