[ 
https://issues.apache.org/jira/browse/SPARK-33686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17245651#comment-17245651
 ] 

xiepengjie commented on SPARK-33686:
------------------------------------

[~srowen]  : thx for your report, it's really not a bug, but an improvement. We 
have a lot of tasks about hive sql, when migrating it to spark sql, we found we 
can't. Hive support it, if Spark also supports it, it will be easier for users 
to use Spark. Can we talk about it on github?

> Spark SQL unrecognized `db.tbl`
> -------------------------------
>
>                 Key: SPARK-33686
>                 URL: https://issues.apache.org/jira/browse/SPARK-33686
>             Project: Spark
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 2.4.2
>            Reporter: xiepengjie
>            Priority: Major
>
> When executing command like this:
> {code:java}
> create table `bigdata_db.test_spark_33686` (c1 int);
> {code}
> exception will thrown:
> {code:java}
> spark-sql> create table `bigdata_db.test_spark_33686` (c1 int);Error in 
> query: `bigdata_db.test_spark_33686` is not a valid name for 
> tables/databases. Valid names only contain alphabet characters, numbers and 
> _.;
> {code}
> you must write command like this:
> {code:java}
> create table `bigdata_db`.`test_spark_33686` (c1 int);
> {code}
> i think we should support `db.tbl`



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org

Reply via email to