zfno111 commented on issue #5267: URL: https://github.com/apache/iceberg/issues/5267#issuecomment-1183854811
> @zfno111 are you potentially missing the [iceberg-hive-runtime.jar](https://search.maven.org/artifact/org.apache.iceberg/iceberg-hive-runtime/0.11.1/jar)? See also https://iceberg.apache.org/docs/latest/hive/#loading-runtime-jar on how to add this tks for answer, here is my full code hive hive> add jar /mnt/disk1/iceberg/iceberg-hive-runtime-0.11.1.jar ; Added [/mnt/disk1/iceberg/iceberg-hive-runtime-0.11.1.jar] to class path Added resources: [/mnt/disk1/iceberg/iceberg-hive-runtime-0.11.1.jar] hive> add jar /mnt/disk1/iceberg/libfb303-0.9.3.jar; Added [/mnt/disk1/iceberg/libfb303-0.9.3.jar] to class path Added resources: [/mnt/disk1/iceberg/libfb303-0.9.3.jar] hive> add jar /mnt/disk1/iceberg/iceberg-hive-metastore-0.11.1.jar; Added [/mnt/disk1/iceberg/iceberg-hive-metastore-0.11.1.jar] to class path Added resources: [/mnt/disk1/iceberg/iceberg-hive-metastore-0.11.1.jar] hive> CREATE EXTERNAL TABLE `iceberg_hive`( > `id` int, > `name` string) > STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler' > LOCATION > 'hdfs://10.0.5.66:9000/tmp/warehouse/test/iceberg_hive' > TBLPROPERTIES ( > 'numFiles'='1', > 'table_type'='ICEBERG'); FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Could not initialize class org.apache.iceberg.mr.hive.serde.objectinspector.IcebergObjectInspector i‘m use hive EXTERNAL TABLE to connect iceberg,not flink -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
