Cassandra JDBC

2011-11-16 Thread Jone Lura
Hi, I downloaded the cassandra-jdbc and built with maven. And when I am trying to use it in my application I get an exception on the following code: java.sql.Connection conn = DriverManager.getConnection(jdbc:cassandra://localhost:9160/MyKeyspace); java.lang.IncompatibleClassChangeError:

Re: memory problems still post- CASSANDRA-3492

2011-11-16 Thread Radim Kolar
Dne 15.11.2011 22:04, Mick Semb Wever napsal(a): But another node (on the same machine but different cluster), even after an upgrade to the staging 1.0.3 and a `nodetool scrub`, always soaks all available memory (up to and plateau at 30G). In fact no cf there use compression anymore. I had

Re: Cassandra JDBC

2011-11-16 Thread Nilabja Banerjee
Try this it should work.. import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class InsertData { public static void main(String[] args) throws ClassNotFoundException, SQLException{

Re: Fast lookups for userId to username and vice versa

2011-11-16 Thread Konstantin Naryshkin
Or just have two column families to do it: A CF idToName that has the userIds as keys and the userName as the only column and a CF nameToId that has the userNames as keys and the userId as the only column On Mon, Nov 14, 2011 at 03:50, chovatia jaydeep chovatia_jayd...@yahoo.co.in wrote: Check

Re: Fast lookups for userId to username and vice versa

2011-11-16 Thread Boris Yen
I think secondary index could do the trick. However, if you need to provide the pagination function, I will go for Konstantin's solution. On Wed, Nov 16, 2011 at 10:27 PM, Konstantin Naryshkin konstant...@a-bb.net wrote: Or just have two column families to do it: A CF idToName that has the

CQL and subcolumns

2011-11-16 Thread Jone Lura
Hi, I am trying to find out how to use CQL to be able to use cassandra-jdbc in my application, and I have some questions. I have tried to find the answers int the documentation of Cassandra Query Language (CQL) v2.0, but I did not find the answers to my following questions. How do I create a

Thanks for CQL

2011-11-16 Thread Peter Lin
I just wanted to say thanks to the entire Cassandra Team and Hector client team for CQL. I've been using it this week and it makes life easier. At first I had mixed feelings on CQL, but after using it the last few days, the user friendly factor makes a huge difference. peter

Re: Thanks for CQL

2011-11-16 Thread Cass Costello
+1 Sent from my iPhone On Nov 16, 2011, at 8:09 AM, Peter Lin wool...@gmail.com wrote: I just wanted to say thanks to the entire Cassandra Team and Hector client team for CQL. I've been using it this week and it makes life easier. At first I had mixed feelings on CQL, but after using it

sstableloader issue

2011-11-16 Thread mike.li
Hello , I need to load an external SSTABLEs to a cluster with 4 nodes. So I shutdown one of the node , and created a separate folder on this node as a temporary staging place for the external sstables, and run the sstableloader command like: ./bin/sstableloader /cassandra/bulk_load/Timeseries

Re: BulkLoader

2011-11-16 Thread Brandon Williams
On Mon, Nov 14, 2011 at 2:49 PM, Giannis Neokleous gian...@generalsentiment.com wrote: Hello everyone, We're using the bulk loader to load data every day to Cassandra. The machines that use the bulkloader are diferent every day so their IP addresses change. When I do describe cluster i see

Efficiency of Cross Data Center Replication...?

2011-11-16 Thread Brian Fleming
Hi All, I have a question about inter-data centre replication : if you have 2 Data Centers, each with a local RF of 2 (i.e. total RF of 4) and write to a node in DC1, how efficient is the replication to DC2 - i.e. is that data : - replicated over to a single node in DC2 once and internally

Re: Efficiency of Cross Data Center Replication...?

2011-11-16 Thread Sylvain Lebresne
To be complete, https://issues.apache.org/jira/browse/CASSANDRA-3472 is relevant. -- Sylvain On Wed, Nov 16, 2011 at 9:40 PM, Jake Luciani jak...@gmail.com wrote: the former On Wed, Nov 16, 2011 at 3:33 PM, Brian Fleming bigbrianflem...@gmail.com wrote: Hi All, I have a question about

Re: Efficiency of Cross Data Center Replication...?

2011-11-16 Thread Brian Fleming
Great - thanks Jake B. On Wed, Nov 16, 2011 at 8:40 PM, Jake Luciani jak...@gmail.com wrote: the former On Wed, Nov 16, 2011 at 3:33 PM, Brian Fleming bigbrianflem...@gmail.comwrote: Hi All, I have a question about inter-data centre replication : if you have 2 Data Centers, each

Re: Efficiency of Cross Data Center Replication...?

2011-11-16 Thread ehers...@gmail.com
On a related note - assuming there are available resources across the board (cpu and memory on every node, low network latency, non-saturated nics/circuits/disks), what's a reasonable expectation for timing on replication? Sub-second? Less than five seconds? Ernie On Wed, Nov 16, 2011 at 4:00

Re: Seeking advice on Schema and Caching

2011-11-16 Thread Aditya
Thanks to samal who pointed to look at the composite columns. I am now using composite columns names containing username+userId valueless column. Thus column names are now unique even for users with same name as userId is also attached to the same composite col name. Thus the supercolumn issue is

Re: Network traffic patterns

2011-11-16 Thread Todd Burruss
Are all of your machines equal hardware? Since those machines are sending data somewhere, maybe they are behind in replicating and are continuously catching up? Use a tool like tcpdump to find out where the data is going From: Philippe watche...@gmail.commailto:watche...@gmail.com Reply-To:

Re: Efficiency of Cross Data Center Replication...?

2011-11-16 Thread Jeremiah Jordan
Pretty sure data is sent to the coordinating node in DC2 at the same time it is sent to replicas in DC1, so I would think 10's of milliseconds after the transport time to DC2. On Nov 16, 2011, at 3:48 PM, ehers...@gmail.com wrote: On a related note - assuming there are available resources

Re: Seeking advice on Schema and Caching

2011-11-16 Thread samal
Edanuff + Beautiful People I think row cache could be the best fit but it can take resource depending on row size. It will only touch disk once (first time) in case of SST, rest of the req for that row will be served from memory. Try increasing row cache size and decreasing save period to

Re: Seeking advice on Schema and Caching

2011-11-16 Thread Aditya
On Thu, Nov 17, 2011 at 10:25 AM, samal samalgo...@gmail.com wrote: Edanuff + Beautiful People I think row cache could be the best fit but it can take resource depending on row size. It will only touch disk once (first time) in case of SST, rest of the req for that row will be served from

About compile YCSB with Cassandra 1.02

2011-11-16 Thread Matsumoto, Miki | DU
Hi, I want to have performance measurement of Cassandra 1.02 using YCSB. But YCSB only supports Cassandra 0.7. If someone have knowledge about how to compile Cassandra 1.02 with YCSB or tips, could please share it with me? Thank you very much. Regards Miki

mmap I/O and shared memory

2011-11-16 Thread Jaesung Lee
I am running 7 nodes cassandra(v1.0.2) cluster. I am putting 20K rows per sec to the cluster. This cluster has 1 KS, 3CFs. Each CF has 4-5 secondary indices. After I'v run for 1 week, nodes use swap memory. I changed disk-access-mode to index_only or standard. I got strange memory results.

Dropped request...

2011-11-16 Thread Jeesoo Shin
Hello. I'm using cassandra 0.8.6 with nodetool tpstats, dropped statistics are shown. when drop happens... what can I do? are there ways to turn on debug messages or to look into? thanks.