I have 32 years of data that I want to put into a partitioned table. However BigQuery says that I'm going over the limit (4000 partitions).

For a query like:

CREATE TABLE `deleting.day_partition` PARTITION BY FlightDate AS SELECT * FROM `flights.original`

I'm getting an error like:

Too many partitions produced by query, allowed 2000, query produces at least 11384 partitions

How can I get over this limit?