Dear phoenix developers,
I would like to hint at an issue related to the configuration of the phoenix
JDBC driver for clients (not thin-client!). Currently, client-side connection
properties can only be set in Java code, like this:
Connection conn = null;
try {
Properties props = new Properties();
props.setProperty("phoenix.functions.allowUserDefinedFunctions",
"true");
Class.forName("org.apache.phoenix.jdbc.PhoenixDriver");
conn = DriverManager.getConnection(
"jdbc:phoenix:tdm-p-nn01:2181:/hbase-unsecure", props);
} catch (Exception e) {
e.printStackTrace();
LOGGER.error("error occurs " + e.getMessage());
}
In order to be integrated into 3rd party client applications that just need to
integrate the jdbc driver and establish a connection via the URI, it is to my
knowledge not possible to set
the client connection settings like:
jdbc:phoenix:<nn-host>:2181:/hbase-unsecure;
phoenix.functions.allowUserDefinedFunctions; phoenix.query.timeoutMs=1800000;
...
Also, I don't see any other option to set the client connection settings, e.g.
for enabling phoenix user-defined functions in 3rd party client applications
like logstash, etc.
I would much appreciate any workaround or hint for resolving this problem ...
in particular for enabling udfs in 3rd party jdbc clients.
Thanks and best regards,
Hidir
------------------------------------------------------------------------------
FIZ Karlsruhe - Leibniz-Institut für Informationsinfrastruktur GmbH.
Sitz der Gesellschaft: Eggenstein-Leopoldshafen, Amtsgericht Mannheim HRB
101892.
Geschäftsführerin: Sabine Brünger-Weilandt.
Vorsitzender des Aufsichtsrats: MinDirig Dr. Stefan Luther.
