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.

Kurt Van den Branden · Accepted Answer · 2016-09-21 14:58:50Z

13

spark.sql("create database test")

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

edited Sep 21, 2016 at 14:58

Kurt Van den Branden

13.2k10 gold badges83 silver badges92 bronze badges

answered Sep 21, 2016 at 14:08

user6858809

1311 silver badge3 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Rajat Mishra · Accepted Answer · 2021-08-19 16:19:26Z

5

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

Link for your reference

edited Aug 19, 2021 at 16:19

Rajat Mishra

3,7904 gold badges32 silver badges44 bronze badges

answered Sep 12, 2017 at 6:35

Nagesh Singh Chauhan

8142 gold badges13 silver badges28 bronze badges

Collectives™ on Stack Overflow

How to Create a Database in Spark SQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related