SAS Hadoop Configuration Issue

Reply
Regular Learner
Posts: 1

SAS Hadoop Configuration Issue

Hi,

Good Morning.

We have done below Manual configuration steps  for SAS Hadoop configuration.and we encountered issue mentioned below.

Please let us know if you have questions/concerns.

Manual configuration steps for SAS 9.4  SAS Access Interface to Hadoop:

-------------------------------------------------------------------------------------------------------------------

1.Get Keytab file created in Hadoop server : Completed

2. copy the Keytab file created in Hadoop server to SAS Server then kinit (creating the Ticket )for the user in SAS Server  : Completed

3.Update the Ticket Varibale information in KRB5CCNAME environment variable name : Completed

4.Copy Jar & XML files from Hadoop server to SAS Server  : Completed

5.Update the Jar & XML configuration file path in SAS Configuration file  : Completed

6.Restart the SAS Service to reflect the SAS Configuration file  : Completed

7.Run the Sample Lib code for SAS Hadoop connectivity  : Issue Encountered

Sample Program (i.e) Lib Name to connecting Hadoop server:

option SASTRACE = "d,d,d,d" sastraceloc=saslog;

LIBNAME hdplib HADOOP SERVER='znlhacdq0002.amer.zurich.corp' HIVE_PRINCIPAL="hive/_HOST@ZHDPDEV.COM" SUBPROTOCOL=hive2;

Error :

22         GOPTIONS ACCESSIBLE;

23         option SASTRACE = "d,d,d,d" sastraceloc=saslog;

ACCESS ENGINE:  Entering dbiconi. 21 1436234265 dbiconi 0 OBJECT_E

ACCESS ENGINE:  Exiting dbiconi.  rc=0x00000000 22 1436234265 dbiconi 0 OBJECT_E

ACCESS ENGINE: Entering DBICON 23 1436234265 dbicon 0 OBJECT_E

ACCESS ENGINE:  CONNECTION= SHAREDREAD 24 1436234265 dbicon 0 OBJECT_E

HADOOP: ACC/HADOOP configured with XML configuration files in SAS_HADOOP_CONFIG_PATH, /sas/Hadoop_SAS9.4/Config 25 1436234265

process_configuration 0 OBJECT_E

24         LIBNAME hdplib HADOOP SERVER='znlhacdq0002.amer.zurich.corp' port=10010 HIVE_PRINCIPAL="hive/_HOST@ZHDPDEV.COM"

24       ! SUBPROTOCOL=hive2;

HADOOP: Connection to DSN=znlhacdq0002.amer.zurich.corp failed. 26 1436234265 hdcon 0 OBJECT_E

ERROR: Unable to connect to the Hive server.

ACCESS ENGINE: Exiting DBICON with  rc=0X801F9007 27 1436234265 dbicon 0 OBJECT_E

ERROR: Error trying to establish connection.

ERROR: Error in the LIBNAME statement.

Note :

1. We did'nt executed below Manual one step on Hadoop node (i.e) running Hadoop Tracer on Hadoop node due to security constraint .Let us know whether it;s mandatory step to execute it.

Transfer the following file to the Hive Node from SAS server :

-----------------------------------------------------------------------------

/sas/SAS9.4/SASDeploymentManager/9.4/products/deploywiz__94300__prt__xx__sp0__1/deploywiz/data/hadoop/hadooptracer.pyto /hadooptracer.py

Set the files to execute mode on Hive Node:

-----------------------------------------------------------------------------

chmod 755 /hadooptracer.py

Change directory to your user home directory :

-----------------------------------------------------------------------------

cd ~

Run the batch script :

-----------------------------------------------------------------------------

python ./hadooptracer.py -f /tmp/test.json

Thanks With Regards,

Magesh Vadivel

Cell   :  847-909-3821

Esteemed Advisor
Posts: 5,198

Re: SAS Hadoop Configuration Issue

What distribution do you use (and version)?

Can you ping the Hadoop server master node?

Data never sleeps
Learner
Posts: 1

Re: SAS Hadoop Configuration Issue

Hi Magesh,

I am having the same issue. Can you please let me know if you were able to resolve it.

Thanks,

New Contributor
Posts: 4

Re: SAS Hadoop Configuration Issue

Hello - what was the resolution to this?
Ask a Question
Discussion stats
  • 3 replies
  • 628 views
  • 0 likes
  • 4 in conversation