We use a Phoenix table where each row in the table represents a sequence and the increment is done atomically.
FWIW, Calcite supports sequences. On Tue, Oct 20, 2015 at 5:04 PM, Jacques Nadeau <[email protected]> wrote: > Not currently. > > How do you guys implement that in Phoenix since I assume the sequence would > need to be global and unique (and also distributed). > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Tue, Oct 20, 2015 at 9:24 AM, James Taylor <[email protected]> > wrote: > > > Does Drill support sequences in queries for things such as ID generation? > > > > CREATE TABLE suppliers > > AS (SELECT NEXT VALUE FOR supplier_id_seq, address, city, state, zip > > FROM companies > > WHERE city = 'San Francisco'); > > > > Thanks, > > James > > >
