Skip to main content

​
What this error means

UNSUPPORTED_PARTITIONING_FEATURE means a table uses a MySQL partitioning feature that PlanetScale does not support in schema linting. Common messages include: 
only RANGE, HASH, and KEY based partitioning is supported
SUBPARTITION is not supported
partition "p0" has unsupported storage engine MyISAM
SUBPARTITION for partition "p0" is not supported

​
Why PlanetScale rejects it

Vitess already provides horizontal sharding at the keyspace level. Some MySQL table partitioning features are difficult to apply safely through online schema changes or are not compatible with the schema deployment path.

​
How to fix it

Use only supported partitioning types: RANGE, HASH, or KEY. Remove LIST partitioning, subpartitioning, and non-InnoDB partition engines. Invalid: 
CREATE TABLE events (
  id bigint unsigned NOT NULL,
  region_id int NOT NULL,
  PRIMARY KEY (id)
)
PARTITION BY LIST(region_id) (
  PARTITION us VALUES IN (1, 2),
  PARTITION eu VALUES IN (3, 4)
);
A supported partitioning type: 
CREATE TABLE events (
  id bigint unsigned NOT NULL,
  created_at date NOT NULL,
  PRIMARY KEY (id, created_at)
)
PARTITION BY RANGE COLUMNS(created_at) (
  PARTITION p2026 VALUES LESS THAN ('2027-01-01')
);
If you are using partitioning to distribute data at scale, consider Vitess sharding instead of MySQL table partitioning.

​
Need help?

Get help from the PlanetScale Support team, or join our Discord community to see how others are using PlanetScale.