Hi Flavio, Did you see Mujtaba's response (repeated below) and did it work out for you after making that change?
Date: Tue, 27 Jan 2015 10:02:29 -0800 Subject: Re: Crete table with salting and compression From: Mujtaba Chohan <[email protected]> To: "[email protected]" <[email protected]> I think you are missing a comma after SALT_BUCKETS=10*,* in your first example. On Fri, Jan 30, 2015 at 12:01 AM, Flavio Pompermaier <[email protected]> wrote: > Hi to all, > > I'm using phoenix 4.2.2 and I'm trying to create a table both with > compression and salting but this seems not to be possible. > > Here's my SQL: > > CREATE TABLE IF NOT EXISTS %s (ID BIGINT NOT NULL, S VARCHAR NOT NULL, MODEL > VARCHAR CONSTRAINT pk PRIMARY KEY (ID, S)) SALT_BUCKETS=10 COMPRESSION='GZ', > BLOCKSIZE='4096'"; > > If I do > > CREATE TABLE IF NOT EXISTS %s (ID BIGINT NOT NULL, S VARCHAR NOT NULL, MODEL > VARCHAR CONSTRAINT pk PRIMARY KEY (ID, S)) COMPRESSION='GZ', > BLOCKSIZE='4096'"; > > or > > CREATE TABLE IF NOT EXISTS %s (ID BIGINT NOT NULL, S VARCHAR NOT NULL, MODEL > VARCHAR CONSTRAINT pk PRIMARY KEY (ID, S)) SALT_BUCKETS=10; > > everything works, but not putting all options together as in the first > example.. > > is this a bug or there's something I cannot see? > > Best, > Flavio > >
