[jira] [Created] (ZEPPELIN-5110) Presto interpreter unable to pick up credentials from credentials page

["Anchal Agarwal (Jira)" <ji...@apache.org>]

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)