azavea / osmesa

OSMesa is an OpenStreetMap processing stack based on GeoTrellis and Apache Spark
Apache License 2.0
80 stars 26 forks source link

Use left joins where nulls can be tolerated #90

Closed moradology closed 5 years ago

moradology commented 5 years ago

In the user_statistics materialized view, certain users were not being displayed due to nulls which were causing no harm. A more cautious and less picky LEFT JOIN preferring strategy has been adopted instead to avoid unnecessary errors