Apache Hive is not a full database. The design constraints and limitations of Hadoop and Hadoop Distributed File System impose limits on what Hive can do.
Hive is suited for the kind of data warehouse applications, where
Relatively static data is analyzed,
Fast response times are not required, and
When the data is not changing rapidly.
Also, watch this video to know more: