Ayush Anubhava created SPARK-25032:
--------------------------------------
Summary: Create table is failing, after dropping the database . It
is not falling back to default database
Key: SPARK-25032
URL: https://issues.apache.org/jira/browse/SPARK-25032
Project: Spark
Issue Type: Improvement
Components: Spark Shell
Affects Versions: 2.3.1, 2.3.0, 2.1.0
Environment: Spark 2.3.1
Hadoop 2.7.3
Reporter: Ayush Anubhava
*Launch spark-beeline for both the scenarios*
*Scenario 1*
create database cbo1;
create table test2 ( a int, b string , c int) stored as parquet;
drop database cbo1 cascade;
create table test1 ( a int, b string , c int) stored as parquet;
{color:#FF0000}Output : Exception is thrown at this point {color}
{color:#FF0000}Error:
org.apache.spark.sql.catalyst.analysis.NoSuchDatabaseException: Database 'cbo1'
not found; (state=,code=0){color}
*Scenario 2:*
create database cbo1;
create table test2 ( a int, b string , c int) stored as parquet;
drop database cbo1 cascade;
create database cbo1;
create table test1 ( a int, b string , c int) stored as parquet;
{color:#FF0000}Output : Table is getting created in the database "*cbo1*",
even on not using the database.It should have been created in default db.{color}
In beeline session, after dropping the database , it is not falling back to
default db
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
