Access Hadoop from SAS in Windows

[osmelbrito]

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

[alexal]

@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

[osmelbrito]

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

[alexal]

@osmelbrito,

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

[osmelbrito]

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

[alexal]

@osmelbrito,

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