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
Feedback
Was this page helpful?
Glad to hear it!
Sorry to hear that. We'll track this issue and see how we can improve.
Last modified 2021.09.25: Altinity.Cloud updates and Connectivity added.