Data Set Options for Impala

All SAS/ACCESS data set options in this table are supported for Impala. Default values are provided where applicable. For details, see Data Set Options for Relational Databases.

SAS/ACCESS Data Set Options for Impala
Option	Default Value
BL_DATAFILE=	automatically generated
BL_DELETE_DATAFILE=	YES
BL_HOST=	SERVER= value, if SERVER= is specified; otherwise, none
BL_PORT=	50070
BULKLOAD=	none
CURSOR_TYPE=	LIBNAME option value
DBCOMMIT=	LIBNAME option value
DBCONDITION=	none
DBCREATE_TABLE_EXTERNAL=	NO
DBCREATE_TABLE_LOCATION=	/user/hive/warehouse/tabname [with the default schema], /user/hive/warehouse/schema.db/tabname [with a nondefault schema]
DBCREATE_TABLE_OPTS=	LIBNAME option value
DBFORCE=	NO
DBGEN_NAME=	DBMS
DBINDEX=	NO
DBLABEL=	NO
DBLARGETABLE=	none
DBMAX_TEXT=	1024
DBNULLKEYS=	LIBNAME option value
DBPROMPT=	LIBNAME option value
DBSASLABEL=	COMPAT
DBSASTYPE=	see Data Types for Impala
DBTYPE=	see Data Types for Impala
HDFS_PRINCIPAL=	none
INSERTBUFF=	LIBNAME option value
PARTITIONED_BY=	none
POST_STMT_OPTS=	none
POST_TABLE_OPTS=	none
PRE_STMT_OPTS=	none
PRE_TABLE_OPTS=	none
PRESERVE_COL_NAMES=	LIBNAME option value
QUERY_TIMEOUT=	LIBNAME option value
READBUFF=	LIBNAME option value
SCHEMA=	LIBNAME option value
SCRATCH_DB=	none
SUB_CHAR=	none

Last updated: February 3, 2026