Count Number of Columns In Hive

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'

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

Answer

try this

SHOW COLUMNS (FROM|IN) table_name [(FROM|IN) db_name]

Advertisement

Answer