as far as measuring distance between two points is concern, you can very easily do that in Google earth Pro software (free software).

Link to google earth software (if required) is linked below

https://earth.google.com/download-earth.html

https://filehippo.com/download_google-earth-pro/

This is what you need : http://esri.github.io/gis-tools-for-hadoop/ , a GIS tools for Hadoop toolkit. The Hive Spatial component of this spatial framework adds geometric user-defined functions(UDFs) to Hive. These UDFs (e.g. distance between two points) are built on top of the Esri Geometry API and are modeled on the ST_Geometry OGC compliant geometry type.

Otherwise, you can simply compute the distance using the Haversine formula :

dlon = lon2 - lon1

dlat = lat2 - lat1

a = (sin(dlat/2))^2 + cos(lat1) * cos(lat2) * (sin(dlon/2))^2

c = 2 * atan2( sqrt(a), sqrt(1-a) )

d = R * c (where R is the radius of the Earth and it's equal to 6378137 meters).

Raju Thapa- I want integration of Google Maps API in Hive for calculating the driving mode distance.

@Mehdi Boukhechba- Thanks for the reply.I think that Haversine formula will give you Aerial or spatial distance between two points.Actually i need to get the "driving mode" distance between two points using Google Api's.

I have used below mentioned query and formula in hive to find out the spatial distance but result was given me some kms variation when i compared with Google Maps API result.

Select * from

(

SELECT ( 3959 * acos( cos( radians(28.4593) ) * cos( radians(freezedlattitude ) )

* cos( radians(freezedlongitude) - radians(77.0724)) + sin(radians(28.4593))

* sin( radians(freezedlattitude)))) * 1.6 AS distance, * FROM partnerlocationdetail

) T

where distance < 10;

In this case you need to create your own User Defined Function (UDF).

Here is a tutorial on how to do these steps: https://dzone.com/articles/writing-custom-hive-udf-andudaf

Mehdi Boukhechba-- Thanks for the wonderful suggestion...Seems like it will work with UDF concept.I am writing the UDF in python.Will share the code as well if it works fine.

Here is the answer :-

import sys

import datetime

import googlemaps

from datetime import datetime

now = datetime.now()

gmaps = googlemaps.Client(key='####################')

for line in sys.stdin:

line = line.strip()

partnercode , latitude, longitude = line.split('\t')

new_lat = latitude

new_long = longitude

directions_result = gmaps.directions("28.4593, 77.0724", '"%s, %s"' % (new_lat,new_long),mode="driving",avoid="ferries",departure_time=now)

result = str(directions_result[0]['legs'][0]['distance']['text'])

durations = str(directions_result[0]['legs'][0]['duration']['text'])

result_new = float(result[:-2])

if result_new < 20:

print '\t'.join([partnercode,str(result),durations])