spark SQL里面出现mismatched input ‘lg_edu_warehouse‘ expecting {＜EOF＞, ‘；‘}解决方法

mismatched input ‘lg_edu_warehouse’ expecting {, ‘;’}问题解决1、报错信息== SQL ==select lastedittime form lg_edu_warehouse.dwd_student_allinfo_day_detailwhere dataflag=0at org.apache.spark.sql.catalyst.parser.

加盐不加辣

6783人浏览 · 2021-11-10 11:14:46

加盐不加辣 · 2021-11-10 11:14:46 发布

mismatched input ‘lg_edu_warehouse’ expecting {, ‘;’}问题解决

1、报错信息

== SQL ==
select lastedittime form lg_edu_warehouse.dwd_student_allinfo_day_detailwhere dataflag=0

at org.apache.spark.sql.catalyst.parser.ParseException.withCommand(ParseDriver.scala:266)
at org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parse(ParseDriver.scala:133)
at org.apache.spark.sql.execution.SparkSqlParser.parse(SparkSqlParser.scala:48)
at org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parsePlan(ParseDriver.scala:81)
at org.apache.spark.sql.SparkSession.$anonfun$sql$2(SparkSession.scala:604)
at org.apache.spark.sql.catalyst.QueryPlanningTracker.measurePhase(QueryPlanningTracker.scala:111)
at org.apache.spark.sql.SparkSession.$anonfun$sql$1(SparkSession.scala:604)
at org.apache.spark.sql.SparkSession.withActive(SparkSession.scala:763)
at org.apache.spark.sql.SparkSession.sql(SparkSession.scala:601)
at StudentPrediectEveryday.EveryDayPrediect$.everyDayPrediect(EveryDayPrediect.scala:306)
at StudentPrediectEveryday.EveryDayPrediect$.main(EveryDayPrediect.scala:267)
at StudentPrediectEveryday.EveryDayPrediect.main(EveryDayPrediect.scala)

找到原因后，发现是from写错了，写成了form。但是SQL是不会将form报错的，所以需要仔细观察。