Can I connect hive without impersonate mode?

When I’m trying to query a dataset, I have the following error : User: dremio is not allowed to impersonate arnault.

I saw some articles about impersonate mode, but I want to use without impersonate mode like facebook presto engine.

Is it possible?

Hi @Jude

Yes, you can use Hive without impersonation, try this, open your Hive source on the Dremio UI and under “Advanced Options”, click on +, add property and add this

Name: hive.server2.enable.doAs
Value: False

Now try the query


1 Like