topic Connection between SAS and Hadoop in SAS Procedures

Connection between SAS and Hadoop

dbigdate_19 — Thu, 05 May 2016 12:43:21 GMT

Hi experts,

I already create the Hadoop Server and Hive Library on SAS Management Console. Now I want register the tables to use in SAS Tools Analytics.

But when I introduce the User ID and Password I get the following error:

SAS_HADOOP_JAR_PATH environment variable not set. It must be se for SAS/ACCESS to connect to Hadoop

I'm using the following tutorial:

http://support.sas.com/documentation/cdl/en/bidsag/68193/HTML/default/viewer.htm#n1vhinse09cw5on1vmcvop1tnbi0.htm
SAS 9.4 Hadoop Configuration Guide For Base SAS and SAS/ACCESS

I don't know what I've to do to have access to Hive tables... I don't know which jar files I need, neither where I can found it in Cloudera VM...

Re: Connection between SAS and Hadoop

DavidPope — Thu, 05 May 2016 15:28:14 GMT

I think Chapter 4 in this configuration guide should help you

http://support.sas.com/resources/thirdpartysupport/v94/hadoop/hadoopbacg.pdf

Re: Connection between SAS and Hadoop

dbigdate_19 — Thu, 05 May 2016 15:55:47 GMT

I read that I don't need to do anyhting on Hadoop Machine... But this chapter indicates that I need to do some configurations there.

There exists some basic tutorial to do the integration between Hadoop and SAS? The Configuration Guide that I'm reading are some complex and confusing...

Re: Connection between SAS and Hadoop

LinusH — Thu, 05 May 2016 17:21:42 GMT

It sounds like that you need on site support.

Re: Connection between SAS and Hadoop

DavidPope — Thu, 05 May 2016 20:37:46 GMT

If you continue to have difficulty contact technical support for assistance as this is provided as part of your SAS license.

Re: Connection between SAS and Hadoop

Rodgers_125 — Fri, 06 May 2016 08:36:45 GMT

I'm trying to move the Jar files from Hadoop Machine to SAS... next I will be test the SAS Procedure