USER MANUALS

What Is New in Embedded MPP 9.20241007

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

Presto

  • Upgrade Presto version to 0.289.

  • Now, the MPP can read Delta Lake tables up to Delta Protocol Version 3,7

  • Now, the MPP will skip empty Parquet files when reading Hive tables

  • Dynamic filtering has been enabled. This optimization improves the performance of queries with selective joins by avoiding reading of data that would be filtered by join condition

  • Pushdown filter has been enabled. This optimization makes table scan more efficient

  • “Quick stats” has been enabled. This optimization builds stats from metadata when statistics are missing. These “quick” statistics, even if incomplete help the planner to build better plans

  • Now, vectorized readings can be enabled, as the timing improvements are noticeable when running TPCH-100 and TPCH-1000. Still, the default value will remain false, as reading complex types with decimals inside with the property enabled will result in an error. But, in any other case, it is strongly recommended to enable it.

  • Now, the MPP support KeyStores with multiple Subject Alternative Name (SAN) in certificates

  • Presto CLI has been included for easy query execution for debugging and testing

Kubernetes and Helm

  • AWS SKD v1.12.746 is included to enable EKS Pod Identities to manage AWS credentials. This method is preferable to IRSA or the instance role

  • Now, you can import any certificate into the JVM by simply placing those certificates under the certs/ folder of the Helm chart

  • Horizontal autoscaling has been upgraded to v2 to provide additional options for modifying the scalability behavior of the HPA

  • The Hive Metastore heap size can be configured via values.yaml. Its default value has been increased to 2GB

  • The host name of the MPP can be configured via values.yaml

Denodo

  • denodo-connector has been upgraded to v1.2.1 to improve the Embedded MPP acceleration in Denodo 9.1 by storing the statistics of the auxiliary views that expose the Denodo data to the MPP

Security

  • Several third-party library versions have been updated to address some security vulnerabilities: Denodo Embedded MPP Security Bulletin

How to Upgrade to this New Version

Run helm upgrade prestocluster prestocluster/ with the updated version of the Helm chart after modifying the values.yaml file according to your needs.

Add feedback