[
https://issues.apache.org/jira/browse/SPARK-28696?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16905196#comment-16905196
]
Ajith S commented on SPARK-28696:
---------------------------------
I think we should disallow if a identifier starts with _ for create database
and create table
Partially we can see its effect in SPARK-28697 where as the table name starts
with _ (like _sampleTable) , the FileFormat assumes it to be a hidden folder
and do not list it which causes unusual behavior
> create database _; allowing in Spark but Hive throws Parse Exception
> --------------------------------------------------------------------
>
> Key: SPARK-28696
> URL: https://issues.apache.org/jira/browse/SPARK-28696
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 3.0.0
> Reporter: ABHISHEK KUMAR GUPTA
> Priority: Minor
>
> In Spark
> spark-sql> create database _;
> Time taken: 0.062 seconds
> spark-sql> show databases;
> _
> adap
> adaptive
> adaptive_tc8
> In Hive
> 0: jdbc:hive2://10.18.98.147:21066/> create database _;
> Error: Error while compiling statement: FAILED: ParseException line 1:16
> cannot recognize input near '_--0' '<EOF>' '<EOF>' in create database
> statement (state=42000,code=40000)
--
This message was sent by Atlassian JIRA
(v7.6.14#76016)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
