Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of sylvain@datastax.com
 designates 209.85.160.44 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CANJo1uBoHRP3A_A03qDLJcJVzJac4NNrVJ3ntV24EeETqFpikw@mail.gmail.com>
References: 
 <CANJo1uBi19faYxrGF79Au4A+9CdxUBzPKE-X79ZYffm7Zxw-=A@mail.gmail.com>
	<17C39FE466076C46B6E83F129C7B19CE16B8B5B5@HKXPRD0310MB352.apcprd03.prod.outlook.com>
	<CANJo1uBqypoJWrjFTi9JGk1xGyo7RcYeK+N2aNox5HwdGG-3uw@mail.gmail.com>
	<EEBBD9C0-B931-40D8-B1BD-C7EFF6FD8F5F@alumni.brown.edu>
	<CANJo1uDfXNX4anqcL6Vnk2qKF7x3JUaNW_96a=4YjC6i_AH6Ew@mail.gmail.com>
	<CANJo1uBoHRP3A_A03qDLJcJVzJac4NNrVJ3ntV24EeETqFpikw@mail.gmail.com>
Date: Tue, 9 Oct 2012 09:46:59 +0200
Message-ID: 
 <CAKkz8Q2x2xixNJ=1SxjqOW9s_9_8AhNjs52wTKPBG8xA3JmhwA@mail.gmail.com>
Subject: Re: Using compound primary key
From: Sylvain Lebresne <sylvain@datastax.com>
To: user@cassandra.apache.org
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Oct 9, 2012 at 8:57 AM, Vivek Mishra <mishra.vivs@gmail.com> wrote:
> Ok. I am able to understand the problem now. Issue is:
>
> If i create a column family altercations as:
>
> **********************************************************************************************************8
> CREATE TABLE altercations (
>        instigator text,
>        started_at timestamp,
>        ships_destroyed int,
>        energy_used float,
>        alliance_involvement boolean,
>        PRIMARY KEY (instigator,started_at,ships_destroyed)
>    );
> /
>    INSERT INTO altercations (instigator, started_at, ships_destroyed,
>                              energy_used, alliance_involvement)
>                      VALUES ('Jayne Cobb', '2012-07-23', 2, 4.6, 'false');
> *********************************************************************************************************************
>
> it works!
>
> But if i create a column family with compound primary key with 2 composite
> column as:
>
> CREATE TABLE altercations (
>        instigator text,
>        started_at timestamp,
>        ships_destroyed int,
>        energy_used float,
>        alliance_involvement boolean,
>        PRIMARY KEY (instigator,started_at)
>    );
>
> *********************************************************************************************************************
> and Then drop this column family:
>
> drop columnfamily altercations;
>
> and then try to create same one with primary compound key with 3 composite
> column:
>
> CREATE TABLE altercations (
>        instigator text,
>        started_at timestamp,
>        ships_destroyed int,
>        energy_used float,
>        alliance_involvement boolean,
>        PRIMARY KEY (instigator,started_at,ships_destroyed)
>    );
>
> it gives me error: "TSocket read 0 bytes"
>
> Rest, as no column family is created, so nothing onwards will work.
>
> Is this an issue?

Sounds like it yes (I mean the theory is, you shouldn't ever get such
an error by creating and dropping tables. Even if you do something
wrong, you should get a meaningful error).

Is there an exception in the log server side? (it's often the case
with a "TSocket read 0 bytes").

--
Sylvain