Skip to main content

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

  • April 25, 2018
  • 3 replies
  • 11 views

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

3 replies

Ben_Vandiver
Forum|alt.badge.img
  • Participating Frequently
  • April 25, 2018

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
  • Author
  • New Participant
  • April 25, 2018

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
Forum|alt.badge.img
  • Participating Frequently
  • April 25, 2018

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.