DB-EnginesExtremeDB: the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Apache Phoenix vs. Google BigQuery vs. Hive

System Properties Comparison Apache Phoenix vs. Google BigQuery vs. Hive

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Phoenix  Xexclude from comparisonGoogle BigQuery  Xexclude from comparisonHive  Xexclude from comparison
DescriptionA scale-out RDBMS with evolutionary schema built on Apache HBaseLarge scale data warehouse service with append-only tablesdata warehouse software for querying and managing large distributed datasets, built on Hadoop
Primary database modelRelational DBMSRelational DBMSRelational DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score3.16
Rank#103  Overall
#52  Relational DBMS
Score50.12
Rank#24  Overall
#16  Relational DBMS
Score78.43
Rank#17  Overall
#11  Relational DBMS
Websitephoenix.apache.orgcloud.google.com/­bigqueryhive.apache.org
Technical documentationphoenix.apache.orgcloud.google.com/­bigquery/­docscwiki.apache.org/­confluence/­display/­Hive/­Home
DeveloperApache Software FoundationGoogleApache Software Foundation infoinitially developed by Facebook
Initial release201420102012
Current release5.0-HBase2, July 2018 and 4.15-HBase1, December 20193.1.2, August 2019
License infoCommercial or Open SourceOpen Source infoApache Version 2.0commercialOpen Source infoApache Version 2
Cloud-based only infoOnly available as a cloud servicenoyesno
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageJavaJava
Server operating systemsLinux
Unix
Windows
hostedAll OS with a Java VM
Data schemeyes infolate-bound, schema-on-read capabilitiesyesyes
Typing infopredefined data types such as float or dateyesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.nono
Secondary indexesyesnoyes
SQL infoSupport of SQLyesyesSQL-like DML and DDL statements
APIs and other access methodsJDBCRESTful HTTP/JSON APIJDBC
ODBC
Thrift
Supported programming languagesC
C#
C++
Go
Groovy
Java
PHP
Python
Scala
.Net
Java
JavaScript
Objective-C
PHP
Python
Ruby
C++
Java
PHP
Python
Server-side scripts infoStored proceduresuser defined functionsuser defined functions infoin JavaScriptyes infouser defined functions and integration of map-reduce
Triggersnonono
Partitioning methods infoMethods for storing different data on different nodesShardingnoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesMulti-source replication
Source-replica replication
selectable replication factor
MapReduce infoOffers an API for user-defined Map/Reduce methodsHadoop integrationnoyes infoquery execution via MapReduce
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual ConsistencyImmediate ConsistencyEventual Consistency
Foreign keys infoReferential integritynonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDno infoSince BigQuery is designed for querying datano
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesno
User concepts infoAccess controlAccess Control Lists (using HBase ACL) for RBAC, integration with Apache Ranger for RBAC & ABAC, multi-tenancyAccess privileges (owner, writer, reader) on dataset, table or view level infoGoogle Cloud Identity & Access Management (IAM)Access rights for users, groups and roles

More information provided by the system vendor

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services
3rd partiesSQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.
» more

CData: Connect to Big Data & NoSQL through standard Drivers.
» more

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
Apache PhoenixGoogle BigQueryHive
DB-Engines blog posts

Cloudera's HBase PaaS offering now supports Complex Transactions
11 August 2021,  Krishna Maheshwari (sponsor) 

show all

Cloud-based DBMS's popularity grows at high rates
12 December 2019, Paul Andlinger

The popularity of cloud-based DBMSs has increased tenfold in four years
7 February 2017, Matthias Gelbmann

Increased popularity for consuming DBMS services out of the cloud
2 October 2015, Paul Andlinger

show all

Why is Hadoop not listed in the DB-Engines Ranking?
13 May 2013, Paul Andlinger

show all

Recent citations in the news

Apache Spark vs Apache Hadoop | Compare Data Science Tools
26 May 2022, TechRepublic

Apache Phoenix Now HBase 2.0 Compatible
20 July 2018, iProgrammer

Azure HDInsight Analytics Platform Now Supports Apache Hadoop 3.0
18 April 2019, eWeek

Apache Calcite Report: Part 1
3 July 2016, DZone

Hadoop 101: HBase and Client Access
16 February 2017, DZone

provided by Google News

Google’s Logica language addresses SQL’s flaws
15 April 2021, InfoWorld

Winning the 2020 Google Cloud Technology Partner of the Year – Infrastructure Modernization Award
20 July 2021, CIO

provided by Google News

Open-Source Database Software Market Size, Share | Global Report with Key Players Analysis - Titan, SQLite, Re
27 September 2022, openPR

AWS Glue Now Supports Crawler History
19 September 2022, InfoQ.com

Is Apache Iceberg the Future of Cloud Data Workload?
8 September 2022, Analytics Insight

Bluesky built cost guardrails to help cut Snowflake data spend
14 September 2022, TechCrunch

Dremio Cloud review: A fast and flexible data lakehouse on AWS
7 September 2022, InfoWorld

provided by Google News

Job opportunities

Solutions Architct
Cloudera, Virginia

Manager Field Data Analytics
Generac Power Systems, South Portland, ME

Distributed Big Data Platform Engineer
Bloomberg, New York, NY

Data Management / Data Integration Engineer- Core Technology Infrastructure
Bank of America, Richmond, VA

Senior Full Stack Software Developer in Test
Amiseq, Milpitas, CA

Data Architect
Perficient, Inc, United States

Presales Engineer / Solutions Architect- Data Privacy (REMOTE) NE USA or Canada
Micro Focus, Maryland

Python Hive Developer
Cognizant Technology Solutions, Hartford, CT

Associate Data Scientist
Ford Motor Company, Dearborn, MI

Flink Data Engineer
Intone Networks, Remote

Hive Developer with Python
Cognizant, Hartford, CT

Data Engineer
Qcentrio, Seattle, WA

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

Redis logo

The world’s most loved real‑time data platform.
Try free

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Present your product here