Skip to main content

data are deleted automatically after insert

  • January 22, 2016
  • 3 replies
  • 14 views
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?

    3 replies

    sKwa
    Forum|alt.badge.img+1
    • sKwa
    • Participating Frequently
    • January 23, 2016

    Hi!

     

    commit?

    yabchexu
    • yabchexu
    • Author
    • New Participant
    • January 26, 2016

    Hi, Skwa,

     

    Do I have to use Commit after the query?

     

     

    Thanks!

    eli_revach
    Forum|alt.badge.img+2
    • eli_revach
    • Participating Frequently
    • January 26, 2016

    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

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement