It seems that Matamo indeed requires temporary tables. But we don’t provide temporary table support with free hosting. So I’m sorry to say that this probably means that you cannot host Matamo on our hosting.
You should also know that running Matamo on our hosting would probably be quite painful because you couldn’t use it to monitor other websites, because this security system would prevent the tracking code from working: Ensuring only web browsers can access your website