Member since
03-06-2020
406
Posts
56
Kudos Received
37
Solutions
My Accepted Solutions
| Title | Views | Posted |
|---|---|---|
| 1096 | 08-29-2025 12:27 AM | |
| 1631 | 11-21-2024 10:40 PM | |
| 1539 | 11-21-2024 10:12 PM | |
| 5285 | 07-23-2024 10:52 PM | |
| 3017 | 05-16-2024 12:27 AM |
08-29-2022
05:07 AM
1 Kudo
Hi, Yes, Hive metastore is a component that stores all the structure information(metadata) of objects like tables and partitions in the warehouse including column and column type information etc... Regards, Chethan YM Note: If this answered your question please accept the reply as a solution.
... View more
08-29-2022
03:43 AM
1 Kudo
Hi, There's no limit about the number of databases in Hive metastore. As a good practice we do not recommend to create tables with more than 10,0000 partitions. In my opinion, you shouldn't have problem with 2,000 tables. You can expect to have some type of performance issues if you have a total number object greater than 500,000 and there's no a hard limit about the number of Hive/Impala databases/tables that you can have in the cluster. Regards, Chethan YM
... View more
08-16-2022
08:25 AM
Hi @PNW If you want to disable the automatic restart of cloudera services visit the configuration page of the service you'd like to manage, then search for "Automatically Restart Process". You should see this option for each role within the service, then uncheck it. Regards, Chethan YM
... View more
07-06-2022
07:44 AM
Hello Syed, Can you try the alternatives command to change the python version? Check the below link. https://medium.com/coderlist/how-to-change-default-python-version-on-linux-fedora-28-c22da18bdd6 Regards, Chethan YM
... View more
06-23-2022
09:04 AM
Hello, You need to enable trace level logging for ODBC driver and should check the logs after reproducing the issue. Check if you have any socket timeout errors in the trace logs if yes refer the below doc to set the socket timeout. https://docs.cloudera.com/documentation/other/connectors/impala-odbc/2-6-5/Cloudera-ODBC-Driver-for-Impala-Install-Guide.pdf Regards, Chethan YM
... View more
06-23-2022
08:53 AM
Hello @Bluetruth Have you tried query like below? Here year is a partition it shows the name in the year 2010. ## select name from census where year=2010; If you need data only from partition column use query like below: ## select <col-name> from <table-name>; Regards, Chethan YM
... View more
05-31-2022
03:22 AM
Hi @wert_1311 It shows the number of impalad connections are hitting the limit. You can check on these below points: 1. you can increase the value of "Impala Daemon Max Client Connections" property in the impala configs if really more number of connections are coming. 2. If you think the connections are less but the opened connections are not closing properly and causing the issue you can check the timeouts has been set properly in the Hue safety-valve advance configs. -idle_session_timeout=3600 -idle_query_timeout=3600 Regards, Chethan YM
... View more
05-31-2022
02:57 AM
Hi @KPG1 , I have found a another cloudera article similar to your concern, Please check the below link: https://community.cloudera.com/t5/Support-Questions/How-to-move-all-the-regions-of-a-region-server-to-another/td-p/175535 StackOverflow; https://stackoverflow.com/questions/39749517/how-to-force-an-hbase-table-to-a-region-server Regards, Chethan YM
... View more
04-28-2022
11:45 PM
Hi @yagoaparecidoti , I do not think we have such option of blocking but as i know i think you can make it using sentry authorisation. If sentry is enabled in the cluster you should grant only "SELECT" privilege to all the users for all the databases/tables so if the users try any other DDL commands it will throw 'Authorisation exceptions". Do refer the below documentation: https://docs.cloudera.com/documentation/enterprise/6/6.3/topics/cm_sg_sentry_service.html If you are using Ranger same can be achieved from ranger also. Regards, Chethan YM
... View more
04-12-2022
05:59 AM
Hi, Can you regenerate the kerberos credentials for impala from CM and see if it helps? Regards, Chethan YM
... View more