phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <jamestay...@apache.org>
Subject Re: Crete table with salting and compression
Date Fri, 30 Jan 2015 08:08:15 GMT
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 <mujtaba@apache.org>
To: "dev@phoenix.apache.org" <dev@phoenix.apache.org>

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
<pompermaier@okkam.it> 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
>
>

Mime
View raw message