Re: Counter Column

2014-12-27 Thread Ajay
Thanks. I went through some articles which mentioned that the client to pass the timestamp for insert and update. Is that anyway we can avoid it and Cassandra assume the current time of the server? Thanks Ajay On Dec 26, 2014 10:50 PM, Eric Stevens migh...@gmail.com wrote: Timestamps are

Re: any code to load large data from web into Cassandra

2014-12-27 Thread Jack Krupansky
Sorry, but you are still not being clear. In particular, website data has no common, defined meaning. You'll need to use some standard, defined terminology or specific examples so that we can have some idea what you are referring to. The blog post you cited is referring to the Twitter API,

Re: Counter Column

2014-12-27 Thread Phil Yang
In java, http://docs.oracle.com/javase/7/docs/api/java/lang/System.html#currentTimeMillis() return the difference, measured in milliseconds, between the current time and midnight, January 1, 1970 UTC. It means the timestamp which Cassandra uses is not independent on the timezone. 2014-12-27 21:08

Re: Counter Column

2014-12-27 Thread Phil Yang
sorry for typo.. timestamp which Cassandra uses is independent on the timezone. Usually, it is recommended to use NTP to reduce the difference of timestamps in each nodes 2014-12-27 21:20 GMT+08:00 Phil Yang ud1...@gmail.com: In java,

Re: any code to load large data from web into Cassandra

2014-12-27 Thread Keith Sterling
Check out this datastax article http://www.datastax.com/documentation/cassandra/2.0/cassandra/tools/toolsBulkloader_t.html And code examples can be found here https://github.com/PatrickCallaghan/datastax-bulkloader-writer-example You can write a writer in scala or Java which will

Re: Counter Column

2014-12-27 Thread Eric Stevens
Having the client pass the timestamp is optional, if you do not provide one from the client, then it will use the server's timestamp. On Sat, Dec 27, 2014, 6:25 AM Phil Yang ud1...@gmail.com wrote: sorry for typo.. timestamp which Cassandra uses is independent on the timezone. Usually, it is

Re: any code to load large data from web into Cassandra

2014-12-27 Thread Eric Stevens
I think Joanne is taking not about bulk loading, but about just general access as in any standard client driver. Joanne, this is a pretty broad topic. You would need to have some part of a website built in some language such as Python or Java or some other language. Then you would use an

RE: Why read row is so slower than read column.

2014-12-27 Thread Andreas Finke
Hi, I would recommend to turn tracing on in CQL. Using this you can find out that part of the query results in high latency. http://www.datastax.com/documentation/cql/3.0/cql/cql_reference/tracing_r.html Regards Andi From: yhq...@sina.com [yhq...@sina.com]

Best practice for sorting on frequent updated column?

2014-12-27 Thread ziju feng
I need to sort data on a frequent updated column, such as like count of an item. The common way of getting data sorted in Cassandra is to have the column to be sorted on as clustering key. However, whenever such column is updated, we need to delete the row of old value and insert the new one,

Re: Re: Why read row is so slower than read column.

2014-12-27 Thread Eric Stevens
Can you send us your exact data model? Even though you normally use Thrift, you may also be able to access the data from CQL, and if so, query tracing is a very powerful feature in CQL which may describe why there is a performance difference. Do you do deletes of data? If so, tombstones really