GET_NUM_REJECTED and ACCEPTED_ROWS by Session or Statement?

Moderator: NorbertKrupa

Post Reply
User avatar
Jbaskin
Intermediate
Intermediate
Posts: 61
Joined: Sat Jan 28, 2012 1:21 pm

GET_NUM_REJECTED and ACCEPTED_ROWS by Session or Statement?

Post by Jbaskin » Wed Sep 25, 2013 8:00 pm

Hi guys,

Are the results returned by the GET_NUM_REJECTED_ROWS and GET_NUM_ACCEPTED_ROWS functions by session or for each COPY command? What if I am loading a bunch of files at once or in parallel?

Thanks!

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: GET_NUM_REJECTED and ACCEPTED_ROWS by Session or Stateme

Post by id10t » Wed Sep 25, 2013 8:19 pm

Hi!

Depends on what you mean "parallel" - subprocesses or threads. If subprocesses so each parallel stream has it own session and results returned by the GET_NUM_REJECTED_ROWS and GET_NUM_ACCEPTED_ROWS will be per stream/session. If it threads so you will get result for the last executed stream.

PS
I can't imagine how you can realize it in "threads" and not in subprocesses, so probably each stream has it own session. Check it by

Code: Select all

select * from sessions

User avatar
Jbaskin
Intermediate
Intermediate
Posts: 61
Joined: Sat Jan 28, 2012 1:21 pm

Re: GET_NUM_REJECTED and ACCEPTED_ROWS by Session or Stateme

Post by Jbaskin » Thu Sep 26, 2013 12:56 pm

Cool, thanks for explaining, sKwa!

Post Reply

Return to “Vertica Data Load”