Created 03-11-2016 03:01 PM
Is there any way for hbase to return case insensitive values from the cells.
if a cell has value 'XYZ' and If a query it with 'xyZ' . is there a way to get the result back as value present?
Created 03-11-2016 03:11 PM
Want to get a detailed solution you have to login/registered on the community
Register/LoginCreated 03-11-2016 03:11 PM
Want to get a detailed solution you have to login/registered on the community
Register/LoginCreated 03-11-2016 03:30 PM
@arunkumar
There is no direct way compare insensitive values from HBase. You need to write custom filter and add the jar to all region servers and client Or else you need to write custom coprocessor to check the value and not to skip the results when upper of value matching.
If you use phoenix you can run query with where condition on UPPER(column_name) = 'XYZ'. It's just simple. Phoenix do lot of things for us.