Using the CONVERT_TZ command with an UPDATE query throws "IDB-1815: Unknown Error".
Here is an example query that produces the error:
UPDATE mytable SET `dateTimeOriginationConverted`= CONVERT_TZ(FROM_UNIXTIME(`dateTimeOrigination`), @@session.time_zone,'America/New_York') WHERE ID = 1;
This only happens when referencing the field value (dateTimeOrigination is an INT field in the database that contains the UNIX timestamp value). If you use a static INT, the update works fine. The command also works fine as is on a standard MySQL 5.7 server using InnoDB. so this must be specific to MariaDB or ColumnStore.