cannot be resolved on the right side of the join. The right-side columns

最新推荐文章于 2022-10-05 15:13:28 发布
原创 最新推荐文章于 2022-10-05 15:13:28 发布 · 2.4k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

博客讲述了右侧数据全为null的问题，原因是写代码时为防止报错，在返回值处使用了spark.emptyDataFrame，上线时未去掉，导致问题未被及时发现，属于低级错误。 
ERROR yarn.ApplicationMaster: User class threw exception: org.apache.spark.sql.AnalysisException: USING column `user_id` cannot be resolved on the right side of the join. The right-side columns: [];
org.apache.spark.sql.AnalysisException: USING column `user_id` cannot be resolved on the right side of the join. The right-side columns: [];

这个就是右侧的数据全部为null，可以看下右侧数据是否存在问题（我的原因是 自己在写代码的时候 在返回值处给了一个spark.emptyDataFrame，防止在写代码的时候提示报错，但是上线的时候没有去掉，导致一直没有检查出来） 

 

低级错误！！！！！！！

4-The Network Layer
gaoxiangnumber1——Gao Xiang's Blog
09-21 8403
Please indicate the source: http://blog.csdn.net/gaoxiangnumber1Welcome to my github: https://github.com/gaoxiangnumber14.1 Introduction Figure 4.1 shows a network with two hosts, H1 and H2, and severa
IBM DB2 SQL error code list
weixin_30426957的博客
08-25 2336
SQL return codes that are preceded by a minus sign (-) indicate that the SQL statement execution was unsuccessful. IBM DB2 SQL error code list 官方文档地址：https://www.ibm.com/support/knowledgecente...
报出现“"cannot be resolved or is not a field"，
蚁人日记
02-14 3326
出现“"cannot be resolved or is not a field"，是因为当前java类的导入不是当前项目的R文件 ，而是导入了Android.R文件。 解决：找到对应报错误的类，删除java代码中的”import Android.R“（在类导入部分）。然后导入项目R文件即可
出现"cannot be resolved or is not a field"莫名错误的解决方法
A13428103432的博客
09-13 5万+
程序出现一个很奇怪的错误，检查程序很多遍，确定程序没有任何问题，还出现“"cannot be resolved or is not a field"错误，最有可能的原因就是导入的包不正确。解决方法如下： 1、检查一下该类中你所导入的包，把不正确的包删除掉，例如删除java代码中的”import android.R“代码，并且如果代码是你从其他地方复制过来的话，可能程序也会默认导入其他项目的包
Presto “Column 'xxx' cannot be resolved”的解决办法
甘焕的博客
09-20 3万+
在使用Presto的过程中，提示如下错误： Query 20180912_035603_00940_xc5ft failed: line 1:75: Column 'xxx' cannot be resolved LINE 1: select system, concat(year, month, day, hour) from mytable where "value"="xxx" 更奇怪的是...
column can not be re-read 问题的解决办法
Inber
03-10 2925
我觉得有必要在这里分享一下我得到解决关于 column can not be re-read 的问题，尽管这篇文章是受网上一篇文章的影响而发jsp 页面：view_edit.jsp1 2 3 4 String listsId=request.getParameter("id");5 Lists lists=ls.getListsInfo(listsId);6 %>ListsBean 的部分代码：2
关于"cannot be resolved or is not a field"错误的解决方法
nocol的博客
12-07 1万+
关于"cannot be resolved or is not a field"错误的解决方法
2025-06-17 16:27:18,765 | INFO | [Driver] | Final app status: FAILED, exitCode: 15, (reason: User class threw exception: org.apache.spark.sql.AnalysisException: USING column `MEASUREMENT_ID` cannot be resolved on the left side of the join. The left-side columns: [MEASVREMENT_ID, V1, V2, V3, V4, V5, V6, V7, V8, V9, V10, V11, V12, V13, V14, V15, V16, V17, V18, V19, V20, V21, V22, V23, V24, V25, V26, V27, V28, V29, V30, V31, V32, V33, V34, V35, V36, V37, V38, V39, V40, V41, V42, V43, V44, V45, V46, V47, V48, V49, V50, V51, V52, V53, V54, V55, V56, V57, V58, V59, V60, V61, V62, V63, V64, V65, V66, V67, V68, V69, V70, V71, V72, V73, V74, V75, V76, V77, V78, V79, V80, V81, V82, V83, V84, V85, V86, V87, V88, V89, V90, V91, V92, V93, V94, V95, V96, TELEMETRY_TYPE, TRANSANALOGU]
06-18
</think>### Spark SQL AnalysisException: "USING column cannot be resolved on the left side of the join" 解决方案 这个错误通常发生在使用`USING`子句进行表连接时，Spark无法在左表中找到指定的连接列。以下...
2025-03-24 20:39:40,980 INFO org.apache.spark.deploy.yarn.ApplicationMaster - Final app status: FAILED, exitCode: 15, (reason: User class threw exception: org.apache.spark.sql.AnalysisException: USING column `left` cannot be resolved on the left side of the join. The left-side columns: [COLLECT_ID, MP_ID, CITY_ORG_ID, CITY_ORG_NAME, MAINTAINER_ID, MAINTAINER_NAME, MAINTCREW_ID, MAINTCREW_NAME, ORG_NO, ORG_NAME, CUST_ID, CUST_NO, CUST_NAME, TRANSFORMER_ID, TRANSFORMER_NAME, CUST_MP_LEVEL_NAME, CUST_VOLTAGE_LEVEL_NAME, MP_VOLTAGE_LEVEL_NAME, CUST_MP_LEVEL_CODE, CUST_VOLTAGE_LEVEL_CODE, MP_VOLTAGE_LEVEL, LINE_ID, LINE_NAME, UPPER_RATE, LOWER_RATE, UPPER_TL, LOWER_TL, QUALIFIED_TL, TOTAL_TL, QUALIFIED_RATE, MAX_VOLTAGE, MAX_VOLTAGE_TIME, MIN_VOLTAGE, MIN_VOLTAGE_TIME, PROVINCE_NAME, PROVINCE_ID, WIRING_MODE, MEAS_MODE, STATION_ID, STATION_NAME, AVG_VOLTAGE, RANGE_QUALIFIED_RATE, RANGE_UPPER_RATE, RANGE_LOWER_RATE, RANGE_UPPER_HIGH_RATE, RANGE_LOWER_LOW_RATE, RANGE_UPPER_HIGHER_RATE, RANGE_LOWER_DOWN_RATE, CRITICAL_LOWER_RATE, RANGE_UPPER_TL_A, RANGE_LOWER_TL_A, RANGE_UPPER_HIGH_TL_A, RANGE_LOWER_LOW_TL_A, RANGE_UPPER_HIGHER_TL_A, RANGE_LOWER_DOWN_TL_A, CRITICAL_LOWER_TIME, RANGE_QUALIFIED_TL, UPPER_TIME, UPPER_TIME_HUG, LOWER_TIME, LOWER_TIME_HUG, UPPER_TIME1, UPPER_TIME2, WAVE_ORDINARY_TIME, WAVE_TIME, IS_UPPER_OVER, IS_UPPER_OVER_HUG, IS_LOWER_OVER, IS_LOWER_OVER_HUG, UPPER_CUST_NUM1, UPPER_CUST_NUM2, IS_WAVE, IS_ORDINARY_WAVE, IS_CRITICAL_LOWER_OVER, IS_RANGE_LOWER_DOWN_A, IS_RANGE_LOWER_LOW_A, IS_RANGE_LOWER_A, IS_RANGE_UPPER_A, IS_RANGE_UPPER_HIGH_A, IS_RANGE_UPPER_HIGHER_A, UPPER_TIME_INDEX, UPPER_TIME_INDEX_HUG, LOWER_TIME_INDEX, LOWER_TIME_INDEX_HUG, INDEX, FC_GC_FLAG, TG_NO, TRADE_CODE, TRADE_NAME, ELEC_TYPE_CODE, IS_DUAL_POWER, CUST_PRIO_CODE, IMPORTANT_TYOE_NAME, INSTALLED_CAPACITY, CONTRACT_CAP, FREQUENCY_TYPE, ABNORMAL_PT_VALUE, PT_VALUE, IS_IMPORT_CUST, IS_FOCUS_CUST, IS_COMPLAINT_CUST, IS_REPORT_CUST, IS_PROJECT_CUST, IS_PROTECTION_CUST, IS
03-26
当遇到 `AnalysisException` 异常，提示 `USING column cannot be resolved` 时，通常表明查询中的某些列名未被正确识别或不存在于数据集中。以下是可能的原因及其对应的解决办法： #### 可能原因一：列名拼写错误 ...
【COMP2411: Database Systems Learning Notes】
m0_66706847的博客
10-05 1515
Database Systems Learning Notes
spark sql中join的filter下推规则
egraldloi的专栏
06-24 4292
object PushPredicateThroughJoin extends Rule[LogicalPlan] with PredicateHelper {   // split the condition expression into 3 parts,    // (canEvaluateInLeftSide, canEvaluateInRightSide, haveToEvaluat
hibernate jpa Table "xxxx" cannot be resolved
Jc0803kevin的专栏
04-29 1465
新建一个hibernate 的jpa项目 出现 Table "xxxx" cannot be resolved 这个问题。 解决办法 将这个钩去掉，之后就可以了。
Tableau学习笔记：join
weixin_33905756的博客
12-27 1216
The data that you analyze in Tableau is often made up of a collection of tables that are related by specific fields (that is, columns). Joining is a method for combining the related data on those comm...
"cannot be resolved or is not a field"问题解决
热门推荐
记录和分享程序人生的点点滴滴
11-18 7万+
在修改了资源文件后，出现“"cannot be resolved or is not a field"，解决方法如下： 1.   删除R.java文件，这时，系统会重新生成一个R.java; 2.  删除java代码中的”import android.R“文件。 问题解决。
解决 XXX cannot be resolved or is not a field 问题
ste239的博客
02-28 2万+
1、案例 list1 = this.getSelectService().getDao().getSession().createSQLQuery(sqlK).list(); this. UmppExtendRecord uer = new UmppExtendRecord(); 2、原因 1）代码错误，查看报错附近代码是否完整。 2）i...
the import org.testng cannot be resolved
最新发布
08-10
首先，用户的问题是关于Java项目中TestNG导入错误的解决方案："Java TestNG import cannot be resolved solution"。我需要基于系统级指令来构建回答。 系统级指令关键点： - 所有行内数学表达式使用$...$格式（但这...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值