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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]

Reply via email to