@John Cod The Hive Metastore, also referred to as HCatalog is a relational database repository containing metadata about objects you create in Hive. When you create a Hive table, the table definition (column names, data types, comments, etc.) are stored in the Hive Metastore. This is automatic and simply part of the Hive architecture. The reason why the Hive Metastore is critical is because it acts as a central schema repository which can be used by other access tools like Spark and Pig. Additionally, through Hiveserver2 you can access the Hive Metastore using ODBC and JDBC connections. This opens the schema to visualization tools like PowerBi or Tableau. The only configuration you have to be concerned about is the initial install when you decide what relational database to use. The default is ProgresSQL but for production we recommend using Oracle or a system which is already being backed up and secured. Hope this helps. ... View more

@Bruce Perez Hi Bruce. I'm not certain this will answer your question but the widget's data you see is served to Ambari via REST API. All the metrics data is in the collector. Keep in mind Ambari is a framework and what you are seeing the in dashboard is an Ambari View. Its similar to any other view in Ambari. The dashboard is essentially a webpage. ... View more

@Abdus Sagir Mollah the designation of primary key is simply metadata describing the column. It doesn't apply any referential constraints. ... View more

@Pardeep Gorla The best place to start is here. http://hortonworks.com/hadoop-tutorial/loading-data-into-the-hortonworks-sandbox/. This is also good. http://hortonworks.com/hadoop-tutorial/how-to-process-data-with-apache-hive/. ... View more