Need help /suggestions on how to connect Airpal to Presto DB query engine .
As per my analysis i found below 2 ways.
1) Connect using Presto JDBC
Class.forName("com.facebook.presto.jdbc.PrestoDriver");
config.getDataSourceFactory().setUrl("jdbc:presto:linadv360pt3:8080/oracle/AF360ST1");
config.getDataSourceFactory().setDriverClass("com.facebook.presto.jdbc.PrestoDriver");
config.getDataSourceFactory().setPassword(password);
Reference.yml file prestoCatalog :oracle
Not sure whether presto server required here .
2) Using Presto Server setup
catalog files setup as shown
./presto-server-0.77/etc/catalog/oracle.properties
./presto-server-0.77/etc/catalog/mysql.properties
In this case we can set only one schema details in oracle.properties file
how to dynamically set other schema details.
My confusion is whether we need to use any one of the them or both the ways.
In my case i have multiple tenants with multiple schemas access.Need to configure schema access for them dynamically for Airpal to prestodb.
Hi ,
Need help /suggestions on how to connect Airpal to Presto DB query engine . As per my analysis i found below 2 ways. 1) Connect using Presto JDBC Class.forName("com.facebook.presto.jdbc.PrestoDriver"); config.getDataSourceFactory().setUrl("jdbc:presto:linadv360pt3:8080/oracle/AF360ST1"); config.getDataSourceFactory().setDriverClass("com.facebook.presto.jdbc.PrestoDriver"); config.getDataSourceFactory().setPassword(password);
Reference.yml file prestoCatalog :oracle
Not sure whether presto server required here .
2) Using Presto Server setup catalog files setup as shown ./presto-server-0.77/etc/catalog/oracle.properties ./presto-server-0.77/etc/catalog/mysql.properties
In this case we can set only one schema details in oracle.properties file how to dynamically set other schema details.
My confusion is whether we need to use any one of the them or both the ways. In my case i have multiple tenants with multiple schemas access.Need to configure schema access for them dynamically for Airpal to prestodb.
Like : Tenant Client 1 : Admin ,FIN ,HRM ,PB (schemas) Tenant Client 2 : Admin ,FIN,HRM ,PB (schemas)
Please guide me .
Thanks Surendra