H2ODB Query Templates
Representative SQL and DataFrame renderings for each of the 10 H2ODB queries. Every page also shows how to extract the exact query for a given platform and scale.
| Query | Name |
|---|---|
| Q1 | Count |
| Q2 | Sum and Mean |
| Q3 | Sum by Passenger Count |
| Q4 | Sum and Mean by Passenger Count |
| Q5 | Sum by Passenger and Vendor |
| Q6 | Sum and Mean by Passenger and Vendor |
| Q7 | Sum by Hour |
| Q8 | Sum by Year and Hour |
| Q9 | Percentiles by Passenger Count |
| Q10 | Top Pickup Locations |