Architecting, installing and maintaining your SAS environment

Access Hadoop from SAS in Windows

Reply
Occasional Contributor
Posts: 18

Access Hadoop from SAS in Windows

We are trying to connect our SAS 9.4 (9.4 TS1M4) Intelligence Platform installed and deployed in Windows with a Hadoop cluster installed in Linux. When we are trying to connect using a libname statement, we got this error

 

1 LIBNAME hive HADOOP PORT=9083 SERVER="data-hadoopsrv" SCHEMA=metastore_db AUTHDOMAIN="HadoopAuth" ;
WARNING: No login information was available for authdomain HadoopAuth.
ERROR: SAS_HADOOP_JAR_PATH environment variable not set. It must be set for SAS/ACCESS to connect to Hadoop. See the SAS
Configuration Guide for SAS_HADOOP_JAR_PATH requirements.
ERROR: Error in the LIBNAME statement.

 

As I understant, we are needing some jar files and environment variables. Do these files have to be located in my windows server or in the linux hadoop server? 

 

Is it possible to access hadoop in linux from sas in windows?

 

Any thoughts??

 

Thanks a lot

SAS Employee
Posts: 318

Re: Access Hadoop from SAS in Windows

Posted in reply to osmelbrito

@osmelbrito,

 

Check this document SAS® 9.4 Hadoop Configuration Guide for Base SAS® and SAS/ACCESS®, Fourth Edition especially Appendix 1 Using the SAS Deployment Manager to Obtain Hadoop JAR and Configuration Files

Occasional Contributor
Posts: 18

Re: Access Hadoop from SAS in Windows

Of course we already checked that document, but it is not clear that if it's possible to connect SAS in Windows to Hadoop in linux. And also it doesn't show where jar files has to be located

SAS Employee
Posts: 318

Re: Access Hadoop from SAS in Windows

Posted in reply to osmelbrito

@osmelbrito,

 

Sure, you can access Hadoop from SAS on Windows. JAR files has to be located in SAS_HADOOP_JAR_PATH.

Occasional Contributor
Posts: 18

Re: Access Hadoop from SAS in Windows

Ok, but SAS_HADOOP_JAR_PATH has to be configured in my windows server?  This is not clear in the manual

SAS Employee
Posts: 318

Re: Access Hadoop from SAS in Windows

Posted in reply to osmelbrito

@osmelbrito,

 

On the server where you starting SAS session that connects to Hadoop. In your case Windows.

Ask a Question
Discussion stats
  • 5 replies
  • 183 views
  • 0 likes
  • 2 in conversation