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.     ... View more

I don't believe we did. Below is the hotfix we recently installed.   http://support.sas.com/kb/57/099.html ... View more

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; ... View more

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; ... View more