GitHub user myui opened a pull request:
https://github.com/apache/incubator-hivemall/pull/73
Add GEO Spatial UDFs (tile, map_url)
## What changes were proposed in this pull request?
Add GEO Spatial UDFs (`tile`, `map_url`)
## What type of PR is it?
Feature
## What is the Jira issue?
https://issues.apache.org/jira/browse/HIVEMALL-96
## How was this patch tested?
unit tests and manual tests
## How to use this feature?
```sql
-- tile(double lat, double lon, int zoom) => tile number
WITH data as (
select 51.51202 as lat, 0.02435 as lon, 17 as zoom
)
select
tile(lat, lon, zoom)
from
data;
WITH data as (
select 51.51202 as lat, 0.02435 as lon, 17 as zoom
)
select
map_url(lat,lon,zoom) as osm_url,
map_url(lat,lon,zoom,'googlemaps') as gmap_url
from
data;
```
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/myui/incubator-hivemall HIVEMALL-96
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-hivemall/pull/73.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #73
----
commit 678045694e2bbd69c7fd815d1335182cc373f53d
Author: myui <[email protected]>
Date: 2017-04-24T07:27:26Z
Add Geo spatial UDFs (tile, map_url)
----
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at [email protected] or file a JIRA ticket
with INFRA.
---
