What is the main difference between SAS ACCESS Interface to HADOOP and SAS ACCESS Interface to IMPALA. Can SAS ACCESS Interface to HADOOP be used to query Impala tables?
Thanks
Hi @qoit
SAS/Access interface to Hadoop is for native access to Hive and HiveServer2 tables. SAS/Access interface to Impala is for native access to Impala tables. There is a difference in how these two Hadoop services works with the latter bypassing MapReduce. But for both of these to work from SAS, HDFS is also required.
Hi @qoit
SAS/Access interface to Hadoop is for native access to Hive and HiveServer2 tables. SAS/Access interface to Impala is for native access to Impala tables. There is a difference in how these two Hadoop services works with the latter bypassing MapReduce. But for both of these to work from SAS, HDFS is also required.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.