Version 1.1 SELECT * FROM CCMPrepare ( ON { table | view | (query) } PARTITION BY { 1 | key } ) AS alias;