Member since
10-29-2015
123
Posts
31
Kudos Received
4
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
673 | 06-27-2024 02:42 AM | |
2239 | 06-24-2022 09:06 AM | |
3578 | 01-19-2021 06:56 AM | |
55233 | 01-18-2016 06:59 PM |
05-24-2021
09:22 PM
Hello Vos, Please share an email address to send the doc. Thanks Snm1523
... View more
05-14-2021
08:01 AM
@tusharkathpal , got hit to another issue, working on that. Will revert with these results by Monday.
... View more
05-14-2021
08:00 AM
Hello @vidanimegh, We are not changing any permissions to users (including me) on default DB. They are just default (whatever they get once created). We are managing permissions using Sentry on each DB that is created. We have verified permissions are all okay in Sentry as users (including me) are able to see / query tables in Impala via Hue but not in Hive. Thanks snm1523
... View more
05-14-2021
04:48 AM
Hello @tusharkathpal, Thank you for the reply. Have verified all the users are in correct groups and same on all nodes. Please suggest what can be checked further. Thanks snm1523
... View more
05-10-2021
07:53 AM
Any suggestions please?
... View more
03-23-2021
04:01 AM
Hello All, We have a around 22 databases and their respective tables which are accessible via Impala in Hue, but not via Hive for 3 newly added users. We get below error which is related to permissions to databases via Sentry, however, this looks strange to me since the permissions are managed at DB level and not specific to service. So if permissions are not correct, we should not have been able to access them via Impala as well. Error message: Error while compiling statement: FAILED: SemanticException No valid privileges User xxxxxx does not have privileges for SWITCHDATABASE The required privileges: Server=server1->Db=*->Table=+->Column=*->action=select->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=insert->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=alter->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=create->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=drop->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=index->grantOption=false;Server=server1->Db=*->Table=+->Column=*->action=lock->grantOption=false; Query that works fine in Impala but not Hive: select * from dbname.tablename limit 5; Please suggest what can be checked / done to fix this. Thanks snm1523
... View more
Labels:
- Labels:
-
Apache Hive
-
Apache Impala
-
Cloudera Hue
02-08-2021
07:15 AM
Hello, We have a strange issue here. We are on CDH 6.3.0 and have sentry in place for authorizations. A user is trying to execute queries from Hue on Impala Editor and fails with Authorization errors. However, same query works fine via Hive and also via Impala shell. It fails only from Hue editor. We have: 1. Refreshed metadata 2. Invalidated metadata 3. Verified permissions are in place in Sentry 4. There are no logs generated (I checked in Hue, Sentry Server and Catalog server). Please suggest if any other place should also be checked. Example query: select * from DB.table limit 5; Kindly help to diagnose and resolve this issue. Thanks Snm1523
... View more
Labels:
01-19-2021
06:56 AM
Thank you for the reply @smdas After looking at the privilege logs, found that the port was reported to be used. In reality it was not being used so possible some caching issue. We rebooted the server and were able to then restart the DN successfully. Thanks snm1523
... View more
01-11-2021
04:05 AM
Hello, Does anyone has any clue about below error. Datanode is not coming up with this error in the logs. We are on Cloudera Hadoop 6.3.0. RECIEVED SIGNAL 15: SIGTERM Thanks snm1523
... View more
Labels:
- Labels:
-
Apache Hadoop