Member since
09-17-2017
5
Posts
0
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
6876 | 10-06-2017 07:58 PM |
10-06-2017
07:58 PM
Sqoop eval and Sqoop list tables requires only the Name node connection with the SQL server. But for SQOOP import, all the nodes in the cluster needs to have access to the remote SQL server. Here the Telnet failed from datanodes. It was due the network settings and firewalls configuration. Later when every node was able to access the Remote SQL server the SQOOP IMPORT was successful.
... View more
09-20-2017
10:30 AM
I am able to Telnet to the SQL Server. Connected success Sqoop eval, Sqoop list-database, Sqoop list-tables are all working. Able to view the status and Log in the Job Browser. Only sqoop import throws this TCP/IP Connection refused error.
... View more
09-19-2017
03:28 AM
Sqoop list-tables , sqoop eval is successful But fails in Sqoop import. sqoop import --connect "jdbc:sqlserver://10.xxx.xxx.xxx:1433; database=Runtime" --username ** --password ****** --table live -m 1 The error is : Error: java.lang.RuntimeException: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host 10.xxx.xxx.xxx, port 1433 has failed. Error: "Connection refused. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".
... View more
Labels:
- Labels:
-
Apache Sqoop
09-17-2017
12:43 AM
sqoop import - errors out GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)] WARN security.UserGroupInformation: PriviledgedActionException as:pars7611 (auth:KERBEROS) cause:java.io.IOException: Failed on local exception: java.io.IOException: javax.security.sasl.SaslException: GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)]; ERROR tool.ImportTool: Import failed: java.io.IOException: Failed on local exception: java.io.IOException: javax.security.sasl.SaslException: GSS initiate failed [Caused by GSSException: No valid credentials provided (Mechanism level: Failed to find any Kerberos tgt)]; sqoop eval runs good.
... View more
Labels:
- Labels:
-
Apache Sqoop
-
Kerberos
-
Security