Direct Pass-through commands, such as SHOW TABLES and DESCRIBE tablename, do not display any results.

This can be avoided by adding a comment:

ENGINE SQLHIV
/*QUERY*/ SHOW TABLES ;
END