Member since
12-10-2015
27
Posts
7
Kudos Received
4
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
1101 | 10-15-2024 09:03 AM | |
2957 | 02-27-2018 07:07 AM | |
3027 | 02-13-2018 09:00 AM | |
1779 | 11-21-2016 02:53 PM |
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
11-21-2024
10:40 PM
1 Kudo
Hi @mrblack To avoid full table scan you follow these tips: 1. Ensure proper partition pruning: https://impala.apache.org/docs/build/html/topics/impala_partitioning.html#:~:text=the%20impalad%20daemon.-,Partition%20Pruning%20for%20Queries,-Partition%20pruning%20refers 2. Re write the query with sub queries. 3. Add explicit hints for join behaviour. Impala supports join hints like brodcast and shuffle that can influence query planning. After optimising check the explain plan. Regards, Chethan YM
... View more
10-15-2024
10:03 AM
1 Kudo
I know about CTE solution I was trying to find if the variable like SQL Server solution is there or not. I will use CTE. thanks
... View more
10-10-2024
05:13 AM
1 Kudo
Hi @evanle96 This error is not an issue. Usually in the HA setup the call goes to both the NN and the Active NN acknowledges the call but the standby NN will through this warning. So you can ignore this warning here.
... 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
02-27-2018
07:07 AM
Hi csguna, Navigator audit is auditing the Hadoop Master roles only, and the hdfs shell commands are working as a regular HDFS client from the NameNode's perspective. At the namenode side, where HDFS audit logs are generated, is not possible to determine why a client would like to read a file. The only thing that the namenode knows & can log that a client/user would like to open&read a file, but we have no information about what the client will actually do with the data. The client could save the data to a local disk, send it to a network service, simply display the contents of the file, or do an ordinary ETL job and write the results back to HDFS, etc. That is why an "open" operation is logged for both 'hadoop fs -cat size.log' and 'hadoop fs -get size.log'. Therefore with Navigator Audit, this is not currently possible, as the knowledge what the client will do with the data read from HDFS is missing. Usually there are some ways on the OS level itself to audit what users/processes do (like the Linux audit framework), and that can be used to audit file access on the OS level. It might be possible to combine audit data form the OS and Navigator to pinpoint such operations that you mentioned, but I do not know any automated way to do that.
... View more
02-13-2018
09:00 AM
Hi, support for device UUIDs with navencrypt was introduced in version 3.13.0: https://www.cloudera.com/documentation/enterprise/release-notes/topics/rg_navigator_encrypt_new_features.html#nav_encrypt_313 Please check the relevant documentation on how to use it here: https://www.cloudera.com/documentation/enterprise/latest/topics/navigator_encrypt_prepare.html#concept_device_uuids regards, Gabor Zele Customer Operations Engineer
... View more
06-13-2017
06:24 PM
Problem resolved with your above update.
... View more
11-21-2016
02:53 PM
1 Kudo
Hi keagles, It can be still useful to do manual failover in some cases. For example, you would like to do some HW/OS maintenance on the active datanode - you can fail over manually to the other NN without distrupting running processes on the cluster. Also, you can do configuration changes to the NN in the same way. Change config, then restart the Standby NN, it will start with the new configuration, fail over, then restart the other one. See, you updated your NN's settings without the need to do a full cluster stop. These are not possible with a non-HA configuration. cheers, zegab
... View more