data are deleted automatically after insert

yabchexuyabchexu
in General Discussion

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

  • sKwasKwa

    Hi!

     

    commit?

  • yabchexuyabchexu

    Hi, Skwa,

     

    Do I have to use Commit after the query?

     

     

    Thanks!

  • eli_revacheli_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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...