Explanation:
The correct standard Spark SQL syntax to safely create a database (or schema) at a specific storage path is CREATE DATABASE [IF NOT EXISTS] db_name [LOCATION 'path']. The IF NOT EXISTS clause prevents the command from throwing an error if the database is already present.
Ultimate access to all questions.
A
CREATE DATABASE IF NOT EXISTS customer360 LOCATION '/customer/customer360'
B
SET PATH customer360 '/customer/customer360'
C
ENSURE DATABASE customer360
D
ALTER DATABASE customer360 LOCATION '/customer/customer360'
No comments yet.