How to Create a Database in Spark SQL

Question

How do I create a database or multiple databases in sparkSQL. I am executing the SQL from spark-sql CLI. The query like in hive create database sample_db does not work here. I have Hadoop 2.7 and Spark 1.6 installed on my system.

Answer 1

spark.sql("create database test")

//fetch metadata data from the catalog. your database name will be listed here
spark.catalog.listDatabases.show(false)

Answer 2

CREATE (DATABASE|SCHEMA) [IF NOT EXISTS] db_name  
    [COMMENT comment_text]  
    [LOCATION path]  
    [WITH DBPROPERTIES (key1=val1, key2=val2, ...)]  

Link for your reference