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 or S3.

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.