How to create materialized view in trino by iceberg connector? #18991
Replies: 3 comments
-
How do I run hive containers? set version: export HIVE_VERSION=4.0.0-alpha-2 metastore-standalone: docker run -d -p 9083:9083 --env SERVICE_NAME=metastore --name metastore-standalone apache/hive:${HIVE_VERSION} server-standalone: docker run -d -p 10000:10000 -p 10002:10002 --env SERVICE_NAME=hiveserver2 \
--env SERVICE_OPTS="-Dhive.metastore.uris=thrift://metastore_host:9083" \
--env IS_RESUME="true" \
--name hiveserver2-standalone apache/hive:${HIVE_VERSION} |
Beta Was this translation helpful? Give feedback.
-
For the sake of simplicity of the test environment, I have not configured anything beyond the above, which may have caused me to miss some details about the permissions between trino icerberg connector and hive. |
Beta Was this translation helpful? Give feedback.
-
There is no problem with the network and I can perform the corresponding query operations. |
Beta Was this translation helpful? Give feedback.
-
I deployed hive's docker container, used hive4 as the image.
I deployed a metastore-standalone and a server-standalone.
And I configured iceberg.properties files according to the official trino documents.
I can see tables in hive through the iceberg connector.
But I cannot create table, create view or create materialized view by iceberg connector.
iceberg.properties:
hive image: apache/hive:4.0.0-alpha-2
create table reports an error:
Query 20230911_122041_00013_esht9 failed: Failed to write manifest list file
create view for a table which is created by hive client:
Query xxx failed: Metadata not found in metadata location for table default.table_name
version info:
Beta Was this translation helpful? Give feedback.
All reactions