1 Answer
- Newest
- Most votes
- Most comments
4
Hello,
I presume your issue might relies on any of the below considerations,
1. Only the MR (MapReduce) execution engine is supported for DML (data manipulation language) operations, and MR is deprecated in Hive 3.1.3.
2. AWS Glue Data Catalog is not currently supported for Iceberg with Hive.
Please check your hive engine as Tez is the default engine in EMR 6.4.1 and make sure it is mr. Also check if you are not using glue as metastore. It requires external metastore to interact with iceberg and transaction tables.
References:
[1] - https://docs.aws.amazon.com/emr/latest/ReleaseGuide/hive-considerations.html
Relevant content
- Accepted Answerasked 2 years ago
- Accepted Answerasked 4 months ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated 2 years ago
Excellent, when I checked the execution engine to mr, it started working. Thanks a lot💪