10-05-2016 04:23 PM
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.
10-05-2016 04:38 PM - edited 10-05-2016 04:39 PM
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.
10-05-2016 05:02 PM
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.
10-06-2016 09:48 AM
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.
10-06-2016 11:12 AM
04-18-2017 10:03 PM - edited 04-21-2017 11:35 AM
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.
04-19-2017 04:36 PM
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.