RE: Unable to fetch large amount of rows

2013-03-21 Thread Pushkar Prasad
dra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 21/03/2013, at 4:48 PM, Pushkar Prasad wrote: Yes, I'm reading from a single partition. -Original Message- From: Hiller, Dean [mailto:dean.hil...@nrel.gov] Sent: 21 March 2013 01:38 To: user@cassand

RE: Unable to fetch large amount of rows

2013-03-20 Thread Pushkar Prasad
From: Pushkar Prasad mailto:pushkar.prasad@airtightnetworks. net>> Reply-To: "user@cassandra.apache.org<mailto:user@cassandra.apache.org>" mailto:user@cassandra.apache.org>> Date: Wednesday, March 20, 2013 11:41 AM To: "user@cassandra.apache.org<mailt

RE: Unable to fetch large amount of rows

2013-03-20 Thread Pushkar Prasad
dra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 19/03/2013, at 9:38 PM, Pushkar Prasad wrote: Aaron, Thanks for your reply. Here are the answers to questions you had asked: I am trying to read all the rows which have a particular TimeStamp. In my data base,

Overheads in fetching many (500K) rows for a partitionID

2013-03-19 Thread Pushkar Prasad
With the following schema: - TimeStamp - Device ID - Device Name - Device Owner - Device Color PKEY (TimeStamp, DeviceID) Each record is 40 bytes. I'm trying to fetch all the rows for a particular TimeStamp (partitionID). Select * from schema where TimeStamp = '.' There ar

RE: Unable to fetch large amount of rows

2013-03-19 Thread Pushkar Prasad
h. Cheers - Aaron Morton Freelance Cassandra Consultant New Zealand @aaronmorton http://www.thelastpickle.com On 19/03/2013, at 3:51 AM, Pushkar Prasad wrote: > Hi, > > I have following schema: > > TimeStamp > MACAddress > Data Transfer > Data Rate > LocationI

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

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