Hi Kumar,
Thank you for good information. I am looking forward your next blog.
When we use "Spark" to download the queried data from Hadoop using FedSQL procedure, do we add only properties options("hive.execution.engine=SPARK") to libname statement?
e.g.
libname test hadoop server="HADOOP" AUTHDOMAIN="XXXXX" schema="TEST"
cfg="/opt/sas/hadoopfiles/confs/sitexmls/merged-site.xml" properties="hive.execution.engine=SPARK";

The execution time (269 sec) was longer than when not added (119 sec) in my environment. Do you expect what is wrong?
Katsunari