I'm trying to create a partitioned table for GPS device data. Like this example.

CREATE TABLE data (

   deviceId BIGINT UNSIGNED NOT NULL,

   createdAt DATETIME NOT NULL,

   location POINT NOT NULL,

   PRIMARY KEY (deviceId, createdAt),

   SPATIAL KEY (location)

)Engine=InnoDB PARTITION BY HASH ( deviceId ) PARTITIONS 1024;

But MariaDB server returning an error message

[42000][1178] (conn=30) The storage engine for the table doesn't support GEOMETRY

I googled and found this (https://bugs.mysql.com/bug.php?id=60298). This issue is filed more than 10 years ago. Still has no resolution. I think MariaDB has the same problem because it is forked from MySQL. Maybe this can be fixed on the MariaDB side?