Can we use Sqoop to load BLOB into HIVE

[王国栋]

HI guys,

I am using sqoop 1.4.2 to import data into HIVE warehosue.

In my understanding, BLOB and CLOB can not map to any HIVE data type. But I
am not sure if we can do some hack to import BLOB into HIVE.

*My questions are as follow*
1. Can we use "--map-column-hive" to map blob to HIVE string ?
2. Usually, BLOB may contain '\n', '\A', these are HIVE field separator and
record separator, obviously, we can not save BLOB as TextFile. Can we
import blob as SequenceFile or AvroFile which can be loaded with HIVE ?


Thanks.

Guodong