Supported Hive distributions for profiling data
The table below shows the compatibility between big data distributions and the HiveServer.
Information noteNote: The Hive embedded mode is available for test purposes for
Hadoop developers. When in embedded mode, the studio may not run correctly.
| Big data distribution | HiveServer 1 | HiveServer2 | |
|---|---|---|---|
| HortonWorks | HDP 1.0.0 (deprecated) | Embedded and Standalone | - |
| HDP 1.2 | Embedded and Standalone | Embedded and Standalone | |
| HDP 1.3 | Embedded and Standalone | Embedded and Standalone | |
| HDP 2.0 | Embedded (Linux only) and Standalone | Embedded (Linux only) and Standalone | |
| HDP 2.1 | Embedded (Linux only) and Standalone | Embedded (Linux only) and Standalone | |
| HDP 2.2 | Embedded (Linux only) and Standalone | Embedded (Linux only) and Standalone | |
| HDP 2.3.2 | - | Standalone | |
| HDP 2.4.0 | - | Standalone | |
| HDP 2.5.0 | - | Standalone | |
| HDP 2.6.0 | - | Standalone | |
| Cloudera 1 | CDH4 | Embedded and Standalone | Embedded and Standalone |
| CDH5 | Embedded and Standalone | Embedded and Standalone | |
| CDH5.1 MR1 | - | Standalone | |
| CDH5.4 YARN | - | Standalone | |
| CDH5.5 (and above) YARN | - | Standalone | |
| MapR | MapR 1.2 (deprecated) | Standalone | - |
| MapR 2.0 | Embedded and Standalone | - | |
| MapR 2.1.2 | Embedded and Standalone | - | |
| MapR 3.0.1 | Embedded and Standalone | Embedded and Standalone | |
| MapR 3.1.0 | Embedded and Standalone | Embedded and Standalone | |
| MapR 4.0.1 YARN | Embedded and Standalone | Embedded and Standalone | |
| MapR 5.0 (and above) YARN | - | Standalone | |
| Apache | Apache 1.0.0 (Hive 0.9.0) | Embedded and Standalone | - |
| Apache 0.20.23 (Hive 0.7.1) | Standalone | - | |
| Pivotal HD | Pivotal HD 1.0.1 | Standalone | - |
| Pivotal HD 2.0 (deprecated) | Embedded (Linux only) and Standalone | Embedded (Linux only) and Standalone (Linux only) | |
1 Kerberos authentication is supported.