Member since
10-29-2015
127
Posts
31
Kudos Received
4
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1484 | 06-27-2024 02:42 AM | |
2792 | 06-24-2022 09:06 AM | |
4240 | 01-19-2021 06:56 AM | |
57741 | 01-18-2016 06:59 PM |
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
10-07-2020
05:12 AM
Hello @Elf , Yes I was able to. Have prepared a quick guide detailing the steps to be taken which in turn refers to Apache Griffin documentations and other required pre-reqs. Unsure, how do i share with you since I am unable to attach it here. Thanks snm1523
... View more
10-07-2020
05:07 AM
Hello Shishir, Would you mind to please how do we migrate a standalone Nifi setup to cluster mode? Thanks snm1523
... View more
08-31-2020
04:25 AM
Thank you... This helped.
... View more
08-20-2020
07:22 AM
Hi All,
Need opinions / thoughts / best practices.
Has anyone tried integrating Apache Griffin (An open source Data Quality solution for Big Data. More details at http://griffin.apache.org/#about_page) with deployed CDH clusters?
If yes, any documentation available on how to get this done? What are the requirements / prereqs? Any recommendations on best practices? Any additional information or help or documentation (apart from the link shared) shared would be highly beneficial.
Please share your thoughts / feedback / comments.
Thanks
SNM1523
... View more
Labels:
01-23-2020
03:09 AM
Hello, While browsing through various articles related to Cloudera Manager, I came across an article which talks about exporting Cloudera Manager configs using a script. In this a wget from "${SCM_URL}/cmf/exportCLI" url is doing the trick. Being fairly new with playing APIs, I tried to read across somethings related to CM APIs, however, did not find much. Would be great if someone could help me to understand which exact configurations are exported with the mentioned API. Apologies if seems to be a basic question. However, thought of asking community instead of creating confusions for myself. Thanks snm1523
... View more
Labels:
- Labels:
-
Cloudera Manager