02-26-2019 12:55 AM - edited 02-26-2019 12:56 AM
I fetch some images from the web.
I created a hive table this way:
CREATE TABLE images(id INT, url STRING, picture BINARY)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|'
STORED AS SEQUENCEFILE
I thought to create a file and put it into the hdfs location ('mypath/images') but I really don't know what to write into that file about the binary image column...
the same, I dont' kknow how to INSERT directly into the hive table
someone can help me?
02-26-2019 01:02 AM
02-26-2019 01:06 AM - edited 02-26-2019 01:17 AM
Hi HArsh and thank you for your suggestion
Have you some sample or example?
Could I use python for that?