topic Re: SAS access to hadoop in SAS Programming

SAS access to hadoop

parmis — Fri, 09 Feb 2018 13:06:51 GMT

Hi guys,

Does anyone know how we can connect to hive and hadoop environment using SAS pc?

Thanks

Re: SAS access to hadoop

soham_sas — Fri, 09 Feb 2018 13:30:26 GMT

You can Create a library using the ODBC , or you can directly access the table also by connect to odbc option

libname syntax will be like below

libname name odbc dsn = " " schema=" ";

ODBC connection syntax will be like below

proc sql inobs=10;
CONNECT TO ODBC (noprompt= " enter your DSN ; schema= ;");
create table dsn as
select * from connection to odbc
(
SELECT varnames
from table name );
quit;

NOTE : accessing the data through ODBC connection is more faster than a Libname

Re: SAS access to hadoop

parmis — Fri, 09 Feb 2018 13:42:15 GMT

what would be the dsn and schema?

I already run my query in hive and I have the result. I'm trying to bring it to SAS

Thanks

Re: SAS access to hadoop

soham_sas — Fri, 09 Feb 2018 15:26:01 GMT

DSN is your hadoop/hive server name , and schema is your folder name inside the hadoop/hive

for better clarification , it will be a good option to check with your hadoop/hive admin they will tell you exactly what will be the DSN and Schema for the table which you want to access