Count Number of Columns In Hive

Question

I am looking for a way to count the number of columns in a table in Hive.

I know the following code works in Microsoft SQL Server. Is there a Hive equivalent?

SELECT COUNT(*),
  FROM INFORMATION_SCHEMA.COLUMNS
 WHERE TABLE_CATALOG = 'database_name'
   AND TABLE_SCHEMA = 'schema_name'
   AND TABLE_NAME = 'table_name'

user_13579951 · Answer

Just do a describe it will show you all columns then at the bottom then you can see number of rows it fetched that is number of columns.

Count Number of Columns In Hive

5 Answers