title: Hive - How to see the table created in metastore?
body: <p>Here is our setup -
  We have Hive that uses MySQL on another machine as a metastore.
  I can start the Hive command line shell and create a table and describe it.
  But when I log on to the other machine where MySQL is used as metastore, I cannot see the Hive table details on the MySQL.</p>
  
  <p>e.g. Here are hive commands -</p>
  
  <pre><code>hive&gt; create table student(name STRING, id INT);
  OK
  Time taken: 7.464 seconds
  hive&gt; describe student;
  OK
  name    string
  id      int
  Time taken: 0.408 seconds
  hive&gt;
  </code></pre>
  
  <p>Next, I log on to the machine where MySQL is installed and this MySQL is used as Hive metastore. I use the "metastore" database. But if I want to list the tables, I cannot see the table or the table info I have created in Hive.</p>
  
  <p>How can I see the Hive table information in the metastore?</p>