You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Jiayu Shen (Jira)" <ji...@apache.org> on 2020/11/19 03:58:00 UTC
[jira] [Created] (CARBONDATA-4051) Geo spatial index algorithm
improvement and UDFs enhancement
Jiayu Shen created CARBONDATA-4051:
--------------------------------------
Summary: Geo spatial index algorithm improvement and UDFs enhancement
Key: CARBONDATA-4051
URL: https://issues.apache.org/jira/browse/CARBONDATA-4051
Project: CarbonData
Issue Type: New Feature
Reporter: Jiayu Shen
This is requirement from SEQ,related algorithms is provided by group Discovery.
# replace geohash encoded algorithm, and reduce required properties of CREATE TABLE. For example,
{code:java}
CREATE TABLE geoTable(
timevalue BIGINT,
longitude LONG,
latitude LONG) COMMENT "This is a GeoTable"
STORED AS carbondata
TBLPROPERTIES ($customProperties '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') {code}
# add some geo spatial UDFs,
{code:java}
// query filter UDFs {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)