Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Whrere is Ambari save info about avaliable Hadoop Frameworks ?

Solved Go to solution
Highlighted

Whrere is Ambari save info about avaliable Hadoop Frameworks ?

Contributor

In my case, ambari installed on postgres database

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Whrere is Ambari save info about avaliable Hadoop Frameworks ?

Super 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

Re: Whrere is Ambari save info about avaliable Hadoop Frameworks ?

Super 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

Highlighted

Re: Whrere is Ambari save info about avaliable Hadoop Frameworks ?

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=#


Highlighted

Re: Whrere is Ambari save info about avaliable Hadoop Frameworks ?

Super 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...

Highlighted

Re: Whrere is Ambari save info about avaliable Hadoop Frameworks ?

Contributor

Hi! finded this tables!

Thank you!

Don't have an account?
Coming from Hortonworks? Activate your account here