Sqoop mysql error - communications link failure Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) The Ask Question Wizard is Live! Data science time! April 2019 and salary with experienceShould I use the datetime or timestamp data type in MySQL?Can't make JDBC connection to MySQL (using Java, IntelliJ, and Linux)errors while try to run executeQuery/prepared statements()Unable to perform Sqoop importConnect to a user input databaseMYSQL & SQuirreL - Unexpected Error occurred attempting to open an SQL connectionMultithread instance of mysql errorJDBC MySQL query syntaxElasticbeanstack instance Not able to collect to RDS of AWSSQOOP QUERY: trouble connecting to remote server MySQL
Fishing simulator
Single author papers against my advisor's will?
Stop battery usage [Ubuntu 18]
Working around an AWS network ACL rule limit
If A makes B more likely then B makes A more likely"
How should I respond to a player wanting to catch a sword between their hands?
What is the largest species of polychaete?
What did Darwin mean by 'squib' here?
I'm thinking of a number
Problem when applying foreach loop
Determine whether f is a function, an injection, a surjection
Using "nakedly" instead of "with nothing on"
Is it possible to ask for a hotel room without minibar/extra services?
Estimate capacitor parameters
How do I automatically answer y in bash script?
Who can trigger ship-wide alerts in Star Trek?
3 doors, three guards, one stone
Windows 10: How to Lock (not sleep) laptop on lid close?
Was credit for the black hole image misattributed?
Keep going mode for require-package
Should you tell Jews they are breaking a commandment?
How does modal jazz use chord progressions?
Limit for e and 1/e
I'm having difficulty getting my players to do stuff in a sandbox campaign
Sqoop mysql error - communications link failure
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
The Ask Question Wizard is Live!
Data science time! April 2019 and salary with experienceShould I use the datetime or timestamp data type in MySQL?Can't make JDBC connection to MySQL (using Java, IntelliJ, and Linux)errors while try to run executeQuery/prepared statements()Unable to perform Sqoop importConnect to a user input databaseMYSQL & SQuirreL - Unexpected Error occurred attempting to open an SQL connectionMultithread instance of mysql errorJDBC MySQL query syntaxElasticbeanstack instance Not able to collect to RDS of AWSSQOOP QUERY: trouble connecting to remote server MySQL
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
1
Trying to run the below Command:
sqoop import --connect jdbc:mysql://---.--.--.--:3306/home_credit_risk --table bureau --target-dir /home/sqoop --username root -password root;
I have Placed the mysql connector in the sqoop/lib folder and given permissions(755) to the connector jar to access it.
I am runnnig a AWS EMR service on which i have installed Sqoop Manually.
Getting the Below Error:
19/03/22 07:32:16 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7
19/03/22 07:32:16 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/03/22 07:32:16 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
19/03/22 07:32:16 INFO tool.CodeGenTool: Beginning code generation
19/03/22 07:32:16 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2001)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904)
at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786)
at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289)
at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260)
at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246)
at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:327)
at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at java.net.Socket.<init>(Socket.java:434)
at java.net.Socket.<init>(Socket.java:244)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:168)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:262)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1926)
... 30 more
Any Pointer will be appriciated. Thankyou.
mysql hadoop bigdata sqoop sqoop2
edited Mar 22 at 11:04
danielsepulvedab
5001719
asked Mar 22 at 7:40
Rahul GoyalRahul Goyal
125
add a comment |
1
Trying to run the below Command:
sqoop import --connect jdbc:mysql://---.--.--.--:3306/home_credit_risk --table bureau --target-dir /home/sqoop --username root -password root;
I have Placed the mysql connector in the sqoop/lib folder and given permissions(755) to the connector jar to access it.
I am runnnig a AWS EMR service on which i have installed Sqoop Manually.
Getting the Below Error:
19/03/22 07:32:16 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7
19/03/22 07:32:16 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/03/22 07:32:16 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
19/03/22 07:32:16 INFO tool.CodeGenTool: Beginning code generation
19/03/22 07:32:16 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2001)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904)
at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786)
at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289)
at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260)
at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246)
at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:327)
at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at java.net.Socket.<init>(Socket.java:434)
at java.net.Socket.<init>(Socket.java:244)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:168)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:262)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1926)
... 30 more
Any Pointer will be appriciated. Thankyou.
mysql hadoop bigdata sqoop sqoop2
edited Mar 22 at 11:04
danielsepulvedab
5001719
asked Mar 22 at 7:40
Rahul GoyalRahul Goyal
125
my Mysql Server is running on local machine and i am trying to acces the mysql using sqoop from AWS EMR Cluster .Source is local machine(MYSQL) and destination is AWS EMR.
– Rahul Goyal
Mar 22 at 8:09
Are you sure that the cluster can reach your local machine?
– danielsepulvedab
Mar 22 at 10:37
well i am new to hadoop technology ...i am not sure about that but on an assumption i suppose so that cluster can reach local machine using the ip
– Rahul Goyal
Mar 22 at 11:08
1
I think this is more a network issue than a hadoop related issue... first you have to be sure that your local machine and port are accessible from the internet.
– danielsepulvedab
Mar 22 at 11:42
yeah it was a Issue with the private ip as it cannot be accessed from outside network. Thanks @danielsepulvedab
– Rahul Goyal
Mar 26 at 11:47
add a comment |
1
1
1
1
Trying to run the below Command:
sqoop import --connect jdbc:mysql://---.--.--.--:3306/home_credit_risk --table bureau --target-dir /home/sqoop --username root -password root;
I have Placed the mysql connector in the sqoop/lib folder and given permissions(755) to the connector jar to access it.
I am runnnig a AWS EMR service on which i have installed Sqoop Manually.
Getting the Below Error:
19/03/22 07:32:16 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7
19/03/22 07:32:16 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/03/22 07:32:16 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
19/03/22 07:32:16 INFO tool.CodeGenTool: Beginning code generation
19/03/22 07:32:16 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2001)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904)
at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786)
at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289)
at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260)
at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246)
at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:327)
at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at java.net.Socket.<init>(Socket.java:434)
at java.net.Socket.<init>(Socket.java:244)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:168)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:262)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1926)
... 30 more
Any Pointer will be appriciated. Thankyou.
mysql hadoop bigdata sqoop sqoop2
edited Mar 22 at 11:04
danielsepulvedab
5001719
asked Mar 22 at 7:40
Rahul GoyalRahul Goyal
125
Trying to run the below Command:
sqoop import --connect jdbc:mysql://---.--.--.--:3306/home_credit_risk --table bureau --target-dir /home/sqoop --username root -password root;
I have Placed the mysql connector in the sqoop/lib folder and given permissions(755) to the connector jar to access it.
I am runnnig a AWS EMR service on which i have installed Sqoop Manually.
Getting the Below Error:
19/03/22 07:32:16 INFO sqoop.Sqoop: Running Sqoop version: 1.4.7
19/03/22 07:32:16 WARN tool.BaseSqoopTool: Setting your password on the command-line is insecure. Consider using -P instead.
19/03/22 07:32:16 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
19/03/22 07:32:16 INFO tool.CodeGenTool: Beginning code generation
19/03/22 07:32:16 ERROR manager.SqlManager: Error executing statement: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2001)
at com.mysql.jdbc.Connection.<init>(Connection.java:716)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:353)
at com.mysql.jdbc.Connection.getInstance(Connection.java:295)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at org.apache.sqoop.manager.SqlManager.makeConnection(SqlManager.java:904)
at org.apache.sqoop.manager.GenericJdbcManager.getConnection(GenericJdbcManager.java:59)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:763)
at org.apache.sqoop.manager.SqlManager.execute(SqlManager.java:786)
at org.apache.sqoop.manager.SqlManager.getColumnInfoForRawQuery(SqlManager.java:289)
at org.apache.sqoop.manager.SqlManager.getColumnTypesForRawQuery(SqlManager.java:260)
at org.apache.sqoop.manager.SqlManager.getColumnTypes(SqlManager.java:246)
at org.apache.sqoop.manager.ConnManager.getColumnTypes(ConnManager.java:327)
at org.apache.sqoop.orm.ClassWriter.getColumnTypes(ClassWriter.java:1872)
at org.apache.sqoop.orm.ClassWriter.generate(ClassWriter.java:1671)
at org.apache.sqoop.tool.CodeGenTool.generateORM(CodeGenTool.java:106)
at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:501)
at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:628)
at org.apache.sqoop.Sqoop.run(Sqoop.java:147)
at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76)
at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:183)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:234)
at org.apache.sqoop.Sqoop.runTool(Sqoop.java:243)
at org.apache.sqoop.Sqoop.main(Sqoop.java:252)
Caused by: java.net.ConnectException: Connection refused (Connection refused)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at java.net.Socket.<init>(Socket.java:434)
at java.net.Socket.<init>(Socket.java:244)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:168)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:262)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1926)
... 30 more
Any Pointer will be appriciated. Thankyou.
mysql hadoop bigdata sqoop sqoop2
mysql hadoop bigdata sqoop sqoop2
edited Mar 22 at 11:04
danielsepulvedab
5001719
asked Mar 22 at 7:40
Rahul GoyalRahul Goyal
125
edited Mar 22 at 11:04
danielsepulvedab
5001719
asked Mar 22 at 7:40
Rahul GoyalRahul Goyal
125
edited Mar 22 at 11:04
danielsepulvedab
5001719
edited Mar 22 at 11:04
danielsepulvedab
5001719
edited Mar 22 at 11:04
danielsepulvedab
5001719
5001719
asked Mar 22 at 7:40
Rahul GoyalRahul Goyal
125
asked Mar 22 at 7:40
Rahul GoyalRahul Goyal
125
asked Mar 22 at 7:40
Rahul GoyalRahul Goyal
125
125
my Mysql Server is running on local machine and i am trying to acces the mysql using sqoop from AWS EMR Cluster .Source is local machine(MYSQL) and destination is AWS EMR.
– Rahul Goyal
Mar 22 at 8:09
Are you sure that the cluster can reach your local machine?
– danielsepulvedab
Mar 22 at 10:37
well i am new to hadoop technology ...i am not sure about that but on an assumption i suppose so that cluster can reach local machine using the ip
– Rahul Goyal
Mar 22 at 11:08
1
I think this is more a network issue than a hadoop related issue... first you have to be sure that your local machine and port are accessible from the internet.
– danielsepulvedab
Mar 22 at 11:42
yeah it was a Issue with the private ip as it cannot be accessed from outside network. Thanks @danielsepulvedab
– Rahul Goyal
Mar 26 at 11:47
add a comment |
my Mysql Server is running on local machine and i am trying to acces the mysql using sqoop from AWS EMR Cluster .Source is local machine(MYSQL) and destination is AWS EMR.
– Rahul Goyal
Mar 22 at 8:09
Are you sure that the cluster can reach your local machine?
– danielsepulvedab
Mar 22 at 10:37
well i am new to hadoop technology ...i am not sure about that but on an assumption i suppose so that cluster can reach local machine using the ip
– Rahul Goyal
Mar 22 at 11:08
1
I think this is more a network issue than a hadoop related issue... first you have to be sure that your local machine and port are accessible from the internet.
– danielsepulvedab
Mar 22 at 11:42
yeah it was a Issue with the private ip as it cannot be accessed from outside network. Thanks @danielsepulvedab
– Rahul Goyal
Mar 26 at 11:47
my Mysql Server is running on local machine and i am trying to acces the mysql using sqoop from AWS EMR Cluster .Source is local machine(MYSQL) and destination is AWS EMR.
– Rahul Goyal
Mar 22 at 8:09
my Mysql Server is running on local machine and i am trying to acces the mysql using sqoop from AWS EMR Cluster .Source is local machine(MYSQL) and destination is AWS EMR.
– Rahul Goyal
Mar 22 at 8:09
Are you sure that the cluster can reach your local machine?
– danielsepulvedab
Mar 22 at 10:37
Are you sure that the cluster can reach your local machine?
– danielsepulvedab
Mar 22 at 10:37
well i am new to hadoop technology ...i am not sure about that but on an assumption i suppose so that cluster can reach local machine using the ip
– Rahul Goyal
Mar 22 at 11:08
well i am new to hadoop technology ...i am not sure about that but on an assumption i suppose so that cluster can reach local machine using the ip
– Rahul Goyal
Mar 22 at 11:08
1
1
I think this is more a network issue than a hadoop related issue... first you have to be sure that your local machine and port are accessible from the internet.
– danielsepulvedab
Mar 22 at 11:42
I think this is more a network issue than a hadoop related issue... first you have to be sure that your local machine and port are accessible from the internet.
– danielsepulvedab
Mar 22 at 11:42
yeah it was a Issue with the private ip as it cannot be accessed from outside network. Thanks @danielsepulvedab
– Rahul Goyal
Mar 26 at 11:47
yeah it was a Issue with the private ip as it cannot be accessed from outside network. Thanks @danielsepulvedab
– Rahul Goyal
Mar 26 at 11:47
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55294932%2fsqoop-mysql-error-communications-link-failure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55294932%2fsqoop-mysql-error-communications-link-failure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
my Mysql Server is running on local machine and i am trying to acces the mysql using sqoop from AWS EMR Cluster .Source is local machine(MYSQL) and destination is AWS EMR.
– Rahul Goyal
Mar 22 at 8:09
Are you sure that the cluster can reach your local machine?
– danielsepulvedab
Mar 22 at 10:37
well i am new to hadoop technology ...i am not sure about that but on an assumption i suppose so that cluster can reach local machine using the ip
– Rahul Goyal
Mar 22 at 11:08
1
I think this is more a network issue than a hadoop related issue... first you have to be sure that your local machine and port are accessible from the internet.
– danielsepulvedab
Mar 22 at 11:42
yeah it was a Issue with the private ip as it cannot be accessed from outside network. Thanks @danielsepulvedab
– Rahul Goyal
Mar 26 at 11:47