How to get the number of columns in one or more athena tables

Enjoy

SELECT table_name, COUNT(*)
FROM   information_schema.columns AS columns_number
GROUP BY  table_name 
ORDER BY 2 desc
comments powered by Disqus