After a CDH cluster is enabled with Kerberos, by default, HiveServer2’s web UI will also be enabled with SPNEGO, sometimes it will cause HiveServer2’s web UI to reject user’s request with below error: This can happen when Kerberos has detected that user is trying to authenticate twice within a short …
Welcome again to my 5th episode of Ranger series. In this post, I will focus on what Hive Plugin is in Ranger, how it works and what happens behind the scene when you try to create or modify tables in Hive. If you have missed my previous episodes, please review …
I have seen in a lot of use cases that Hive users need to pass along a variable into Hive VIEW, so that their queries can be run using dynamic conditions. However, this is not currently supported by Hive due to the fact that VIEW’s query string is evaluated during …
As an administrator to manage a Hive cluster, sometimes it is needed to restrict users from updating certain Hive settings from client side. One particular example is mapred.job.queue.name or newer name mapreduce.job.queuename, where we might not want users to blindly submitting to any queues in YARN. To achieve this, Hive …
I have seen lots of Hive users faced an issue that their query took a long time to compile, even for a table that is small and without many columns or partitions. Those queries failed with error message similar to below, which was due to table was locked and query …
My new Snowflake Blog is now live. I will not be updating this blog anymore but will continue with new contents in the Snowflake world!