Re: How can I identify permissions issues given problematic SQL?

Our bug kept us from seeing the results of DESCRIBE/SHOW/etc. but I'll ask the client if they can run it and report the results. That definitely sounds like something we can use in the future. Thanks On Wed, Aug 16, 2017 at 2:59 AM, Furcy Pin wrote: > Hi Giles, > > Did

Re: How can I identify permissions issues given problematic SQL?

Hi Giles, Did you try running the query with the EXPLAIN AUTHORIZATION clause? https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Explain#LanguageManualExplain-TheAUTHORIZATIONClause On Wed, Aug 16, 2017 at 3:08 AM, Bear Giles wrote: > Hi, an issue came up

How can I identify permissions issues given problematic SQL?

Hi, an issue came up during recent AT and I'm hoping someone will have ideas on how we can check for this in the future, esp. if we can automate it somehow. In this case we had a client using our Hive client in the existing release without problems. When they copied their process to the UAT