topic Re: Can I source report data in SAS Viya directly from Hive database without loading data into memor in SAS Visual Analytics

Can I source report data in SAS Viya directly from Hive database without loading data into memory?

kaiyuzhu — Mon, 19 Aug 2019 02:27:34 GMT

Please help.

I wonder if SAS Viya can build a report/dashboard based on non-memory data? for example, my memory is limited, can my reports use direct query to source data from Hive database?

Re: Can I source report data in SAS Viya directly from Hive database without loading data into memor

alexal — Mon, 19 Aug 2019 12:15:10 GMT

@kaiyuzhu ,

No, you have to import a table from Hive to the CAS server.

Re: Can I source report data in SAS Viya directly from Hive database without loading data into memor

kaiyuzhu — Mon, 19 Aug 2019 23:14:49 GMT

Thanks very much for your reply @alexal

If that's the case, what should I do if my report dataset is too big then? Is increasing the memory the only solution?

Does this also mean the report/dashboard can't have up-to-date live data?

In Power BI, you can create a direct query to fetch report data directly from backend database so you can see up-to-date data at the front end report, How do I implement this in SAS Viya though? This functionality seems very common to me .

Also another question is : can dashboards build based on CAS table( *.sashdat file)?

Thank you

Re: Can I source report data in SAS Viya directly from Hive database without loading data into memor

alexal — Tue, 20 Aug 2019 17:05:33 GMT

@kaiyuzhu ,

How big is your dataset? How much RAM is available for you on the CAS nodes?

Re: Can I source report data in SAS Viya directly from Hive database without loading data into memor

kaiyuzhu — Tue, 20 Aug 2019 21:29:43 GMT

@alexal my dataset is around 60G, my RAM is only 30G, and we don't have budget to upgrade RAM at the moment, that's why I' seeking alternative solution