Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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."

Comments

  • 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.

  • 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.

  • 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.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.