Re: newbie question: how do I know the total number of rows of a cf?

Not all NoSQL is like that. Or perhaps the term NoSQL has became vague these days. On Mon, Mar 28, 2011 at 6:16 PM, Stephen Connolly wrote: > iterate. > > otherwise if that will be too slow and you will do it often, the nosql way > is to create a separate column family updated with each row add/d

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 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 fe

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 wrote: > What exactly was the folder that was left in place? Dropping a keyspace does > not physically delete the data immed

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 wrote: > On Thu, Feb 24, 2011 at 6:54 AM, Joshua Partogi > wrote:

Re: Is it possible to get list of row keys?

Hi Buddha system It is updated. Kind regards, Joshua. On Thu, Feb 24, 2011 at 12:41 PM, buddhasystem wrote: > > Is your data updated or large chunks are read-only? > -- > View this message in context: > http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/Is-it-possible-to-get-list

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, R

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: 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 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 de

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: simple erlang example

andra 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 > wrote: >> >> Is there an

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 wrote: > hi, > does anyone have an erlang example for

Re: Replacing Redis

Any reason why you want to do that? On Sat, Feb 19, 2011 at 1:32 AM, Benson Margulies 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

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=4a6f

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 wrote: > Why is it that when I start cassandra, it is taking up to 1G of memory? a

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 wrote: > On Sat, Feb 5, 2011 at 10:12 PM, Joshua Partogi > wrote:

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

Re: Document Mapper for Ruby?

, 2011 at 11:03 PM, Joshua Partogi > 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

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

Re: How do you implement pagination?

i, Dec 10, 2010 at 7:01 PM, Joshua Partogi wrote: > >> 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 ca

How do you implement pagination?

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 Rec

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

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 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

Re: fauna/cassandra gem does not work with Cassandra 0.7

> > -ryan > > On Tue, Dec 7, 2010 at 2:21 AM, Joshua Partogi > 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 '

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') => # irb(main):004:0> client.insert(:Standard1, "5", {'screen_name' =

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

Re: Set an index on column

gt; On Fri, Dec 3, 2010 at 6:44 PM, Tyler Hobbs 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 >

Re: Set an index on column

r" means "there's an error in the server log" > > On Fri, Dec 3, 2010 at 2:47 AM, Joshua Partogi > wrote: > > Hi Jonathan, > > > > Thanks for the hint. I've tried it but it throws an error like this: > > > > [defa...@keyspace1] updat

Re: Set an index on column

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.'; > &

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 wrote: > On Thu, 2010-12-02 at 08:11 +1100, Joshua Partogi wrote: > >

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 enou

Re: Can not connect to cassandra 0.7 using CLI

t'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 wrote: > &

Re: Can not connect to cassandra 0.7 using CLI

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

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' o