Hive is not a relational database, but a query engine that supports the parts of SQL specific to querying data code example

Example: how to check which table has data in mysql

mysql> SELECT table_name, table_rows
   ->FROM INFORMATION_SCHEMA.TABLES
   ->WHERE TABLE_SCHEMA = 'business';