Specifies a Hive schema so that SAS can store temporary output.
| Valid in: | SAS/ACCESS LIBNAME statement, CONNECT statement |
|---|---|
| Category: | Data Set Control |
| Default: | none (the current schema is used) |
| Requirement: | SAS must be able to write to the schema. |
| Data source: | Hadoop, Impala |
| See: | SCRATCH_DB= LIBNAME option |
Table of Contents
specifies the name that is assigned to a logical classification of objects in a relational database.
This option lets the user specify a target schema that SAS can use for temporary output. It is needed when a user does not have permissions to perform DDL operations such as CREATE TABLE or DROP TABLE in the current schema.