Configuring Materialized View database information
In CDP Private Cloud Base, PostgreSQL is configured during the installation of SQL
Stream Builder (SSB) as a service. You can review the database configuration for SSB using
Cloudera Manager.
SSB uses PostgreSQL database to store the queried data of the
Materialized View feature. In CDP Private Cloud Base, you can only use PostgreSQL as a
database for SSB. In case you need to connect to the PostgreSQL database of SSB, you can
review the necessary information of the database in Cloudera Manager. You can also configure
the user and the password of the database using CLI, and then updating the existing
information in Cloudera Manager.
Where to find the PostgreSQL database information?
Go to your cluster in Cloudera Manager.
Select SQL Stream Builder from the list of services
Click Configuration.
Filter down the configuration parameters to Materialized View
Engine.
The following information is listed about the PostgreSQL
database:
Database Name
Database Host
Database Port
Database User
Database Password
When you want to change the default configuration of PostgreSQL database, first you
need to change the information in PostgreSQL and then update the configuration in Cloudera
Manager for SSB.