https://community.cloudera.com/t5/Archives-of-Support-Questions/SAS-Connecting-to-Hive-1-2-1-from-SAS-9-3-using-odbc-driver/m-p/141629#M27961 <P>Yes. Get ODBC driver from <A href="http://hortonworks.com/downloads" target="_blank">http://hortonworks.com/downloads</A>. You have ODBC driver for multiple OS targets. Once you get the driver, you can follow documentation from <A href="http://hortonworks.com/wp-content/uploads/2016/04/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf" target="_blank">http://hortonworks.com/wp-content/uploads/2016/04/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf</A> to setup ODBC driver. </P><P>Once you set ODBC driver, you can connect to this from SAS like any other ODBC driver. </P> Wed, 11 May 2016 21:15:38 GMT ravi1 2016-05-11T21:15:38Z https://community.cloudera.com/t5/Archives-of-Support-Questions/SAS-Connecting-to-Hive-1-2-1-from-SAS-9-3-using-odbc-driver/m-p/141628#M27960 <P>Can we connect to hive 1.2.1 from SAS 9.3 using odbc driver?If yes what are steps?</P><P>Thanks!</P> Wed, 11 May 2016 19:25:27 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/SAS-Connecting-to-Hive-1-2-1-from-SAS-9-3-using-odbc-driver/m-p/141628#M27960 sreegeetha_venk 2016-05-11T19:25:27Z https://community.cloudera.com/t5/Archives-of-Support-Questions/SAS-Connecting-to-Hive-1-2-1-from-SAS-9-3-using-odbc-driver/m-p/141629#M27961 <P>Yes. Get ODBC driver from <A href="http://hortonworks.com/downloads" target="_blank">http://hortonworks.com/downloads</A>. You have ODBC driver for multiple OS targets. Once you get the driver, you can follow documentation from <A href="http://hortonworks.com/wp-content/uploads/2016/04/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf" target="_blank">http://hortonworks.com/wp-content/uploads/2016/04/Hortonworks-Hive-ODBC-Driver-User-Guide.pdf</A> to setup ODBC driver. </P><P>Once you set ODBC driver, you can connect to this from SAS like any other ODBC driver. </P> Wed, 11 May 2016 21:15:38 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/SAS-Connecting-to-Hive-1-2-1-from-SAS-9-3-using-odbc-driver/m-p/141629#M27961 ravi1 2016-05-11T21:15:38Z https://community.cloudera.com/t5/Archives-of-Support-Questions/SAS-Connecting-to-Hive-1-2-1-from-SAS-9-3-using-odbc-driver/m-p/141630#M27962 <P>Hi <A href="https://community.hortonworks.com/users/3492/sreegeetha-venkata.html">Sree Venkata</A> Now Can you connect to hive from SAS 9.3 ? ,if you can please help share SAS script i will appreciate so much</P> Wed, 29 Nov 2017 01:04:51 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/SAS-Connecting-to-Hive-1-2-1-from-SAS-9-3-using-odbc-driver/m-p/141630#M27962 Piyapornen 2017-11-29T01:04:51Z