I am using Hortonworks Sandbox (a clean setup), and created a simple table in mysql which I want to sqoop into hdfs. I'm used the MySql that was already installed on the sandbox, by running 'mysql' in the shell. My first attempt at sqoop was: sqoop import --connect jdbc:mysql://localhost/test --table mytable This gave "..access denied to localhost.." error, so based on an answer another post, and finding the MySQL port using "show variables like 'port'" within MySQL, I then tried: sqoop import --connect jdbc:mysql://sandbox.hortonworks.com:3306/test --username root --table mytable This gave errors about ".. streaming result sets are open...", which was solved by another post by adding the 'driver' argument as follows: sqoop import --connect jdbc:mysql://sandbox.hortonworks.com:3306/test --username root --table mytable --driver com.mysql.jdbc.Driver It now gets a bit further, but now fails with a RemoteException: ...Permission denied: user=root, access=WRITE, inode="user/root/.staging":hdfs:hdfs:drwxr-xr-x That's as far as I've got. Am I doing something wrong, or do I need to set up some access permissions somewhere? I would've expected that many people have been sqooping from MySql without having to change the set up, so is my sqoop command incorrect?
... View more
