SAS Viya CAS

[krishnaavm123]

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!!

[sbxkoenk · Accepted solution]

---

@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

[krishnaavm123]

Hi Koen Well noted and thank you for your response.