Try with `SparkSession.builder().enableHiveSupport` ?
On Tue, Dec 5, 2017 at 3:22 PM, 163 <[email protected]> wrote:
> Hi,
> How can I persistent database/table created in spark application?
>
> object TestPersistentDB {
> def main(args:Array[String]): Unit = {
> val spark = SparkSession.builder()
> .appName("Create persistent table")
> .config("spark.master”,"local")
> .getOrCreate()
> import spark.implicits._
> spark.sql("create database testdb location \"
> hdfs://node1:8020/testdb\")
>
> }
> }
>
> When I use spark.sql(“create database”) in sparkSession, and close this
> sparkSession.
> The created database is not persisted to metadata, So I cannot find it
> in spark-sql: show databases.
>
>
>
> regards
> wendy
>
