BookmarkSubscribeRSS Feed
Victor
Calcite | Level 5

Hello,

 

it does not work either.

 

I think you will have to reproduce the same issue. I'm using the following components :

 

  • Hortonworks Sandbox VM 2.5 or above for Oracle VirtualBox
  • Network Configuration of the sandbox :NAT
  • sandbox address : 127.0.0.1
  • the address added to "c:\windows\system32\drivers\etc\hosts" file
  • SAS 9.4 1M4 on Windows
  • JAVA
    • JAVA_HOME=C:\Program Files\Java\jdk1.8.0_131
    • JRE_HOME=C:\Program Files\Java\jre1.8.0_144\bin
  • JARs files downloaded from the sandbox
  • Config files downloaded from the sandbox
  • pig code :

a = load '/user/maria_dev/class.csv' using PigStorage(';')
   as (name :chararray, sex :chararray, age :int, height :double, weight :double);
b = foreach a generate name;
dump b;

 

  • sas code :

filename pigcode "K:\hadoop\exercice\pigcode.txt";
options set=SAS_HADOOP_CONFIG_PATH "K:\hadoop\config";
options set=SAS_HADOOP_RESTFUL 0;
options set=SAS_HADOOP_JAR_PATH "K:\hadoop\jars";
options set=HADOOP_HOME "K:\hadoop";

proc hadoop user="maria_dev" password="maria_dev" verbose;
    pig code=pigcode
    workingdir="/user/maria_dev/workingdir"
    ;
run;
quit;

 

Regards

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 15 replies
  • 4298 views
  • 0 likes
  • 3 in conversation