Help using Base SAS procedures

Joining Heterogeneous Data with proc FEDSQL is very slow

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

Joining Heterogeneous Data with proc FEDSQL is very slow

I am able to run proc FEDSQL on a hadoop environment using SAS interface to Impala. Following a SAS example on page 42 of “SAS® 9.4 FedSQL Language Reference, Fifth Edition”, I joined a SAS table and a hadoop table. The query is very slow. Has anyone had experience with joining a SAS table and a database table using proc FEDSQL? 

 


Accepted Solutions
Solution
Monday
New Contributor
Posts: 2

Re: Joining Heterogeneous Data with proc FEDSQL is very slow

Thank you Linus for the answer. I have used dbkey option or inserted SAS data to the database table with proc SQL.

Loading SAS data to a database table works very well but I need IT to create the DB table for me. I thought that the new proc FEDSQL gave me more flexibility in joining SAS table with database tables.

View solution in original post


All Replies
Super User
Posts: 5,881

Re: Joining Heterogeneous Data with proc FEDSQL is very slow

I don't know if there's a difference in behaviour between FedSQL and SQL but typically the join will take place in the SAS session.
This can be avoided/optimized by either uploading your SAS table to Hadoop, or try the DBKEY option.
Data never sleeps
Solution
Monday
New Contributor
Posts: 2

Re: Joining Heterogeneous Data with proc FEDSQL is very slow

Thank you Linus for the answer. I have used dbkey option or inserted SAS data to the database table with proc SQL.

Loading SAS data to a database table works very well but I need IT to create the DB table for me. I thought that the new proc FEDSQL gave me more flexibility in joining SAS table with database tables.

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 69 views
  • 0 likes
  • 2 in conversation