get_partitions.sql

CREATE OR REPLACE FUNCTION
  `osm_planet.get_partitions`(name STRING)
RETURNS ARRAY<DATE> AS (
  CASE
  WHEN name="place-city" THEN ARRAY<DATE>["1970-01-01"]
  WHEN name="place-town" THEN ARRAY<DATE>["1970-01-02"]
  WHEN name="place-village" THEN ARRAY<DATE>["1970-01-03"]
  WHEN name="place-hamlet" THEN ARRAY<DATE>["1970-01-04"]
  WHEN name="place-national_capital" THEN ARRAY<DATE>["1970-01-05"]
  WHEN name="place-suburb" THEN ARRAY<DATE>["1970-01-06"]
  WHEN name="place-island" THEN ARRAY<DATE>["1970-01-07"]
  WHEN name="place-farm" THEN ARRAY<DATE>["1970-01-08"]
  WHEN name="place-dwelling" THEN ARRAY<DATE>["1970-01-09"]
  WHEN name="place-region" THEN ARRAY<DATE>["1970-01-10"]
  WHEN name="place-country" THEN ARRAY<DATE>["1970-01-11"]
  WHEN name="place-locality" THEN ARRAY<DATE>["1970-01-12"]
  WHEN name="place-named_place" THEN ARRAY<DATE>["1970-01-13"]  
  WHEN name="place" THEN ARRAY<DATE>["1900-01-01","1900-01-02","1900-01-03","1900-01-04","1900-01-05","1900-01-06","1900-01-07","1900-01-08","1900-01-09","1900-01-10","1900-01-11","1900-01-12","1900-01-13"]
  ELSE ARRAY<DATE>[]
  END
);