hadoop - how to make a sqoop job iterative by catching the tables from the sqlserver? -


hi have multiple tables in sql server. can use select statement list tables , make sqoop job iterative catching tables. , create hive schema. have tried using sqoop import-all-tables didn't worked. can please provide me documentation go through.

thank you.

i don't think so. there way of using sqoop direct command.

try following, below. may you:

sqoop import-all-tables --connect jdbc:mysql://localhost/databasename --username $user_name$ --password $password$ --exclude-tables table1, table2 -m 1 

Comments

Popular posts from this blog

php - Wordpress: Link a post to posts of another category manually -

delphi xe7 upload/download dropbox file using the rest client and show progress -

java - Get more than One value and display it -