To configure a Presto data source to perform bulk data loads, follow the same process described for Impala. When enabling “Use bulk data load API” on the “Read & Write” tab, there is an additional step:

  • In the Server time zone box, select the time zone of the Presto server.


By default, the URI configured to upload the data files must be the same than the location of the schema used for caching or data movement. To remove this limitation, do this:

  1. Execute:

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

    You do not need to restart to apply this change.

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

Add feedback