无法使用Spark在Apache Iceberg的表中写入数据

Question

我是第一次接触阿帕奇冰山。我想使用Apache Iceberg执行读写操作。我使用的是Spark 3.0.0。

代码：

    System.setProperty("hadoop.home.dir","C:\\hadoop" )
    val conf = new SparkConf()
    conf.set("spark.sql.extensions","org.apache.iceberg.spark.extensions.IcebergSparkSessionExtensions")
    conf.set("spark.sql.catalog.spark_catalog","org.apache.iceberg.spark.SparkSessionCatalog")
    conf.set("spark.sql.catalog.spark_catalog.type","hive")
    conf.set("spark.sql.catalog.local","org.apache.iceberg.spark.SparkCatalog")
    conf.set("spark.sql.catalog.local.type","hadoop")
    conf.set("spark.sql.catalog.local.warehouse","warehouse")

    val spark = SparkSession.builder().master("local").config(conf).getOrCreate()
    
    spark.sql("CREATE TABLE local.db.table (id bigint, data string) USING iceberg")
    spark.sql("INSERT INTO local.db.table VALUES (1, 'a'), (2, 'b'), (3, 'c')")

依赖列表：

    compile group: 'org.scala-lang', name: 'scala-library', version: '2.12.0'

    compile group: 'org.apache.spark', name: 'spark-core_2.12', version: '3.0.0'
    compile group: 'org.apache.spark', name: 'spark-sql_2.12', version: '3.0.0'

    compile group: 'org.apache.iceberg', name: 'iceberg-spark', version: '0.11.1'
    compile group: 'org.apache.iceberg', name: 'iceberg-spark3-runtime', version: '0.11.1'

    compile group:  'org.apache.hive', name: 'hive-metastore', version: '2.0.1'

异常消息：

java.lang.ClassCastException: org.apache.iceberg.shaded.org.apache.parquet.schema.MessageType cannot be cast to org.apache.parquet.schema.MessageType
    at org.apache.iceberg.parquet.ParquetWriter.<init>(ParquetWriter.java:96)
    at org.apache.iceberg.parquet.Parquet$WriteBuilder.build(Parquet.java:250)
    at org.apache.iceberg.spark.source.SparkAppenderFactory.newAppender(SparkAppenderFactory.java:110)

是否需要任何其他依赖项才能启用MessageType强制转换。

Answer 1

当使用Spark和Iceberg时，你只想使用iceberg-spark3-runtime jar。这是一个阴影jar，可以防止与Spark依赖发生依赖冲突。如果你也包含iceberg-spark，你将会遇到冲突，因为这是Spark2的未着色jar，并且将包含未着色的依赖项，这将与Spark3和Iceberg-Spark3-Runtime冲突。

所以总而言之，你应该删除

    compile group: 'org.apache.iceberg', name: 'iceberg-spark', version: '0.11.1'

还有这个

    compile group: 'org.apache.iceberg', name: 'iceberg-spark3-runtime', version: '0.11.1'

应标记为提供的(或运行时)依赖项