[CARBONDATA-4167] Case sensitive issues in Geospatial index support

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 2.2.0
• Assignee: Unassigned
• Reporter: SHREELEKHYA GAMPA
• Created: 19/Apr/21 13:33
• Updated: 27/Apr/21 13:13
• Resolved: 27/Apr/21 13:13

Description

1) create table source_index(TIMEVALUE BIGINT,LONGITUDE long,LATITUDE long) STORED AS carbondata TBLPROPERTIES ('SPATIAL_INDEX.MYGEOHASH.type'='geohash','SPATIAL_INDEX.MYGEOHASH.sourcecolumns'='longitude, latitude','SPATIAL_INDEX.MYGEOHASH.originLatitude'='39.930753','SPATIAL_INDEX.MYGEOHASH.gridSize'='50','SPATIAL_INDEX'='MYGEOHASH','SPATIAL_INDEX.MYGEOHASH.conversionRatio'='1000000');

 properties are being case sensitive:

 

2) select query with lower case in Query UDFs fails

 

 select query with with lower case linestring in Polyline UDf does not return any value.

 

 Select query with lower case rangelist in IN_POLYGON_RANGE_LIST UDF returns no value.