question Re: Sqoop Import triggering error in Support Questions

Sqoop Import triggering error

ravikumashi — Sun, 18 Aug 2019 12:49:20 GMT

Hi @slachterman

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

Thanks,

Ravikumar.

Re: Sqoop Import triggering error

slachterman — Wed, 27 Jul 2016 20:41:11 GMT

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

--driver com.mysql.jdbc.Driver

Re: Sqoop Import triggering error

ravikumashi — Wed, 27 Jul 2016 21:34:02 GMT

@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 ?

Re: Sqoop Import triggering error

slachterman — Wed, 27 Jul 2016 21:47:30 GMT

@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 \

Re: Sqoop Import triggering error

ravikumashi — Wed, 27 Jul 2016 22:27:39 GMT

@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?

Re: Sqoop Import triggering error

slachterman — Wed, 27 Jul 2016 22:34:27 GMT

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

Re: Sqoop Import triggering error

ravikumashi — Wed, 27 Jul 2016 23:07:54 GMT

@slachterman Thank you!!!