Spark SQL DROP Statements Reference
DROP DATABASE
Description
Removes a database and its associated directory from the file system. An exception is thrown if the database does not exist.
Syntax
DROP { DATABASE | SCHEMA } [ IF EXISTS ] db_name [ RESTRICT | CASCADE ]
Parameters
DATABASE | SCHEMA
These keywords are interchangeable. Either can be used to refer to the database obje ...
Posted on Mon, 27 Jul 2026 16:36:06 +0000 by lpxxfaintxx
Configuring and Running Spark SQL with Hive Integration
To build a Spark distribution compatible with Hadoop CDH 5.7.0 and Hive support, navigate to the Spark source directory:
[hadoop@hadoop001 spark-2.1.0]$ pwd
/home/hadoop/source/spark-2.1.0
Compile using Maven with profiles for YARN, Hadoop 2.6, Hive, and Hive Thriftserver:
./build/mvn -Pyarn -Phadoop-2.6 -Phive -Phive-thriftserver \
-Dhadoop ...
Posted on Thu, 07 May 2026 02:26:00 +0000 by kporter.porter