Adding Query Processor service to a cluster
The Query Processor service indexes Hive and Tez events and provides APIs to access them. It is required if you want to view the Queries tab (query history and query details) on the Hue Job Browser. You must install the Query Processor service on your CDP Private Cloud Base clusters manually.
This task assumes that you already have a database installed on a host in your cluster. On CDP, Hue Query Processor supports PostgreSQL, MySQL, and Oracle databases. The supported PostgreSQL database version for Hue Query Processor is 9.6 and higher.
Next, you need to create a database for the Query Processor service with the required
roles. To create the Query Processor database:
- SSH into your database host as a root user.
- Start the database terminal by running the following commands:
(PostgreSQL)
sudo -u postgres psql
(MySQL)systemctl start mysqld
(Oracle)sqlplus / as sysdba
- Run the following statement while specifying the username, password, and a
database name for the Query Processor: (PostgreSQL)
CREATE ROLE [***QP-USER***] WITH LOGIN PASSWORD '[***QP-PASSWORD***]'; ALTER ROLE [***QP-USER***] CREATEDB; CREATE DATABASE [***QP-DATABASE***]; GRANT ALL PRIVILEGES ON DATABASE [***QP-DATABASE***] TO [***QP-USER***];
(MySQL)CREATE USER [***QP-USER***] IDENTIFIED BY '[***QP-PASSWORD***]'; CREATE DATABASE [***QP-DATABASE***]; USE [***QP-DATABASE***]; GRANT ALL PRIVILEGES ON [***QP-DATABASE***].* TO [***QP-USER***];
(Oracle)CREATE USER [***QP-USER***] IDENTIFIED BY [***QP-PASSWORD***]; GRANT ALL PRIVILEGES TO [***QP-USER***];