New Contributor
Posts: 2
Registered: ‎02-05-2015

Does impala support 'binary' data type ?

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





Cloudera Employee
Posts: 271
Registered: ‎10-16-2013

Re: Does impala support 'binary' data type ?

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.

Posts: 7
Registered: ‎07-31-2017

Re: Does impala support 'binary' data type ?

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 ?