Re: cql query not giving any result.

2013-03-18 Thread Sylvain Lebresne
> If this is the case, Why can't we restrict "key" as a keyword and not to > be used as a column name? This is only a problem when upgrading from thrift to CQL. Forbidding "key" as a column name in thrift would be weird to say the least. What could be done is that CQL could, when it picks the def

Re: cql query not giving any result.

2013-03-18 Thread Vivek Mishra
If this is the case, Why can't we restrict "key" as a keyword and not to be used as a column name? -Vivek On Mon, Mar 18, 2013 at 2:37 PM, Sylvain Lebresne wrote: > CQL can't work correctly if 2 (CQL) columns have the same name. Now, to > allow upgrade from thrift, CQL does use some default name

Re: cql query not giving any result.

2013-03-18 Thread Sylvain Lebresne
CQL can't work correctly if 2 (CQL) columns have the same name. Now, to allow upgrade from thrift, CQL does use some default names like "key" for the Row key when there isn't anything else. Honestly I think the easiest workaround here is probably to disambiguate things manually. Typically, you cou

Re: cql query not giving any result.

2013-03-15 Thread Vivek Mishra
Any suggestions? -Vivek On Fri, Mar 15, 2013 at 5:20 PM, Vivek Mishra wrote: > Ok. So it's a case when, CQL returns rowkey value as "key" and there is > also column present with name as "key". > > Sounds like a bug? > > -Vivek > > > On Fri, Mar 15, 2013 at 5:17 PM, Kuldeep Mishra > wrote: > >>

Re: cql query not giving any result.

2013-03-15 Thread Vivek Mishra
Ok. So it's a case when, CQL returns rowkey value as "key" and there is also column present with name as "key". Sounds like a bug? -Vivek On Fri, Mar 15, 2013 at 5:17 PM, Kuldeep Mishra wrote: > Hi Sylvain, > I created it using thrift client, here is column family creation > script, > >

Re: cql query not giving any result.

2013-03-15 Thread Kuldeep Mishra
Hi Sylvain, I created it using thrift client, here is column family creation script, Cassandra.Client client; CfDef user_Def = new CfDef(); user_Def.name = "DOCTOR"; user_Def.keyspace = "KunderaExamples"; user_Def.setComparator_type("UTF8Type");

Re: cql query not giving any result.

2013-03-15 Thread Sylvain Lebresne
On Fri, Mar 15, 2013 at 11:43 AM, Kuldeep Mishra wrote: > Hi, > Is it possible in Cassandra to make multiple column with same name ?, like > in this particular scenario I have two column with same name as "key", > first one is rowkey and second on is column name . > > No, it shouldn't be possible

Re: cql query not giving any result.

2013-03-15 Thread Jason Wee
Here is a list of keywords and whether or not the words are reserved. A reserved keyword cannot be used as an identifier unless you enclose the word in double quotation marks. Non-reserved keywords have a specific meaning in certain context but can be used as an identifier outside this context. ht

Re: cql query not giving any result.

2013-03-15 Thread Kuldeep Mishra
Hi, Is it possible in Cassandra to make multiple column with same name ?, like in this particular scenario I have two column with same name as "key", first one is rowkey and second on is column name . Thanks and Regards Kuldeep On Fri, Mar 15, 2013 at 4:05 PM, Kuldeep Mishra wrote: > > Hi , >