We have support for sequences now with the:
CREATE SEQUENCE my.seq
SELECT NEXT VALUE FOR my.seq, k, v FROM t;
UPSERT INTO T(k,v) VALUES(NEXT VALUE FOR my.seq, 'a');
We should perf test it to make sure it performs ok. Also, one new config parameter: phoenix.sequence.batchSize that controls how big of a batch of sequences we get from the server and cache on the connection (defaults to 100).
We have support for sequences now with the: CREATE SEQUENCE my.seq SELECT NEXT VALUE FOR my.seq, k, v FROM t; UPSERT INTO T(k,v) VALUES(NEXT VALUE FOR my.seq, 'a');
We should perf test it to make sure it performs ok. Also, one new config parameter: phoenix.sequence.batchSize that controls how big of a batch of sequences we get from the server and cache on the connection (defaults to 100).