1. How to write the dynamic sqoop command
i have 10 tables in the mysql database but i want to move the 5 to hive using sqoop
Please share the query
2. How to pass the parameter dynamically in sqoop query
"sqoop job --create incjoba12 -- import --connect jdbc:mysql://xxxx/db--driver com.mysql.jdbc.Driver --username zzz --table a1 -- --target-dir /tmp/a1 -m 1 "
instead of give the username password connection string and drivers.
Please try to help me to solve this problem
thanks in advance
I am not sure I understand you correctly. It looks like you want to have parameters provided on the fly.
In that case, you need to code with shell script, and embed your sqoop command in the script, and provide parameter either at prompt or from a file. Sqoop does allow you provide password from a file.