Member since
10-25-2014
147
Posts
6
Kudos Received
5
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
419 | 03-19-2025 12:39 PM | |
648 | 10-08-2024 04:27 PM | |
2737 | 10-06-2024 12:35 PM | |
958 | 10-03-2024 11:04 AM | |
5572 | 11-14-2014 06:24 PM |
03-20-2025
05:20 AM
@Boris G, I literaly started my thread explaining why I need Impala. Problem solved by the way.
... View more
03-10-2025
05:27 AM
Try query below and let us know if it solves the problem and any other issues you are facing related select id, st.value street, ph.value phone
from table, table.result st, table.result ph
where st.key=’street’ and st.value='abc' and ph.key=’phone’ and ph.value='123'
... View more
03-09-2025
05:25 AM
@zeeshanmcs It seem you're having an issue with unavailable tablets in your Kudu table, which is preventing Spark from inserting data. The output from kudu cluster ksck clearly shows the problem: the leader replicas for all tablets in the impala::mrs.NumberofSubs table are on a tablet server that's unavailable. The key issue is that the tablet server with ID 24483fcd36ce45d78d80beb04b3b0cf4 is not running, and it happens to be the leader for all 7 tablets in your table. Here's a solution to resolve this issue: 1. First, check the status of all Kudu tablet servers sudo systemctl status kudu-tserver 2. Look specifically for the tablet server with ID 24483fcd36ce45d78d80beb04b3b0cf4 sudo -u kudu kudu tserver list tstewputil1 3. If the tablet server is down, start it. sudo systemctl start kudu-tserver 4. If the tablet server is running but not responding, restart it sudo systemctl restart kudu-tserver 5. After restarting the tablet server, wait a few minutes for it to rejoin the cluster and for leadership transitions to occur, then check the status again sudo -u kudu kudu cluster ksck tstewputil1 If the tablet server is permanently lost or damaged, you'll need to recover the tablets a. Check if you have enough replicas (you should have at least 3 for production) sudo -u kudu kudu table describe impala::mrs.NumberofSubs tstewputil1 b. If you have other healthy replicas, you can delete the failed server from the cluster and Kudu will automatically recover sudo -u kudu kudu tserver delete tstewputil1 <tablet_server_uuid> c. If this is the only replica and you don't have backups, you may need to: Create a new table with the same schema Load data from your source systems Or restore from a backup if available If, after restarting, you still have issues, the problem might be: Disk space issues on the tablet server Configuration problems Network connectivity problems between servers Check the Kudu tablet server logs for more details less /var/log/kudu/kudu-tserver.log Once the tablet server is back online and healthy, your Spark job should be able to insert data into the table successfully Happy hadooping
... View more
11-13-2024
01:42 PM
1 Kudo
@repealp Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks.
... View more
10-22-2024
05:06 AM
hi @krishna2023 according to the documentation: https://docs.cloudera.com/documentation/other/connectors/impala-jdbc/2-6-23/Cloudera-JDBC-Driver-for-Impala-Install-Guide.pdf try to create the JAAS login file and check if the connection will occur.
... View more
10-11-2024
05:01 PM
1 Kudo
@emmanuelkatto Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. Thanks.
... View more
10-10-2024
04:27 PM
1 Kudo
@hanumanth Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, Thanks.
... View more
10-07-2024
07:52 AM
Sure, it’s the latest version available. We have opened a case to cloudera, but being Impala and python widely used together I am surprised not finding lots bug report about this.
... View more
10-03-2024
11:52 AM
Hello- First of all, make sure you are using the latest Impala JDBC connector. If you do - then try to add 'UseNativeQuery=1' to the JDBC connection string and re-test.
... View more
10-03-2024
11:33 AM
Hello- Make sure first of all you are using the latest Cloudera JDBC.
... View more