ContextQMD
Back to Spark

SET

docs/sql-ref-syntax-aux-conf-mgmt-set.md

4.1.11.3 KB
Original Source

Description

The SET command sets a property, returns the value of an existing property or returns all SQLConf properties with value and meaning.

To set SQL variables defined with DECLARE VARIABLE use SET VAR.

Syntax

sql
SET
SET [ -v ]
SET property_key[ = property_value ]

Parameters

  • -v

    Outputs the key, value and meaning of existing SQLConf properties.

  • property_key

    Returns the value of specified property key.

  • property_key=property_value

    Sets the value for a given property key. If an old value exists for a given property key, then it gets overridden by the new value.

Examples

sql
-- Set a property.
SET spark.sql.variable.substitute=false;

-- List all SQLConf properties with value and meaning.
SET -v;

-- List all SQLConf properties with value for current session.
SET;

-- List the value of specified property key.
SET spark.sql.variable.substitute;
+-----------------------------+-----+
|                          key|value|
+-----------------------------+-----+
|spark.sql.variable.substitute|false|
+-----------------------------+-----+