Share this on Social Media: Twitter  Facebook   LinkIn

Setup the connection to ClickHouse demo site.

select toString(rand64()) as rnd_id, * from tripdata limit 100000000

ACOS( (SIN (RADIANS (LOOKUP (AVG ( [dropoff_latitude] ), [IsJFK] ) ) ) * SIN (RADIANS (AVG ( [dropoff_latitude] ) ) ) + COS (RADIANS (LOOKUP (AVG ( [dropoff_latitude] ) ), [IsJFK] ) ) ) * COS (RADIANS (AVG ( [dropoff_latitude] ) ) ) ) * COS (RADIANS (AVG ( [dropoff_longitude] )

)
RADIANS
(LOOKUP
(AVG
(
[dropoff_longitude]
)
, [IsJFK]
)
)
)
)
* 3959
Last modified 2021.07.28: Removed Github change link.