必须在mysql上创建,不能在mycat上,否则报错java.sql.SQLSyntaxErrorException: op table not in schema----VIEW然后配xml就可以select了。show table status where comment =‘view’;