cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kh jo <jo80la...@yahoo.com>
Subject Re: Between Clause
Date Mon, 17 Jan 2011 11:40:35 GMT

example: finding country from IP address

Mysql: I have table with 140,000 rows each with ipNumStart, IpNumEnd, Country

so to find the country I use:
WHERE ipNum BETWEEN ipNumStart AND ipNumEnd

ipNumStart   ipNumEnd    Country
16777216    
    17301503      Australia
18939904    
    19005439      Japan
etc
etc
etc

--- On Mon, 1/17/11, aaron morton <aaron@thelastpickle.com> wrote:

From: aaron morton <aaron@thelastpickle.com>
Subject: Re: Between Clause
To: user@cassandra.apache.org
Date: Monday, January 17, 2011, 12:24 PM

Can you provide some more information ?
Aaron
On 17/01/2011, at 11:55 PM, kh jo wrote:
What is the best way to model a query with between clause.. given that you have a large number
of entries... 

thanks
Jo










      



      
Mime
View raw message