About karan_alang1

karan_alang1 · ‎12-05-2016

@Kuldeep Kulkarni - i seem to be having another issue .. i've users (hive_user1, hive_user2) and i've created policy giving the access to table - test. On trying to access the table on Hive View, it gives the following error -> ----------------- Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [ambari-server] does not have [SELECT] privilege on [default/test/sno] [ERROR_STATUS] ---------------- Details in the link below -> https://community.hortonworks.com/questions/69761/kerberized-hdp-24-getting-error-in-using-hive-view.html#answer-69863 what needs to be done to fix this issue ? Thanks !

karan_alang1 · ‎12-05-2016

@Sunile Manjee, @Daniel Kozlowski - the above steps you mentioned are already done, hence i'm able to access the HIVE VIEW on Kerberized HDP2.4 Attaching the screen shot of the HIVE VIEW config, made some minor change -now getting the following error .. ------------------------------- Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [ambari-server] does not have [SELECT] privilege on [default/test/sno] [ERROR_STATUS] ----------------- Any ideas on this ? I'm able to access the Hive table if i add ambari-ranger to Ranger policy, but it is not able to access if i give only the users - hive_user1, hive_user2 acess to the table - 'test'ambari-hive-view-hdp24-1.pdf

karan_alang1 · ‎12-03-2016

@jss - actually, this is not working as desired.. i don't want to put 'hdfs' as group within Ranger, instead i want to be able to control access using users - hive_user1 or hdfs_user2 (instead of using service account - hdfs for controlling access).

karan_alang1 · ‎12-03-2016

@jss - this is set to false in hive-site.xml .. what should the value be set to ? I tried changing to true, but the error is still the same yes, ranger is installed, i'm changing permissions using Ranger.

karan_alang1 · ‎12-03-2016

screen-shot-2016-12-02-at-112143-pm.png @Sunile Manjee, @Daniel Kozlowski, @jss - attaching the screenshot of permissions on Ranger. if i add user - hdfs - and provide read access - i'm able to access the table using HIVE VIEW.

karan_alang1 · ‎12-03-2016

@Sunile Manjee, this is regular table .. not external table Attaching the Table definition, also permissions at the hdfs level is as shown below - I'm able to access the table - test - from the command line. I'm currently trying to restrict access from the Hive View. ------------------------------------------------------------------------------------------------------------- hive> dfs -ls /apps/hive/warehouse/; Found 5 items drwxrwxrwx - hdfs hdfs 0 2016-12-01 22:32 /apps/hive/warehouse/test

karan_alang1 · ‎12-03-2016

Hi All, I've a kerberized HDP 2.4 - and i've created user - hive_user1 I logon to Hive View on Ambari, and fire simple query - select * from test The error i get is shown below - ------------------------------- Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [hdfs] does not have [SELECT] privilege on [default/test/sno] [ERROR_STATUS] ----------------------------- Pls note - i've disabled Global access to Hive, but given access to user - hive_user1 But somehow, it is using hdfs user to access Hive. Any ideas on this ? attached is the screenshot of the user, and the error obtained. screen-shot-2016-12-02-at-61927-pm.png screen-shot-2016-12-02-at-62808-pm.png

karan_alang1 · ‎12-01-2016

@Kuldeep Kulkarni, thanks for the input .. using the Custom setting (with changed values) instead of the default 'local cluster' seems to have fixed the issue !

karan_alang1 · ‎12-01-2016

@Kuldeep Kulkarni, btw, i'm running Hive on MapReduce (was getting error on running on Tez)

karan_alang1 · ‎12-01-2016

ambari-hive-view-hdp24.pdf @Kuldeep Kulkarni - yes, used the following link to configure Ambari for Kerberos https://community.hortonworks.com/articles/40635/configure-tez-view-for-kerberized-hdp-cluster.html also, attached is ambari-server.log & the screenshot of the Hive View on Ambari Pls let me know, thanks !ambari-server-1201log.zip

Online	Offline
Last Visited	‎05-18-2019 05:02 PM

Member Since	‎10-28-2016 06:06 PM
Last Visited	‎05-18-2019 05:02 PM
Posts	392
Kudos received	7

Cloudera Community

Re: Reading avro file from HDFS using Scala - Exce...

Re: Kafka MirrorMaker - not working

Re: newly added Node, Yarn NodeManager not startin...

Re: Yarn Node Managers shutting down

Re: Error in Kafka startup with the JMX exporter -...

Re: Kerberized HDP 2.4 - not able to access Hive V...

Re: Kerberized HDP 2.4 - getting error in using Hi...

Re: Kerberized HDP 2.4 - getting error in using Hi...

Re: Kerberized HDP 2.4 - getting error in using Hi...

Re: Kerberized HDP 2.4 - getting error in using Hi...

Re: Kerberized HDP 2.4 - getting error in using Hi...

Kerberized HDP 2.4 - getting error in using Hive V...

Re: Kerberized HDP 2.4 - not able to access Hive V...

Re: Kerberized HDP 2.4 - not able to access Hive V...

Re: Kerberized HDP 2.4 - not able to access Hive V...