Re: create secondary index on column family

2013-03-26 Thread aaron morton
> the error "can not parse FUNCTION_CALL as hex bytes" is thrown in CLI, no log > printed on server. Is the conversion function > not allowed in "update column family" statement? Looks like functions are not supported in column meta data. You can raise a ticket if you want to https://issues.apac

Re: create secondary index on column family

2013-03-24 Thread Xu Renjie
On Mon, Mar 25, 2013 at 1:35 AM, aaron morton wrote: > I tried to wrap 'name' to bytes('name'), but it would throw "can not parse >> FUNCTION_CALL as hex bytes", seems this does not work. >> >>> What was the statement you used and what was the error. > OK, I have tried using ascii code 6e616d65(n

Re: create secondary index on column family

2013-03-24 Thread aaron morton
> > I tried to wrap 'name' to bytes('name'), but it would throw "can not parse > FUNCTION_CALL as hex bytes", seems this does not work. What was the statement you used and what was the error. > So the stored bytes are the same, right? Yes. - Aaron Morton Freelance Cassandra

Re: create secondary index on column family

2013-03-24 Thread Xu Renjie
On Sun, Mar 24, 2013 at 1:45 AM, aaron morton wrote: > But a error is thrown saying "can not parse name as hex bytes". > > If the comparator is Bytes then the column names need to be a hex string. > > The easiest thing to do is create a CF where the comparator is UTF8Type so > you can use string c

Re: create secondary index on column family

2013-03-24 Thread Xu Renjie
Thanks, aaron. On Sun, Mar 24, 2013 at 1:45 AM, aaron morton wrote: > But a error is thrown saying "can not parse name as hex bytes". > > If the comparator is Bytes then the column names need to be a hex string. > > The easiest thing to do is create a CF where the comparator is UTF8Type so > you

Re: create secondary index on column family

2013-03-23 Thread aaron morton
> But a error is thrown saying "can not parse name as hex bytes". If the comparator is Bytes then the column names need to be a hex string. The easiest thing to do is create a CF where the comparator is UTF8Type so you can use string column names. > just that the UTF8Type needs to be validated

Re: create secondary index on column family

2013-03-22 Thread Xu Renjie
Sorry, continued: I have created a column family User with no parameters specified, just create column family User. Then I checked that the default comparator is BytesType. Then I want to create secondary index on one column like below: update column family User with column_metadata=[

create secondary index on column family

2013-03-22 Thread Xu Renjie
Hello, guys: I am new to Cassandra. I am currently using cassandra-cli(version 1.1.6).