Re: Slow Reads

2011-07-27 Thread CASSANDRA learner
R u using hector client for java On Tue, Jul 26, 2011 at 11:17 PM, Priyanka wrote: > this is how my data looks > “rowkey1”:{ >“supercol1”:{ “col1”:T,”col2”:C} >“supercol2”:{“col1”:C,”col2”:T } >“supercol3”:{ “col1”:C,”col2”:T} >} > "rowkey2”:{

Is Cassandra Secured

2011-07-27 Thread CASSANDRA learner
Hi, My Question is regarding security. The data will be written in the disks in strings right! then how come the data is secured, Is it not secured ???

Can we store java objects and images/files in cassandra

2011-07-27 Thread CASSANDRA learner
Hi, Can we store images , java objects, files in cassandra, if so , how Please let me know this as i need it urgently...

Read process

2011-07-27 Thread CASSANDRA learner
Hi, I am having one doubt regarding reads. The data will be stored in commitlog,memtable,sstables right.. While reading the data may be available in all the three right, then from where the reads happens,, form commit log? or from Memtable ? or from SSTables.. Please explain friends Thnks

Re: Can we store java objects and images/files in cassandra

2011-07-27 Thread Oliver Dungey
You can store anything you like in Cassandra. The type of data is not relevant as there are no types in Cassandra, they all get stored as byte arrays. The only relevant limit is a column value cannot exceed 2GB (see http://wiki.apache.org/cassandra/CassandraLimitations). In terms of how: you just

Re: Is Cassandra Secured

2011-07-27 Thread Oliver Dungey
Out of the box there is no security turned on but there are a number of options: http://wiki.apache.org/cassandra/StorageConfiguration, http://wiki.apache.org/cassandra/ExtensibleAuth If you are worried about storing data in clear text then you should encrypt it before storage.

Re: Recovering from a multi-node cluster failure caused by OOM on repairs

2011-07-27 Thread Maki Watanabe
This kind of information is very helpful. Thank you to share your experience. maki 2011/7/27 Teijo Holzer : > Hi, > > I thought I share the following with this mailing list as a number of other > users seem to have had similar problems. > > We have the following set-up: > > OS: CentOS 5.5 > RAM:

Too many open files

2011-07-27 Thread Donna Li
All: What does the following error mean? One of my cassandra servers print this error, and nodetool shows the state of the server is down. Netstat result shows the socket number is very few. WARN [main] 2011-07-27 16:14:04,872 CustomTThreadPoolServer.java (line 104) Transport error occurred du

Re: Can we store java objects and images/files in cassandra

2011-07-27 Thread CASSANDRA learner
Thanks for the response Oliver, Can you please let me know where can i find an example for storing images and files. I could not able to find one in tht link. Please let me know On Wed, Jul 27, 2011 at 1:48 PM, Oliver Dungey wrote: > You can store anything you like in Cassandra. The type of data

Re: Cassandra 0.7.8 and 0.8.1 fail when major compaction on 37GB database

2011-07-27 Thread lebron james
I zip last version of cassandra with yaml file and 37gb database, can anybody download and do major compaction to check what is wrong? and why cassandra fall in outofmemory exception. Tanks! here is link to download http://213.186.117.181/apache-cassandra-0.8.2-bin.zip

Re: Slow Reads

2011-07-27 Thread Priyanka Ganuthula
Yes am using hector for java On Wed, Jul 27, 2011 at 3:35 AM, CASSANDRA learner < cassandralear...@gmail.com> wrote: > R u using hector client for java > > > On Tue, Jul 26, 2011 at 11:17 PM, Priyanka wrote: > >> this is how my data looks >> “rowkey1”:{ >>“supercol1”:{ “col1”:T,”col2

Re: Too many open files

2011-07-27 Thread Peter Schuller
> What does the following error mean? One of my cassandra servers print this > error, and nodetool shows the state of the server is down. Netstat result > shows the socket number is very few. The operating system enforced limits have been hit, so Cassandra is unable to create additional file descr

Re: Cassandra 0.7.8 and 0.8.1 fail when major compaction on 37GB database

2011-07-27 Thread lebron james
Why when i give jvm 1 GB heap size and try launch cassandra with 37GB database, cassandra start loading database, but after memory usage full, they fall with OutOfMemory Exception. Cassandra can`t work with low memory? or she critical need more RAM if database grows? here is link to download cassnd

results of index slice query

2011-07-27 Thread Roland Gude
Hi, I was just experiencing that when i do an IndexSliceQuery with the index column not in the slicerange the index column will be returned anyways. Is this behavior intended or is it a bug (if so - is it a Cassandra bug or a hector bug)? I am using Cassandra 0.7.7 and hector 0.7-26 Greetings,

Re: Too many open files

2011-07-27 Thread Adil
u should take a look at this http://www.datastax.com/docs/0.7/troubleshooting/index @dil 2011/7/27 Donna Li > All: > > What does the following error mean? One of my cassandra servers print this > error, and nodetool shows the state of the server is down. Netstat result > shows the socket

Error when set memtable_troughput with Cassandra-CLI

2011-07-27 Thread lebron james
Hi! Need set memtable_troughput for cassandra I try do this with help cassandra-cli by write this command "update column family columnfamily2 memtable_troughput=155;" but i get error "missing EOF at memtable_troughput" help! how i can set attribute memtable_troughput?

Re: Cassandra 0.7.8 and 0.8.1 fail when major compaction on 37GB database

2011-07-27 Thread Edward Capriolo
On Wed, Jul 27, 2011 at 7:40 AM, lebron james wrote: > Why when i give jvm 1 GB heap size and try launch cassandra with 37GB > database, cassandra start loading database, but after memory usage full, > they fall with OutOfMemory Exception. Cassandra can`t work with low memory? > or she critical n

Java bits: Horizontal Scalibility and DAO layer design

2011-07-27 Thread Selcuk Bozdag
Hi, The question I am asking is a bit about the design of a data access objects layer on top of a cassandra datastore. I had a look at project Kundera which basically implies JPA approach by creating POJOs and mapping them through annotations. Looks promising but what if I would like to have new

Re: Read process

2011-07-27 Thread samal
from ROW CACHE {if enabled} -->KEY CACHE-->MEMTABLE-->SSTABLE On Wed, Jul 27, 2011 at 1:19 PM, CASSANDRA learner < cassandralear...@gmail.com> wrote: > Hi, > > I am having one doubt regarding reads. The data will be stored in > commitlog,memtable,sstables right.. While reading the data may be ava

Re: Java bits: Horizontal Scalibility and DAO layer design

2011-07-27 Thread Ikeda Anthony
Speaking from personal experience (and believe me it all comes down to this) we attempted a DAO approach as well. However, we found that based upon all the mutator.addInsertion()s we were creating across column families everything ended up in the same DAO - we only have 3 main Column Families th

Re: Re: Cassandra start/stop scripts

2011-07-27 Thread Jonathan Ellis
The main advantage to that is, If you kill it without -9 it will make sure to let the commitlog flush and fsync first, if you've been using periodic sync (the default). On Wed, Jul 27, 2011 at 1:31 AM, wrote: > A simple kill without -9 should work. Have you tried that? > > On , Jason Pell wrote

Re: results of index slice query

2011-07-27 Thread Jonathan Ellis
Sounds like a Cassandra bug to me. On Wed, Jul 27, 2011 at 6:44 AM, Roland Gude wrote: > Hi, > > I was just experiencing that when i do an IndexSliceQuery with the index > column not in the slicerange the index column will be returned anyways. Is > this behavior intended or is it a bug (if so – i

Re: Java bits: Horizontal Scalibility and DAO layer design

2011-07-27 Thread Selcuk Bozdag
Thanks Anthony. Following your comments, I searched for a similar approach using command pattern. http://code.google.com/p/casemate seems a way of doing that. On 27 July 2011 18:23, Ikeda Anthony wrote: > Speaking from personal experience (and believe me it all comes down to this) > we attempted

Re: Error when set memtable_troughput with Cassandra-CLI

2011-07-27 Thread Adi
typo in >> memtable_troughput "update column family columnfamily2 memtable_troughput=155;" "update column family columnfamily2 memtable_throughput=155;" On Wed, Jul 27, 2011 at 9:59 AM, lebron james wrote: > Hi! > Need set memtable_troughput for cassandra > I try do this with help cassandra-cl

Questions over the use of CQL

2011-07-27 Thread Anthony Ikeda
For our current project we have decided to use Hector as the client API, however, with the introduction of CQL I need to understand a few things. Firstly, CQL use SQL like constructs. Column names seem to be limited to the same constraints of SQL (restricted use of delimiters) and yet the strength

Re: Slow Reads

2011-07-27 Thread Indranath Ghosh
You might want to avoid super columns and denormalize your schema... Since you are querying by the supercoumns... you can make them the rowkeys and current rowkeys can be your column names.. and using composite column names to get to the columns faster. Something like this (used your representation

Re: Can we store java objects and images/files in cassandra

2011-07-27 Thread mcasandra
CASSANDRA learner wrote: > > Hi, > > Can we store images , java objects, files in cassandra, if so , how > Please let me know this as i need it urgently... > Look at http://goo.gl/S2E3C http://goo.gl/S2E3C It really depends on your workload. With heavy workloads cassandra is not the rig

Re: Error when set memtable_troughput with Cassandra-CLI

2011-07-27 Thread lebron james
sorry, i dont understand, what right syntax to set memtable_throughput? >

Re: Error when set memtable_troughput with Cassandra-CLI

2011-07-27 Thread Jeremy Hanna
Try help on the CLI for how to do it, specifically "help update column family;" It looks like you're missing the "with." update column family columnfamily2 memtable_throughput=155; should be update column family columnfamily2 with memtable_throughput=155; On Jul 27, 2011, at 12:49 PM, lebron j

Re: Slow Reads

2011-07-27 Thread Priyanka
Thank you Indra for your suggestion. But the thing is apart from pulling data based on supercol in the below example I also need to query to pull the data based on a particular rowkey.If I change the model as u mentioned this query becomes slow. I need to do both the retrievals efficiently. -- Vie

Re: Slow Reads

2011-07-27 Thread Jake Luciani
The philosophy in no-sql is to store the data as you plan to access it. that means duplicating the data many time possibly. Disk is cheap, writes are fast. On Wed, Jul 27, 2011 at 2:22 PM, Priyanka wrote: > Thank you Indra for your suggestion. > But the thing is apart from pulling data based o

Re: Java bits: Horizontal Scalibility and DAO layer design

2011-07-27 Thread Peter Tillotson
I had a quick look at DAO and my common uses case is, row names appearing as column ID's elsewhere (indexes etc). I also wanted to track deltas at a column level and have a reasonable sized client side cache. I ended up with two abastract DAO's, one for Column Family, one for Super column factory,

Expanding 0.6.x cluster to multiple datacenters

2011-07-27 Thread Ashley Martens
I have a current 0.6.x cluster in a single datacenter with RackUnaware and am looking to expand into a second data center. I know I need to change to RackAwareStrategy however, I'm not sure what will happen to my data when I restart the nodes in the current cluster before I even add the new DC. Wil

Re: Expanding 0.6.x cluster to multiple datacenters

2011-07-27 Thread Jonathan Ellis
As you know, with 0.6 adding a datacenter is not as easy as 0.7 with NetworkTopologyStrategy. With 0.6 there is a right way that will work with some manual effort, and a wrong way that can cause you major pain and grief. The right way: - Switch to a DC-aware snitch but leave your cluster on RUS t

Changing the CLI, not a great idea!

2011-07-27 Thread Edward Capriolo
Notice how users react to these things. At one point for example we decided to add a ';' to the CLI. http://www.amazon.com/Cassandra-Definitive-Guide-Eben-Hewitt/dp/1449390412 The initial chapters on downloading and installing the product get the reader started using Cassandra immediately. Then t

Re: Changing the CLI, not a great idea!

2011-07-27 Thread Jonathan Ellis
On Wed, Jul 27, 2011 at 10:53 PM, Edward Capriolo wrote: > You can not even put two statements on the same line. So the ';' is semi > useless syntax. Nobody ever asked for that, but lots of people asked to allow statements spanning multiple lines. > Is their a way to move things forward without

Re: Changing the CLI, not a great idea!

2011-07-27 Thread Edward Capriolo
On Thu, Jul 28, 2011 at 12:01 AM, Jonathan Ellis wrote: > On Wed, Jul 27, 2011 at 10:53 PM, Edward Capriolo > wrote: > > You can not even put two statements on the same line. So the ';' is semi > > useless syntax. > > Nobody ever asked for that, but lots of people asked to allow > statements spa