Member since
11-29-2017
4
Posts
0
Kudos Received
0
Solutions
11-30-2017
03:15 PM
Thanks for your reply! The question was created twice without knowing it. Sorry! https://community.hortonworks.com/questions/149484/is-it-possible-in-phoenix-to-create-a-functional-i-1.html
... View more
11-29-2017
08:35 PM
We need to execute geo-spatial queries where we use geo-spatial functions that operate on columns from two different tables (YELLOW_TAXI_TRIPS, TAXI_ZONES). The UDF works as a comparison to join the two tables, below is the query in which we want to improve performance applying a functional index. SELECT ZONES.zone, count(1) AS hits
FROM YELLOW_TAXI_TRIPS AS TRIPS, TAXI_ZONES AS ZONES
WHERE STWithinFromText('POINT('||TRIPS.PICKUP_LONGITUDE||' '||TRIPS.PICKUP_LATITUDE||')', ZONES.geom)
GROUP BY ZONES.zone;
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix