skip to main content
Connection Option Descriptions for Apache Spark SQL : Use Current Schema for Catalog Functions
  

Try DataDirect Drivers Now

Use Current Schema for Catalog Functions

Attribute

UseCurrentSchema (UCS)

Purpose

Specifies whether results are restricted to the tables and views in the current schema if a catalog function call is made without specifying a schema or if the schema is specified as the wildcard character %. Restricting results to the tables and views in the current schema improves performance of catalog calls that do not specify a schema.

Valid Values

0 | 1

Behavior

If set to 1 (Enabled), results of catalog function calls are restricted to the tables and views in the current schema.
If set to 0 (Disabled), results of catalog function calls are not restricted.

Default

0 (Disabled)

GUI Tab

Advanced tab