BookmarkSubscribeRSS Feed
pauger2
Calcite | Level 5

Hello All!

 

Has anyone encountered the error below while writing to hadoop? 

Can you please share some insight and how you got around it. 

 

ERROR: java.sql.SQLException: org.apache.thrift.transport.TTransportException:

       java.net.SocketException: Software caused connection abort: recv failed

 

Thanks.

4 REPLIES 4
JBailey
Barite | Level 11

Hi @pauger2,

 

Can you tell us which Hadoop distribution you are using, provide a code sample which reproduces the error, and include the entire error message (Java dump)?

 

Thanks!

Jeff 

pauger2
Calcite | Level 5

Hi Jeff,

 

Thanks for your response.

 

The hadoop distribution is Hortonworks and hadoop version is 2.7.1.2.3.4.23-3.

 

Attached is a full dump of the log...luckily I used sastrace= option.

 

I see the same error when I am closing my sas session in the log window as well....I attach as well.

 

Thanks,

Gerald

 

pauger2
Calcite | Level 5

....here is what I see in my log window when exiting sas.

JBailey
Barite | Level 11

Hi @pauger2

 

Your KNOX_GATEWAY_URL= value does not include the Knox port number. This could be a problem.

 

OPTIONS SET=KNOX_GATEWAY_URL='https://knox-dev.some-madeup-corp.com/gateway/default';

 

Have you installed the SAS Hotfix for Knox?

Problem Note 56644: The SAS/ACCESS® Interface to Hadoop does not support Hortonworks Apache Knox Gat...

 

Best wishes,

Jeff

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 3524 views
  • 0 likes
  • 2 in conversation