Details
-
Bug
-
Status: Open
-
Blocker
-
Resolution: Unresolved
-
0.9.0
-
None
-
None
-
Zeppelin version: 0.9.0-preview2
Presto JDBC driver version: presto-jdbc-340
Presto version: presto-server-323
OS: Linux
Description
With zeppelin version 0.8.1, if I save credentials on 'credentials' page, remove default.user from presto interpreter, restart interpreter and then run the query, I can see that presto receives the user from the credentials page (as expected).
url: jdbc:presto://mypresto:8080/hive dependency: presto-jdbc-0.170.jar driver: com.facebook.presto.jdbc.PrestoDriver query result: query executes successfully and on presto ui i can see the user from the credentials page for that query
With zeppelin version 0.9.0-preview2, zeppelin throws exceptions and is unable to read credentials from 'credentials' page. It expects the credentials to be set in the interpreter settings.
case1:
url: jdbc:presto://mypresto:8080/hive
dependency: presto-jdbc-0.170.jar
driver: com.facebook.presto.jdbc.PrestoDriver
query result:
java.sql.SQLException: Username property (user) must be set
at com.facebook.presto.jdbc.PrestoDriver.connect(PrestoDriver.java:94)
case2:
url: jdbc:presto://mypresto:8080/hive OR jdbc:presto://mypresto:8443/hive?SSL=true&SSLTrustStorePath=mypath&SSLTrustStorePassword=mypassword dependency: presto-jdbc-340.jar driver: io.prestosql.jdbc.PrestoDriver query result: java.sql.SQLException: Connection property 'user' is required at io.prestosql.jdbc.AbstractConnectionProperty.getValue(AbstractConnectionProperty.java:100) at io.prestosql.jdbc.AbstractConnectionProperty.validate(AbstractConnectionProperty.java:124) at io.prestosql.jdbc.PrestoDriverUri.validateConnectionProperties(PrestoDriverUri.java:374) at io.prestosql.jdbc.PrestoDriverUri.<init>(PrestoDriverUri.java:105) at io.prestosql.jdbc.PrestoDriverUri.<init>(PrestoDriverUri.java:95) at io.prestosql.jdbc.PrestoDriver.connect(PrestoDriver.java:85)