sqoop command for map-hive-columns for import-all-tables

Question

I am importing all tables from a schema using sqoop command.The map-column-hive works fine in table level. But when I run for schema level it gives an error.

sqoop import-all-tables --verbose --connect "jdbcconnectionstring" --username user --password password  --hive-import --hive-database hiveschematest --map-column-hive "emptest.id=int,emptest.name=varchar(100),emptest.address=varchar(100)"  -m 1

I need to map some table data type with hive data types. It is giving error as "No column name found while importing".Whether map-hive-column support for import-all-tables(Schema) option also?

why don't you import 1 table only (you are providing --map-column-hive for 1 table)? — Dev
actually my requirement is to import all tables and some table having Binary_double data type which is not supported in hive.For that case I need map-hive-column for import-all-table option — Prakash

Arunakiran Nulu Arunakiran Nulu · Accepted Answer · 2016-10-01T17:45:11

Try this , you have given double quotes for map-column-hive

sqoop import-all-tables --verbose --connect "jdbcconnectionstring" --username user --password password  --hive-import --hive-database hiveschematest --map-column-hive emptest.id=int,emptest.name=varchar(100),emptest.address=varchar(100)  -m 1

sqoop command for map-hive-columns for import-all-tables

1 Answers