Two things about get_count API

2010-08-31 Thread Dop Sun
Hi, Two things about get_count API: 1) In the http://wiki.apache.org/cassandra/API, there is only one get_count method there: i32 get_count(string keyspace, string key, ColumnParent column_parent, ConsistencyLevel consistency_level) But as per the Thrift Client API, it looks like t

RE: Using Pelops with Cassandra 0.7.X

2010-07-14 Thread Dop Sun
Hector will released one along with 0.7, or there are any beta or alpha before official release of 0.7? I’m planning to update my client to work with Cassandra 0.7 trunk now, and I have a dependency on your library. J Dop From: Ran Tavory [mailto:ran...@gmail.com] Sent: Wednesday, Ju

RE: Is anyone using version 0.7 schema update API

2010-07-11 Thread Dop Sun
seems to be the wrong way. If you have something that works that will put me on the right track I hope. Gavan On Mon, Jul 12, 2010 at 2:41 AM, Dop Sun wrote: Based on current source codes in the head, moving from 0.6.x to 0.7, means some code changes in the client side (other than

RE: Is anyone using version 0.7 schema update API

2010-07-11 Thread Dop Sun
Based on current source codes in the head, moving from 0.6.x to 0.7, means some code changes in the client side (other than server side changes, like storage_conf.xml). Something like: 1. New Clock class instead of timestamp: this may be trivia, but it takes some time to change 2.

RE: Guava vs. Google-collections

2010-07-03 Thread Dop Sun
Cool. Thanks. -Original Message- From: Eric Evans [mailto:eev...@rackspace.com] Sent: Sunday, July 04, 2010 12:07 AM To: user@cassandra.apache.org Subject: Re: Guava vs. Google-collections On Sat, 2010-07-03 at 23:05 +0800, Dop Sun wrote: > Cassandra has dependencies on Goo

Guava vs. Google-collections

2010-07-03 Thread Dop Sun
Hi, Cassandra has dependencies on Google-collections, and as stated in the Google-collections official site, it has been deprecated, and replaced by its super set Guava. Is there any plan to replace the dependencies from Google-collections to guava? Here are some lines from Google-colle

RE: error in I/O Console updater

2010-07-03 Thread Dop Sun
>From your log, you are using Eclipse/ Equinox, and it's because one of the .so file cannot be found in the path specified by java.library.path, Maybe check the settings. Looks it's not related with the Cassandra or Hector. Try to find out whether the java.library.path has been set properly?

RE: About Remove API

2010-06-26 Thread Dop Sun
Aha, I believe it's explained here: http://spyced.blogspot.com/2010/02/distributed-deletes-in-cassandra.html Thanks, Regards, Dop From: Dop Sun [mailto:su...@dopsun.com] Sent: Sunday, June 27, 2010 6:56 AM To: user@cassandra.apache.org Subject: About Remove API Hi,

About Remove API

2010-06-26 Thread Dop Sun
Hi, I was reminded that there is a Remove API, which can delete the whole rows by specifying the timestamp, key, and column family (in this case, super_column or column are optional). But I found, even I delete all rows for the specified keys with this method, the get_range_slices API will

RE: read operation is slow

2010-06-15 Thread Dop Sun
, 2010 at 6:05 PM, Dop Sun wrote: And also, you are only select 1 key and 10 columns? criteria.keyList(Lists.newArrayList(userName)).columnRange(nameFirst, nameFirst, 10); Then, if you have 200k keys, you have 200k Thrift calls. If this is the case, you may need to optimize the way you do

RE: Pelops - a new Java client library paradigm

2010-06-14 Thread Dop Sun
Good to have new API wrappers. I guess different APIs because people look Cassandra from different angle with different backgrounds/ skills. At this stage, it's better that different API find the good ideas from each other, and maybe one day, there is one, which widely accepted. That's good for al

RE: read operation is slow

2010-06-11 Thread Dop Sun
keys into a single query), and to reduce the number of calls. From: Dop Sun [mailto:su...@dopsun.com] Sent: Saturday, June 12, 2010 8:57 AM To: user@cassandra.apache.org Subject: RE: read operation is slow You mean after you "I remove some unnecessary column family and change the si

RE: read operation is slow

2010-06-11 Thread Dop Sun
: Saturday, June 12, 2010 8:48 AM To: user@cassandra.apache.org Subject: Re: read operation is slow Hi, do you mean this one should not introduce much extra delay? To read a record, I need select here, not sure where the extra delay comes from. On Fri, Jun 11, 2010 at 5:29 PM, Dop Sun wrote: Ja

RE: read operation is slow

2010-06-11 Thread Dop Sun
Jassandra is used here: Map> map = criteria.select(); The select here basically is a call to Thrift API: get_range_slices From: Caribbean410 [mailto:caribbean...@gmail.com] Sent: Saturday, June 12, 2010 8:00 AM To: user@cassandra.apache.org Subject: Re: read operation is slow I

RE: keyrange for get_range_slices

2010-06-10 Thread Dop Sun
asily turn into a "dump the entire datastore" if you aren't careful. On Jun 10, 2010, at 10:03 AM, Dop Sun wrote: Hi, As documented in the http://wiki.apache.org/cassandra/API, the key range for get_range_slices are both inclusive. As discussed in this thread: http

keyrange for get_range_slices

2010-06-10 Thread Dop Sun
Hi, As documented in the http://wiki.apache.org/cassandra/API, the key range for get_range_slices are both inclusive. As discussed in this thread: http://groups.google.com/group/jassandra-user/browse_thread/thread/c2e56453c de067d3, there is a case that user want to discover all keys (huge

RE: Moving/copying columns in between ColumnFamilies

2010-05-26 Thread Dop Sun
really meant was, moving or copying the ROWS defined by a KeyRange in between ColumnFamilies. Do you think it's doable with an efficient way? On Wed, May 26, 2010 at 3:14 PM, Dop Sun wrote: There are no single API call to achieve this. It’s read and write, plus a delete (if move) API ca

RE: Moving/copying columns in between ColumnFamilies

2010-05-26 Thread Dop Sun
There are no single API call to achieve this. It’s read and write, plus a delete (if move) API calls I guess. From: Utku Can Topçu [mailto:u...@topcu.gen.tr] Sent: Wednesday, May 26, 2010 9:09 PM To: user@cassandra.apache.org Subject: Moving/copying columns in between ColumnFamilies He

RE: Hector vs cassandra-java-client

2010-05-25 Thread Dop Sun
edit) On Tue, May 25, 2010 at 2:12 AM, Dop Sun wrote: > A good chance to introduce my http://code.google.com/p/jassandra/ > > > > J > > > > Another Java client, and well, it cannot be found with Cassandra java client > keywords. K > > > > From: Ran Tavory

RE: Hector vs cassandra-java-client

2010-05-25 Thread Dop Sun
A good chance to introduce my http://code.google.com/p/jassandra/ J Another Java client, and well, it cannot be found with Cassandra java client keywords. K From: Ran Tavory [mailto:ran...@gmail.com] Sent: Tuesday, May 25, 2010 2:52 PM To: user@cassandra.apache.org Subject: Re: Hector

RE: long type

2010-05-22 Thread Dop Sun
Then what kink of column name should I use? 2010/5/23 Dop Sun CompareWith defines type for column name/ super column name, and at the moment, key should be always String. From: huajun qi [mailto:qih...@gmail.com] Sent: Saturday, May 22, 2010 10:19 PM To: user@cassandra.apache.org Subject

RE: long type

2010-05-22 Thread Dop Sun
CompareWith defines type for column name/ super column name, and at the moment, key should be always String. From: huajun qi [mailto:qih...@gmail.com] Sent: Saturday, May 22, 2010 10:19 PM To: user@cassandra.apache.org Subject: long type I set the "CompareWith" property to "longtype", but

RE: How to initialize the Cassandra

2010-05-06 Thread Dop Sun
utate. If Cassandra CPU is your bottleneck then using the binary load method from StorageProxy can help (see contrib/bmt_example). If Casssandra disk or network is your bottleneck then binary load won't really help. On Thu, May 6, 2010 at 7:51 AM, Dop Sun wrote: > Hi, > > > &

How to initialize the Cassandra

2010-05-06 Thread Dop Sun
Hi, I just discovered that the json file exported by sstable2json contains more than the data itself, like deletedAt values. I'm thinking whether there is a tool can import some initial data? When we are doing the typical RDBMS system, this is how we are doing: 1) Define the sche

RE: sstable2jason bat script on windows

2010-05-05 Thread Dop Sun
n bat script on windows can you create a ticket at https://issues.apache.org/jira/browse/CASSANDRA and attach your .bat files? On Wed, May 5, 2010 at 8:32 AM, Dop Sun wrote: > Thanks for your reply. > > Since I need to import several hundred lines of data into my laptop instance > (singe

RE: sstable2jason bat script on windows

2010-05-05 Thread Dop Sun
files yet. On Tue, May 4, 2010 at 6:29 PM, Dop Sun wrote: > Hi, > > > > As of 0.6.1, I don't find sstable2jason.bat. I don't know if I missed > anything? > > > > It will good if we can have one, which can help import/ export data in/ out > deve

sstable2jason bat script on windows

2010-05-04 Thread Dop Sun
Hi, As of 0.6.1, I don't find sstable2jason.bat. I don't know if I missed anything? It will good if we can have one, which can help import/ export data in/ out development machine. Thanks, Regards, Dop

RE: What's the best maximum size for a single column?

2010-04-29 Thread Dop Sun
? Regards, Michael On Wed, Apr 28, 2010 at 7:37 AM, Dop Sun wrote: Hi, Yesterday, I saw a lot of discussion about how to store a file (big one). It looks like the suggestion is store in multiple rows (even not multiple column in a single row). My question is: Is there any best maximum c

RE: Long Time relational Database Programmer needing help

2010-04-28 Thread Dop Sun
Hi, Here are some links I collected: 1. http://wiki.apache.org/cassandra/CassandraCli: this is how bring it up and run 2. http://arin.me/blog/wtf-is-a-supercolumn-cassandra-data-model is very good to start to understand the schema 3. http://codeqm.blogspot.com/2010/03/jav

What's the best maximum size for a single column?

2010-04-28 Thread Dop Sun
Hi, Yesterday, I saw a lot of discussion about how to store a file (big one). It looks like the suggestion is store in multiple rows (even not multiple column in a single row). My question is: Is there any best maximum column size which can help to make the decision on the segment size? Is

RE: lazyboy - batch insert

2010-04-23 Thread Dop Sun
http://code.google.com/p/jassandra/source/browse/trunk/org.softao.jassandra/ src/org/softao/jassandra/thrift/ThriftColumnFamily.java Insert and Delete method of this class are using batch_mutation. Cheers. Dop From: Lubos Pusty [mailto:lubospu...@gmail.com] Sent: Friday, April 23, 2010 9

RE: Cassandra Java Client

2010-04-20 Thread Dop Sun
like other ppl have done with ORM layers on top of it. Hector's main features include extensive jmx counters, failover and connection pooling. It's available for all recent versions, including 0.5.0, 0.5.1, 0.6.0 and 0.6.1 On Mon, Apr 19, 2010 at 5:58 PM, Dop Sun wrote: Well, there

RE: Cassandra Java Client

2010-04-19 Thread Dop Sun
ppl have done with ORM layers on top of it. Hector's main features include extensive jmx counters, failover and connection pooling. It's available for all recent versions, including 0.5.0, 0.5.1, 0.6.0 and 0.6.1 On Mon, Apr 19, 2010 at 5:58 PM, Dop Sun wrote: Well, there are couple

RE: Cassandra Java Client

2010-04-19 Thread Dop Sun
rget to close the connection. connection.close(); } } -Original Message- From: Jonathan Ellis [mailto:jbel...@gmail.com] Sent: Monday, April 19, 2010 10:35 PM To: user@cassandra.apache.org Subject: Re: Cassandra Java Client How is Jassandra different from http://github.com/ranta

RE: Cassandra Java Client

2010-04-19 Thread Dop Sun
May I take this chance to share this link here: http://code.google.com/p/jassandra/ It currently based with Cassandra 0.6 Thrift APIs. The class ThriftCriteria and ThriftColumnFamily has direct use of Thrift API. Also, the site itself has test code, which is actually works on Jassandra abs

RE: FW: Is there any way to enable the multiple super column names at a time?

2010-04-12 Thread Dop Sun
and finish is for the standard columns Thanks for all your help. Appreciated! Dop -Original Message----- From: Dop Sun [mailto:su...@dopsun.com] Sent: Monday, April 12, 2010 9:44 PM To: user@cassandra.apache.org Subject: RE: FW: Is there any way to enable the multiple super column names

RE: FW: Is there any way to enable the multiple super column names at a time?

2010-04-12 Thread Dop Sun
uper1. Regards, Dop -Original Message- From: Dop Sun [mailto:su...@dopsun.com] Sent: Monday, April 12, 2010 9:03 PM To: user@cassandra.apache.org Subject: RE: FW: Is there any way to enable the multiple super column names at a time? Thanks for your quick reply. Actually, I tried to lea

RE: FW: Is there any way to enable the multiple super column names at a time?

2010-04-12 Thread Dop Sun
mn parameter to ColumnParent is optional precisely so you can do this. http://wiki.apache.org/cassandra/API On Mon, Apr 12, 2010 at 6:37 AM, Dop Sun wrote: > I guess I'm putting in the wrong email list. Sorry for this. > > My question in short is: whether I can get a certain range of sup

FW: Is there any way to enable the multiple super column names at a time?

2010-04-12 Thread Dop Sun
_parent as parameter, means a single CF + SC multiget_slice: contains column_parent as parameter, means a single CF + SC get_range_slices: contains column_parent as parameter, means a single CF + SC Regards, Dop -Original Message----- From: Dop Sun [mailto:su...@dopsun.com] Sent: Monday, April 12, 20

RE: Two dimensional matrices

2010-04-11 Thread Dop Sun
I don't know whether I'm wrong or not (I'm also new to Cassandra). But looks like we only can query a single Super Column at a single query since these values are specified in the ColumnParent parameter. Which means that you only can query a single week or month (as your super column). From: Ph

RE: How to perform queries on Cassandra?

2010-04-11 Thread Dop Sun
...@gmail.com] Sent: Sunday, April 11, 2010 9:12 PM To: user@cassandra.apache.org Subject: Re: How to perform queries on Cassandra? How to handle same usernames. Otherwise seems fine to me. On Sun, Apr 11, 2010 at 6:17 PM, Dop Sun wrote: Hi, As far as I can see it, the Cassandra API currently

RE: How to perform queries on Cassandra?

2010-04-11 Thread Dop Sun
Hi, As far as I can see it, the Cassandra API currently supports criterias on: Token – Key – Super Column Name (if applicable) - Column Names I guess Token is not usually used for the day to day queries, so, Key and Column Names are normally used for querying. For the user name and passwo

RE: How many KeySpace will you use in a single application?

2010-04-10 Thread Dop Sun
whoss can be lost (some non critical logs?), then a dedicated keyspace with a smaller replication factor can be a good thing. Kind regards, Benoit. 2010/4/10 Dop Sun : > Hi, a question troubles me now: how many KeySpaces one application is better > to use? > > > > The question i

RE: How many KeySpace will you use in a single application?

2010-04-10 Thread Dop Sun
things. On Fri, Apr 9, 2010 at 11:17 PM, Dop Sun wrote: > Hi, a question troubles me now: how many KeySpaces one application is better > to use? > > > > The question is coming out since 0.6, Cassandra introduced a new API named > as “login”, which is done against a specific ke

How many KeySpace will you use in a single application?

2010-04-09 Thread Dop Sun
Hi, a question troubles me now: how many KeySpaces one application is better to use? The question is coming out since 0.6, Cassandra introduced a new API named as "login", which is done against a specific keySpace. Thanks to the org.apache.cassandra.auth.AllowAllAuthenticator, the old version c