PrestoDB/Trino¶

To configure a Presto data source to perform bulk data loads, follow these steps:

1. In Presto, check the configuration property hive.non-managed-table-writes-enabled is true.

   Virtual DataPort transfers data into PrestoDB/Trino using non-managed (external) Hive tables. By using external tables, the URI configured to upload the data files can be different than the location of the schema used for caching or perform data movements. If the property hive.non-managed-table-writes-enabled is not true, the process of storing data in PrestoDB/Trino will fail. To restore the behavior of previous versions of Denodo (i.e. not using external tables), execute this:

   SET 'com.denodo.vdb.util.tablemanagement.sql.PrestoTableManager.useExternalTables'='false';
   

   You do not need to restart to apply this change.

2. Follow the steps in section Bulk Data Load on a Distributed Object Storage like HDFS, S3 or ADLS.

3. In the configuration of the data source, on the section Use bulk data load API of the Read & Write tab, set the Server time zone box to the time zone of the PrestoDB/Trino server.

For information about creating Iceberg tables in PrestoDB/Trino, see Create Iceberg Tables in the Denodo Embedded MPP section.