SPDSACWH= Macro Variable

Specifies whether to perform WHERE processing optimization by subsetting the data in the Hadoop cluster with MapReduce.

Valid in:	SPD Server
Requirement:	To perform data subsetting in the Hadoop cluster, there are table and SAS code requirements. For more information, see WHERE Processing Optimization with MapReduce.
Interaction:	The status of the HADOOPACCELWH parameter file option determines the functionality of the SPDSACWH= macro variable. See HADOOPACCELWH Parameter File Option.

Syntax

Required Arguments

Details

Example

Syntax

SPDSACWH=YES | NO

Required Arguments

YES

turns on WHERE processing optimization when the HADOOPACCELWH parameter option is not included (undeclared) in the spdsserv.parm file, which is the default state. If the NOHADOOPACCELWH parameter option is included in the spdsserv.parm file, SPDSACWH=YES is ignored, and WHERE processing optimization is not performed.

NO

turns off WHERE processing optimization when the HADOOPACCELWH parameter option is included (declared) in the spdsserv.parm file.

Details

By default, WHERE processing optimization is not enabled. That is, the spdsserv.parm file does not include the HADOOPACCELWH parameter file option, which requests that data subsetting be performed in the Hadoop cluster with MapReduce. In the default state, you can use the SPDSACWH=YES macro variable to turn on WHERE processing optimization in specific cases.

If global WHERE processing optimization is enabled with the HADOOPACCELWH parameter file option, you can use the SPDSACWH=NO macro variable to turn off WHERE processing optimization in specific cases.

If WHERE processing optimization is disabled with the NOHADOOPACCELWH parameter file option, the SPDSACWH= macro variable setting is ignored.

The ACCELWHERE= table option overrides the SPDSACWH= macro variable. For information about the ACCELWHERE= table option, see ACCELWHERE= Table Option.

Example

%let spdsacwh=yes;

Note: Because SPD Server is able to operate in select Hadoop environments, you might want to determine whether a libref resides in a Hadoop domain. For example, to determine whether the libref My_Lib is in a Hadoop domain, submit the LIBNAME LIST statement libname my_lib list;. If the queried libref is in a Hadoop domain, SPD Server returns HADOOP=YES.