Hive |
Traditional database |
Schema on READ – it’s does not verify the schema while it’s loaded the data |
Schema on WRITE – table schema is enforced at data load time i.e if the data being loaded does’t conformed on schema in that case it will rejected |
It’s very easily scalable at low cost | Not much Scalable, costly scale up. |
It’s based on hadoop notation that is Write once and read many times | In traditional database we can read and write many time |
Record level updates is not possible in Hive | Record level updates, insertions and deletes, transactions and indexes are possible |
OLTP (On-line Transaction Processing) is not yet supported in Hive but it’s supported OLAP (On-line Analytical Processing) | Both OLTP (On-line Transaction Processing) and OLAP (On-line Analytical Processing) are supported in RDBMS |