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.