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) |
|---|---|
| Category: | Data Set Control |
| Aliases: | 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_LOCATION= LIBNAME option, DBCREATE_TABLE_EXTERNAL= LIBNAME option, DBCREATE_TABLE_EXTERNAL= data set option, DBCREATE_TABLE_OPTS= LIBNAME option, DBCREATE_TABLE_OPTS= data set option |
Table of Contents
specifies the HDFS location of the root directory for storing table data.
Use this option to specify an alternative HDFS location, which adds the LOCATION keyword to the CREATE TABLE DDL.
Both DBCREATE_TABLE_EXTERNAL= and DBCREATE_TABLE_LOCATION= data set options are specified in this example.
data db.mytab (
dbcreate_table=external=yes
dbcreate_table_location="/mydir/mytab");
set mydata;
run;