The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

data are deleted automatically after insert

I use the insert clause in vertica console

 

INSERT INTO TABLE A SELECT .......

 

I can query the the inserted data once I inserted but the data are deleted automatically if I log out. when I come log in again, they are not in the table.

 

Anyone know what's the reason?

Comments

  • Hi!

     

    commit?

  • Hi, Skwa,

     

    Do I have to use Commit after the query?

     

     

    Thanks!

  • Hi ,
    In your case its DML based on a query , for any DML to be able to see your data after logout , you must explicit execute commit command
    Thanks

Leave a Comment

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