title: Hive one line command to catch SCHEMA + TABLE NAME info
body: <p>Is there a way to catch all <strong>schema + table name info in a single command</strong> through Hive in a similar way to </p>
  
  <pre><code>SELECT *  FROM information_schema.tables
  </code></pre>
  
  <p>from the PostgreSQL world?</p>
  
  <p><code>show databases</code> and <code>show tables</code> combined in a loop<a href="https://stackoverflow.com/questions/57221549/how-to-export-all-hive-databases-and-their-tables-to-a-csv-or-txt-fiile/57225273#57225273"> [here</a> an example] is an answer, but I'm looking for a more compact way to have the same result in a single command. </p>