No, Apache Hive is not a relational database. Hive is a data warehouse infrastructure system that is built on top of Apache Hadoop for providing data summarization, data querying, and data analysis in the Hadoop distributed file system (HDFS).
Also, watch this video on Hive to understand more: