Search code examples
netezza

Why Netezza Sequence next value giving random values?

Sequence: 

CREATE SEQUENCE STG.TEMP_PPC_SEQ AS BIGINT
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    MAXVALUE 2147483647
    NO CYCLE;

Select Query:

SELECT TPLCST.code,NEXT VALUE FOR STAGING.STG.TEMP_PPC_SEQ
FROM TEMP_PRODUCT_LIFE_CYCLE_STATUS_TYPE TPLCST

Result:

CODE    NEXTVAL
30  8
80  10008
40  30008
50  40015
10  40016
20  20008

I am getting nextval random. How can I make them sequential?

Solution

  • They are random because Netezza is massively parallel and each SPU gets its own block of sequence values.