Migrating the Presto Repository from 3.1.1 to 3.2
If you are upgrading to Presto 3.2, but using an existing 3.1.1 Presto Repository, there are several minor updates to the schema or configuration properties that you must make to your 3.1.1 Presto Repository.
1. If your existing 3.1.1 Presto Repository is hosted in a PostgreSQL database, you must replace one JAR file before you apply schema changes:
a. Remove the web-apps-home/presto/WEB-INF/lib/rds.jar JAR file. You can delete this JAR or simply move it to a folder outside of the Presto web application.
b. Copy this JAR file:
presto-install/dist/rds-postgresql.jar
To the web-apps-home/presto/WEB-INF/lib folder.
2. Use the SQL client or command line tool for your existing 3.1.1 Presto Repository. Run the SQL script shown below from the folder that corresponds to your database in presto-install/prestorepository:
Database | Folder | SQL Script |
HSQL | hsqldb | updateDB3.2.sql |
Microsoft SQL Server | mssqldb |
MySQL | mysqldb |
Oracle | oracledb |
PostgreSQL | postgresdb |
Contact Support
|
Community
|
Feedback