https://community.cloudera.com/t5/Support-Questions/Cloudera-7-1-9-with-PostgreSQL-on-RDS-creates-all-tables-in/m-p/389699#M247047 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/110638">@ldylag</a>&nbsp;No, it is not expected behavior. We expect the tables to be created in the 'public' schema under 'metastore' database.</P> Fri, 28 Jun 2024 05:54:44 GMT smruti 2024-06-28T05:54:44Z https://community.cloudera.com/t5/Support-Questions/Cloudera-7-1-9-with-PostgreSQL-on-RDS-creates-all-tables-in/m-p/388812#M246792 <P>After installing CDP 7.1.9 on AWS ec2 machines and RDS Postgres as backend database, below databases are created, where scm is the Cloudera Manager database:</P><LI-CODE lang="markup"> List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -------------------------+-------------------------+----------+-------------+-------------+----------------------- amon | amon | UTF8 | en_US.UTF-8 | en_US.UTF-8 | classic-clusters | classic-clusters | UTF8 | en_US.UTF-8 | en_US.UTF-8 | cluster-proxy | cluster-proxy | UTF8 | en_US.UTF-8 | en_US.UTF-8 | das | das | UTF8 | en_US.UTF-8 | en_US.UTF-8 | db-alerts | db-alerts | UTF8 | en_US.UTF-8 | en_US.UTF-8 | db-clusteraccessmanager | db-clusteraccessmanager | UTF8 | en_US.UTF-8 | en_US.UTF-8 | db-dex | db-dex | UTF8 | en_US.UTF-8 | en_US.UTF-8 | db-dwx | db-dwx | UTF8 | en_US.UTF-8 | en_US.UTF-8 | db-env | db-env | UTF8 | en_US.UTF-8 | en_US.UTF-8 | db-liftie | db-liftie | UTF8 | en_US.UTF-8 | en_US.UTF-8 | db-mlx | db-mlx | UTF8 | en_US.UTF-8 | en_US.UTF-8 | db-resourcepoolmanager | db-resourcepoolmanager | UTF8 | en_US.UTF-8 | en_US.UTF-8 | db-ums | db-ums | UTF8 | en_US.UTF-8 | en_US.UTF-8 | hue | hue | UTF8 | en_US.UTF-8 | en_US.UTF-8 | metastore | hive | UTF8 | en_US.UTF-8 | en_US.UTF-8 | nav | nav | UTF8 | en_US.UTF-8 | en_US.UTF-8 | navms | navms | UTF8 | en_US.UTF-8 | en_US.UTF-8 | oozie | oozie | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ranger | rangeradmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | rdsadmin | rdsadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | rdsadmin=CTc/rdsadmin rman | rman | UTF8 | en_US.UTF-8 | en_US.UTF-8 | schemaregistry | schemaregistry | UTF8 | en_US.UTF-8 | en_US.UTF-8 | scm | rangeradmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | sentry | sentry | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ssb_admin | ssb_admin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | ssb_mve | ssb_mve | UTF8 | en_US.UTF-8 | en_US.UTF-8 | streamsmsgmgr | streamsmsgmgr | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | rdsadmin | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/rdsadmin + | | | | | rdsadmin=CTc/rdsadmin template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres + | | | | | postgres=CTc/postgres</LI-CODE><P>What worries us is that all tables are created inside this CM database and other databases are empty:</P><P>Clodera Manager (scm) database:</P><LI-CODE lang="markup">scm=&gt; \dt List of relations Schema | Name | Type | Owner --------+--------------------------------+-------+------------- public | WM_TRIGGER | table | hive public | WRITE_SET | table | hive public | audits | table | scm public | auth_group | table | hue public | auth_group_permissions | table | hue public | auth_permission | table | hue public | auth_roles | table | scm public | auth_roles_scopes | table | scm public | auth_user | table | hue public | auth_user_groups | table | hue ... public | beeswax_savedquery | table | hue public | beeswax_session | table | hue public | bundle_actions | table | oozie public | bundle_jobs | table | oozie ... public | upgrade_state | table | scm public | user_auth_roles | table | scm public | user_roles | table | scm public | user_settings | table | scm public | useradmin_grouppermission | table | hue public | useradmin_huepermission | table | hue public | useradmin_ldapgroup | table | hue public | useradmin_userprofile | table | hue public | users | table | scm public | validate_conn | table | oozie public | wf_actions | table | oozie public | wf_jobs | table | oozie public | x_access_type_def | table | rangeradmin public | x_audit_metrics | table | rangeradmin public | x_auth_sess | table | rangeradmin ... (307 rows)</LI-CODE><P>Values in column owner seems suspicious, as we were expecting the 'rangeradmin' owned tables to go to ranger schema, hive owned to go to metastore db and so on.<BR />When checking those databases, there are no tables at all:</P><LI-CODE lang="markup">scm=&gt; \c metastore You are now connected to database "metastore" as user "postgres". metastore=&gt; \dt Did not find any relations. metastore=&gt; \c ranger You are now connected to database "ranger" as user "postgres". ranger=&gt; \dt Did not find any relations. ranger=&gt; \c ranger rangeradmin ranger=&gt; \dt Did not find any relations.</LI-CODE><P>All services Ranger, Hue, Hive are running and writing to the scm database tables.</P><P><STRONG>Questions:</STRONG><BR />Is this expected behavior?<BR />Where can I find the DDL/SQL codes used during installation?</P><P>&nbsp;</P> Tue, 21 Apr 2026 06:30:03 GMT https://community.cloudera.com/t5/Support-Questions/Cloudera-7-1-9-with-PostgreSQL-on-RDS-creates-all-tables-in/m-p/388812#M246792 ldylag 2026-04-21T06:30:03Z https://community.cloudera.com/t5/Support-Questions/Cloudera-7-1-9-with-PostgreSQL-on-RDS-creates-all-tables-in/m-p/389699#M247047 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/110638">@ldylag</a>&nbsp;No, it is not expected behavior. We expect the tables to be created in the 'public' schema under 'metastore' database.</P> Fri, 28 Jun 2024 05:54:44 GMT https://community.cloudera.com/t5/Support-Questions/Cloudera-7-1-9-with-PostgreSQL-on-RDS-creates-all-tables-in/m-p/389699#M247047 smruti 2024-06-28T05:54:44Z https://community.cloudera.com/t5/Support-Questions/Cloudera-7-1-9-with-PostgreSQL-on-RDS-creates-all-tables-in/m-p/390018#M247151 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/110638">@ldylag</a>&nbsp;You may find the DDLs under&nbsp;/opt/cloudera/parcels/CDH/lib/hive/scripts/metastore/upgrade/&lt;db type&gt;</P> Tue, 09 Jul 2024 12:45:30 GMT https://community.cloudera.com/t5/Support-Questions/Cloudera-7-1-9-with-PostgreSQL-on-RDS-creates-all-tables-in/m-p/390018#M247151 smruti 2024-07-09T12:45:30Z https://community.cloudera.com/t5/Support-Questions/Cloudera-7-1-9-with-PostgreSQL-on-RDS-creates-all-tables-in/m-p/390027#M247155 <P><a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/110638">@ldylag</a>&nbsp;you can check which database the service uses by checking its configuration in the cloudera manager. For instance, go to hive service » configuration » and search for database. The configuration named "hive_metastore_database_name" will tell you the actual database hive service is using.&nbsp;</P><P>I hope this helps!</P> Tue, 09 Jul 2024 15:18:27 GMT https://community.cloudera.com/t5/Support-Questions/Cloudera-7-1-9-with-PostgreSQL-on-RDS-creates-all-tables-in/m-p/390027#M247155 tj2007 2024-07-09T15:18:27Z