在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;