CTE functionality is new to MariaDB 10.2. This is a complex feature and is compounded by the distributed nature of Columnstore. Changes will have to be effected in almost all processes. The full scope has to be determined and a design document created.
Sergey Petrunia is a resource to be consulted.