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

mnaufalmnaufal Registered User

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

  • Ben_VandiverBen_Vandiver Employee, Registered User, VerticaExpert

    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.

  • mnaufalmnaufal Registered User

    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_VandiverBen_Vandiver Employee, Registered User, VerticaExpert

    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