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.09.25: Altinity.Cloud updates and Connectivity added.