iceberg load data with hive

hayder-cardano — Tue, 21 Apr 2026 07:44:51 GMT

hi

I want to know if its possible to use the LOAD DATA INPATH to load parquet files into an external iceberg table?

right now I am getting the following error:
Error while compiling statement: FAILED: SemanticException [Error 10101]: A non-native table cannot be used as target for LOAD

does hive support LOAD DATA INPATH with Iceberg tables?

Re: iceberg load data with hive

hayder-cardano — Mon, 06 Feb 2023 14:07:43 GMT

going to answer myself.

as of hive3, its not yet possible to directly bulk load external datasets (e.g. parquet / orc) files. so its necessary to do the following.
create temporary managed hive table
LOAD DATA INPATH the parquet / orc / csv into the temporary managed hive table
create external table as iceberg.
Select * and copy into the external iceberg table

this has worked with the following iceberg features.
write, append, time-travel

question iceberg load data with hive in Support Questions

iceberg load data with hive

Re: iceberg load data with hive