successfully loaded data is missing after few minutes!!

Hi all, I am loading the data into a table using insert /*+ direct */ into c select * from a,b as i wanna load data from 2 tables into one table. the query executes and shows 20000 rows added BUT after few minutes when i execute query like select count(*) from c, it shows 0 rows!! how this can happen??!!


  • Options
    Navin_CNavin_C Vertica Customer
    Hello Renu, How are you executing the insert query, via some script or using vsql. Are you executing the "select count(*) from c" in a new session?
  • Options
    hi Thanks for your response yes! am using script. yes! I am getting 0 rows when I execute the query in a new session!
  • Options
    Navin_CNavin_C Vertica Customer
    Hello Renu, By default the Autocommit is off in Vertica. Insert query will always need a "COMMIT" statement to save all the inserted records. If you don't specify a "COMMIT" in your script then the transaction ends without saving the changes. That might be the reason when you open a new session, you are getting 0 records. Hope this helps
  • Options
    ya Thanks it worked :):):):)

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file