[jira] [Resolved] (CARBONDATA-4168) UDF validation Issues related to Geospatial support

Posted by Akash R Nilugal (Jira) on Apr 27, 2021; 1:14pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Resolved-CARBONDATA-4168-UDF-validation-Issues-related-to-Geospatial-support-tp107957.html


     [ https://issues.apache.org/jira/browse/CARBONDATA-4168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Indhumathi Muthu Murugesh resolved CARBONDATA-4168.
---------------------------------------------------
    Fix Version/s: 2.2.0
       Resolution: Fixed

> UDF  validation Issues related to Geospatial support
> ----------------------------------------------------
>
>                 Key: CARBONDATA-4168
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-4168
>             Project: CarbonData
>          Issue Type: Bug
>            Reporter: SHREELEKHYA GAMPA
>            Priority: Minor
>             Fix For: 2.2.0
>
>
> --Gives a wrong error message for size less than equal to 0.
> drop table if exists source_index;
> create table source_index(TIMEVALUE BIGINT,LONGITUDE long,LATITUDE long) STORED AS carbondata TBLPROPERTIES ('SPATIAL_INDEX'='mygeohash','SPATIAL_INDEX.mygeohash.type'='geohash','SPATIAL_INDEX.mygeohash.sourcecolumns'='longitude, latitude','SPATIAL_INDEX.mygeohash.originLatitude'='39.832277','SPATIAL_INDEX.mygeohash.gridSize'='50','SPATIAL_INDEX.mygeohash.conversionRatio'='1000000');
> LOAD DATA inpath '/geodata/geodata2.csv' INTO TABLE source_index OPTIONS ('DELIMITER'= ',');
> select longitude, latitude from source_index where IN_POLYLINE_LIST('LINESTRING (120.184179 30.327465, 120.191603 30.328946, 120.199242 30.324464, 120.190359 30.315388)', -65);
> select longitude, latitude from source_index where IN_POLYLINE_LIST('LINESTRING (120.184179 30.327465, 120.191603 30.328946, 120.199242 30.324464, 120.190359 30.315388)', 0);
> Scenario 2:
> --Accepts Invalid Buffer Size
> select longitude, latitude from source_index where IN_POLYLINE_LIST('LINESTRING (120.184179 30.327465, 120.191603 30.328946, 120.199242 30.324464), LINESTRING (120.199242 30.324464, 120.190359 30.315388)', 'X');
> Scenario 3:
> --Accepts negative and 0 gridSize
> select LatLngToGeoId(39930753, 116302895, 39.832277, -50) as geoId;
> select GeoIdToLatLng(855279270226, 39.832277, -50) as LatitudeAndLongitude;
> select ToRangeList('116.321011 40.123503, 116.320311 40.122503,116.321111 40.121503, 116.321011 40.123503', 39.832277, -50) as rangeList;
> select LatLngToGeoId(39930753, 116302895, 39.832277, 0) as geoId;
> select GeoIdToLatLng(855279270226, 39.832277, 0) as LatitudeAndLongitude;
> --Gives Wrong error message fro gridSize 0
> select ToRangeList('116.321011 40.123503, 116.320311 40.122503,116.321111 40.121503, 116.321011 40.123503', 39.832277, 0) as rangeList;
> Scenario 4:
> --Accepting Double values for GeoId
> select GeoIdToLatLng(8.55279270226, 39.832277, -50) as LatitudeAndLongitude;
> select ToUpperLayerGeoId(8.55279270226) as upperLayerGeoId;
> select GeoIdToGridXy(8.55279270226) as GridXY;
> Scanerio 5:
> --Accepting Invalid Values in All UDFs
> select GeoIdToGridXy('X') as GridXY;
> select LatLngToGeoId('X', 'X', 'X', 'X') as geoId;
> select GeoIdToLatLng('X', 'X', 'X') as LatitudeAndLongitude;
> select ToUpperLayerGeoId('X') as upperLayerGeoId;
> select ToRangeList('116.321011 40.123503, 116.320311 40.122503,116.321111 40.121503, 116.321011 40.123503', 39.832277, 'X') as rangeList;
> select ToRangeList('116.321011 40.123503, 116.320311 40.122503,116.321111 40.121503, 116.321011 40.123503', 'X', 50) as rangeList;

--
This message was sent by Atlassian Jira
(v8.3.4#803005)