PrestoDB/PrestoSQL¶
To configure a Presto data source to perform bulk data loads, follow these steps:
In Presto, check the configuration property
hive.non-managed-table-writes-enabled
istrue
.Virtual DataPort transfers data into PrestoDB/PrestoSQL 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 nottrue
, the process of storing data in PrestoDB/PrestoSQL 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.
Follow the same steps as for Impala.
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/PrestoSQL server.