We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


successfully loaded data is missing after few minutes!! — Vertica Forum

successfully loaded data is missing after few minutes!!

renurenu
in General Discussion
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??!!

Comments

  • 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?
  • renurenu
    hi Thanks for your response yes! am using script. yes! I am getting 0 rows when I execute the query in a new session!
  • 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
  • renurenu
    ya Thanks it worked :):):):)

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 ...