栏目分类:
子分类:
返回
名师互学网用户登录
快速导航关闭
当前搜索
当前分类
子分类
实用工具
热门搜索
名师互学网 > IT > 前沿技术 > 大数据 > 大数据系统

spark SQL里面出现mismatched input ‘lg

spark SQL里面出现mismatched input ‘lg

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报错的,所以需要仔细观察。

转载请注明:文章转载自 www.mshxw.com
本文地址:https://www.mshxw.com/it/467315.html
我们一直用心在做
关于我们 文章归档 网站地图 联系我们

版权所有 (c)2021-2022 MSHXW.COM

ICP备案号:晋ICP备2021003244-6号