I’ve done this previously, my answer here 
https://stackoverflow.com/a/44238195/1335793

I was using an older version though.
Did you try appending catalog, or a catalog & schema to the url?

Error message suggests problem is with the “default.url” in the interpreter 
settings.

On another note, AWS has released Athena (managed version of presto) so when 
it's available in my region I will look at using that.

Dave

From: Richard Xin<mailto:richardxin...@yahoo.com>
Sent: Wednesday, 1 November 2017 9:35 AM
To: Users<mailto:users@zeppelin.apache.org>
Subject: Zeppelin 0.7.2 integration with Presto 0.184

I am not sure Zeppelin 0.7.2 is compatible with Presto 0.184
here are the steps:

1. create new presto interpreter
[Inline image]

2. %presto
show tables

java.sql.SQLException: Unrecognized connection property 'url'
at 
com.facebook.presto.jdbc.PrestoDriverUri.validateConnectionProperties(PrestoDriverUri.java:292)
at com.facebook.presto.jdbc.PrestoDriverUri.<init>(PrestoDriverUri.java:89)
at com.facebook.presto.jdbc.PrestoDriverUri.<init>(PrestoDriverUri.java:79)
at com.facebook.presto.jdbc.PrestoDriver.connect(PrestoDriver.java:86)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at 
org.apache.commons.dbcp2.DriverManagerConnectionFactory.createConnection(DriverManagerConnectionFactory.java:79)
at 
org.apache.commons.dbcp2.PoolableConnectionFactory.makeObject(PoolableConnectionFactory.java:205)
at 
org.apache.commons.pool2.impl.GenericObjectPool.create(GenericObjectPool.java:836)
at 
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:434)
at 
org.apache.commons.pool2.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:361)
at org.apache.commons.dbcp2.PoolingDriver.connect(PoolingDriver.java:129)

...

it seems that presto has some strict property name checking, I believe it's not 
uncommon that people want to use presto in Zeppelin, is there any work-around? 
I am on AWS EMR


related presto code:
prestodb/presto<https://github.com/prestodb/presto/blob/431f8701899145a62ab51a30d0b6ef9fe139dd76/presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoDriverUri.java#L292>

<https://github.com/prestodb/presto/blob/431f8701899145a62ab51a30d0b6ef9fe139dd76/presto-jdbc/src/main/java/com/facebook/presto/jdbc/PrestoDriverUri.java#L292>




[https://s.yimg.com/nq/storm/assets/enhancrV2/23/logos/github.png]
prestodb/presto

presto - Distributed SQL query engine for big data








Reply via email to