from:"Pushkar Prasad"

Unable to fetch large amount of rows

2013-03-18 Thread Pushkar Prasad

Hi, I have following schema: TimeStamp MACAddress Data Transfer Data Rate LocationID PKEY is (TimeStamp, MACAddress). That means partitioning is on TimeStamp, and data is ordered by MACAddress, and stored together physically (let me know if my understanding is wrong). I have 1000 ti

Slow search on secondary index

2013-03-14 Thread Pushkar Prasad

Hi, I have the following schema in Cassandra 1.2.1: + TimeStamp + MACAddress + Data Transfer + LocationID + MacAddressCopy// Copy of MAC Address ** Primary KEY(TimeStamp, MacAddress) // Composite key, partitioned on TimeStamp There are close to

Unable to create index on a column of row key, how to accomplish quick retrieval for given schema?

2013-03-12 Thread Pushkar Prasad

Hi, I have following table structure in Cassandra 1.2.1: * TimeStamp * MACAddress * Data Transfer * LocationID * Primary KEY(TimeStamp, MacAddress) // Composite key, partitioned on TimeStamp There are close to 500K different MAC Address,

RE: Problem in running code using thrift api and cassandra

2013-03-10 Thread Pushkar Prasad

Sounds like you are hitting a 16 bit limit someplace. -Original Message- From: Annu Agrawal [mailto:annu.agrawa...@gmail.com] Sent: 10 March 2013 19:00 To: dev@cassandra.apache.org Subject: Problem in running code using thrift api and cassandra Hi , The following program has a loop whic

Use several non primary key column in Cassandra, and use Pycassa for inserts

2013-03-07 Thread Pushkar Prasad

My requirement is to have a column family like the following: mac_ap text, proto int, stime int, total_data int, total_assoc int, location_id int, location_name text PRIMARY KEY(mac_ap, proto, stime) I don't think COMPACT STORAGE allows this. Also, I want to use py

RE: Pycassa with Composite keys

2013-03-07 Thread Pushkar Prasad

. Best, Michael On Mar 7, 2013, at 2:45 AM, "Pushkar Prasad" wrote: > I want to insert a lot of rows from a csv file into Cassandra, and I figured > out copy command would not be fast enough. I want to use composite keys. I > figured out pycassa does not yet support CQL 3'

Pycassa with Composite keys

2013-03-07 Thread Pushkar Prasad

I want to insert a lot of rows from a csv file into Cassandra, and I figured out copy command would not be fast enough. I want to use composite keys. I figured out pycassa does not yet support CQL 3's composite key. I don't have much idea of how to go ahead. Are there any good drivers which will en

Very slow inserts

2013-03-05 Thread Pushkar Prasad

Hi, I'm using Cassandra 1.2.1, and I am using COPY command to insert millions of rows. Each row is 100 bytes long. The issue is that the insertion happens rather slowly, at rate of 1500 rows per second. We have 3 node cluster with 50 GB disk space each, and 4 GB RAM each. Cassandra process is r

RE: COPY command not working

2013-03-01 Thread Pushkar Prasad

@cassandra.apache.org Cc: Pushkar Prasad Subject: Re: COPY command not working This is being caused by stricter validation in 1.2.2. I opened a ticket https://issues.apache.org/jira/browse/CASSANDRA-5305 - thanks for the report. -- AY On Friday, March 1, 2013 at 19:08 PM, Pushkar Prasad wrote: > Hi, >