Help Center/
MapReduce Service/
Component Operation Guide (LTS)/
Using Spark2x/
Common Issues About Spark2x/
Spark SQL and DataFrame/
Why the Operation Fails When the Table Name Is TABLE?
Updated on 2022-11-18 GMT+08:00
Why the Operation Fails When the Table Name Is TABLE?
Question
When the table name is set to table, why the error information similar to the following is displayed after the drop table table command or other command is run?
16/07/12 18:56:29 ERROR SparkSQLDriver: Failed in [drop table table] java.lang.RuntimeException: [1.1] failure: identifier expected table ^ at scala.sys.package$.error(package.scala:27) at org.apache.spark.sql.catalyst.SqlParserTrait$class.parseTableIdentifier(SqlParser.scala:56) at org.apache.spark.sql.catalyst.SqlParser$.parseTableIdentifier(SqlParser.scala:485)
Answer
The word table is a keyword of Spark SQL statements and must not be used as a table name.
Parent topic: Spark SQL and DataFrame
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
