USER MANUALS

What Is New in Embedded MPP 8.0.20240505

This page lists the main enhancements of the Denodo Embedded MPP 8.0.20240506.

Presto

  • Upgrade Presto version to 0.286.

    This Presto version includes several enhancements like:

    • Add UPDATE sql support in Presto.

    • Add register and unregister procedures for Iceberg tables.

    • Add support for creating Iceberg tables using the AWS Glue metastore.

    • Add support for Iceberg views.

    • Add support for reading v2 row level deletes in Iceberg connector.

    • Add support for time travel in Iceberg tables, with the AS OF syntax.

  • The self-signed certificate has been renewed. If you are using it for testing, be sure to import this new certificate into the truststore of the Denodo servers.

How to Upgrade to this New Version

Create a backup of the embedded PostgreSQL or the external database of the embedded Hive Metastore.

If you are using the embedded PostgreSQL this backup is mandatory since upgrades to new major versions of PostgreSQL do not maintain backwards compatibility.

You must create a manual dump before the upgrade and restore it before creating new tables in the Denodo Embedded MPP.

Dump of the old Embedded Postgresql
kubectl exec <PostgreSQL Pod> -- bash -c "PGPASSWORD=hive pg_dump -c -U hive -h localhost metastore" > database.sql
Restore the new Embedded Postgresql
 cat database.sql | kubectl exec -i <PostgreSQL Pod> -- bash -c "PGPASSWORD=hive psql -U hive -h localhost -d metastore"

Once the manual dump is done, set postgresql.version15BackupWarning to false in values.yaml and continue with the installation upgrade of the Denodo Embedded MPP.

Add feedback