Hive I believe is vulnerable and running 2.10. ... View more

Ok, I think I understand.   I CAN install secure versions of these components, but that would be separate from Ambari and would sacrifice that level of control and maintenance. In order to get Ambari and these more secure components, I'll need to reach out to Cloudera for a private hotfix version or to upgrade off of HDP.   Thank you for the clarification. ... View more

Hi @Shifu    Thanks for the response! Regarding something you posted: "You can either install a component or you can upgrade to the next available HDP 3.X version but I can see you are in the latest 3.1.5 version."   If I installed a later version of Zookeeper (for example), would ambari recognize that later version in it's management? Or would it exist in parallel with the version of Zookeeper packaged with 3.1.5?   The current big security issues I see I've listed in the original question. Is there a contact form? Grafana is running v6.4.2, but has a major security issue that was patched in future releases: https://grafana.com/blog/2020/06/03/grafana-6.7.4-and-7.0.2-released-with-important-security-fix/ Infra Solr is running SOLR 7.7 and has a RCE vulnerability. This was patched in SOLR 8.3, which is not part of Ambari 2.7.5's InfraSolr. Zookeeper packaged is 3.4.6, but SSL implementation was added in 3.5.5   ... View more

@stevenmatison  Thanks for responding!   I did think this was a file permissions issue on the start, but I ran some tests.   Test 1: I chown'd/chmod'd the underlining files to match ORC files that presto could read from (those not written by PutHive3Streaming). Didn't work.   Test 2: I ran Nifi's SelectHive3QL (which supports inserts). This wrote the data with file permissions and ownership similar to the other processor. Presto is able to read that data.   Were you able to get to work? Additionally here's a snippet of puthive3streaming (minus the specifics like table, pathways, dbs). Using an avroreader to write.   ... View more

What version of NiFi? Is it the Apache standalone or the HDF version? Also, are you saying you have other nifi nodes that work but the new one doesn't? What does the ui say? Is there errors in nifi-app.log? ... View more

So Presto now supports ACID tables, but only for Hive3. However, the subdirectory exception is from a configuration on the presto client side. In the hive.properties in presto's catalog directory, add "hive.recursive-directories=true" ... View more

@Ellyly  No permanent solution to this collision type issue. The workaround I did was to split up the table into several smaller tables. That way no collisions occur. Not a great solution, but worked for my need. ... View more

If I can ask, why are you deleting? If you want to go through nifi, it sounds like an automated process. If it's a data retention issue, I think Hbase has a way to prune on timer. The TTL setting. ... View more