Mailing-List: contact dev-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of
 pushkar.prasad@airtightnetworks.net designates 64.78.61.187 as permitted
 sender)
From: "Pushkar Prasad" <pushkar.prasad@airtightnetworks.net>
To: <dev@cassandra.apache.org>
Subject: Unable to fetch large amount of rows
Date: Mon, 18 Mar 2013 19:59:54 +0530
Message-ID: <B949A599A013441EBF4EE1FA22C88F15@pune.wibhu.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_00AD_01CE2413.2C4A04B0"
Thread-Index: Ac4j5M3MgWnMcHMbQkCyWu+bf/IxeQAACPqw

------=_NextPart_000_00AD_01CE2413.2C4A04B0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

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 timestamps, and for each
timestamp, I have 500K different MACAddress. 

 
When I run the following query, I get RPC Timeout exceptions:

 
Select * from db_table where Timestamp='...'

 
>From my understanding, this should give all the rows with just one disk
seek, as all the records for a particular timeStamp. This should be very
quick, however, clearly, that doesn't seem to be the case. Is there
something I am missing here? Your help would be greatly appreciated.

 
Thanks

PP


------=_NextPart_000_00AD_01CE2413.2C4A04B0--