How to integrate Presto plugin into CDP private cloud base 7.1.5

[#1]

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-c...

Much appreciate,

[#2 · Accepted solution]

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

[#3 · Accepted solution]

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

[#4 · Accepted solution]

@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

[#5]

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-se...

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,