pingcap/tidb

Please help support distance calculations for geographic like ST_Distance in Mysql

Open

#18,290 opened on Jun 30, 2020

View on GitHub
 (6 comments) (0 reactions) (0 assignees)Go (6,186 forks)batch import
feature/acceptedhelp wantedtype/feature-request

Repository metrics

Stars
 (40,090 stars)
PR merge metrics
 (Avg merge 14d 4h) (346 merged PRs in 30d)

Description

Feature Request

Is your feature request related to a problem? Please describe:

Please help support distance calculations for geographic like ST_Distance in mysql https://asktug.com/t/topic/35682

Describe the feature you'd like:

customer could use this fuction calcuate distance.

Describe alternatives you've considered:

please refer to mysql : https://dev.mysql.com/doc/refman/8.0/en/spatial-relation-functions-object-shapes.html#function_st-distance

Teachability, Documentation, Adoption, Migration Strategy:

https://asktug.com/t/topic/35682

Contributor guide

Research direction
Study MySQL's ST Distance implementation and TiDB's existing spatial functions to design and implement a similar function.
Tech stack
go
Domain
database
Issue type
Feature
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
4
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
3-5 days
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
GoSQL
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
10