topic SAS / ACCESS to Hadoop in SAS Data Management

SAS / ACCESS to Hadoop

pauger2 — Wed, 21 Sep 2016 14:48:16 GMT

Hi All!

I am having some issues using SAS /ACCESS to Hadoop.

I would like to resolve this issue ASAP and I hope someone had similar experience and can share how they resolved it.

I can connect to the hadoop environment via a libname statement.

I can also read from a table in the hadoop environment and write it out as a SAS dataset but I cannot write to a database in the Hadoop environment.

When I submit a sample data step to write, my session goes away and I don't even get a SAS log that would tell me what's happening.

If anyone has any suggestiong they would like share I would very much appreciate it.

I am using SAS 9.4 TS Level 1M3 in window and my Hadoop distribution is Hortonworks. Thank you so much and I look forward to your suggestions.

Re: SAS / ACCESS to Hadoop

ballardw — Wed, 21 Sep 2016 15:12:30 GMT

It may help someone diagnose your issue if you provide an example of the code that makes the "session go away".

Re: SAS / ACCESS to Hadoop

JBailey — Tue, 27 Sep 2016 20:08:01 GMT

Hi,

When you say "my session goes away" what do you mean? Is SAS abending or is the connection to Hadoop lost?

Many customers experience issues because of missing JARs or XML config files with incorrect information in them.

Re: SAS / ACCESS to Hadoop

pauger2 — Wed, 28 Sep 2016 15:17:58 GMT

Hello Ballardw:

Thanks for your response. Below is the code I am using.

When I submit this code, my sas session terminates by itself and no sas log is generated.

Thie code creates a directory entry, puts a filename in metadata but the actual data doesn’t make it and I end up with an empty hive table.

OPTIONS SET=SAS_HADOOP_RESTFUL='1';

OPTIONS SET=KNOX_GATEWAY_URL='';

LIBNAME HDP HADOOP URI=''

SERVER='' USER=xxxxxx PW=xxxxxxxx DATABASE=xxxxxxxxxxxx;

DATA HDP.SAMPLE(DBCREATE_TABLE_OPTS='STORED AS SEQUENCEFILE');

SET LOCAL.SAMPLE;

RUN;

Re: SAS / ACCESS to Hadoop

pauger2 — Wed, 28 Sep 2016 15:34:02 GMT

Hello JBailey.

Thanks for your response.

My SAS session goes away means It's gone..bye bye.. by just running the code below and no SAS log is generated.

With the code below, we can connect to Hadoop. We can also read data from Hadoop but we cannot write to hadoop.

The code simply creates a directory entry, puts a filename in metadata but the actual data doesn’t make it and we end up with an empty hive table.

Do you happen to have a comple set of JARs and XMLs config files from a client who have successfully connect, read and write?

We're using Hortonworks for our hadoop distribution. We're connecting using PC SAS in window and we have SAS 9.4 - TS Level 1M3.

Anything you can contribute to help solve this issue would be greatly appreciated. Thanks a lot.

OPTIONS SET=SAS_HADOOP_RESTFUL='1';

OPTIONS SET=KNOX_GATEWAY_URL='';

LIBNAME HDP HADOOP URI=''

SERVER='' USER=xxxxxx PW=xxxxxxxx DATABASE=xxxxxxxxxxxx;

DATA HDP.SAMPLE(DBCREATE_TABLE_OPTS='STORED AS SEQUENCEFILE');

SET LOCAL.SAMPLE;

RUN;

Re: SAS / ACCESS to Hadoop

JBailey — Wed, 28 Sep 2016 15:39:42 GMT

Hi @pauger2,

Have you installed the hotfix for Knox?

http://support.sas.com/kb/56/644.html

Re: SAS / ACCESS to Hadoop

pauger2 — Wed, 28 Sep 2016 15:53:35 GMT

I don't believe we did.

Below is the hotfix we recently installed.

http://support.sas.com/kb/57/099.html

Re: SAS / ACCESS to Hadoop

pauger2 — Thu, 29 Sep 2016 00:53:06 GMT

Great news JBailey!

My SAS session is no longer disappearing and was able to write 1000 rows in HDFS...very exciting...

The only is now when we attempt to write 2000 rows or more we get the error below. It seems to be about a permission issue that we hope to be able to work out with our admin hadoop team.

NOTE: The data set HDP.WRITES_SAMPLE2 has 3000 observations and 11 variables.

ERROR: Execute error on statement: LOAD DATA INPATH

'/tmp/sasdata-2016-09-28-19-47-22-419-e-00001.dlv' OVERWRITE INTO TABLE

sastmp_09_28_19_48_23_228_00002. Could not load

/tmp/sasdata-2016-09-28-19-47-22-419-e-00001.dlv into table

sastmp_09_28_19_48_23_228_00002 in schema xxxxxxxxxxxx_TBLS. A common cause of this

issue is conflicting HDFS permissions between the data file and the Hive warehouse

directory for the table. Another possible cause is the "sticky" bit set on HDFS directory

/tmp.

Thanks for helping out.

Re: SAS / ACCESS to Hadoop

sasprofile — Sat, 26 Aug 2017 13:43:08 GMT

Hello Pauger2,

I see you have raised a Question about SAS to Hadoop connectivity issue, hope your issue is resolved.

I need your help in establishing a connection from SAS 9.4 to Hadoop.

I never worked before with SAS connecting Hadoop

I would appreciate if any one can assist me with some high-level step by step Instructions for connecting from SAS to Hadoop.

Thank you in Advance

Re: SAS / ACCESS to Hadoop

SASKiwi — Sun, 27 Aug 2017 03:15:58 GMT

@sasprofile - You've already asked the same question in your own separate post. You are more likely to get your answers there, rather than by repeating your questions on old posts.

Re: SAS / ACCESS to Hadoop

JBailey — Wed, 30 Aug 2017 12:13:08 GMT

Hi,

I replied to the other thread. Hope it helps.

Best wishes,

Jeff