Apache Hive
7.4#3 in query engine softwareFree planFree planAPILinuxmacOSSelf-hosted
VisitApache Hive vs Query
What both publish
| Fact | Apache Hive | Query |
|---|---|---|
| Authentication | HiveServer2 supports unauthenticated modes plus Kerberos, LDAP, PAM and pluggable custom authentication. | The product supports single sign-on through identity providers such as Google, Microsoft, and Okta, and supports Google SSO through OAuth 2.0. |
| Integrations | The project site names Spark, Presto, and Impala as integrations; it also describes Apache Ranger for authorization and Apache Atlas for lineage and governance. | Query says it supports more than 50 federated sources, including Splunk, Microsoft Sentinel, CrowdStrike Falcon, Okta, Snowflake, and Google BigQuery. |
| Security | The site describes Kerberos authentication, fine-grained access control, and audit logging; HiveServer2 documentation also lists LDAP, PAM, and custom authentication options. | Query says its product design follows a “secure by design” principle and that it has an active bug bounty policy. |
Apache Hive plans
- Apache HiveFree
Query plans
No prices published.
Pick Apache Hive if…
Hive suits teams managing large datasets with SQL that need a data warehouse with distributed storage and integrations. Its documentation lists Linux for production use and Mac for development, with Windows also among the listed platforms.
Pick Query if…
It suits security teams looking for answers across distributed security data without centralizing more data. Teams can connect sources and use federated searches or detections while data stays in place.