title: Showing tables from specific database with Pyspark and Hive
body: <p>Having some databases and tables in them in Hive instance. I'd like to show tables for some specific database (let's say 3_db). </p>
  
  <pre><code>+------------------+--+
  |  database_name   |
  +------------------+--+
  | 1_db             |
  | 2_db             |
  | 3_db             |
  +------------------+--+
  </code></pre>
  
  <p>If I enter beeline from bash-nothing complex there, I just do the following:</p>
  
  <pre><code>show databases;
  show tables from 3_db;
  </code></pre>
  
  <p>When I'm using pyspark via ipython notebeook- my cheap tricks are not working there and give me error on the second line (show tables from 3_db) instead:</p>
  
  <pre><code>sqlContext.sql('show databases').show()
  sqlContext.sql('show tables from 3_db').show()
  </code></pre>
  
  <p>What seems to be wrong and why's the same code works in one place and don't work in another?</p>