Search code examples
ignitegridgain

Apache Ignite's Support for Sequences

Does ignite support creating sequences? What is the equivalent of this statement in ignite?

CREATE SEQUENCE public.id_seq1
    START WITH 1
    INCREMENT BY 1
    MINVALUE 1
    NO MAXVALUE
    CACHE 1;
Solution

    • SQL sequences are not supported, you can check here what DDL operations could be done in Ignite. Apache Ignite doesn't need to support all auxiliary DDL objects like SEQUENCE or AGGREGATE but is rather focused on TABLE and INDEX definitions, and the way you access your data using DML or SELECT queries instead.

    • You can use Atomic Sequence as an alternative.