Anchal Agarwal created ZEPPELIN-5110:
----------------------------------------
Summary: Presto interpreter unable to pick up credentials from
credentials page
Key: ZEPPELIN-5110
URL: https://issues.apache.org/jira/browse/ZEPPELIN-5110
Project: Zeppelin
Issue Type: Bug
Components: JdbcInterpreter
Affects Versions: 0.9.0
Environment: Zeppelin version: 0.9.0-preview2
Presto JDBC driver version: presto-jdbc-340
Presto version: presto-server-323
OS: Linux
Reporter: Anchal Agarwal
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).
{code:java}
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
{code}
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*:
{code:java}
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)
{code}
*case2*:
{code:java}
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)
{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
