question Re: BMp Image data to hive in Support Questions

BMp Image data to hive

saidvs — Fri, 16 Jul 2021 18:47:54 GMT

Hello,

I am trying to load bmp image data to hive and getting below error. I went through many past discussions but didn't find an exact solution to implement.

Appreciate your help in solving this.

Steps I followed.

1: Copied the images to HDFS

2: Created a table with a column Binary

3: Load using data in path.

Error: Error while compiling statement: FAILED: SemanticException Unable to load data to destination table. Error: The file that you are trying to load does not match the file format of the destination table.

My scripts:

create table wrk_image
(id int
, filename STRING
, data BINARY
);

load data inpath '/warehouse/tablespace/external/hive/cadt.db/scriptpro/' into table wrk_image;

Re: BMp Image data to hive

asish — Sun, 18 Jul 2021 15:22:30 GMT

Please provide the below information:

1. What is the version? HDP/CDP/CDH ?

2. provide "scriptpro"

3. What si the error recieved ?

Re: BMp Image data to hive

saidvs — Mon, 19 Jul 2021 16:21:03 GMT

Hi Asis,

Here is the info.

CDH version : CDH-7.1.5

Scripture : its just a directory I created under db.

Error:

Error while compiling statement: FAILED: SemanticException Unable to load data to destination table. Error: The file that you are trying to load does not match the file format of the destination table.

Please let me know if you need more information.

Thanks,

Sai

Re: BMp Image data to hive

asish — Mon, 19 Jul 2021 17:26:06 GMT

Hi Sai,

Please follow https://community.cloudera.com/t5/Support-Questions/Does-hive-support-Photo-or-images-datatypes/td-p/221473

Copy the data to hdfs instead of loadpath and check,

Thanks,
Asish