You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'grouped AS ( SELECT DISTINCTROW d.disease_id, hsym.cui, hd.date, hs.source_id' code example

Example: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json DEFAULT NULL COMMENT 'storing the data of before sending to Gateway', `r' at line 14

MariaDB does not natively implement the 'JSON' data type but it uses it as an 
alias for 'LONGTEXT' for compatibility reasons