title: Count Number of Columns In Hive
body: <p>I am looking for a way to count the number of columns in a table in Hive.</p>
  
  <p>I know the following code works in Microsoft SQL Server. Is there a Hive equivalent?</p>
  
  <pre><code>SELECT COUNT(*),
    FROM INFORMATION_SCHEMA.COLUMNS
   WHERE TABLE_CATALOG = 'database_name'
     AND TABLE_SCHEMA = 'schema_name'
     AND TABLE_NAME = 'table_name'
  </code></pre>