Re: Assume Keys in cqlsh?

2012-08-18 Thread paul cannon
"assume" isn't in CQL, that's right--however, it IS in cqlsh. You're just using it wrong. Try: ASSUME KEY values are text; Remember, in CQL, row keys are just another column, so you need to treat "KEY" (if that's the name of your key column) as a normal column. "HELP ASSUME" in cqlsh migh

Re: CQL connections

2012-08-18 Thread paul cannon
People are aware of the need, but I don't think it's on any roadmaps yet, and there are other "necessary features" that have been getting more attention so far. I hope that I or someone else can get to it fairly soon, but I don't have any guarantees to give. In the meantime, patches are welcome! p

Re: cqlsh commands

2012-06-21 Thread paul cannon
What do you mean when you say you can't display the related documentations using the help command? What does cqlsh do instead? I don't know about any bugs in that area. p On Wed, Jun 20, 2012 at 6:47 AM, Thierry Templier < thierry.templ...@restlet.com> wrote: > Hello, > > I'm using cqlsh tool

Re: Number format in cqlsh

2012-06-12 Thread paul cannon
No, but a way could be added pretty easily. File a ticket on Jira? p On Tuesday, June 12, 2012, Leonid Ilyevsky wrote: > Is there a way to control the floating numbers format in the cqlsh output? > I need more digits than it gives by default (in my tests, I see only one > digit after the point).

Re: Correct way to set strategy options in cqlsh?

2012-05-23 Thread paul cannon
I agree, this is a bug. I opened https://issues.apache.org/jira/browse/CASSANDRA-4278 to track it. The workaround for now is to use the CLI or the thrift interface to create your keyspace. p On Wed, May 23, 2012 at 8:29 AM, Damick, Jeffrey wrote: > Since this is the EC2MultiRegionSnitch, how

Re: C 1.1 & CQL 2.0 or 3.0?

2012-05-16 Thread paul cannon
myPC:~$ cqlsh -3 1xx.xx.xxx.xx 9165 > Connected to Test Cluster at 1xx.xx.xxx.xx:9165. > [cqlsh 2.2.0 | Cassandra 1.1.0 | CQL spec 3.0.0 | Thrift protocol 19.30.0] > Use HELP for help. > cqlsh> use Mykeyspace; > Bad Request: Keyspace 'mykeyspace' does not exist > cqlsh

Re: CQL 3.0 Features

2012-05-16 Thread paul cannon
Sylvain has a draft on https://issues.apache.org/jira/browse/CASSANDRA-3779, and that should be an official cassandra project doc "real soon now". If you're asking about Datastax's reference docs for CQL 3, they will probably be released once Datastax Enterprise or Datastax Community is released w

Re: C 1.1 & CQL 2.0 or 3.0?

2012-05-14 Thread paul cannon
This should not be the case- a keyspace is a keyspace, however created. I haven't been able to reproduce this; are you sure that the cassandra-cli and cqlsh are connecting to the same instance? Maybe you should create a Jira ticket. p On Fri, May 11, 2012 at 2:05 PM, cyril auburtin wrote: > ye

Re: odd CQL behavior

2012-05-03 Thread paul cannon
sed that much. Does CQL have any > functions to convert ascii to hex so that I don't have to do that > conversion elsewhere (I don't see one in the docs)? > > > On Thu, May 3, 2012 at 2:09 PM, paul cannon wrote: > >> On Thu, May 3, 2012 at 12:46 PM, Eric Czech w

Re: odd CQL behavior

2012-05-03 Thread paul cannon
On Thu, May 3, 2012 at 12:46 PM, Eric Czech wrote: > I can't believe I have to ask this but I have a CF with about 10 rows and > the keys are literally 1 through 9. > > Why does this not work if I want the row where the key is ascii('5')? > > cqlsh:Keyspace1> select first 1 * from CF where key

Re: execute_prepared_cql_query and variable range filter parameter

2012-04-30 Thread paul cannon
Town where > key in ('Paris', 'London')]. > > In that case, I must prepare the statement again, losing the benefit of > prepare. > > ** ** > > Maybe there is another way to avoid preparing again ? > > ** ** > > Thanks, > > - Pierr

Re: Cql 3 wide rows filter expressions in where clause

2012-04-30 Thread paul cannon
CQL doesn't currently let you filter on columns which aren't part of a primary key or indexed, so the "and x=2 and z=2" part of your query is not valid. p On Mon, Apr 30, 2012 at 8:54 PM, Jonathan Ellis wrote: > That should work. I don't see anything obviously wrong with your > query, other th

Re: execute_prepared_cql_query and variable range filter parameter

2012-04-30 Thread paul cannon
Hi Pierre- Yes, each ? can only represent one value at a time (although it can take on a different value for each actual execution of the prepared query). This is certainly normal for SQL binding libraries. Not sure why you feel that defeats statement preparation. p On Mon, Apr 30, 2012 at 3:45

Re: Doubt regarding CQL

2012-02-22 Thread paul cannon
Rishabh- It looks like you're not actually using the cqlsh that comes with Cassandra 1.0.7. Are you using an old version of the Python CQL driver? Old versions of the driver had cqlsh bundled with it, instead of with Cassandra. The 1.0.7 Debian/Ubuntu packages do not include cqlsh, because of s

Re: Debian package jna bug workaroung

2011-11-04 Thread paul cannon
> * JAVA_HOME=/usr/lib/jvm/java-6-sun > and jna.jar copied into /usr/share/cassandra(/lib) > > I then saw the detail in the init script and how it was being linked > > Is there a way I can verify which provider is being used? I want to make > sure Off heap is being used in the de

Re: Debian package jna bug workaroung

2011-11-03 Thread paul cannon
I can't reproduce this. What version of the cassandra deb are you using, exactly, and why are you symlinking or copying jna.jar into /usr/share/cassandra? The initscript should be adding /usr/sahre/java/jna.jar to the classpath, and that should be all you need. The failure you see with o.a.c.cach