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: