Zeppelin 0.7.2 integration with Presto 0.184

[Richard Xin]

I am not sure Zeppelin 0.7.2 is compatible with Presto 0.184here are the steps:
1. create new presto interpreter 

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.(PrestoDriverUri.java:89) at 
com.facebook.presto.jdbc.PrestoDriverUri.(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


| 
| 
| 
|  |  |

 |

 |
| 
|  | 
prestodb/presto

presto - Distributed SQL query engine for big data
 |

 |

 |

Re: OpenAM LDAP integration with Zeppelin

[Suresh Ayyavoo]

How to map groups in LDAP & Shiro?

Thanks

On Sun, Oct 29, 2017 at 8:13 PM, Jongyoul Lee  wrote:

> Hi,
>
> I'm not an expert of LDAP and Shiro, AFAIK, currently, Shiro doesn't
> support group-related things on LDAP.
>
> I knew a reference to use LDAP in Zeppelin by setting all groups manually.
>
> Hope this help,
> Jongyoul Lee
>
> On Tue, Oct 17, 2017 at 5:13 PM, Suresh Ayyavoo 
> wrote:
>
>> Hi All,
>>
>> Who have integrated OpenAM LDAP with Zeppelin0.7.2?
>> The group are not honoured in zeppelin roles?Any idea?
>>
>> LoginRestApi.java[postLogin]:115) - {"status":"OK","message":"","b
>> ody":{"principal":"admin","ticket":"81e0db18-a10a-454f-a9b1-
>> c9fa41abc877","roles":"[]"}}
>>
>> --
>>
>> Suresh Ayyavoo
>>
>> Solution Architect / R Lead
>>
>> iAPPS Pte. Ltd.
>>
>> 3 Fusionopolis Way
>> ,
>> Symbiosis #13-25 S(138633)
>>
>> [O] 64631795   [F] 6778 5300 [M] 91540224
>>
>> Website: www.iappsasia.com
>>
>> Facebook: www.facebook.com/iappsasia
>>
>> Youtube: www.youtube.com/user/iAPPSasia
>>
>
>
>
> --
> 이종열, Jongyoul Lee, 李宗烈
> http://madeng.net
>



-- 

Suresh Ayyavoo

Solution Architect / R Lead

iAPPS Pte. Ltd.

3 Fusionopolis Way, Symbiosis #13-25 S(138633)

[O] 64631795   [F] 6778 5300 [M] 91540224

Website: www.iappsasia.com

Facebook: www.facebook.com/iappsasia

Youtube: www.youtube.com/user/iAPPSasia

Re: OpenAM LDAP integration with Zeppelin

[Suresh Ayyavoo]

ldapRealm = org.apache.zeppelin.realm.LdapRealm

On Mon, Oct 30, 2017 at 12:34 PM, Khalid Huseynov 
wrote:

> Hi,
>
> Which shiro realm did you use for integration? have you tried
> LdapGroupReal or ActiveDirectoryGroupReal?
>
>
>
> On Sun, Oct 29, 2017 at 9:13 PM, Jongyoul Lee  wrote:
>
>> Hi,
>>
>> I'm not an expert of LDAP and Shiro, AFAIK, currently, Shiro doesn't
>> support group-related things on LDAP.
>>
>> I knew a reference to use LDAP in Zeppelin by setting all groups manually.
>>
>> Hope this help,
>> Jongyoul Lee
>>
>> On Tue, Oct 17, 2017 at 5:13 PM, Suresh Ayyavoo 
>> wrote:
>>
>>> Hi All,
>>>
>>> Who have integrated OpenAM LDAP with Zeppelin0.7.2?
>>> The group are not honoured in zeppelin roles?Any idea?
>>>
>>> LoginRestApi.java[postLogin]:115) - {"status":"OK","message":"","b
>>> ody":{"principal":"admin","ticket":"81e0db18-a10a-454f-a9b1-
>>> c9fa41abc877","roles":"[]"}}
>>>
>>> --
>>>
>>> Suresh Ayyavoo
>>>
>>> Solution Architect / R Lead
>>>
>>> iAPPS Pte. Ltd.
>>>
>>> 3 Fusionopolis Way
>>> ,
>>> Symbiosis #13-25 S(138633)
>>>
>>> [O] 64631795   [F] 6778 5300 [M] 91540224
>>>
>>> Website: www.iappsasia.com
>>>
>>> Facebook: www.facebook.com/iappsasia
>>>
>>> Youtube: www.youtube.com/user/iAPPSasia
>>>
>>
>>
>>
>> --
>> 이종열, Jongyoul Lee, 李宗烈
>> http://madeng.net
>>
>
>


-- 

Suresh Ayyavoo

Solution Architect / R Lead

iAPPS Pte. Ltd.

3 Fusionopolis Way, Symbiosis #13-25 S(138633)

[O] 64631795   [F] 6778 5300 [M] 91540224

Website: www.iappsasia.com

Facebook: www.facebook.com/iappsasia

Youtube: www.youtube.com/user/iAPPSasia