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?
Do I have to use Commit after the query?
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 commandThanks