Architecting, installing and maintaining your SAS environment

Connecting PC SAS to a Hadoop environment using ODBC ?

Reply
Frequent Contributor
Posts: 83

Connecting PC SAS to a Hadoop environment using ODBC ?

Hi ,

 

We have a PC SAS and an ODBC conenction setup on the desktop to Hadoop.

 

Wanted to know if its possible to conenct to Hadoop hIVE and assign libraries via ODBC / JDBC.

 

Is it mandatory to have SAS ACCESS to Hadoop to do this even if we are able to establish a connection via ODBC to Hadoop ? There is a Tablue environment which we are connecting to HIVE tables via ODBC.

SAS Super FREQ
Posts: 291

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

[ Edited ]

Hi,

 

You can connect to Hadoop via ODBC / SAS libname, the difference between ODBC and SAS/Access to Hadoop is that

the latter uses the Hadoop engine, whereas ODBC uses the ODBC engine.

 

If you have ODBC DSN configured on your pc, you could do a Libname hdp odbc prompt;

and then select the DSN you set up.

 

Hope that helps.

 

Thanks

Anja

Frequent Contributor
Posts: 83

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

Thanks Anja.I`ll try to connect it via ODBC


SAS Super FREQ
Posts: 291

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

Hi

 

in addition to my last post, i meant to add some of the options you can use to actually access hadoop from sas

 

Hadoop FILENAME statement, which enables read/write of HDFS files and folders

Scalable Performance Data Engine – SPDE

PROC HADOOP, which enables Pig, Map Reduce, HDFS statement submission

SAS/ACCESS Interface to Hadoop, to Read/Write data to and from HIVE

PROC SQL to submit Hive QL statements

and ODBC, which however doesn't use hadoop nor sas engine.

Frequent Contributor
Posts: 83

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

We tried the following options, however it went into error.Attaching screenshots


libname_error.jpgODBC_SPARK.jpg
SAS Super FREQ
Posts: 291

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

Hi,

 

sorry if my last info has caused confusion. You would need SAS/Access to Hadoop to use the Hadoop engine.

My intend was to generally list the options you have to access Hadoop.

 

Again, my apologies if this was confusing.

 

Thanks

Anja

Frequent Contributor
Posts: 83

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

Ok. So even if we have setup ODBC on the windows machine , we still need to have SAS/ACCESS to Hadoop driver to connect and assign libnames ?

no attachments. -##
Super User
Posts: 5,260

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

If you wish to use ODBC instead of "native" Hadoop connection you'll need a SAS/ACCESS to ODBC licence.
Data never sleeps
Super User
Posts: 5,260

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

If you wish to use ODBC instead of "native" Hadoop connection you'll need a SAS/ACCESS to ODBC licence.
Data never sleeps
Occasional Contributor
Posts: 5

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

[ Edited ]

Very interesting topic, I'm curious as what difference does it make in terms of using SAS Access to ODBC versus SAS Access to hadoop. In terms of fuctionality, will I still be able to deal with HDFS files, read/write files, or only access Hive tables.

Contributor
Posts: 61

Re: Connecting PC SAS to a Hadoop environment using ODBC ?

Hi,

 

Even i'm curious to know how we can configure HDI cluster or Hive using SAS ODBC. Can you please help with presice details we need to configure. we have seperate SAS Environment(with ODBC) and Hadoop on MS Azure. Please help me with more details how we can establish connection.

 

Thanks in advance.

Ask a Question
Discussion stats
  • 10 replies
  • 694 views
  • 0 likes
  • 5 in conversation