Partitioning zabbix database with Mariadb 5.5.60 + Zabbix 4.2

[isantos]

Good afternoon guys
Can anybody help me ?
When I run the "ALTER TABLE" command, I get the error below:

ALTER TABLE `history_uint` PARTITION BY RANGE (clock) (PARTITION p2019_12_04 LESS THAN VALUES (UNIX_TIMESTAMP (" 2019-12-05 00:00:00 ")) ENGINE = InnoDB;

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1


I am using Centos 7 with zabbix 4.2 and Mariadb in version (mysql Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1)

Could you tell me where the mistake is?

[walter]

You can try this,
ALTER TABLE `history_uint` PARTITION BY RANGE (clock)
(PARTITION p2019_12_04 VALUES LESS THAN (UNIX_TIMESTAMP("2019-12-05 00:00:00")) ENGINE = InnoDB);