Hi All I am testing SAS/ACCESS for Hadoop (9.4 TS1M1) against the Cloudera Quickstart VM Image (CDH 4.4.0.1) When i create a table, everything looks fine at first; the table is created in Hadoop and the SAS-log claims that observations is written. But afterwards there is no data in it, only the metadata. (SAS-log below) In the 9.4 documentaion "LIBNAME Statement Specifics for Hadoop" there is a note stating "If HDFS /tmp has enabled the sticky bit, the LOAD command can fail. To resolve this, see the SAS system requirements and configuration guide documents, which are available at http://support.sas.com.". It is not unlikely that the Sticky Bit is on, as Cloudera recomends it; but i cant find anything on the matter at support.sas.com. Does anybody know the solution to this problem ? regards Steen 8 libname cdh hadoop server="192.168.198.131" subprotocol=hive2 user=cloudera password=XXXXXXXX; NOTE: Libref CDH was successfully assigned as follows: Engine: HADOOP Physical Name: jdbc:hive2://192.168.198.131:10000/default 9 data cdh.class; 10 set sashelp.class; 11 run; NOTE: There were 19 observations read from the data set SASHELP.CLASS. NOTE: The data set CDH.CLASS has 19 observations and 5 variables. 12 data test; set cdh.class; run; NOTE: There were 0 observations read from the data set CDH.CLASS. NOTE: The data set WORK.TEST has 0 observations and 5 variables.
... View more