<SYSTEM_TASK:>
Solve the following problem using Python, implementing the functions described below, one line at a time
<END_TASK>
<USER_TASK:>
Description:
 def show_files(self, name, database=None):
 """ Retrieve results of SHOW FILES command for a table. See Impala documentation for more. Parameters name : string Table name. Can be fully qualified (with database) database : string, optional """

        stmt = self._table_command('SHOW FILES IN', name, database=database)
        return self._exec_statement(stmt)