BookmarkSubscribeRSS Feed
BilaTheLegend
Fluorite | Level 6

Hi Guys,

 

SAS Metadata providers an abstraction of data, while is possible to use different data sources in your SAS E. Guide .

 

However, when I´m join a table from work and another table from a hive database, SAS Guide is in loop and my query is not finishing. 

 

I´ve checked my hive database and query is finished. But, results are not processed in SAS guide. How to identify the error in platform SAS 9.4 ?

 

Did anyone see something like this ? 

 

Thanks in advance,

1 REPLY 1
AhmedAl_Attar
Ammonite | Level 13

Hi @BilaTheLegend 

Have a look at this paper https://www.sas.com/content/dam/SAS/support/en/sas-global-forum-proceedings/2019/3626-2019.pdf for some solid advice,

then have a look at this page for other potential useful insights https://support.sas.com/en/documentation/third-party-software-reference/9-4/guides-papers-for-hadoop...

 

The other advice I can give you, Find a way to push down your WORK data set into Hadoop, and join the data in Hadoop before bringing back the result set to SAS -- This is way you'll only dealing with the join results

 

Hope this helps,

Ahmed

suga badge.PNGThe SAS Users Group for Administrators (SUGA) is open to all SAS administrators and architects who install, update, manage or maintain a SAS deployment. 

Join SUGA 

Get Started with SAS Information Catalog in SAS Viya

SAS technical trainer Erin Winters shows you how to explore assets, create new data discovery agents, schedule data discovery agents, and much more.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 540 views
  • 1 like
  • 2 in conversation