Have you tried "--map-column-java"? http://sqoop.apache.org/docs/1.4.6/SqoopUserGuide.html#_controlling_type_mapping .
On Mon, Jul 6, 2015 at 5:16 AM, Manikandan R <[email protected]> wrote: > I am using > > select unhex(regexp_replace(name, " ", "")) from tempdb.stg_mi_blob_test4; > > and it works. > > On Mon, Jul 6, 2015 at 3:34 PM, Manikandan R <[email protected]> wrote: > >> 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 >> > >
