Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

SAS -Connecting to Hive 1.2.1 from SAS 9.3 using odbc driver

Solved Go to solution

SAS -Connecting to Hive 1.2.1 from SAS 9.3 using odbc driver

New Contributor

Can we connect to hive 1.2.1 from SAS 9.3 using odbc driver?If yes what are steps?

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

Re: SAS -Connecting to Hive 1.2.1 from SAS 9.3 using odbc driver

Guru

Yes. Get ODBC driver from http://hortonworks.com/downloads. You have ODBC driver for multiple OS targets. Once you get the driver, you can follow documentation from http://hortonworks.com/wp-content/uploads/2016/04/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf to setup ODBC driver.

Once you set ODBC driver, you can connect to this from SAS like any other ODBC driver.

2 REPLIES 2

Re: SAS -Connecting to Hive 1.2.1 from SAS 9.3 using odbc driver

Guru

Yes. Get ODBC driver from http://hortonworks.com/downloads. You have ODBC driver for multiple OS targets. Once you get the driver, you can follow documentation from http://hortonworks.com/wp-content/uploads/2016/04/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf to setup ODBC driver.

Once you set ODBC driver, you can connect to this from SAS like any other ODBC driver.

Re: SAS -Connecting to Hive 1.2.1 from SAS 9.3 using odbc driver

New Contributor

Hi Sree Venkata Now Can you connect to hive from SAS 9.3 ? ,if you can please help share SAS script i will appreciate so much