We briefly went to k-safety 2 and pretty hastily beat a retreat back to 1. I/O performance took a bit of a hit at 2 and thinking it through, even at 1, you can have more than 1 node go down (depending on which node it it). When I taked to Vertica support, they recommended avoiding 2 as well.

I am loading a large JSON file into a flex table ... it looks like a very small percentage of rows have some formatting errors .... is there a way to skip those records and just load everything else? I am getting an error like this Error calling process() in User Function UDParser at [src/JSONParse ...

Thanks for the reply .... to read the file in, I should just need to change outputstream to inputstream?

I am not sure what I am doing wrong here .. this is not my area of expertise. Essentially I need to have a file run based on a trigger from an event in SQL, for other things like this, we have called a simple java program to do things like run a copy command. For this, I need to execute commands ins...