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.