spark sql中Exception in thread “main“ 问题

时间:2024-10-21 07:48:36
在spark中遇到Exception in thread “main” .,这往往是所选取 'pibid'字段不存在,或者名字写错了。所以要查该字段!!!

Exception in thread “main” : cannot resolve ‘pibid’ given input columns: [spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.courseno, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.createtime, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.creator, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.dataflag, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.examendtime, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.examlevel, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.examstarttime, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.fullmark, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.globalgrade, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.gradeid, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.gradename, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.havenostunum, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.havestunum, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.id, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.import, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.islatest, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.lasteditor, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.lastedittime, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.pubid, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.ratea, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.rateb, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.ratec, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.remark, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.schoolid, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.subjectid, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.subjectname, spark_catalog.lg_edu_warehouse.dwd_t_baseexamhead.term]; line 1 pos 19;

查明后,发现是字段名称写错了,因此需要修改字段

在这里插入图片描述