Member since
03-31-2016
2
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
3551 | 03-31-2016 01:44 AM |
03-31-2016
01:44 AM
Solved the issue in a minute after posting it - the power of the Cloudera forum ❤️ The solution was to specify not 'localhost', but the localhosts' ip address in the connection string 🙂
... View more
03-31-2016
01:33 AM
I am successfully listing tables in my 'test' db on the master node like so: sqoop list-tables --driver com.mysql.jdbc.Driver --connect jdbc:mysql://localhost/test --username hadoop ... test_table But when i try importing data like so, it fails with the following error: sqoop import --driver com.mysql.jdbc.Driver --connect jdbc:mysql://localhost/test --username hadoop --table 'test_table' -m 1 --verbose; Error: java.io.IOException: SQLException in nextKeyValue Caused by: java.sql.SQLSyntaxErrorException: Table 'test.test_table' doesn't exist Caused by: org.mariadb.jdbc.internal.common.QueryException: Table 'test.test_table' doesn't exist While trying to fix this i tried doing following: In my MySQL database i ran the following command for each data node: create user 'hadoop'@'<node ip>'; grant all on test.* to 'hadoop'@'<node ip>'; and commented out the bind-address address in mysql settings. And restarted the server But that didn't help. Does anyone have an idea what is wrong?
... View more
Labels:
- Labels:
-
Apache Hadoop
-
Apache Sqoop