How can i connect Hadoop with SAS using JDBC connector

[VaibhavGhoghari]

Hi ,

I have all the credentials with me in order to connect SAS with Hadoop and also the JDBC connector installed onto our SAS server.

So after trying the below mention query I got an error stating “ERROR: The HADOOP engine cannot be found.”

libname h4 hadoop
user=XXXXX
password= XXXXX
port=XXXX
schema= default
url = "jdbc:hive2://cflhortonwork02.kiac.in:";

Is there a way by which we can create DSN using JDBC connector and then connect Hadoop.

I am suppose to use JDBC only instead of ODBC.

Please help. Any help would be appreciated.

Thanks and Regards,
Vaibhav

[SuryaKiran]

You might need to refer some documentation.

SAS® 9.4 Hadoop Configuration Guide for Base SAS® and SAS/ACCESS

Something similar post here