spark报错java.lang.IllegalArgumentException: Can‘t get JDBC type for array＜string＞

喜欢ヅ旅行 2024-03-23 18:36 6阅读 0赞

> 1、使用spark任务将hive中的表数据存入到mysql中报如下错误

java.lang.IllegalArgumentException: Can't get JDBC type for array<string>
    	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$org$apache$spark$sql$execution$datasources$jdbc$JdbcUtils$$getJdbcType$2.apply(JdbcUtils.scala:183)
    	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$org$apache$spark$sql$execution$datasources$jdbc$JdbcUtils$$getJdbcType$2.apply(JdbcUtils.scala:183)
    	at scala.Option.getOrElse(Option.scala:121)
    	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$.org$apache$spark$sql$execution$datasources$jdbc$JdbcUtils$$getJdbcType(JdbcUtils.scala:182)
    	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$schemaString$1$$anonfun$23.apply(JdbcUtils.scala:737)
    	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$schemaString$1$$anonfun$23.apply(JdbcUtils.scala:737)
    	at scala.collection.MapLike$class.getOrElse(MapLike.scala:128)
    	at scala.collection.AbstractMap.getOrElse(Map.scala:59)
    	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$schemaString$1.apply(JdbcUtils.scala:737)
    	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$schemaString$1.apply(JdbcUtils.scala:734)
    	at scala.collection.IndexedSeqOptimized$class.foreach(IndexedSeqOptimized.scala:33)
    	at scala.collection.mutable.ArrayOps$ofRef.foreach(ArrayOps.scala:186)
    	at com.wq.cloud.sparkJob.job.ExchangeDataJob.jobScript(ExchangeDataJob.java:93)
    	at com.wq.cloud.sparkJob.job.ExchangeDataJob.main(ExchangeDataJob.java:41)
    	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    	at java.lang.reflect.Method.invoke(Method.java:498)
    	at org.apache.spark.deploy.yarn.ApplicationMaster$$anon$2.run(ApplicationMaster.scala:673)
    23/08/04 16:48:05 INFO yarn.ApplicationMaster: Final app status: FAILED, exitCode: 15, (reason: User class threw exception: java.lang.IllegalArgumentException: Can't get JDBC type for array<string>
    	at org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils$$anonfun$org$apache$spark$sql$execution$datasources$jdbc$JdbcUtils$$getJdbcType$2.apply(JdbcUtils.scala:183)

> 2、原因：hive表中元素为数组类型，mysql不支持，需要将类型转换一下就可（比如转换成字符串等等）

> 3、方案：进行备份之前将hive中为数组类型的数据结构进行转换一下

StructType schema = hiveData.schema();
    StructField[] fields = schema.fields();
    
    for (StructField field : fields) {
        
        String fieldName = field.name();
        DataType fieldType = field.dataType();
    
        if (fieldType instanceof ArrayType) {
        
            String newColumnName = fieldName + "_asString";
    
            hiveData = hiveData.withColumn(newColumnName, functions.concat_ws(",", functions.col(fieldName)));
            hiveData = hiveData.drop(fieldName).withColumnRenamed(newColumnName, fieldName);
        }
    }