Re: Compund/Composite column names
Sounds like you're running into the keyspace drop bug. It's "mostly" fixed
in 1.1.5 but you might need the latest from 1.1 branch. 1.1.6 will be
released soon with the final fix.
On Oct 9, 2012 1:58 AM, "Vivek Mishra" 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?
>
> -Vivek
>
>
>
> From: Jonathan Ellis
> To: dev@cassandra.apache.org; Vivek Mishra
> Sent: Tuesday, October 9, 2012 9:08 AM
> Subject: Re: Compund/Composite column names
>
> Works for me on latest 1.1 in cql3 mode. cql2 mode gives a parse error.
>
> On Mon, Oct 8, 2012 at 9:18 PM, Vivek Mishra
> wrote:
> > Hi All,
> >
> > I am trying to use compound primary key column name and i am referring
> to:
> > http://www.datastax.com/dev/blog/whats-new-in-cql-3-0
> >
> >
> > As mentioned on this example, i tried to create a column family
> containing compound primary key (one or more) as:
> >
> > CREATE TABLE altercations (
> >instigator text,
> >started_at timestamp,
> >ships_destroyed int,
> >energy_used float,
> >alliance_involvement boolean,
> >PRIMARY KEY (instigator,started_at,ships_destroyed)
> >);
> >
> > And i am getting:
> >
> >
> > **
> > TSocket read 0 bytes
> > cqlsh:testcomp>
> > **
> >
> >
> > Then followed by insert and select statements giving me following errors:
> >
> >
>
> >
> > cqlsh:testcomp>INSERT INTO altercations (instigator, started_at,
> ships_destroyed,
> > ... energy_used,
> alliance_involvement)
> > ... VALUES ('Jayne Cobb', '2012-07-23',
> 2, 4.6, 'false');
> > TSocket read 0 bytes
> >
> > cqlsh:testcomp> select * from altercations;
> > Traceback (most recent call last):
> > File "bin/cqlsh", line 1008, in perform_statement
> > self.cursor.execute(statement, decoder=decoder)
> > File
> "bin/../lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cursor.py", line
> 117, in execute
> > response = self.handle_cql_execution_errors(doquery, prepared_q,
> compress)
> > File
> "bin/../lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cursor.py", line
> 132, in handle_cql_execution_errors
> > return executor(*args, **kwargs)
> > File
> "bin/../lib/cql-internal-only-1.0.10.zip/cql-1.0.10/cql/cassandra/Cassandr
[VOTE] Release Apache Cassandra 1.1.6
Quite a few fixes since 1.1.5 and there's at least #4772 that makes it worth pushing a new release. So I propose the following artifacts for release as 1.1.6. sha1: 2773f7cd8ba5e9b3b293f26f546ddcd450831d82 Git: http://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=shortlog;h=refs/tags/1.1.6-tentative Artifacts: https://repository.apache.org/content/repositories/orgapachecassandra-038/org/apache/cassandra/apache-cassandra/1.1.6/ Staging repository: https://repository.apache.org/content/repositories/orgapachecassandra-038/ The artifacts as well as the debian package are also available here: http://people.apache.org/~slebresne/ The vote will be open for 72 hours (longer if needed). [1]: http://goo.gl/MYRFT (CHANGES.txt) [2]: http://goo.gl/I9xPL (NEWS.txt)
Re: [VOTE] Release Apache Cassandra 1.1.6
+1 On Tue, Oct 9, 2012 at 10:48 AM, Sylvain Lebresne wrote: > Quite a few fixes since 1.1.5 and there's at least #4772 that makes it worth > pushing a new release. So I propose the following artifacts for release as > 1.1.6. > > sha1: 2773f7cd8ba5e9b3b293f26f546ddcd450831d82 > Git: > http://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=shortlog;h=refs/tags/1.1.6-tentative > Artifacts: > https://repository.apache.org/content/repositories/orgapachecassandra-038/org/apache/cassandra/apache-cassandra/1.1.6/ > Staging repository: > https://repository.apache.org/content/repositories/orgapachecassandra-038/ > > The artifacts as well as the debian package are also available here: > http://people.apache.org/~slebresne/ > > The vote will be open for 72 hours (longer if needed). > > [1]: http://goo.gl/MYRFT (CHANGES.txt) > [2]: http://goo.gl/I9xPL (NEWS.txt) -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com
Re: [VOTE] Release Apache Cassandra 1.1.6
+1 On Oct 9, 2012, at 11:48 AM, Sylvain Lebresne wrote: > Quite a few fixes since 1.1.5 and there's at least #4772 that makes it worth > pushing a new release. So I propose the following artifacts for release as > 1.1.6. > > sha1: 2773f7cd8ba5e9b3b293f26f546ddcd450831d82 > Git: > http://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=shortlog;h=refs/tags/1.1.6-tentative > Artifacts: > https://repository.apache.org/content/repositories/orgapachecassandra-038/org/apache/cassandra/apache-cassandra/1.1.6/ > Staging repository: > https://repository.apache.org/content/repositories/orgapachecassandra-038/ > > The artifacts as well as the debian package are also available here: > http://people.apache.org/~slebresne/ > > The vote will be open for 72 hours (longer if needed). > > [1]: http://goo.gl/MYRFT (CHANGES.txt) > [2]: http://goo.gl/I9xPL (NEWS.txt)
Re: [VOTE] Release Apache Cassandra 1.1.6
Just committed a fix for possible infinite L0 compaction in LCS (f34bd79b9a92f23c1fc5e185e074d7faa880fc0b), can we include that? On Tue, Oct 9, 2012 at 11:12 AM, Jonathan Ellis wrote: > +1 > > On Tue, Oct 9, 2012 at 10:48 AM, Sylvain Lebresne > wrote: >> Quite a few fixes since 1.1.5 and there's at least #4772 that makes it worth >> pushing a new release. So I propose the following artifacts for release as >> 1.1.6. >> >> sha1: 2773f7cd8ba5e9b3b293f26f546ddcd450831d82 >> Git: >> http://git-wip-us.apache.org/repos/asf?p=cassandra.git;a=shortlog;h=refs/tags/1.1.6-tentative >> Artifacts: >> https://repository.apache.org/content/repositories/orgapachecassandra-038/org/apache/cassandra/apache-cassandra/1.1.6/ >> Staging repository: >> https://repository.apache.org/content/repositories/orgapachecassandra-038/ >> >> The artifacts as well as the debian package are also available here: >> http://people.apache.org/~slebresne/ >> >> The vote will be open for 72 hours (longer if needed). >> >> [1]: http://goo.gl/MYRFT (CHANGES.txt) >> [2]: http://goo.gl/I9xPL (NEWS.txt) > > > > -- > Jonathan Ellis > Project Chair, Apache Cassandra > co-founder of DataStax, the source for professional Cassandra support > http://www.datastax.com -- Jonathan Ellis Project Chair, Apache Cassandra co-founder of DataStax, the source for professional Cassandra support http://www.datastax.com
