drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: support for sequences?
Date Wed, 21 Oct 2015 01:30:32 GMT
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 <jacques@dremio.com> 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 <jamestaylor@apache.org>
> 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
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message