Problem Note 63493: You can use the newly added DATASOURCE option, SLICECOLUMN=, to specify which column to use with multinode mode
Starting in SAS® Viya® 3.4, data connectors that use the serial data transfer mode can take advantage of multinode mode. This mode allows multiple CAS nodes to connect to a data source to help speed performance by dividing the table into slices with the use of the MOD function. To use multinode data transfer, specify a value other than 1 for the NUMREADNODES= option.
Currently, the first numeric variable that is found is used to divide the table. The loadTable action and the LOAD statement in the CASUTIL procedure are being enhanced to allow you to specify which variable to use rather than using the default, which is the first variable found.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
The hot fix includes the newly added DATASOURCE option, SLICECOLUMN=.
Here is an example using the SLICECOLUMN option with the loadTable action:
s:loadtable{caslib="foo", source="emp", options={numReadNodes=0, sliceColumn="deptno"}, casout={caslib="casfoo" name="CASEMP"}}
Here is an example using the SLICECOLUMN option in the LOAD statement with PROC CASUTIL:
proc casutil;
load casdata="emp" incaslib="foo" casout="casemp" outcaslib="casfoo" options=(numReadNodes=0, sliceColumn="deptno");
quit;
You can also use the SLICECOLUMN= option with the save action and the SAVE statement with the NUMWRITENODES= option.
Operating System and Release Information
SAS System | SAS Data Connector to Amazon Redshift | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
SAS System | SAS Data Connector to MySQL | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
SAS System | SAS Data Connector to Oracle | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
SAS System | SAS Data Connector to PostgreSQL | Microsoft® Windows® for x64 | V.03.04 | V.03.05 | Viya | Viya |
Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
SAS System | SAS Data Connector to Microsoft SQL Server | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
SAS System | SAS Data Connector to Impala | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
SAS System | SAS Data Connector to SAP HANA | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
SAS System | SAS Data Connector to DB2 | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
SAS System | SAS Data Connector to Vertica | Linux for x64 | V.03.04 | V.03.05 | Viya | Viya |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
The hot fix in this note includes the SLICECOLUMN= option. You can use the option to specify which column to use to slice data tables when using multinode mode.
Type: | Problem Note |
Priority: | high |
Date Modified: | 2019-03-14 14:48:54 |
Date Created: | 2019-01-15 14:21:48 |