data are deleted automatically after insert

yabchexu

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?

sKwa

Hi!

 

commit?

yabchexu

Hi, Skwa,

 

Do I have to use Commit after the query?

 

 

Thanks!

eli_revach

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