Help using Base SAS procedures

Using Hive Data in SAS. Push Hadoop Data into SAS

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Using Hive Data in SAS. Push Hadoop Data into SAS

My goal is: Use Hive Tables into SAS Virtual Analytics

I already do this steps:
1) SAS Management Console
1.1) Create a Hadoop Server
1.2) Create a Data Library from Hive


But I don't know if was needed...

 

Now I read that SAS/ACCESS Interface to Hadoop provides a LIBNAME engine to get to your Hadoop Hive data.

 

But I don't know where I have to execute this code! Is in SAS 9.4?

 

And next Can I load the tables into SAS Virtual Analytics??

 

I already read amount of documents But the more I read more confused I get.

I'm using two virtual machines. One for Hadoop and another for SAS, and I don't know what type of configuration I need to do(even the order)...

 

I've some urgency to put SAS reading from Hadoop. Can anyone help me?


Accepted Solutions
Solution
‎05-02-2016 03:57 PM
Super User
Posts: 5,434

Re: Using Hive Data in SAS. Push Hadoop Data into SAS

Posted in reply to dbigdate_19

"This steps in Management Console are mandatory to have access to data in Hadoop?"

I'm not sure, perhaps possible to do the corresponding thing in the VA admin...?

 

"I need to do some configurations in Hadoop machine?"

As I recall, there's only need for configuration on the SAS server for the "simple" SAS/ACCESS type of connection.

If that's have been done properly, you should be able to verify this in Management Console be registering tables from that library you have defined.

 

 

Data never sleeps

View solution in original post


All Replies
Super User
Posts: 5,434

Re: Using Hive Data in SAS. Push Hadoop Data into SAS

Posted in reply to dbigdate_19

If you by 1.2 mean that you have defined a library in metadata, you should be all set to load data directly to LASR/VA.

You should be able to access this data in Data Builder in VA (given that you use the same metadata server).

Data never sleeps
New Contributor
Posts: 4

Re: Using Hive Data in SAS. Push Hadoop Data into SAS

Hi LinusH, thanks for your response! 

This steps in Management Console are mandatory to have access to data in Hadoop?

I need to do some configurations in Hadoop machine?

Thanks!

Solution
‎05-02-2016 03:57 PM
Super User
Posts: 5,434

Re: Using Hive Data in SAS. Push Hadoop Data into SAS

Posted in reply to dbigdate_19

"This steps in Management Console are mandatory to have access to data in Hadoop?"

I'm not sure, perhaps possible to do the corresponding thing in the VA admin...?

 

"I need to do some configurations in Hadoop machine?"

As I recall, there's only need for configuration on the SAS server for the "simple" SAS/ACCESS type of connection.

If that's have been done properly, you should be able to verify this in Management Console be registering tables from that library you have defined.

 

 

Data never sleeps
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 644 views
  • 0 likes
  • 2 in conversation