Sqoop Import triggering error

[#1]

Hi @slachterman

when i am trying to run the sqoop import command i am getting the below error.

Thanks,

Ravikumar.

[#2 · Accepted solution]

@Ravikumar Kumashi Please try including the below option in the sqoop import command and let us know the results.

--driver com.mysql.jdbc.Driver

[#3]

@slachterman Thanks it worked now!!! where can i find that data in HDFS if no path is specified ?

So It has to be changed if i am importing from oracle/postgresql ?

[#4]

@Ravikumar Kumashi please see these docs. By default, Sqoop will import a table named foo to a directory named foo inside your home directory in HDFS. For example, if your username is someuser, then the import tool will write to /user/someuser/foo/(files). You can adjust the parent directory of the import with the--warehouse-dir argument. For example:

$ sqoop import --connnect <connect-str> --table foo --warehouse-dir /shared \

You can also explicitly choose the target directory, like so:

$ sqoop import --connnect <connect-str> --table foo --target-dir /dest \

[#5]

@slachterman Understood, Thanks for the detailed explaination!!!

What if i have to re import again and output directory already exist, is there options for sqoop import with overwrite option?

[#6]

@Ravikumar Kumashi please see the --delete-target-dir option for sqoop import.

[#7]

@slachterman Thank you!!!