Specifies whether to try the connection regardless of the minimum required Hadoop version.
| Valid in: | SAS/ACCESS LIBNAME statement |
|---|---|
| Category: | Data Set Control |
| Default: | NO |
| Data source: | Hadoop, Spark |
| Note: | Support for Spark was added in SAS 9.4M7. |
Table of Contents
Specifies that SAS allows connections to a target DBMS that does not meet minimum requirements. Although using this option is not recommended, it might be useful when version information is reported incorrectly or in test environments.
Specifies that SAS rejects connections to a target DBMS that does not meet minimum requirements and issues an error to the SAS log.
Many SAS/ACCESS engines have a minimum supported version requirement. For details, see the configuration guide for the specific product. The IGNORE_BASELINE= option checks the target DBMS version to see whether it meets the minimum baseline requirement. An error occurs if that condition is not met. For more information about Hadoop (Hive and Spark) minimum baseline requirements, see Support for Hadoop 9.4.
Specifying IGNORE_BASELINE=YES can be useful if, for example, you are testing a new version of SAS but have not yet upgraded your DBMS to the required version. Some DBMS systems might also report version information incorrectly. In that case, this option can be helpful.
option set=SAS_HADOOP_JAR_PATH="C:\Progam Files\SASHome\AccessClients\9.4\DataDrivers\hadoop"; /* site-specific */
option set=SAS_HADOOP_CONFIG_PATH="c:\temp\mysrv1_cfg"; /* site-specific */
options sastrace=',,,d' sastraceloc=saslog
nostsuffix sql_ip_trace=(note,source) msglevel=i;
libname hdp hadoop user=myusr1 pw=mypwd1;ERROR: The version of Hive on this cluster (0.13) does not meet the SAS minimum version requirements (1.1 or greater). Upgrade your version of Hive, set LIBNAME option IGNORE_BASELINE=YES, or set the environment variable SAS_ACCESS_IGNORE_BASELINE=YES. Very old versions of Hive might report version information incorrectly. ERROR: Error in the LIBNAME statement.
libname hdp hadoop user=myusr1 pw=mypwd1 ignore_baseline=YES;NOTE: Libref HDP was successfully assigned as follows:
Engine: HADOOP
Physical Name: jdbc:hive2:c:/mysrvm.it.com:10000/default