Apache Hive
SQL on Hadoop: a data warehouse layer that turns HiveQL into batch jobs over files in HDFS or object storage. See how developers rate it month by month on DTDb.
- Category
- database engine
- Developer
- Apache Software Foundation
- Created by
- Joydeep Sen Sarma, Ashish Thusoo
- First release
- 2010
- License
- Apache-2.0
- Open source
- Yes
- Pricing
- Free
- Website
- https://hive.apache.org
- Written in
- Java
- Data model
- Relational
- Storage layout
- Column-oriented
- Workload
- Analytics (OLAP)
- Analytics architecture
- Data lake
- Query language
- HiveQL
- ACID transactions
- Yes
- Schema
- Strict
- Deployment
- Distributed cluster
- Scaling
- Natively distributed
- Create, read, update, delete
- Create: fast (Batch loads into files on HDFS or object storage); Read: moderate (Batch queries, seconds to minutes); Update: slow (ACID tables write delta files, compaction merges them); Delete: slow (ACID tables write delete deltas, compaction merges them)