title: How to get column name and type in hive
body: <p>I know of these,</p>
  
  <ul>
  <li><p>To get column names in a table we can fire:</p>
  
  <pre><code>show columns in &lt;database&gt;.&lt;table_name&gt;
  </code></pre></li>
  <li><p>To get description of a table (including column_name, column_type and many other details):</p>
  
  <pre><code>describe [formatted] &lt;database&gt;.&lt;table_name&gt;
  </code></pre></li>
  </ul>
  
  <p>I know that I can use the above query and filter the result to get the columns names and types. But I want to know if there is any direct command to get just the column names and types like <code>select columns, column_type ...</code>?</p>