All Forums Database
jamesd 1 post Joined 09/14
25 Sep 2014
job sequence number

Sometimes the sequence number increases by 1 and sometimes by large numbers like 100,000. How do I set the sequence number increment?

Raja_KT 1246 posts Joined 07/09
25 Sep 2014

My suggestion.For which tool/technology or hadoop or ..... Maybe you can put under the right forum, someone who knows better about it can answer. 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

dnoeth 4628 posts Joined 11/04
25 Sep 2014

Do you mean a column defined with GENERATED ALWAYS AS IDENTITY?
This is the the way it is implemented in TD, it's not one sequence, it's a parallel sequence. Each AMP/PE reserverves a batch of 100,000 numbers and assignes them sequentially. The batch size can only be modified on a system level, but will never be set to 1.
If you need sequential values without gaps you should do it within SQL using ROW_NUMBER.

Dieter

You must sign in to leave a comment.