Apache Hive on Ubuntu 24.04 LTS

Apache Hive on Ubuntu 24.04 LTS

Apache Hive is a data warehouse system that lets you query and manage large datasets with a familiar SQL dialect (HiveQL), backed by a relational metastore. This image is built and maintained by cloudimg on a hardened, fully patched Ubuntu 24.04 LTS base — sparing you the notoriously fiddly Hadoop + metastore + HiveServer2 wiring.

### What's included

• Apache Hive 4.0 on OpenJDK, with Hadoop (HDFS) and a MariaDB-backed metastore, managed by systemd
• HiveServer2 (Thrift) and its web UI on port 80, protected by HTTP Basic authentication
• A unique admin password generated on first boot (no shared default credential)
• The Hive warehouse, HDFS, and metastore data on a dedicated managed data disk
• Automatic security updates enabled

### Getting started

Retrieve the generated password with `sudo cat /root/hive-credentials.txt`, then connect with beeline: `beeline -u 'jdbc:hive2://127.0.0.1:10000/default' -n hive -p <password>`. Create tables and run HiveQL queries. The deployment guide on cloudimg.co.uk covers table design and day-2 operations.