SET (SQL Analytics)
Sets a property, returns the value of an existing property or returns all SQL configuration properties with value and meaning.
Parameters
-v
Outputs the key, value and meaning of existing SQL configuration 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
-- Set a property.
SET spark.sql.variable.substitute=false;
-- List all SQL configuration properties with value and meaning.
SET -v;
-- List all SQL configuration 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|
+-----------------------------+-----+