phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Flavio Pompermaier <pomperma...@okkam.it>
Subject Re: Fwd: Crete table with salting and compression
Date Fri, 30 Jan 2015 10:08:39 GMT
You're right..that works!
Thanks!

On Fri, Jan 30, 2015 at 9:19 AM, sunfl@certusnet.com.cn <
sunfl@certusnet.com.cn> wrote:

> Hi,
> Aha, you are missing a comma after you specifying SALT_BUCKETS=10  The
> following sql grammer should work
>            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';
>
>
> ------------------------------
> ------------------------------
>
> CertusNet
>
>
> *From:* Flavio Pompermaier <pompermaier@okkam.it>
> *Date:* 2015-01-30 16:01
> *To:* user <user@phoenix.apache.org>
> *Subject:* Fwd: Crete table with salting and compression
> 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
>
>
>

Mime
View raw message