Re: Representation of dynamically added columns in table (column family) schema using cqlsh

2013-07-13 Thread Tristan Seligmann
See http://www.datastax.com/dev/blog/thrift-to-cql3 for more information. On Sat, Jul 13, 2013 at 1:19 AM, Eric Stevens wrote: > If you're creating dynamic columns via Thrift interface, they will not be > reflected in the CQL3 schema. I would recommend not mixing paradigms like > that, either

Re: IllegalArgumentException on query with AbstractCompositeType

2013-07-13 Thread Tristan Seligmann
On Fri, Jul 12, 2013 at 10:38 AM, aaron morton wrote: > CREATE INDEX ON conv_msgdata_by_participant_cql(msgReadFlag); > > On general this is a bad idea in Cassandra (also in a relational DB IMHO). > You will get poor performance from it. > Could you elaborate on why this is a bad idea? -- mi

Re: IllegalArgumentException on query with AbstractCompositeType

2013-07-13 Thread Shahab Yunus
Aaron Morton can confirm but I think one problem could be that to create an index on a field with small number of possible values is not good. Regards, Shahab On Sat, Jul 13, 2013 at 9:14 AM, Tristan Seligmann wrote: > On Fri, Jul 12, 2013 at 10:38 AM, aaron morton wrote: > >> CREATE INDEX ON c

Re: Node tokens / data move

2013-07-13 Thread Jeremiah D Jordan
Pretty sure you can put the list in the yaml file too. -Jeremiah On Jul 12, 2013, at 3:09 AM, aaron morton wrote: >> Can he not specify all 256 tokens in the YAML of the new >> cluster and then copy sstables? >> I know it is a bit ugly but should work. > You can pass a comma sepa