*Closed* : How to import mutilple tables (not all tables) in Sqoop

[#1]

Hi all,

I want to import specific tables from MsSQL to HIVE database. Although I have tried --exclude-tables arguments for excluding some table while importing.

But my scenario is a little bit different.

For Example, If I have 100 tables and I want to import only 98 tables then I could exclude those 2 tables using --exclude-tables argument. But what if I want to import only 2 tables among those 100 tables.

I tried to give multiple tables names in --table argument.

My observation:

import-all-tables
--connect
jdbc:sqlserver://<HOST>:<port>;databasename=<mssql_database_name>
--username
xxxxx
--password
xxxx
--table
mssql_table1,mssql_table2
--hive-import
--hive-database
<hive_database_name>
--fields-terminated-by
","
-m
1

Does anyone have an idea?

Regards,

Jay.

[#2]

@JAy PaTel

If that is the case you might need to script it in advance see using Sqoop to fetch many tables in parallel

Hope that helps

[#3]

@JAy PaTel

Can you share your sqoop code,please remember to obfuscate sensitive info?

[#4]

Hi @Geoffrey Shelton Okot,

Please have a look into my sqoop code.

sqoop import --connect jdbc:sqlserver://<HOST>:<PORT>;databasename=<mssql_database_nameMS> --username xxxx --password xxxx --hive-database <hive_database_name> --table <mssql_table1>,<mssql_table2> --hive-import -m 1

Thank you,

Jay.