Software Alternatives, Accelerators & Startups

TiDB VS Apache Hive

Compare TiDB VS Apache Hive and see what are their differences

TiDB logo TiDB

A distributed NewSQL database compatible with MySQL protocol

Apache Hive logo Apache Hive

Apache Hive data warehouse software facilitates querying and managing large datasets residing in distributed storage.
  • TiDB Landing page
    Landing page //
    2023-09-26
  • Apache Hive Landing page
    Landing page //
    2023-01-13

TiDB videos

Hands-On TiDB - Episode 1: A Brief Introduction to TiDB

More videos:

  • Review - TiDB Contributor 学习之路
  • Tutorial - TiDB Binlog Tutorial

Apache Hive videos

Hive vs Impala - Comparing Apache Hive vs Apache Impala

Category Popularity

0-100% (relative to TiDB and Apache Hive)
Databases
30 30%
70% 70
NoSQL Databases
100 100%
0% 0
Big Data
0 0%
100% 100
Relational Databases
35 35%
65% 65

User comments

Share your experience with using TiDB and Apache Hive. For example, how are they different and which one is better?
Log in or Post with

Reviews

These are some of the external sources and on-site user reviews we've used to compare TiDB and Apache Hive

TiDB Reviews

20+ MongoDB Alternatives You Should Know About
TiDB is another take on MySQL compatible sharding. This NewSQL engine is MySQL wire protocol compatible but underneath is a distributed database designed from the ground up.
Source: www.percona.com

Apache Hive Reviews

We have no reviews of Apache Hive yet.
Be the first one to post

Social recommendations and mentions

Based on our record, TiDB should be more popular than Apache Hive. It has been mentiond 15 times since March 2021. We are tracking product recommendations and mentions on various public social media platforms and blogs. They can help you identify which product is more popular and what people think of it.

TiDB mentions (15)

  • A MySQL compatible database engine written in pure Go
    Tidb has been around for a while, it is distributed, written in Go and Rust, and MySQL compatible. https://github.com/pingcap/tidb. - Source: Hacker News / about 1 month ago
  • Ask HN: Who is hiring? (January 2023)
    PingCAP | https://www.pingcap.com | Database Engineer, Product Manager, Developer Advocate and more | Remote in California | Full-time We work on a MySQL compatible distributed database called TiDB https://github.com/pingcap/tidb/. - Source: Hacker News / over 1 year ago
  • Apache Pegasus – A a distributed key-value storage system
    Isn't TiDB built on top of TiKV?[0] [0]: https://github.com/pingcap/tidb. - Source: Hacker News / over 1 year ago
  • What is your experience with mixed workload (OLTP and OLAP) databases?
    OLTP usually comes with high throughput of transactions, which means usually write(e.g., IUD - insert, update, delete) to read (e.g., select) ratio is above 4 or 5 or even higher. There are some good benchmarks to test OLTP workload like TPC-C (https://www.tpc.org/tpcc/), and some benchmarks to test OLAP workload like TPC-H (https://www.tpc.org/tpch/). For mixed or hybrid OLTP and OLAP (it's called HTAP, see this... - Source: Hacker News / almost 2 years ago
  • NewDB: Fate of an Open Source Database
    I am very agree with some options of this blog. As the maintainer of the open source distributed database TiDB https://github.com/pingcap/tidb, we also face the same problem of choice. We have a community version, an enterprise version(of course, we must sell it to our customers to earn money) and also a cloud service named TiDB cloud. Seven years before, we started to build TiDB to solve MySQL sharding problem,... - Source: Hacker News / almost 2 years ago
View more

Apache Hive mentions (8)

View more

What are some alternatives?

When comparing TiDB and Apache Hive, you can also consider the following products

Redis - Redis is an open source in-memory data structure project implementing a distributed, in-memory key-value database with optional durability.

Apache Spark - Apache Spark is an engine for big data processing, with built-in modules for streaming, SQL, machine learning and graph processing.

Apache Cassandra - The Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance.

Apache Doris - Apache Doris is an open-source real-time data warehouse for big data analytics.

MongoDB - MongoDB (from "humongous") is a scalable, high-performance NoSQL database.

ClickHouse - ClickHouse is an open-source column-oriented database management system that allows generating analytical data reports in real time.