Read only connection?

[gwooding]

Using a JDBC connection I could set up a read-only connection to Hive. Is there a way to do this with Python and PyHive? Let's assume that creating a read-only role on Hive itself is not an option. I know that SQL Alchemy has ways to do this, as PyHive uses SQL Alchemy is there a way to make this work that I'm not seeing?

[iusshpandeh]

Did you find any solution to the problem? I'm stuck with same issue now.