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!
GET_NUM_REJECTED and ACCEPTED_ROWS by Session or Statement?
Moderator: NorbertKrupa
Re: GET_NUM_REJECTED and ACCEPTED_ROWS by Session or Stateme
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
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
Re: GET_NUM_REJECTED and ACCEPTED_ROWS by Session or Stateme
Cool, thanks for explaining, sKwa!