Vertica note: Before using a machine learning function, be aware that all the ongoing transactions m

mnaufal

Can anyone explain what is the below comment means which is mentioned as an important note for machine learning function.
"Important: Before using a machine learning function, be aware that all the ongoing transactions might be committed."

Ben_Vandiver

It means that any in-progress transaction in the current session executing the machine learning function may be auto-committed. In this manner, very similar to the behavior of CREATE TABLE, which commits any existing transaction before proceeding to the table creation operation.

mnaufal

Thanks Ben. Meaning, this “Auto-Commit” would be restricted to the current session only – where the Machine Learning function is being executed – and as such may not affect any other sessions like the CREATE TABLE execution.

Ben_Vandiver

Correct. I'll put something in to adjust the documentation. It currently seems to apply to all transactions on the database, something which is not true.