title: Impala Show Tables
body: <p>I know in Impala (and other databases) I can run both of the following:</p>
  
  <p><code>SHOW DATABASES</code></p>
  
  <p><code>SHOW TABLES</code></p>
  
  <p>I also know I can add optional <code>LIKE</code> or <code>IN</code> arguments e.g. to show me all the tables in database <strong>Bananas</strong> I could write:</p>
  
  <p><code>SHOW TABLES IN Bananas</code></p>
  
  <p>What I really want to know is a way of returning all the tables in the databases without having to recurse through (also showing database name and table name in separate fields.</p>
  
  <p>I'll be running this via impala shell so I'd have to first return back all the database names and then produce a script line per database to give me the tables.</p>
  
  <p>It's not a problem to do this as such, I just can't help wondering there must be a better way to end up with:</p>
  
  <p><a href="https://i.stack.imgur.com/CHX72.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/CHX72.png" alt="DB_Tables"></a></p>