Re: Read performance in map data type

2014-03-29 Thread Sourabh Agrawal
Hi, I don't think there is a problem with the driver. Regarding the schema, you may want to choose between wide rows and skinny rows. http://stackoverflow.com/questions/19039123/cassandra-wide-vs-skinny-rows-for-large-columns http://thelastpickle.com/blog/2013/01/11/primary-keys-in-cql.html When

cassandra 2.0.6 refuses to start

2014-03-29 Thread Tim Dunphy
hey all.. love using the cassandra database. however I've just installed 2.0.6 onto a new host running CentOS 6.5 and when I try to run ./bin/cassandra -f (from within the cassandra directory) I see this weird error I've never seen before ./bin/cassandra: line 146: exec: : not found What the h

select distinct and where ....

2014-03-29 Thread toivo a
Hi Is it possible to restrict select distinct by adding something in where part? For example: cqlsh> select distinct weatherstation_id, date from mixer.temperature; weatherstation_id | date ---+ 1234ABCD | 2013-04-05 1234ABCD | 2013-04-04

Re: Read performance in map data type

2014-03-29 Thread Apoorva Gaurav
Hello Sourabh, I'd prefer to do query like select * from marks_table where studentID = ? and subjectID in (?, ?, ??) but if its costly then can happily delegate the responsibility to the application layer. Haven't tried 2.x java driver for this specific issue but tried it once earlier and fou

Re: No output.log is ever generated

2014-03-29 Thread user 01
Can anyone please confirm, whether output.log is completely deprecated now ? On Mon, Mar 24, 2014 at 6:53 PM, user 01 wrote: > > *@Jonathan Lacefield, * > Yes I am seeing the logs in system.log. I installed cassandra 2.0.6 using > latest Datastax Community package on Ubuntu 12.04. Its is packag

Re: Read performance in map data type

2014-03-29 Thread Sourabh Agrawal
Hi Apoorva, Do you always query on studentID only or do you need to query on both studentID and subjectID? Also, I think using the latest driver (2.x) can make querying large number of rows efficient. http://www.datastax.com/dev/blog/client-side-improvements-in-cassandra-2-0 On Sat, Mar 29, 2