title: Translate MySQL 'SHOW CREATE TABLE' for Hive
body: <p>With MySQL I can run a simple query to get the create statement of a given table:</p>
  
  <pre><code>SHOW CREATE TABLE tableA
  </code></pre>
  
  <p>I want to translate the create statement of a MySQL table into a create statement for Hive.
  I do not want to import the table -sqoop- but just recreate its structure in Hive.</p>
  
  <p>Thanks.</p>