Re: Upgrade to a different version?
So did you downgraded it back to 0.6.x series? On Thu, Mar 17, 2011 at 6:36 AM, Paul Pak p...@yellowseo.com wrote: Sorry guys, that was meant to be private. My opinion stands, but I didn't want to hurt any of the dev's feelings by being too frank. I think the progress has been good in new features, but I feel we have taken a step back in relability and scalability since so many features were added without adequate testing. Hopefully, at some point soon, it will get better and doing a data import job won't take a cassandra cluster to it's knees or we won't experience stop the world GC issues and have out of memory errors from routine usage. Paul On 3/16/2011 2:13 PM, Paul Pak wrote: Hi Jake, I'm sending this privately, because I wanted to tell you my opinion frankly. I don't know about the .6 series or .74, but so far, all of the .7 series of cassandra has been a disaster. I would think twice about switching to anything in .7 series to production until things stabilize and at least one reasonably large site starts using cassandra .7. Jonathan claims reddit is using cassandra, but it can't be a good experience with the type of bugs that have been found. .70 had data corruption issues .71 also had data corruption issues, had major issues with anything over 2 gigs in memory .72 issues with reading properly .73 had major issues with anything over 2 gigs in memory, had issues with performance due to flushing rules being broken, many people had huge issues with large amounts of insertions, and a few had startup issues. .74 too new to say. In either case, do a lot of testing for your use case before switching as things in the .7 series are still way in development. I've talked to Jonathan about putting it into beta status because of the severity of the bugs, but so far, there has been no decision to do so. Good luck. Paul On 3/16/2011 1:21 PM, Jake Maizel wrote: We are running 0.6.6 and are considering upgrading to either 0.6.8 or one of the 0.7.x releases. What is the recommended version and procedure? What are the issues we face? Are there any specific storage gotchas we need to be aware of? Are there any docs around this process for review? Thanks, jake -- http://twitter.com/jpartogi
How does one node communicate with the other node?
Hi there, I am trying to understand the underlying architecture of cassandra. How does one node communicate with other node? Does cassandra use Thrift or JMX to communicate with other node? Kind regards, Joshua. -- http://twitter.com/jpartogi
Re: dropping keyspace in cassandra
Hi Aaron, Does that mean the data will be deleted eventually? Does this also depends on the compaction configuration? Thanks. On Thu, Mar 3, 2011 at 7:23 AM, Aaron Morton aa...@thelastpickle.com wrote: What exactly was the folder that was left in place? Dropping a keyspace does not physically delete the data immediately. Aaron On 3/03/2011, at 1:01 AM, Sagar Kohli sagar.ko...@impetus.co.in wrote: Hi , I am using Cassandra .70, I have dropped a sample keyspace using command “drop keyspace sample” Command executed successfully but when I checked key space folder still exists there, Is there any other process to delete data from file system or Cassandra does it automatically?? Thanks in advance J ~sagar Impetus to Present Big Data -- Analytics Solutions and Strategies at TDWI World Conference (Feb 13-18) in Las Vegas.We are also bringing cloud experts together at CloudCamp, Delhi on Feb 12. CloudCamp is an unconference where early adopters of Cloud Computing technologies exchange ideas. Click http://www.impetus.com to know more. NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference. -- http://twitter.com/jpartogi
Re: Is it possible to get list of row keys?
Hi everyone, Thank you to everyone that have responded to my email. I really appreciate that. I am sorry for not making it clear in my original post that what I am looking for is the list of keys in the database assuming that the client application does not know the keys. From what I understand, RangeSliceQuery requires you to pass the startKey, which means the client application have to know beforehand the key that will be used as startkey. So, I am trying to do this in cassandra: select id from table_name; while RangeSliceQuery would be something like this in SQL (CMIIW), which is not what I want: select id from table_name where id between 100 and 1000; Please let me know whether what I am after is achievable in cassandra. Kind regards, Joshua. On Thu, Feb 24, 2011 at 12:47 AM, Ching-Cheng Chen cc...@evidentsoftware.com wrote: Actually, if you want to get ALL keys, I believe you can still use RangeSliceQuery with RP. Just use setKeys(,) as first batch call. Then use the last key from previous batch as startKey for next batch. Beware that since startKey is inclusive, so you'd need to ignore first key from now on. Keep going until you finish all batches. You will know you'd need to stop when setKeys(key_xyz,) return you only one key. This should get you all keys even with RP. Regards, Chen www.evidentsoftware.com On Wed, Feb 23, 2011 at 8:23 AM, Norman Maurer nor...@apache.org wrote: query per ranges is only possible with OPP or BPP. Bye, Norman 2011/2/23 Sasha Dolgy sdo...@gmail.com: What if i want 20 rows and the next 20 rows in a subsequent query? can this only be achieved with OPP? -- Sasha Dolgy sasha.do...@gmail.com On 23 Feb 2011 13:54, Ching-Cheng Chen cc...@evidentsoftware.com wrote: -- http://twitter.com/jpartogi
Re: Is it possible to get list of row keys?
Thanks Roshan, I think I understand now. The setRowCount() is in the Java Cassandra driver. I'll try to find the similar method in the Ruby API. Kind regards, Joshua On Thu, Feb 24, 2011 at 1:04 PM, Roshan Dawrani roshandawr...@gmail.com wrote: On Thu, Feb 24, 2011 at 6:54 AM, Joshua Partogi joshua.j...@gmail.com wrote: I am sorry for not making it clear in my original post that what I am looking for is the list of keys in the database assuming that the client application does not know the keys. From what I understand, RangeSliceQuery requires you to pass the startKey, which means the client application have to know beforehand the key that will be used as startkey. I think it was quite clear anyway that your client app does not know any specific keys, and you don't have to pass an existing key as the start / end key. You can pass start and end keys as empty values with setRowCount() left to default of 100 or another specific value that u want. After that first batch, you have to pick-up the last key of the batch and make that as the start key of the next batch query, and keep moving along like that (as described previously in this thread) -- Roshan Blog: http://roshandawrani.wordpress.com/ Twitter: @roshandawrani Skype: roshandawrani -- http://twitter.com/jpartogi
Can I get a range of not deleted rows?
Hi there. It seems that when I fetch a range of rows, cassandra also includes rows that has been deleted. Is it possible to only get rows that has not been deleted? Thanks for your help. Kind regards, Joshua. -- http://twitter.com/jpartogi
Re: Does Cassandra use vector clocks
NO it doesn't. Instead of using vector clock, it checks the column timestamps. On Wed, Feb 23, 2011 at 11:59 AM, tijoriwala.ritesh tijoriwala.rit...@gmail.com wrote: Hi, I searched online but couldn't get a detailed document on whether Cassandra uses vector clocks or not? If yes, how does it work. Any pointers to details will be appreciated. Thanks, Ritesh -- View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Does-Cassandra-use-vector-clocks-tp6054778p6054778.html Sent from the cassandra-u...@incubator.apache.org mailing list archive at Nabble.com. -- http://twitter.com/jpartogi
Is it possible to get list of row keys?
Hi, Assuming the application does not know the list of keys that is stored inside cassandra, how would it be possible to get list of row keys? This list of row keys is going to be used to get a range of slices. Thank you for your help. -- http://twitter.com/jpartogi
Re: simple erlang example
Hi, Would you like to share you use both database? Does this mean you have the same data in both database? Thanks for sharing. Kind regards, Joshua. On Sun, Feb 20, 2011 at 12:41 AM, J T jt4websi...@googlemail.com wrote: Hi Joshua, I can't speak for Sasha, but in my case I use both Riak and Cassandra since cassandra has ranges and build in secondary indexes whereas Riak does not. Actually I use others too as the different ones bring different qualities to the table. JT On Sat, Feb 19, 2011 at 7:18 AM, Joshua Partogi joshua.j...@gmail.com wrote: Is there any reason why you would be interested to use erlang with cassandra instead of other erlang based database [i.e Couchbase, Riak] ? I am interested to know the reason. Kind regards, Joshua On Sat, Feb 19, 2011 at 9:39 AM, Sasha Dolgy sdo...@gmail.com wrote: hi, does anyone have an erlang example for connecting to cassandra and performing an operation like a get? I'm not having much luck with: \thrift-0.5.0\test\erl\src\* as a reference point. I generated all of the erlang files using thrift and have successfully compiled them but am having a pretty rough go at it. Found this old post: http://www.mail-archive.com/cassandra-user@incubator.apache.org/msg02893.html ... but seems the examples never made it to the wiki. -sd -- Sasha Dolgy sasha.do...@gmail.com -- http://twitter.com/jpartogi -- http://twitter.com/jpartogi
Re: Replacing Redis
Any reason why you want to do that? On Sat, Feb 19, 2011 at 1:32 AM, Benson Margulies bimargul...@gmail.com wrote: I'm about to launch off on replacing redis with cassandra. I wonder if anyone else has ever been there and done that. -- http://twitter.com/jpartogi
Re: simple erlang example
Is there any reason why you would be interested to use erlang with cassandra instead of other erlang based database [i.e Couchbase, Riak] ? I am interested to know the reason. Kind regards, Joshua On Sat, Feb 19, 2011 at 9:39 AM, Sasha Dolgy sdo...@gmail.com wrote: hi, does anyone have an erlang example for connecting to cassandra and performing an operation like a get? I'm not having much luck with: \thrift-0.5.0\test\erl\src\* as a reference point. I generated all of the erlang files using thrift and have successfully compiled them but am having a pretty rough go at it. Found this old post: http://www.mail-archive.com/cassandra-user@incubator.apache.org/msg02893.html ... but seems the examples never made it to the wiki. -sd -- Sasha Dolgy sasha.do...@gmail.com -- http://twitter.com/jpartogi
Is Avro still supported?
Hi, I saw in the latest source in trunk, avro codes has been deleted. Does this mean Avro is not supported anymore? If so, what was the decision behind dropping the support for Avro? Thanks -- http://twitter.com/jpartogi
Why is it when I removed a row the RowKey is still there?
Hi, I am very puzzled with this. So I removed a row from the client, but when I query the data from CLI, the rowkey is still there: RowKey: 3 --- RowKey: 2 = (column=6e616d65, value=42696c6c, timestamp=1297338131027004) --- RowKey: 1 = (column=6e616d65, value=4a6f65, timestamp=1297420269035522) Did I do something wrong? What do I need to do in order to completely remove the entire row with its key. Thank you for the assistance. Kind regards, Joshua -- http://twitter.com/jpartogi
Re: cassandra memory is huge
Do you have loads of data? 1GB is quite reasonable knowing that 8GB is the recommended RAM size http://wiki.apache.org/cassandra/CassandraHardware Kind regards, Joshua. On Wed, Feb 9, 2011 at 10:48 AM, Blaze Dowis bdow...@aucklanduni.ac.nz wrote: Why is it that when I start cassandra, it is taking up to 1G of memory? and how can I lessen this? here is a small portion of the startup dump. -- http://twitter.com/jpartogi
Re: Ruby thrift is trying to write Time as string
Thanks Ryan. That makes more sense now. So I should instead find a way to (de)serialize Ruby objects to string vice versa when inserting to Column. Kind regards, Joshua On Tue, Feb 8, 2011 at 4:43 AM, Ryan King r...@twitter.com wrote: On Sat, Feb 5, 2011 at 10:12 PM, Joshua Partogi joshua.j...@gmail.com wrote: Hi, I don't know whether my assumption is right or not. When I tried to insert a Time value into a column I am getting this exception: vendor/ruby/1.8/gems/thrift-0.5.0/lib/thrift/protocol/binary_protocol.rb:106:in `write_string' vendor/ruby/1.8/gems/thrift-0.5.0/lib/thrift/client.rb:35:in `write' vendor/ruby/1.8/gems/thrift-0.5.0/lib/thrift/client.rb:35:in `send_message' vendor/ruby/1.8/gems/cassandra-0.9.0/lib/./vendor/0.7/gen-rb/cassandra.rb:213:in `send_batch_mutate' vendor/ruby/1.8/gems/cassandra-0.9.0/lib/./vendor/0.7/gen-rb/cassandra.rb:208:in `batch_mutate' vendor/ruby/1.8/gems/thrift_client-0.6.0/lib/thrift_client/abstract_thrift_client.rb:115:in `send' vendor/ruby/1.8/gems/thrift_client-0.6.0/lib/thrift_client/abstract_thrift_client.rb:115:in `handled_proxy' vendor/ruby/1.8/gems/thrift_client-0.6.0/lib/thrift_client/abstract_thrift_client.rb:57:in `batch_mutate' vendor/ruby/1.8/gems/cassandra-0.9.0/lib/cassandra/0.7/protocol.rb:8:in `_mutate' vendor/ruby/1.8/gems/cassandra-0.9.0/lib/cassandra/cassandra.rb:130:in `insert' But I am not getting any error if I insert a Time value into a sub-column. Is this an error or does it suppose to work that way? Thanks heaps for the insight. IIRC when we wrote that code the idea was to require strings for everything and have users do their own serialization. In that context, the supercolmn behavior is the wrong one here. -ryan -- @rk -- http://twitter.com/jpartogi
Ruby thrift is trying to write Time as string
Hi, I don't know whether my assumption is right or not. When I tried to insert a Time value into a column I am getting this exception: vendor/ruby/1.8/gems/thrift-0.5.0/lib/thrift/protocol/binary_protocol.rb:106:in `write_string' vendor/ruby/1.8/gems/thrift-0.5.0/lib/thrift/client.rb:35:in `write' vendor/ruby/1.8/gems/thrift-0.5.0/lib/thrift/client.rb:35:in `send_message' vendor/ruby/1.8/gems/cassandra-0.9.0/lib/./vendor/0.7/gen-rb/cassandra.rb:213:in `send_batch_mutate' vendor/ruby/1.8/gems/cassandra-0.9.0/lib/./vendor/0.7/gen-rb/cassandra.rb:208:in `batch_mutate' vendor/ruby/1.8/gems/thrift_client-0.6.0/lib/thrift_client/abstract_thrift_client.rb:115:in `send' vendor/ruby/1.8/gems/thrift_client-0.6.0/lib/thrift_client/abstract_thrift_client.rb:115:in `handled_proxy' vendor/ruby/1.8/gems/thrift_client-0.6.0/lib/thrift_client/abstract_thrift_client.rb:57:in `batch_mutate' vendor/ruby/1.8/gems/cassandra-0.9.0/lib/cassandra/0.7/protocol.rb:8:in `_mutate' vendor/ruby/1.8/gems/cassandra-0.9.0/lib/cassandra/cassandra.rb:130:in `insert' But I am not getting any error if I insert a Time value into a sub-column. Is this an error or does it suppose to work that way? Thanks heaps for the insight. Kind regards, Joshua. -- http://twitter.com/jpartogi
Re: Document Mapper for Ruby?
Thanks Ryan. This is what I am looking for. Let me try it out. On Fri, Jan 21, 2011 at 4:58 AM, Ryan King r...@twitter.com wrote: Not sure what you mean by document mapper, but CassandraObject might fit the bill: https://github.com/nzkoz/cassandra_object -ryan On Wed, Jan 19, 2011 at 11:03 PM, Joshua Partogi joshua.j...@gmail.com wrote: Hi all, Is anyone aware of a document mapper for Ruby similar to MongoMapper? Thanks heaps for your help. Kind regards, Joshua. -- http://twitter.com/jpartogi -- http://twitter.com/jpartogi
Document Mapper for Ruby?
Hi all, Is anyone aware of a document mapper for Ruby similar to MongoMapper? Thanks heaps for your help. Kind regards, Joshua. -- http://twitter.com/jpartogi http://twitter.com/scrum8
Is it possible to query using wildcards in cassandra 0.7?
Hi all, I really like the second index feature that has been added to 0.7 release. My question is, Is it possible to query using wildcards in cassandra 0.7? Thanks for the insights. Kind regards, Joshua. -- http://twitter.com/jpartogi http://twitter.com/scrum8
Re: How do you implement pagination?
So you're actually getting n+1 record? Correct? So this is the right way to do it? On Sat, Dec 11, 2010 at 1:02 PM, Tyler Hobbs ty...@riptano.com wrote: Yes, what you described is the correct way to do it. Your next slice will start with that 11th column. - Tyler On Fri, Dec 10, 2010 at 7:01 PM, Joshua Partogi joshua.j...@gmail.comwrote: Hi all, I am interested to see people's way to do record pagination with cassandra because I can not find anything like MySQL LIMIT in cassandra. From what I understand you need to tell cassandra the Record ID for the beginning of the slice and the number of record you want to get after that Record. I am using UUID instead of Long for the Record ID. My question is, how does your application get the next Record ID after the current slice that is displayed on the page? Let's say I want to display record 1-10, do I actually grab 11 records but only display 10 records and only keep the ID of the 11th records so I can use it for pagination? Sorry if the question is a bit obscured, but I am still figuring out how to do pagination. Thanks very much for your assistance. Kind regards, Joshua. -- http://twitter.com/jpartogi http://twitter.com/scrum8 -- http://twitter.com/jpartogi
Obscured question about data size in a Column Family
Hi there, Quoting an information in the wiki about Cassandra limitations ( http://wiki.apache.org/cassandra/CassandraLimitations): ... So all the data from a given columnfamily/key pair had to fit in memory, or 2GB ... Does this mean 1. A ColumnFamily can only be 2GB of data 2. A Column (key/pair) can only be 2GB of data Thanks for the explanation. -- http://twitter.com/jpartogi http://twitter.com/scrum8
Re: fauna/cassandra gem does not work with Cassandra 0.7
Hi Ryan, Thanks for the swift response. I've tested your latest commit and it fixed the problem. Kind regards, Joshua On Wed, Dec 8, 2010 at 5:23 AM, Ryan King r...@twitter.com wrote: Please file this on github issues: https://github.com/fauna/cassandra/issues. And I'll get to it soon. -ryan On Tue, Dec 7, 2010 at 2:21 AM, Joshua Partogi joshua.j...@gmail.com wrote: Hi, I pull out fauna/cassandra gem 0.10.0 from github. I then tried to get a value from cassandra as such. irb(main):002:0 require 'cassandra/0.7' = true irb(main):003:0 client = Cassandra.new('Keyspace1', '127.0.0.1:9160') = #Cassandra:70286805872140, @keyspace=Keyspace1, @schema={}, @servers=[127.0.0.1:9160] irb(main):004:0 client.insert(:Standard1, 5, {'screen_name' = buttonscat}) = nil irb(main):006:0 client.get(:Standard1, 5, 'screen_name') NoMethodError: undefined method `multiget' for #ThriftClient:0x7fd9d82e5270 from /home/jpartogi/.rvm/gems/ruby-1.8.7-p302/gems/cassandra-0.10.0/lib/cassandra/0.7/protocol.rb:53:in `_multiget' from /home/jpartogi/.rvm/gems/ruby-1.8.7-p302/gems/cassandra-0.10.0/lib/cassandra/cassandra.rb:198:in `multi_get' from /home/jpartogi/.rvm/gems/ruby-1.8.7-p302/gems/cassandra-0.10.0/lib/cassandra/cassandra.rb:189:in `get' from (irb):6 from :0 irb(main):007:0 It turns out that the gem is still relying on thrift 0.2.5 as can be seen on cassandra.rb. My question is, will the gem be updated to use thrift client 0.5? Sorry if this question does not fall in to the right place. Kind regards, Joshua -- http://twitter.com/jpartogi -- http://twitter.com/jpartogi
Re: fauna cassandra client 0.9.0
Nice. Thanks for the hardwork Ryan. Will try this out tonight. Cheers, Joshua. On Thu, Dec 9, 2010 at 8:44 AM, Ryan King r...@twitter.com wrote: I just pushed a 0.9.0 release of the fauna-cassandra ruby client. This is our first release that includes support for Cassandra 0.7 (currently supporting RC1 and not earlier 0.7 releases). code/download: https://rubygems.org/gems/cassandra git: http://github.com/fauna/cassandra File any bugs on github, please -ryan -- http://twitter.com/jpartogi http://twitter.com/scrum8
fauna/cassandra gem does not work with Cassandra 0.7
Hi, I pull out fauna/cassandra gem 0.10.0 from github. I then tried to get a value from cassandra as such. irb(main):002:0 require 'cassandra/0.7' = true irb(main):003:0 client = Cassandra.new('Keyspace1', '127.0.0.1:9160') = #Cassandra:70286805872140, @keyspace=Keyspace1, @schema={}, @servers=[127.0.0.1:9160] irb(main):004:0 client.insert(:Standard1, 5, {'screen_name' = buttonscat}) = nil irb(main):006:0 client.get(:Standard1, 5, 'screen_name') NoMethodError: undefined method `multiget' for #ThriftClient:0x7fd9d82e5270 from /home/jpartogi/.rvm/gems/ruby-1.8.7-p302/gems/cassandra-0.10.0/lib/cassandra/0.7/protocol.rb:53:in `_multiget' from /home/jpartogi/.rvm/gems/ruby-1.8.7-p302/gems/cassandra-0.10.0/lib/cassandra/cassandra.rb:198:in `multi_get' from /home/jpartogi/.rvm/gems/ruby-1.8.7-p302/gems/cassandra-0.10.0/lib/cassandra/cassandra.rb:189:in `get' from (irb):6 from :0 irb(main):007:0 It turns out that the gem is still relying on thrift 0.2.5 as can be seen on cassandra.rb. My question is, will the gem be updated to use thrift client 0.5? Sorry if this question does not fall in to the right place. Kind regards, Joshua -- http://twitter.com/jpartogi http://twitter.com/scrum8
Would it be possible to implement query language on top of Cassandra?
Hi, I am still new with cassandra and from what I know so far cassandra is based on Google BigTables model. And one thing that we can do with BigTable is query data using GQL. I tried looking for information about query language that is built on top of cassandra and ends with no luck. The only way we can query over data is either using Range query or Hadoop Map-Reduce. CMIIW. Now with range query, it would be less expressive than query language while with Hadoop Map-Reduce I have heard that it is not suitable for realtime data query. So is it possible to implement query language on top of Cassandra? Or is MapReduce and range query the only option we have? Thanks for the insights. -- http://twitter.com/jpartogi http://twitter.com/scrum8
Re: Set an index on column
Hi Jonathan, Thanks for the hint. I've tried it but it throws an error like this: [defa...@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 jbel...@gmail.com wrote: It's part of update column family: [defa...@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 jpart...@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: [defa...@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
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 jbel...@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 jpart...@scrum8.com wrote: Hi Jonathan, Thanks for the hint. I've tried it but it throws an error like this: [defa...@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 jbel...@gmail.com wrote: It's part of update column family: [defa...@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 jpart...@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: [defa...@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
Thanks for the confirmation. Cheers. On Sat, Dec 4, 2010 at 3:34 PM, Jonathan Ellis jbel...@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 jpart...@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 jbel...@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 jpart...@scrum8.com wrote: Hi Jonathan, Thanks for the hint. I've tried it but it throws an error like this: [defa...@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 jbel...@gmail.com wrote: It's part of update column family: [defa...@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 jpart...@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: [defa...@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
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: [defa...@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: Can not connect to cassandra 0.7 using CLI
Hi Eric, Thanks for the hint. I have found out that if there is an exception thrown, the thrift server won't be started. It is working fine now. Kind regards, joshua. On Fri, Dec 3, 2010 at 10:52 AM, Eric Evans eev...@rackspace.com wrote: On Thu, 2010-12-02 at 08:11 +1100, Joshua Partogi wrote: It is set to localhost I didn't change it and it is the same as configured in 0.6.8. Why doesn't it work out of the box? Thanks heaps. Try netstat -nl | grep 9160. Is the node listening on 9160? Which interface is it bound to? -- Eric Evans eev...@rackspace.com -- http://twitter.com/jpartogi
Can not connect to cassandra 0.7 using CLI
Hi there, I just downloaded cassandra 0.7rc1. I started it using bin/cassandra without making any configuration changes. I then tried to connect using the CLI with command like this: f...@ubuntu:~/Applications/apache-cassandra-0.7.0-rc1$ bin/cassandra-cli Welcome to cassandra CLI. Type 'help' or '?' for help. Type 'quit' or 'exit' to quit. [defa...@unknown] connect localhost/9160; Exception connecting to localhost/9160. Reason: Connection refused. Why am I getting connection refused? I didn't experience this with cassandra 0.6.8. Thank you in advance for your help. Kind regards, Joshua. -- http://twitter.com/jpartogi http://twitter.com/scrum8
Re: Can not connect to cassandra 0.7 using CLI
Hi Brayton. Thanks for the reply. It was running find on 0.6.8 on the same box. Kind regards, Joshua On Thu, Dec 2, 2010 at 1:05 AM, Brayton Thompson thomp...@grnoc.iu.eduwrote: All of the times I have had similar issues the problem has always been misconfigured iptables. You said it was running fine on 0.6.8 though? On the same box or a different box? On Dec 1, 2010, at 6:29 AM, Joshua Partogi wrote: Hi there, I just downloaded cassandra 0.7rc1. I started it using bin/cassandra without making any configuration changes. I then tried to connect using the CLI with command like this: f...@ubuntu:~/Applications/apache-cassandra-0.7.0-rc1$ bin/cassandra-cli Welcome to cassandra CLI. Type 'help' or '?' for help. Type 'quit' or 'exit' to quit. [defa...@unknown] connect localhost/9160; Exception connecting to localhost/9160. Reason: Connection refused. Why am I getting connection refused? I didn't experience this with cassandra 0.6.8. Thank you in advance for your help. Kind regards, Joshua. -- http://twitter.com/jpartogi http://twitter.com/scrum8 -- http://twitter.com/jpartogi
Re: Can not connect to cassandra 0.7 using CLI
It is set to localhost I didn't change it and it is the same as configured in 0.6.8. Why doesn't it work out of the box? Thanks heaps. On Thu, Dec 2, 2010 at 7:49 AM, Aaron Morton aa...@thelastpickle.comwrote: Take a look at your cassandra.yaml file at the rpc_address this is the address it's listening to connections on. The comments there should help, if you set it to 0.0.0.0 it will bind to all interfaces. Probably not what you want in production but handy for dev. Hope that helps. Aaron On 02 Dec, 2010,at 09:40 AM, Joshua Partogi jpart...@scrum8.com wrote: Hi Brayton. Thanks for the reply. It was running find on 0.6.8 on the same box. Kind regards, Joshua On Thu, Dec 2, 2010 at 1:05 AM, Brayton Thompson thomp...@grnoc.iu.eduwrote: All of the times I have had similar issues the problem has always been misconfigured iptables. You said it was running fine on 0.6.8 though? On the same box or a different box? On Dec 1, 2010, at 6:29 AM, Joshua Partogi wrote: Hi there, I just downloaded cassandra 0.7rc1. I started it using bin/cassandra without making any configuration changes. I then tried to connect using the CLI with command like this: f...@ubuntu:~/Applications/apache-cassandra-0.7.0-rc1$ bin/cassandra-cli Welcome to cassandra CLI. Type 'help' or '?' for help. Type 'quit' or 'exit' to quit. [defa...@unknown] connect localhost/9160; Exception connecting to localhost/9160. Reason: Connection refused. Why am I getting connection refused? I didn't experience this with cassandra 0.6.8. Thank you in advance for your help. Kind regards, Joshua. -- http://twitter.com/jpartogi http://twitter.com/scrum8 -- http://twitter.com/jpartogi -- http://twitter.com/jpartogi