Posted by
Akash R Nilugal (Jira) on
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/jira-Created-CARBONDATA-4051-Geo-spatial-index-algorithm-improvement-and-UDFs-enhancement-tp103272.html
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)