Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Whrere is Ambari save info about avaliable Hadoop Frameworks ?

avatar
Expert Contributor

In my case, ambari installed on postgres database

1 ACCEPTED SOLUTION

avatar
Master Mentor

@Dmitro Vasilenko

Most of the configuration version related info and changes (config history) are maintained inside the Ambari DB.

For example some of the tables like "clusterconfig" contains the various config informations like core-site / hdfs-site type informations.
Similarly another inportant table is "hostcomponentdesiredstate" which contains the state information about various components like NAMENODE/DATANODE ..ect on

The "servicecomponentdesiredstate" is another important table which shows all the components/Services installed on cluster and their desired state.

View solution in original post

4 REPLIES 4

avatar
Master Mentor

@Dmitro Vasilenko

Most of the configuration version related info and changes (config history) are maintained inside the Ambari DB.

For example some of the tables like "clusterconfig" contains the various config informations like core-site / hdfs-site type informations.
Similarly another inportant table is "hostcomponentdesiredstate" which contains the state information about various components like NAMENODE/DATANODE ..ect on

The "servicecomponentdesiredstate" is another important table which shows all the components/Services installed on cluster and their desired state.

avatar
Expert Contributor

Thanks you !

But I do not see this tables in postgres database:

postgres=# \connect ambari
You are now connected to database "ambari" as user "postgres".
ambari=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges
-----------+----------+----------+-------------+-------------+------------------------
 ambari    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres          +
           |          |          |             |             | postgres=CTc/postgres +
           |          |          |             |             | ambari=CTc/postgres
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 ranger    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =Tc/postgres          +
           |          |          |             |             | postgres=CTc/postgres +
           |          |          |             |             | rangerdba=CTc/postgres
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres           +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres           +
           |          |          |             |             | postgres=CTc/postgres
(5 rows)


ambari=#  \dt[S+]
                                 List of relations
   Schema   |          Name           | Type  |  Owner   |    Size    | Description
------------+-------------------------+-------+----------+------------+-------------
 pg_catalog | pg_aggregate            | table | postgres | 40 kB      |
 pg_catalog | pg_am                   | table | postgres | 40 kB      |
 pg_catalog | pg_amop                 | table | postgres | 64 kB      |
 pg_catalog | pg_amproc               | table | postgres | 56 kB      |
 pg_catalog | pg_attrdef              | table | postgres | 64 kB      |
 pg_catalog | pg_attribute            | table | postgres | 784 kB     |
 pg_catalog | pg_auth_members         | table | postgres | 0 bytes    |
 pg_catalog | pg_authid               | table | postgres | 40 kB      |
 pg_catalog | pg_cast                 | table | postgres | 48 kB      |
 pg_catalog | pg_class                | table | postgres | 192 kB     |
 pg_catalog | pg_collation            | table | postgres | 256 kB     |
 pg_catalog | pg_constraint           | table | postgres | 120 kB     |
 pg_catalog | pg_conversion           | table | postgres | 56 kB      |
 pg_catalog | pg_database             | table | postgres | 8192 bytes |
 pg_catalog | pg_db_role_setting      | table | postgres | 16 kB      |
 pg_catalog | pg_default_acl          | table | postgres | 0 bytes    |
 pg_catalog | pg_depend               | table | postgres | 560 kB     |
 pg_catalog | pg_description          | table | postgres | 280 kB     |
 pg_catalog | pg_enum                 | table | postgres | 0 bytes    |
 pg_catalog | pg_extension            | table | postgres | 40 kB      |
 pg_catalog | pg_foreign_data_wrapper | table | postgres | 0 bytes    |
 pg_catalog | pg_foreign_server       | table | postgres | 0 bytes    |
 pg_catalog | pg_foreign_table        | table | postgres | 0 bytes    |
 pg_catalog | pg_index                | table | postgres | 104 kB     |
 pg_catalog | pg_inherits             | table | postgres | 0 bytes    |
 pg_catalog | pg_language             | table | postgres | 40 kB      |
 pg_catalog | pg_largeobject          | table | postgres | 0 bytes    |
 pg_catalog | pg_largeobject_metadata | table | postgres | 0 bytes    |
 pg_catalog | pg_namespace            | table | postgres | 40 kB      |
 pg_catalog | pg_opclass              | table | postgres | 48 kB      |
 pg_catalog | pg_operator             | table | postgres | 144 kB     |
 pg_catalog | pg_opfamily             | table | postgres | 48 kB      |
 pg_catalog | pg_pltemplate           | table | postgres | 40 kB      |
 pg_catalog | pg_proc                 | table | postgres | 536 kB     |
 pg_catalog | pg_range                | table | postgres | 40 kB      |
 pg_catalog | pg_rewrite              | table | postgres | 496 kB     |
 pg_catalog | pg_seclabel             | table | postgres | 8192 bytes |
 pg_catalog | pg_shdepend             | table | postgres | 48 kB      |
 pg_catalog | pg_shdescription        | table | postgres | 48 kB      |
 pg_catalog | pg_shseclabel           | table | postgres | 0 bytes    |
 pg_catalog | pg_statistic            | table | postgres | 872 kB     |
 pg_catalog | pg_tablespace           | table | postgres | 40 kB      |
 pg_catalog | pg_trigger              | table | postgres | 160 kB     |
 pg_catalog | pg_ts_config            | table | postgres | 40 kB      |
 pg_catalog | pg_ts_config_map        | table | postgres | 48 kB      |
 pg_catalog | pg_ts_dict              | table | postgres | 40 kB      |
 pg_catalog | pg_ts_parser            | table | postgres | 40 kB      |
 pg_catalog | pg_ts_template          | table | postgres | 40 kB      |
 pg_catalog | pg_type                 | table | postgres | 160 kB     |
 pg_catalog | pg_user_mapping         | table | postgres | 0 bytes    |
(50 rows)


ambari=#


avatar
Master Mentor

@Dmitro Vasilenko

You will need to check the "/etc/ambari-server/conf/ambari.properties" to know which Postrgres instance it is connecting to? And also it is also possible that a user can use the database name other than "ambari" so the following grep command will help in knowing that ambari server is setup to connect to which DB and what is the database name & DB Host.

#  grep 'jdbc' /etc/ambari-server/conf/ambari.properties

.

In case of Embedded Postgres Mode the ambari server creates the DB and the tables on it's own when we run the "ambari-server setup" command.

But in case of non default Database we need to manually create the tables as described in. https://docs.hortonworks.com/HDPDocuments/Ambari-2.6.1.5/bk_ambari-administration/content/ch_amb_ref...

avatar
Expert Contributor

Hi! finded this tables!

Thank you!