Member since
03-06-2020
398
Posts
54
Kudos Received
35
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
144 | 11-21-2024 10:12 PM | |
998 | 07-23-2024 10:52 PM | |
1139 | 05-16-2024 12:27 AM | |
3238 | 05-01-2024 04:50 AM | |
1409 | 03-19-2024 09:23 AM |
08-16-2022
08:38 AM
> Below is the document which has some more details on the same: https://impala.apache.org/docs/build/html/topics/impala_upsert.html > Please let us know what is your concerns.
... 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-30-2022
07:31 AM
Hi, Attached screenshot does not give more details, Do check application logs, HS2 logs and metastore logs to find out the more information. Check if you have required resources in the cluster to run the query. Check if any JVM pauses due to out of memory. Check if the tables involved in this job is not using by anyone for writing etc... Try to restart Hive and rerun the job again and check. 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:56 AM
Hi, We need to check the HS2 logs and application logs if it is throwing any errors/exceptions for this query. 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
06-23-2022
08:35 AM
Hi @Lobitojc , It seems to be a Hive BUG please refer the below Jira: https://issues.apache.org/jira/browse/HIVE-24998 Regards, Chethan YM
... View more
05-31-2022
05:11 AM
Hi, The above log snippet does not give enough details you need to check complete HS2 log file for any other related errors. This error occurs for multiple reasons. 1. Does it work for any other user? can you change the user and try? 2. Check if you have any permission issue for this path/user. 3. Is encryption zone enabled? can set the below property in the beeline and retry the query? set hive.exec.scratchdir=.staging; 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