开启Hive runtime参数设置:
hive.security.authorization.sqlstd.confwhitelist=mapred.*|hive.*|mapreduce.*|spark.*|iceberg.*|engine.*
hive.security.authorization.sqlstd.confwhitelist.append=mapred.*|hive.*|mapreduce.*|spark.*|iceberg.*|engine.*
添加iceberg jar包和设置运行参数:
add jar /data/iceberg-hive-runtime-0.13.1.jar;
SET engine.hive.enabled=true;
SET iceberg.engine.hive.enabled=true;
SET iceberg.mr.catalog=hive;
创建iceberg表:
CREATE EXTERNAL TABLE icebergtest.testhive3(
`name` TIMESTAMP WITH LOCAL TIME ZONE)
STORED BY 'org.apache.iceberg.mr.hive.HiveIcebergStorageHandler' ;