I am trying to return a table location (path) using a SQL query (in my Python code). Is it possible? I’m using Hive and the data is stored in hdfs. I found this snippet of code elsewhere: But unfortunately I don’t understand it, so I don’t even know how to customise it to my problem. I want to use this
Tag: location
How to group latitude/longitude points that are ‘close’ to each other?
I have a database of user submitted latitude/longitude points and am trying to group ‘close’ points together. ‘Close’ is relative, but for now it seems to ~500 feet. At first it seemed I could just group by rows that have the same latitude/longitude for the first 3 decimal places (roughly a 300×300 box, understanding that it changes as you move