You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cassandra.apache.org by Joshua Partogi <jp...@scrum8.com> on 2010/12/02 14:04:55 UTC
Set an index on column
Hi there,
How do I set an index on a column in cassandra 0.7?
This is what I am trying to do:
[default@Keyspace1] get Standard1 where user = 'jpartogi';
No indexed columns present in index clause with operator EQ
I can not find this in the CLI help nor the wiki. Maybe I am not looking
hard enough?
Thanks heaps for your help
--
http://twitter.com/jpartogi
Re: Set an index on column
Posted by Joshua Partogi <jp...@scrum8.com>.
Thanks for the confirmation.
Cheers.
On Sat, Dec 4, 2010 at 3:34 PM, Jonathan Ellis <jb...@gmail.com> wrote:
> Looks like it was actually after rc1 artifacts were tagged and rolled
> (but before it was released). So the fix will be in rc2, or you can
> grab the 0.7 branch from svn before then.
>
> On Fri, Dec 3, 2010 at 6:44 PM, Tyler Hobbs <ty...@riptano.com> wrote:
> > Sounds like 1764:
> >
> > https://issues.apache.org/jira/browse/CASSANDRA-1764
> >
> > This was fixed in RC1.
> >
> > - Tyler
> >
> > On Fri, Dec 3, 2010 at 5:43 PM, Joshua Partogi <jp...@scrum8.com>
> wrote:
> >>
> >> Hi Jonathan,
> >>
> >> Thanks for the hint. This is the error that I get:
> >> ERROR [pool-1-thread-1] 2010-12-04 09:38:20,521 Cassandra.java (line
> 3596)
> >> Internal error processing system_update_column_family
> >> java.lang.NullPointerException
> >> at org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:665)
> >> at
> >>
> org.apache.cassandra.db.migration.UpdateColumnFamily.<init>(UpdateColumnFamily.java:56)
> >> at
> >>
> org.apache.cassandra.thrift.CassandraServer.system_update_column_family(CassandraServer.java:863)
> >> at
> >>
> org.apache.cassandra.thrift.Cassandra$Processor$system_update_column_family.process(Cassandra.java:3592)
> >> at
> >>
> org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2555)
> >> at
> >>
> org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:167)
> >> at
> >>
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> >> at
> >>
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> >> at java.lang.Thread.run(Thread.java:636)
> >>
> >>
> >> Could it be because the column was not created when the column family
> was
> >> created?
> >>
> >> Thanks again
> >>
> >> On Sat, Dec 4, 2010 at 1:08 AM, Jonathan Ellis <jb...@gmail.com>
> wrote:
> >>>
> >>> "internal error" means "there's an error in the server log"
> >>>
> >>> On Fri, Dec 3, 2010 at 2:47 AM, Joshua Partogi <jp...@scrum8.com>
> >>> wrote:
> >>> > Hi Jonathan,
> >>> >
> >>> > Thanks for the hint. I've tried it but it throws an error like this:
> >>> >
> >>> > [default@Keyspace1] update column family Standard1 with
> >>> > column_metadata=[{
> >>> > column_name:user, index_type:0, validation_class:UTF8Type,
> >>> > index_name:Standard1Idx }] and rows_cached=100;
> >>> > Internal error processing system_update_column_family
> >>> >
> >>> > Is there anything wrong with the syntax? I can not figure out what is
> >>> > wrong
> >>> > with it using the error message.
> >>> >
> >>> > Thanks for your help.
> >>> >
> >>> > Kind regards,
> >>> > Joshua.
> >>> >
> >>> > On Fri, Dec 3, 2010 at 12:38 AM, Jonathan Ellis <jb...@gmail.com>
> >>> > wrote:
> >>> >>
> >>> >> It's part of "update column family:"
> >>> >>
> >>> >> [default@unknown] help update column family;
> >>> >> ...
> >>> >> - column_metadata: Metadata which describes columns of column
> >>> >> family.
> >>> >> Supported format is [{ k:v, k:v, ... }, { ... }, ...]
> >>> >> Valid attributes: column_name, validation_class (see
> >>> >> comparator),
> >>> >> index_type (integer), index_name.
> >>> >>
> >>> >> example:
> >>> >> update column family Foo with column_metadata=[{ column_name:Test,
> >>> >> validation_class:IntegerType, index_type:0, index_name:IdxName}] and
> >>> >> rows_cached=100 and comment='this is helpful comment.';
> >>> >>
> >>> >>
> >>> >> On Thu, Dec 2, 2010 at 7:04 AM, Joshua Partogi <jpartogi@scrum8.com
> >
> >>> >> wrote:
> >>> >> > Hi there,
> >>> >> >
> >>> >> > How do I set an index on a column in cassandra 0.7?
> >>> >> >
> >>> >> > This is what I am trying to do:
> >>> >> > [default@Keyspace1] get Standard1 where user = 'jpartogi';
> >>> >> > No indexed columns present in index clause with operator EQ
> >>> >> >
> >>> >> >
> >>> >> > I can not find this in the CLI help nor the wiki. Maybe I am not
> >>> >> > looking
> >>> >> > hard enough?
> >>> >> >
> >>> >> > Thanks heaps for your help
> >>> >> >
> >>> >> > --
> >>> >> > http://twitter.com/jpartogi
> >>> >> >
> >>> >>
> >>> >>
> >>> >>
> >>> >> --
> >>> >> Jonathan Ellis
> >>> >> Project Chair, Apache Cassandra
> >>> >> co-founder of Riptano, the source for professional Cassandra support
> >>> >> http://riptano.com
> >>> >
> >>> >
> >>> >
> >>> > --
> >>> > http://twitter.com/jpartogi
> >>> >
> >>>
> >>>
> >>>
> >>> --
> >>> Jonathan Ellis
> >>> Project Chair, Apache Cassandra
> >>> co-founder of Riptano, the source for professional Cassandra support
> >>> http://riptano.com
> >>
> >>
> >>
> >> --
> >> http://twitter.com/jpartogi
> >
> >
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of Riptano, the source for professional Cassandra support
> http://riptano.com
>
--
http://twitter.com/jpartogi
Re: Set an index on column
Posted by Jonathan Ellis <jb...@gmail.com>.
Looks like it was actually after rc1 artifacts were tagged and rolled
(but before it was released). So the fix will be in rc2, or you can
grab the 0.7 branch from svn before then.
On Fri, Dec 3, 2010 at 6:44 PM, Tyler Hobbs <ty...@riptano.com> wrote:
> Sounds like 1764:
>
> https://issues.apache.org/jira/browse/CASSANDRA-1764
>
> This was fixed in RC1.
>
> - Tyler
>
> On Fri, Dec 3, 2010 at 5:43 PM, Joshua Partogi <jp...@scrum8.com> wrote:
>>
>> Hi Jonathan,
>>
>> Thanks for the hint. This is the error that I get:
>> ERROR [pool-1-thread-1] 2010-12-04 09:38:20,521 Cassandra.java (line 3596)
>> Internal error processing system_update_column_family
>> java.lang.NullPointerException
>> at org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:665)
>> at
>> org.apache.cassandra.db.migration.UpdateColumnFamily.<init>(UpdateColumnFamily.java:56)
>> at
>> org.apache.cassandra.thrift.CassandraServer.system_update_column_family(CassandraServer.java:863)
>> at
>> org.apache.cassandra.thrift.Cassandra$Processor$system_update_column_family.process(Cassandra.java:3592)
>> at
>> org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2555)
>> at
>> org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:167)
>> at
>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
>> at
>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
>> at java.lang.Thread.run(Thread.java:636)
>>
>>
>> Could it be because the column was not created when the column family was
>> created?
>>
>> Thanks again
>>
>> On Sat, Dec 4, 2010 at 1:08 AM, Jonathan Ellis <jb...@gmail.com> wrote:
>>>
>>> "internal error" means "there's an error in the server log"
>>>
>>> On Fri, Dec 3, 2010 at 2:47 AM, Joshua Partogi <jp...@scrum8.com>
>>> wrote:
>>> > Hi Jonathan,
>>> >
>>> > Thanks for the hint. I've tried it but it throws an error like this:
>>> >
>>> > [default@Keyspace1] update column family Standard1 with
>>> > column_metadata=[{
>>> > column_name:user, index_type:0, validation_class:UTF8Type,
>>> > index_name:Standard1Idx }] and rows_cached=100;
>>> > Internal error processing system_update_column_family
>>> >
>>> > Is there anything wrong with the syntax? I can not figure out what is
>>> > wrong
>>> > with it using the error message.
>>> >
>>> > Thanks for your help.
>>> >
>>> > Kind regards,
>>> > Joshua.
>>> >
>>> > On Fri, Dec 3, 2010 at 12:38 AM, Jonathan Ellis <jb...@gmail.com>
>>> > wrote:
>>> >>
>>> >> It's part of "update column family:"
>>> >>
>>> >> [default@unknown] help update column family;
>>> >> ...
>>> >> - column_metadata: Metadata which describes columns of column
>>> >> family.
>>> >> Supported format is [{ k:v, k:v, ... }, { ... }, ...]
>>> >> Valid attributes: column_name, validation_class (see
>>> >> comparator),
>>> >> index_type (integer), index_name.
>>> >>
>>> >> example:
>>> >> update column family Foo with column_metadata=[{ column_name:Test,
>>> >> validation_class:IntegerType, index_type:0, index_name:IdxName}] and
>>> >> rows_cached=100 and comment='this is helpful comment.';
>>> >>
>>> >>
>>> >> On Thu, Dec 2, 2010 at 7:04 AM, Joshua Partogi <jp...@scrum8.com>
>>> >> wrote:
>>> >> > Hi there,
>>> >> >
>>> >> > How do I set an index on a column in cassandra 0.7?
>>> >> >
>>> >> > This is what I am trying to do:
>>> >> > [default@Keyspace1] get Standard1 where user = 'jpartogi';
>>> >> > No indexed columns present in index clause with operator EQ
>>> >> >
>>> >> >
>>> >> > I can not find this in the CLI help nor the wiki. Maybe I am not
>>> >> > looking
>>> >> > hard enough?
>>> >> >
>>> >> > Thanks heaps for your help
>>> >> >
>>> >> > --
>>> >> > http://twitter.com/jpartogi
>>> >> >
>>> >>
>>> >>
>>> >>
>>> >> --
>>> >> Jonathan Ellis
>>> >> Project Chair, Apache Cassandra
>>> >> co-founder of Riptano, the source for professional Cassandra support
>>> >> http://riptano.com
>>> >
>>> >
>>> >
>>> > --
>>> > http://twitter.com/jpartogi
>>> >
>>>
>>>
>>>
>>> --
>>> Jonathan Ellis
>>> Project Chair, Apache Cassandra
>>> co-founder of Riptano, the source for professional Cassandra support
>>> http://riptano.com
>>
>>
>>
>> --
>> http://twitter.com/jpartogi
>
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com
Re: Set an index on column
Posted by Tyler Hobbs <ty...@riptano.com>.
Sounds like 1764:
https://issues.apache.org/jira/browse/CASSANDRA-1764
This was fixed in RC1.
- Tyler
On Fri, Dec 3, 2010 at 5:43 PM, Joshua Partogi <jp...@scrum8.com> wrote:
> Hi Jonathan,
>
> Thanks for the hint. This is the error that I get:
> ERROR [pool-1-thread-1] 2010-12-04 09:38:20,521 Cassandra.java (line 3596)
> Internal error processing system_update_column_family
> java.lang.NullPointerException
> at org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:665)
> at
> org.apache.cassandra.db.migration.UpdateColumnFamily.<init>(UpdateColumnFamily.java:56)
> at
> org.apache.cassandra.thrift.CassandraServer.system_update_column_family(CassandraServer.java:863)
> at
> org.apache.cassandra.thrift.Cassandra$Processor$system_update_column_family.process(Cassandra.java:3592)
> at
> org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2555)
> at
> org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:167)
> at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
> at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
> at java.lang.Thread.run(Thread.java:636)
>
>
> Could it be because the column was not created when the column family was
> created?
>
> Thanks again
>
>
> On Sat, Dec 4, 2010 at 1:08 AM, Jonathan Ellis <jb...@gmail.com> wrote:
>
>> "internal error" means "there's an error in the server log"
>>
>> On Fri, Dec 3, 2010 at 2:47 AM, Joshua Partogi <jp...@scrum8.com>
>> wrote:
>> > Hi Jonathan,
>> >
>> > Thanks for the hint. I've tried it but it throws an error like this:
>> >
>> > [default@Keyspace1] update column family Standard1 with
>> column_metadata=[{
>> > column_name:user, index_type:0, validation_class:UTF8Type,
>> > index_name:Standard1Idx }] and rows_cached=100;
>> > Internal error processing system_update_column_family
>> >
>> > Is there anything wrong with the syntax? I can not figure out what is
>> wrong
>> > with it using the error message.
>> >
>> > Thanks for your help.
>> >
>> > Kind regards,
>> > Joshua.
>> >
>> > On Fri, Dec 3, 2010 at 12:38 AM, Jonathan Ellis <jb...@gmail.com>
>> wrote:
>> >>
>> >> It's part of "update column family:"
>> >>
>> >> [default@unknown] help update column family;
>> >> ...
>> >> - column_metadata: Metadata which describes columns of column
>> family.
>> >> Supported format is [{ k:v, k:v, ... }, { ... }, ...]
>> >> Valid attributes: column_name, validation_class (see
>> comparator),
>> >> index_type (integer), index_name.
>> >>
>> >> example:
>> >> update column family Foo with column_metadata=[{ column_name:Test,
>> >> validation_class:IntegerType, index_type:0, index_name:IdxName}] and
>> >> rows_cached=100 and comment='this is helpful comment.';
>> >>
>> >>
>> >> On Thu, Dec 2, 2010 at 7:04 AM, Joshua Partogi <jp...@scrum8.com>
>> >> wrote:
>> >> > Hi there,
>> >> >
>> >> > How do I set an index on a column in cassandra 0.7?
>> >> >
>> >> > This is what I am trying to do:
>> >> > [default@Keyspace1] get Standard1 where user = 'jpartogi';
>> >> > No indexed columns present in index clause with operator EQ
>> >> >
>> >> >
>> >> > I can not find this in the CLI help nor the wiki. Maybe I am not
>> looking
>> >> > hard enough?
>> >> >
>> >> > Thanks heaps for your help
>> >> >
>> >> > --
>> >> > http://twitter.com/jpartogi
>> >> >
>> >>
>> >>
>> >>
>> >> --
>> >> Jonathan Ellis
>> >> Project Chair, Apache Cassandra
>> >> co-founder of Riptano, the source for professional Cassandra support
>> >> http://riptano.com
>> >
>> >
>> >
>> > --
>> > http://twitter.com/jpartogi
>> >
>>
>>
>>
>> --
>> Jonathan Ellis
>> Project Chair, Apache Cassandra
>> co-founder of Riptano, the source for professional Cassandra support
>> http://riptano.com
>>
>
>
>
> --
> http://twitter.com/jpartogi
>
Re: Set an index on column
Posted by Joshua Partogi <jp...@scrum8.com>.
Hi Jonathan,
Thanks for the hint. This is the error that I get:
ERROR [pool-1-thread-1] 2010-12-04 09:38:20,521 Cassandra.java (line 3596)
Internal error processing system_update_column_family
java.lang.NullPointerException
at org.apache.cassandra.config.CFMetaData.apply(CFMetaData.java:665)
at
org.apache.cassandra.db.migration.UpdateColumnFamily.<init>(UpdateColumnFamily.java:56)
at
org.apache.cassandra.thrift.CassandraServer.system_update_column_family(CassandraServer.java:863)
at
org.apache.cassandra.thrift.Cassandra$Processor$system_update_column_family.process(Cassandra.java:3592)
at
org.apache.cassandra.thrift.Cassandra$Processor.process(Cassandra.java:2555)
at
org.apache.cassandra.thrift.CustomTThreadPoolServer$WorkerProcess.run(CustomTThreadPoolServer.java:167)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:636)
Could it be because the column was not created when the column family was
created?
Thanks again
On Sat, Dec 4, 2010 at 1:08 AM, Jonathan Ellis <jb...@gmail.com> wrote:
> "internal error" means "there's an error in the server log"
>
> On Fri, Dec 3, 2010 at 2:47 AM, Joshua Partogi <jp...@scrum8.com>
> wrote:
> > Hi Jonathan,
> >
> > Thanks for the hint. I've tried it but it throws an error like this:
> >
> > [default@Keyspace1] update column family Standard1 with
> column_metadata=[{
> > column_name:user, index_type:0, validation_class:UTF8Type,
> > index_name:Standard1Idx }] and rows_cached=100;
> > Internal error processing system_update_column_family
> >
> > Is there anything wrong with the syntax? I can not figure out what is
> wrong
> > with it using the error message.
> >
> > Thanks for your help.
> >
> > Kind regards,
> > Joshua.
> >
> > On Fri, Dec 3, 2010 at 12:38 AM, Jonathan Ellis <jb...@gmail.com>
> wrote:
> >>
> >> It's part of "update column family:"
> >>
> >> [default@unknown] help update column family;
> >> ...
> >> - column_metadata: Metadata which describes columns of column family.
> >> Supported format is [{ k:v, k:v, ... }, { ... }, ...]
> >> Valid attributes: column_name, validation_class (see comparator),
> >> index_type (integer), index_name.
> >>
> >> example:
> >> update column family Foo with column_metadata=[{ column_name:Test,
> >> validation_class:IntegerType, index_type:0, index_name:IdxName}] and
> >> rows_cached=100 and comment='this is helpful comment.';
> >>
> >>
> >> On Thu, Dec 2, 2010 at 7:04 AM, Joshua Partogi <jp...@scrum8.com>
> >> wrote:
> >> > Hi there,
> >> >
> >> > How do I set an index on a column in cassandra 0.7?
> >> >
> >> > This is what I am trying to do:
> >> > [default@Keyspace1] get Standard1 where user = 'jpartogi';
> >> > No indexed columns present in index clause with operator EQ
> >> >
> >> >
> >> > I can not find this in the CLI help nor the wiki. Maybe I am not
> looking
> >> > hard enough?
> >> >
> >> > Thanks heaps for your help
> >> >
> >> > --
> >> > http://twitter.com/jpartogi
> >> >
> >>
> >>
> >>
> >> --
> >> Jonathan Ellis
> >> Project Chair, Apache Cassandra
> >> co-founder of Riptano, the source for professional Cassandra support
> >> http://riptano.com
> >
> >
> >
> > --
> > http://twitter.com/jpartogi
> >
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of Riptano, the source for professional Cassandra support
> http://riptano.com
>
--
http://twitter.com/jpartogi
Re: Set an index on column
Posted by Jonathan Ellis <jb...@gmail.com>.
"internal error" means "there's an error in the server log"
On Fri, Dec 3, 2010 at 2:47 AM, Joshua Partogi <jp...@scrum8.com> wrote:
> Hi Jonathan,
>
> Thanks for the hint. I've tried it but it throws an error like this:
>
> [default@Keyspace1] update column family Standard1 with column_metadata=[{
> column_name:user, index_type:0, validation_class:UTF8Type,
> index_name:Standard1Idx }] and rows_cached=100;
> Internal error processing system_update_column_family
>
> Is there anything wrong with the syntax? I can not figure out what is wrong
> with it using the error message.
>
> Thanks for your help.
>
> Kind regards,
> Joshua.
>
> On Fri, Dec 3, 2010 at 12:38 AM, Jonathan Ellis <jb...@gmail.com> wrote:
>>
>> It's part of "update column family:"
>>
>> [default@unknown] help update column family;
>> ...
>> - column_metadata: Metadata which describes columns of column family.
>> Supported format is [{ k:v, k:v, ... }, { ... }, ...]
>> Valid attributes: column_name, validation_class (see comparator),
>> index_type (integer), index_name.
>>
>> example:
>> update column family Foo with column_metadata=[{ column_name:Test,
>> validation_class:IntegerType, index_type:0, index_name:IdxName}] and
>> rows_cached=100 and comment='this is helpful comment.';
>>
>>
>> On Thu, Dec 2, 2010 at 7:04 AM, Joshua Partogi <jp...@scrum8.com>
>> wrote:
>> > Hi there,
>> >
>> > How do I set an index on a column in cassandra 0.7?
>> >
>> > This is what I am trying to do:
>> > [default@Keyspace1] get Standard1 where user = 'jpartogi';
>> > No indexed columns present in index clause with operator EQ
>> >
>> >
>> > I can not find this in the CLI help nor the wiki. Maybe I am not looking
>> > hard enough?
>> >
>> > Thanks heaps for your help
>> >
>> > --
>> > http://twitter.com/jpartogi
>> >
>>
>>
>>
>> --
>> Jonathan Ellis
>> Project Chair, Apache Cassandra
>> co-founder of Riptano, the source for professional Cassandra support
>> http://riptano.com
>
>
>
> --
> http://twitter.com/jpartogi
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com
Re: Set an index on column
Posted by Joshua Partogi <jp...@scrum8.com>.
Hi Jonathan,
Thanks for the hint. I've tried it but it throws an error like this:
[default@Keyspace1] update column family Standard1 with column_metadata=[{
column_name:user, index_type:0, validation_class:UTF8Type,
index_name:Standard1Idx }] and rows_cached=100;
Internal error processing system_update_column_family
Is there anything wrong with the syntax? I can not figure out what is wrong
with it using the error message.
Thanks for your help.
Kind regards,
Joshua.
On Fri, Dec 3, 2010 at 12:38 AM, Jonathan Ellis <jb...@gmail.com> wrote:
> It's part of "update column family:"
>
> [default@unknown] help update column family;
> ...
> - column_metadata: Metadata which describes columns of column family.
> Supported format is [{ k:v, k:v, ... }, { ... }, ...]
> Valid attributes: column_name, validation_class (see comparator),
> index_type (integer), index_name.
>
> example:
> update column family Foo with column_metadata=[{ column_name:Test,
> validation_class:IntegerType, index_type:0, index_name:IdxName}] and
> rows_cached=100 and comment='this is helpful comment.';
>
>
> On Thu, Dec 2, 2010 at 7:04 AM, Joshua Partogi <jp...@scrum8.com>
> wrote:
> > Hi there,
> >
> > How do I set an index on a column in cassandra 0.7?
> >
> > This is what I am trying to do:
> > [default@Keyspace1] get Standard1 where user = 'jpartogi';
> > No indexed columns present in index clause with operator EQ
> >
> >
> > I can not find this in the CLI help nor the wiki. Maybe I am not looking
> > hard enough?
> >
> > Thanks heaps for your help
> >
> > --
> > http://twitter.com/jpartogi
> >
>
>
>
> --
> Jonathan Ellis
> Project Chair, Apache Cassandra
> co-founder of Riptano, the source for professional Cassandra support
> http://riptano.com
>
--
http://twitter.com/jpartogi
Re: Set an index on column
Posted by Jonathan Ellis <jb...@gmail.com>.
It's part of "update column family:"
[default@unknown] help update column family;
...
- column_metadata: Metadata which describes columns of column family.
Supported format is [{ k:v, k:v, ... }, { ... }, ...]
Valid attributes: column_name, validation_class (see comparator),
index_type (integer), index_name.
example:
update column family Foo with column_metadata=[{ column_name:Test,
validation_class:IntegerType, index_type:0, index_name:IdxName}] and
rows_cached=100 and comment='this is helpful comment.';
On Thu, Dec 2, 2010 at 7:04 AM, Joshua Partogi <jp...@scrum8.com> wrote:
> Hi there,
>
> How do I set an index on a column in cassandra 0.7?
>
> This is what I am trying to do:
> [default@Keyspace1] get Standard1 where user = 'jpartogi';
> No indexed columns present in index clause with operator EQ
>
>
> I can not find this in the CLI help nor the wiki. Maybe I am not looking
> hard enough?
>
> Thanks heaps for your help
>
> --
> http://twitter.com/jpartogi
>
--
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of Riptano, the source for professional Cassandra support
http://riptano.com