SHREELEKHYA GAMPA created CARBONDATA-4167: ---------------------------------------------
Summary: Case sensitive issues in Geospatial index support
Key: CARBONDATA-4167
URL: https://issues.apache.org/jira/browse/CARBONDATA-4167
Project: CarbonData
Issue Type: Bug
Reporter: SHREELEKHYA GAMPA
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:
[!https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/5/c71035/9d1b20f836a048909679864f0c0fb4d8/image.png!|https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/5/c71035/9d1b20f836a048909679864f0c0fb4d8/image.png]
2) select query with lower case in Query UDFs fails
[!https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/9/c71035/d28803c9cbc54db997b9d28015d59bee/image.png!|https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/9/c71035/d28803c9cbc54db997b9d28015d59bee/image.png]
select query with with lower case linestring in Polyline UDf does not return
any value.
[!https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/9/c71035/0b1fe6bdd8454079bd52047f2c72bda4/image.png!|https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/9/c71035/0b1fe6bdd8454079bd52047f2c72bda4/image.png]
Select query with lower case rangelist in IN_POLYGON_RANGE_LIST UDF returns no
value.
[!https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/9/c71035/d4d19f80d4d740b99bc5a0b68111159f/image.png!|https://clouddevops.huawei.com/vision-file-storage/api/file/download/upload-v2/2021/3/9/c71035/d4d19f80d4d740b99bc5a0b68111159f/image.png]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
