DBCREATE_TABLE_LOCATION= Data Set Option

Identifies the HDFS location of the root directory for storing table data.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Alias: DBCREATE_LOCATION=, DBCREATE_LOC=, DBCREATE_PATH=
Default: /user/hive/warehouse/tabname [with the default schema], /user/hive/warehouse/schema.db/tabname [with a nondefault schema]
Interaction: You can specify this option, the DBCREATE_TABLE_EXTERNAL= option, or both.
Data source: Hadoop
Tip: This option determines only the physical location of a file.
See: DBCREATE_TABLE_EXTERNAL= LIBNAME option, DBCREATE_TABLE_EXTERNAL= data set option, DBCREATE_TABLE_OPTS= LIBNAME option, DBCREATE_TABLE_OPTS= data set option

Syntax

DBCREATE_TABLE_LOCATION='path'

Syntax Description

'path'
specifies the HDFS location of the root directory for storing table data.

Details

Use this option to specify an alternative HDFS location, which adds the LOCATION keyword to the CREATE TABLE DDL.

Example: Creating a File in an Alternative Hive Depository

Both DBCREATE_TABLE_EXTERNAL= and DBCREATE_TABLE_LOCATION= options are set in this example.
LIBNAME db HADOOP SERVER=myserver USER=myuser DB=myschema;
DATA db.mytab (
       DBCREATE_TABLE_EXTERNAL=YES
       DBCREATE_TABLE_LOCATION=”/mydir/mytab”);
  SET mydata;
RUN;