topic Re: SAS ACCESS Interface to HADOOP in SAS Programming

SAS ACCESS Interface to HADOOP

qoit — Wed, 13 Jan 2021 02:11:41 GMT

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

Re: SAS ACCESS Interface to HADOOP

AnandVyas — Wed, 13 Jan 2021 02:25:12 GMT

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.

Ref: What Is SAS/ACCESS Interface to Hadoop?

What Is SAS/ACCESS Interface to Impala?

Re: SAS ACCESS Interface to HADOOP

qoit — Wed, 13 Jan 2021 06:38:35 GMT

Many thanks for a brief overview!

Cheers