[GitHub] [bigtop] timyuer commented on pull request #965: BIGTOP-3738: Add Hive support for Bigtop 3.1.0 Mpack

[GitBox <gi...@apache.org>]

timyuer commented on PR #965:
URL: https://github.com/apache/bigtop/pull/965#issuecomment-1203675426

   Thanks Yuqi, I used MySQL to test, this problem is caused by not setting the PostgreSQL driver, You can perform the following commands try ,  the tip at the time of set up the database properties. I propose to add this command to `build-containers.sh`.
   
   >To use PostgreSQL with Hive, you must [download the https://jdbc.postgresql.org/ from PostgreSQL](https://jdbc.postgresql.org/). Once downloaded to the Ambari Server host, run:
   ```bash
   ambari-server setup --jdbc-db=postgres --jdbc-driver=/path/to/postgres-driver/postgresql-jdbc.jar
   ```
   If you have not already created the user and database, you should execute the following command in PostgreSQL
   ```sql
   create user hive with password 'hive';
   create database hive owner hive;
   grant all privileges on database hive to hive;
   ```
   ![微信图片_20220803164500](https://user-images.githubusercontent.com/16263438/182565394-a5ecd42a-b236-4337-aae4-2f3dbb42bfde.png)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: dev-unsubscribe@bigtop.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org