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