All the numbers are there - what you are seeing is an artifact of how the numbers are blocked, and possibly of how you are sampling in View Data. It looks like you are getting approximately 96 rows per block (the actual number depends, of course, on the row size).srimitta wrote:And one more thing is Data in DataSet not in Sequence order it starts from 1 and after 96 again row starts from 3704 and ends with 3799 and sratrs from 97 ends with 192.
Sequence no changes app after every 95 rows.
Any idea hwat's going-on and how to staight-up this.
Thanks
srimitta
The values are not necessarily stored in sorted order in the Data Set - did you sort them on the way in?
Even if they are, as you retrieve rows from the different processing nodes it will appear that there are huge jumps. Depending on how your data are partitioned will also affect how big these jumps seem to be. For example with Round Robin partitioning and two nodes you will tend to get even numbers on one node and odd numbers on the other.
I exhort you to experiment further with the variations on this theme, and try to understand what's happening and what's going where.