Presto editor issue

[kush]

Hi ,

I integrated presto in hue 4.6 . But when i am running the queries i am getting permission issues on HDFS , because the queries are not getting run by the end user, instead it is getting run the the user HUE process is running from.

queries are running fine in presto cli.

@Romain is there any config missing?

Below is my config in hue.ini

[[[presto]]]
name=Presto
interface=sqlalchemy
options=’{“url”: “presto://xxxx:8285/hive/default”}’

[Romain]

Looks like it is about the impersonation setting cf. Presto Integration with Hue

[kush]

hi @Romain,

Please let me know how can i fix this impersonation issue.
The hive editor is working fine.
issue is with presto editor.
i have also added below settings in core-site.xml with value as ‘*’

hadoop.proxyuser.presto.groups
hadoop.proxyuser.presto.hosts
hadoop.proxyuser.hue.groups
hadoop.proxyuser.hue.hosts

Thanks