hive table metadata with row and column count

tbl_stats.sql

SELECT d.NAME AS DB_NAME, t. TBL_NAME, COUNT(1) AS COL_COUNT, tp.PARAM_VALUE AS ROW_COUNT
FROM hive.TBLS t
 JOIN hive.DBS d
 ON t.DB_ID = d.DB_ID
 JOIN hive.SDS s
 ON t.SD_ID = s.SD_ID
 JOIN hive.COLUMNS_V2 c
 ON s.CD_ID = c.CD_ID
 JOIN hive.TABLE_PARAMS tp 
 ON t.TBL_ID = tp.TBL_ID
 WHERE tp.PARAM_KEY = 'numRows'
 GROUP BY d.NAME, t.TBL_NAME
 ORDER BY d.NAME, t.TBL_NAME