datasliceid clarification
Posted: Sat Nov 15, 2014 12:42 am
I have userdefined sql In netezza connector which will return 100 rows.Let us assume I Included following condition in where clause
WHERE mod(datasliceid,[[node-count]])=[[node-number]]
1)Can anyone explain for each row what is the value of [[node-count]],[[node-number]] and datasliceid.I am using 4 node configuration so [[node-count]] is always 4.What is the value of datasliceid and [[node-number]].
From the manual The column datasliceid is a special Netezza column specific to each table but not clear to me
WHERE mod(datasliceid,[[node-count]])=[[node-number]]
1)Can anyone explain for each row what is the value of [[node-count]],[[node-number]] and datasliceid.I am using 4 node configuration so [[node-count]] is always 4.What is the value of datasliceid and [[node-number]].
From the manual The column datasliceid is a special Netezza column specific to each table but not clear to me