I am using map column hive option to convert cols of type blob to string as part of import.
for ex, On mysql side, mysql> select * from mi_blob_test; +------+-------+ | id | name | +------+-------+ | 1 | Mani1 | +------+-------+ 1 row in set (0.00 sec) import --connect jdbc:mysql://test.db.gwynniebee.com:3306/tempdb --username root --password-file /tmp/.password --table mi_blob_test --hive-import --hive-table tempdb.stg_mi_blob_test1 --hive-overwrite --target-dir /data/tempdb/stg_mi_blob_test1 --null-string '\\N' --null-non-string '\\N' --map-column-hive name=string command is running fine. But when i tried to read the data using hive or impala shell, I am seeing this select * from stg_mi_blob_test4; Query: select * from stg_mi_blob_test4 +----+----------------+ | id | name | +----+----------------+ | 1 | 4d 61 6e 69 31 | +----+----------------+ Returned 1 row(s) in 0.75s Thanks, Mani
