Explore spark struct streaming write iceberg and synchronize to hive Metastore

[zhangxia1030]

1. build sparksession

val spark = SparkSession
     .builder()
     .config("spark.sql.extensions", "org.apache.iceberg.spark.extensions.IcebergSparkSessionExtensions")
     .config("spark.sql.catalog.spark_catalog", "org.apache.iceberg.spark.SparkSessionCatalog")
     .config("spark.sql.catalog.spark_catalog.type", "hive")
     .config(SQLConf.PARTITION_OVERWRITE_MODE.key, "dynamic")
     .config("spark.hadoop.hive.metastore.uris", "thrift://ip:port")
     .config("hive.exec.dynamic.partition", "true")
     .config("hive.exec.dynamic.partition.mode", "nonstrict")
     .appName("test-iceberg")
     .master("local[*]")
     .enableHiveSupport()
     .getOrCreate()

2. use hive catalog

val v2catlog = spark.sessionState.catalogManager.v2SessionCatalog.asInstanceOf[SparkSessionCatalog[SparkCatalog]]
v2catlog.createTable(id, schema, Spark3Util.toTransforms(spec.build()), immutableMap)


df
.writeStream()
        .outputMode("append")
        .format("iceberg")
        .option("checkpointLocation", checkpointPath)
        .option("path", locationPath)

error log:

Caused by: org.apache.hadoop.ipc.RemoteException: File does not exist: /path/metadata/version-hint.text
	at org.apache.hadoop.hdfs.server.namenode.INodeFile.valueOf(INodeFile.java:71)
	at org.apache.hadoop.hdfs.server.namenode.INodeFile.valueOf(INodeFile.java:61)

SparkSessionCatalog create table, that sync hive metastore. But report an error. Refer to the above

3. use hadoop catalog

val tables = new HadoopTables(spark.sparkContext.hadoopConfiguration)
tables.create(schema, spec, sort, immutableMap, path)

df
.writeStream()
        .outputMode("append")
        .format("iceberg")
        .option("checkpointLocation", checkpointPath)
        .option("path", locationPath)

spark struct streaming works normally, but I need to synchronize the meta information to hive metastroe, Is there any way?

[github-actions]

This issue has been automatically marked as stale because it has been open for 180 days with no activity. It will be closed in next 14 days if no further activity occurs. To permanently prevent this issue from being considered stale, add the label 'not-stale', but commenting on the issue is preferred when possible.

[github-actions]

This issue has been closed because it has not received any activity in the last 14 days since being marked as 'stale'