Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: neutral (nike.apache.org: local policy)
Message-ID: <4FB0FA6A.5060100@mebigfatguy.com>
Date: Mon, 14 May 2012 08:28:26 -0400
From: Dave Brosius <dbrosius@mebigfatguy.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:12.0) Gecko/20120430 Thunderbird/12.0.1
MIME-Version: 1.0
To: user@cassandra.apache.org
Subject: Re: How to make the search by columns in range case insensitive ?
References: 
 <CADwHx2q9JowmYZPfP14HTAN8DMOdecFynRL0eMxhudLw9K3Qtg@mail.gmail.com>
In-Reply-To: 
 <CADwHx2q9JowmYZPfP14HTAN8DMOdecFynRL0eMxhudLw9K3Qtg@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

This could be accomplished with a custom 'CaseInsensitiveUTF8Type' 
comparator to be used as the comparator for that column family. This 
would require adding a class of your writing to the server.


On 05/14/2012 07:26 AM, Ertio Lew wrote:
> I need to make a search by names index using entity names as column 
> names in a row. This data is split in several rows using the first 3 
> character of entity name as row key & the remaining part as column 
> name & col value contains entity id.
>
> But there is a problem, I m storing this data in a CF using byte type 
> comparator. I need to make case insensitive queries to retrieve 'n' no 
> of cols column names starting from a point.
> Any ideas about how should I do that ?