Skip to main content
Hotty
Silver ⭐️
January 26, 2021
Solved

How to integrate Presto plugin into CDP private cloud base 7.1.5

Hi member, 

 

Could you please help my concern ? 

CDP Private Cloud Base 7.1.5 has Ranger 2.1.0, so we can try to use presto plugin.

However, I find that Cloudera CDP Private Cloud Base 7.1.5 don't list presto plugin at at Ranger library.

So, could you please let me know how to install / integrate presto plugin into CDP Private Cloud Base 7.1.5 ?

Of course, I know Cloudera cannot support Presto but we really need to use Presto for our business.

It would be grateful if you could give any advices.

 

Cloudera Runtime component versions (7.1.5) :

https://docs.cloudera.com/cdp-private-cloud-base/7.1.5/runtime-release-notes/topics/rt-pvc-runtime-component-versions.html

 

Much appreciate,

GangWar
GangWarAnswer
Platinum ⭐️⭐️
January 29, 2021

@Hotty I agree with @aakash_nand there is no easy guidelines available by which you can configure. 

 

However you can use this reference if you want Presto Plugin in Ranger it may give you a good start. 

https://cwiki.apache.org/confluence/display/RANGER/Presto+Plugin

Cheers! Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.

3 replies

aakash_nand
Gold ⭐️
January 29, 2021

Hi, I have seen similar question on trino's (formerly know as prestosql) community slack. I think even though CDP 7.1.5's ranger version is 2.1.0 it still does not have presto plugin. I built apache ranger directly from github using maven and it is working fine and have presto source as well. I hope cloudera soon adds actual presto plugin support to their version of ranger.
Hope this helps you a bit
Best regards,
Aakash Nand

Translate
GangWar
Platinum ⭐️⭐️
GangWarAnswer
Platinum ⭐️⭐️
January 29, 2021

@Hotty I agree with @aakash_nand there is no easy guidelines available by which you can configure. 

 

However you can use this reference if you want Presto Plugin in Ranger it may give you a good start. 

https://cwiki.apache.org/confluence/display/RANGER/Presto+Plugin

Translate
Cheers! Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button.
Hotty
HottyAuthor
Silver ⭐️
February 4, 2021

Hi @aakash_nand and @GangWar 

 

Thank you for your comment.

Your advice is so helpful.

 

https://cwiki.apache.org/confluence/display/RANGER/Presto+Plugin

https://github.com/apache/ranger/blob/master/agents-common/src/main/resources/service-defs/ranger-servicedef-presto.json

 

Now, I confirmed that Apache Ranger included in CDP 7.1.5 can display Presto on the Ranger administration screen using the Presto API.

And, confirmed that Ranger can be configured on a per-account basis for Presto from the Ranger management configuration screen.

 

Many thanks,

 

Translate