Hi Rahul,
Here is an sample code with LIBNAME reference to write/read SAS datasets to/from Hive using spark engine.
========= option set=SAS_HADOOP_JAR_PATH="/opt/sas/viya/config/data/hadoop/lib:/opt/sas/viya/config/data/hadoop/lib/spark"; option set=SAS_HADOOP_CONFIG_PATH="/opt/sas/viya/config/data/hadoop/conf"; options sastrace=',,,d' sastraceloc=saslog nostsuffix sql_ip_trace=(note,source) msglevel=i; options DBIDIRECTEXEC;
libname hivelib clear;
libname hivelib hadoop server="server.example.com" user="hadoop" database=default subprotocol=hive2 /*use fetch conversion and strict mode control to have an error message when costly ORDER is generated*/ properties="hive.fetch.task.conversion=minimal;hive.fetch.task.conversion.threshold=-1;hive.mapred.mode=strict;hive.execution.engine=spark";
/* save SAS table to HIVE */ data hivelib.prdsal2; set sashelp.prdsal2; run;
==========
-Uttam
... View more