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 could update the column family definition to set the key_alias (in CfDef) to some name that make sense for you. This will end up being the name of the Row key for CQL. You may also try issue a RENAME from CQL to rename the row key, which "should" work. Typically something like "ALTER KunderaExamples RENAME key TO rowKey". -- Sylvain On Sat, Mar 16, 2013 at 4:39 AM, Vivek Mishra <[email protected]> wrote: > Any suggestions? > -Vivek > > On Fri, Mar 15, 2013 at 5:20 PM, Vivek Mishra <[email protected]>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 <[email protected] >> > wrote: >> >>> 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"); >>> user_Def.setDefault_validation_class("UTF8Type"); >>> user_Def.setKey_validation_class("UTF8Type"); >>> ColumnDef key = new ColumnDef(ByteBuffer.wrap("KEY".getBytes()), >>> "UTF8Type"); >>> key.index_type = IndexType.KEYS; >>> ColumnDef age = new ColumnDef(ByteBuffer.wrap("AGE".getBytes()), >>> "UTF8Type"); >>> age.index_type = IndexType.KEYS; >>> user_Def.addToColumn_metadata(key); >>> user_Def.addToColumn_metadata(age); >>> >>> client.set_keyspace("KunderaExamples"); >>> client.system_add_column_family(user_Def); >>> >>> >>> Thanks >>> KK >>> >>> >>> On Fri, Mar 15, 2013 at 4:24 PM, Sylvain Lebresne >>> <[email protected]>wrote: >>> >>>> On Fri, Mar 15, 2013 at 11:43 AM, Kuldeep Mishra < >>>> [email protected]> 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 and that is your problem. How did you >>>> created that table? >>>> >>>> -- >>>> Sylvain >>>> >>>> >>>>> >>>>> Thanks and Regards >>>>> Kuldeep >>>>> >>>>> >>>>> On Fri, Mar 15, 2013 at 4:05 PM, Kuldeep Mishra < >>>>> [email protected]> wrote: >>>>> >>>>>> >>>>>> Hi , >>>>>> Following cql query not returning any result >>>>>> cqlsh:KunderaExamples> select * from "DOCTOR" where key='kuldeep'; >>>>>> >>>>>> I have enabled secondary indexes on both column. >>>>>> >>>>>> Screen shot is attached >>>>>> >>>>>> Please help.... >>>>>> >>>>>> >>>>>> -- >>>>>> Thanks and Regards >>>>>> Kuldeep Kumar Mishra >>>>>> +919540965199 >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Thanks and Regards >>>>> Kuldeep Kumar Mishra >>>>> +919540965199 >>>>> >>>> >>>> >>> >>> >>> -- >>> Thanks and Regards >>> Kuldeep Kumar Mishra >>> +919540965199 >>> >> >> >
