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??!!
+2Hello 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?
hi Thanks for your response yes! am using script. yes! I am getting 0 rows when I execute the query in a new session!
+2Hello 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
ya Thanks it worked 
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
