MySQL is used for online operations that require reads and writes. Hive uses "schema on read" method for querying data.
MySQL is found on RDBMS. HiveQL is a mixture of OOPs and RDBMS.
MySQL considers the relationship between two tables and HiveQL is concerned with the relationship between two objects.