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

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 2177 views
  • 0 likes
  • 3 in conversation