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?
0
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