topic SAS Viya CAS in SAS Viya

SAS Viya CAS

krishnaavm123 — Tue, 23 Jul 2024 15:11:18 GMT

Hi Team,

Currently I'm loading Db table to CAS inmemory by assigning caslib to ms sql however I hit the following warning

Kindly request you to please advise what does mean by this warning:

WARNING: Unable to find an acceptable column for multi-node reads. Load will proceed with numReadNodes = 1.

Also wanted to understand difference between loading data from dbliname to inmemory vs assigning caslib to db and load db table from caslibto public library and promote.

Is load distribution occures across all the nodes in both the cases?

And also in these two mthods where data will get saved.

Thanks in Advance!!

Re: SAS Viya CAS

sbxkoenk — Tue, 23 Jul 2024 17:13:30 GMT

@krishnaavm123 wrote:

Kindly request you to please advise what does mean by this warning:

WARNING: Unable to find an acceptable column for multi-node reads. Load will proceed with numReadNodes = 1.

Problem Note 62685: The warning "Unable to find an acceptable column for multi-node reads” occurs when you use a multinode read for loading data
https://support.sas.com/kb/62/685.html

For multinode data loads (multi-node read), SAS checks the target data source table for a numeric variable. Then it uses that numeric variable, the MOD function and the number of nodes that you specify to divide the table into slices.

Koen

Re: SAS Viya CAS

krishnaavm123 — Tue, 23 Jul 2024 21:14:42 GMT

Hi Koen Well noted and thank you for your response.