[42000][3] Error while processing statement: FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.spark.SparkTask.

合集 - BigData Learning2023(2)

1.HDFS文件因Hadoop版本原因导致append操作失败的问题2023-05-24

2.[42000][3] Error while processing statement: FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.spark.SparkTask.2023-08-14

收起

[42000][3] Error while processing statement: FAILED: Execution Error, return code 3 from org.apache.hadoop.hive.ql.exec.spark.SparkTask. Spark job failed during runtime. Please check stacktrace for the root cause.
原因:
数据类型不对导致的错误,如果表字段是string类型，装载数据时字段是bigint类型就会出错。
或者
如果字段本应是浮点型的话,你返回0(整数型)就会造成错误!!!

解决方法:
将数据格式修改成对应的即可!!!