Problem Note 67585: A large amount of memory is used for code that creates hash objects in SAS® Cloud Analytic Services (CAS)
 |  |  |  |  |
You might observe excessive use of memory by CAS on SAS® Viya® 3.5. This problem might occur when you run SAS® code for hash tables that use multiple threads. The following syntax is an example:
do ArticleId=1 to 28502;
do Date=today() to today()+120;
article_new_flg=0;
Promotion_flg=0;
output;
end;
end;
run;
data CASUSER.secondtest(copies=0) / sessref=mySession; /*8 threads*/
if 0 then set casuser.test;
if _N_ eq 1 then do;
declare hash scoreh(dataset:"CASUSER.test");
scoreh.definekey('ArticleId', 'Date');
scoreh.definedata('article_new_flg', 'Promotion_flg');
scoreh.definedone();
end;
rc = scoreh.check();
stop;
run;
The excessive memory usage occurs because each thread is allocating the hash tables in memory separately.
Currently there is no workaround. But you can reduce memory consumption significantly with a slight loss in performance by using this declaration with the following highlighted addition:
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Viya | Linux for x64 | 3.5 | 3.5 | Viya | Viya |
| Microsoft® Windows® for x64 | 3.5 | 3.5 | Viya | Viya | ||
Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2021-03-16 09:43:47 |
| Date Created: | 2021-03-11 06:30:13 |