Re: query by column size

2015-02-13 Thread chandra Varahala
I have already secondary index on that column, but how to I query that column by size ? thanks chandra On Fri, Feb 13, 2015 at 3:30 AM, Marcelo Valle (BLOOMBERG/ LONDON) < mvallemil...@bloomberg.net> wrote: > There is no automatic indexing in Cassandra. There are secondary indexes, > but not for

query by column size

2015-02-12 Thread chandra Varahala
Greetings, I have one column family with 10 columns, one of the column we store xml/json. Is there a way I can query that column where size > 50kb ? assuming I have index on that column. thanks CV.

Re: ./cqlsh not working

2014-01-24 Thread chandra Varahala
did you start Cassandra server ? thanks Chandra On Thu, Jan 23, 2014 at 12:08 AM, Jason Wee wrote: > Just meant it cannot find the require library, why don't you install > cassandra package to your distribution ? > http://rpm.datastax.com/community/noarch/cassandra12-1.2.13-1.noarch.rpm > > ht

Re: Help me to find Compatable JDBC jar for Apache Cassandra 2.0.4

2014-01-22 Thread chandra Varahala
Did you put these jars in classpath ? cassandra-all-1.x.x.jar guarva jackson-core-asl jacckson-mapper-asl libthrift snappy slf4j-api metrics-core netty thanks Chandra On Wed, Jan 22, 2014 at 12:52 PM, Colin Clark wrote: > Is the jar on the path? Is cassandra home set correctly? > > Looks li

Re: Moving from relational to Cassandra, how to handle intra-table relationships?

2014-01-22 Thread chandra Varahala
Hello, You can implement relations in couple of ways, JSON/XML and CQL collection Classes. Thanks Chandra On Tue, Jan 21, 2014 at 8:58 PM, Les Hartzman wrote: > True. Fortunately though in this application, the data is > write-once/read-many. So that is one bullet I would dodge! > > Les > >

data export with different replication factor.

2014-01-18 Thread chandra Varahala
Greetings, I have 6 node cluster production cluster with replication factor of 3 with 4 keyspaces, and 1 Test cluster with 2 nodes , is there a way I can export data from production cluster and copy into test cluster with replication factor 1 ? Thanks Chandra

Re: AddContractPoint /VIP

2014-01-18 Thread chandra Varahala
local seeds, it will discover all the > nodes. > > Cheers > > - > Aaron Morton > New Zealand > @aaronmorton > > Co-Founder & Principal Consultant > Apache Cassandra Consulting > http://www.thelastpickle.com > > On 7/12/2013, at 7:12 am, chandra Varahala &g

Re: Need ur expertise on Cassandra issue!!

2014-01-18 Thread chandra Varahala
Hello, How many cassandra nodes you have in the cluster ? when you run MR from hadoop, how many Mappers/Reducers it is creating ? I had same kind of issue before ... thanks chandra On Thu, Jan 16, 2014 at 11:00 PM, Aaron Morton wrote: > Look at the logs for the cassandra servers, are node

AddContractPoint /VIP

2013-12-06 Thread chandra Varahala
Greetings, I have 4 node cassandra cluster that will grow upt to 10 nodes,we are using CQL Java client to access the data. What is the good practice to put in the code as addContactPoint ie.,how many servers ? 1) I am also thinking to put this way here I am not sure this good or bad if i con

Re: replica verification

2013-12-03 Thread chandra Varahala
Thank you Team. -Chandra On Mon, Dec 2, 2013 at 7:32 PM, Robert Coli wrote: > On Mon, Dec 2, 2013 at 8:16 AM, chandra Varahala < > hadoopandcassan...@gmail.com> wrote: > >> I have cassandra cluster with 5 nodes with 1 replication factor initially. >> Now i changed

replica verification

2013-12-02 Thread chandra Varahala
Hello Team, I have cassandra cluster with 5 nodes with 1 replication factor initially. Now i changed to replication factor 3 and ran nodetool repair. Is there way i can verify that i have 3 replicas ? Thanks Chandra

Re: merge sstables

2013-07-11 Thread chandra Varahala
nodetool scrub on each node. Someone please correct me if I'm wrong on > this. > > Faraaz > > On Thu, Jul 11, 2013 at 11:34:08AM -0700, chandra Varahala wrote: > > Hello , > > > > I have small size of sstables like 5mb around 2000 files. Is there a > way i can > > merge into bigger size ? > > > > thanks > > chandra >

merge sstables

2013-07-11 Thread chandra Varahala
Hello , I have small size of sstables like 5mb around 2000 files. Is there a way i can merge into bigger size ? thanks chandra

Re: JNA not found.

2013-01-29 Thread chandra Varahala
andrahome/lib/snaptree-0.1.jar:/etc/alternatives/cassandrahome/lib/jamm-0.2.5.jar > Killed > > And still when I remove those library files cassandra starts without a > problem exception the fact that it is not able to use JNA. > > I'd appreciate any input the

Re: JNA not found.

2013-01-29 Thread chandra Varahala
I think you need Jna jar and jna-plaform jar in cassandra lib folder -chandra On Mon, Jan 28, 2013 at 10:02 PM, Tim Dunphy wrote: > I went to github to try to download jna again. I downloaded version 3.5.1 > > [root@cassandra-node01 cassandrahome]# ls -l lib/jna-3.5.1.jar > -rw-r--r-- 1 ro

Re: Denormalization

2013-01-28 Thread chandra Varahala
My experience we can design main column families and lookup column families. Main column family have all denormalized data,lookup column families have rowkey of denormalized column families's column. In users column family all user's denormalized data and lookup column family name like userB

Re: BulkOutputFormat

2013-01-17 Thread chandra Varahala
I am not reducers, just Map only job still same kind issue ? thanks chandra On Thu, Jan 17, 2013 at 1:50 PM, Michael Kjellman wrote: > https://issues.apache.org/jira/browse/CASSANDRA-4813 > > Fixed in 1.2.0 > > Best, > michael > > From: chandra Varahala > Reply-To: