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 >
