Hive Service layer

Using the tests associated with the Hive Service layer (see Figure 1), you can monitor the following:

  • Number of open/closed queries after query execution.

  • Number of open user sessions currently on the data warehouse.

  • Average time of open user sessions currently on the data warehouse.

  • Number of active user sessions currently on the data warehouse.

  • Average time of active user sessions currently on the data warehouse.

  • Number of abandoned user sessions currently on the data warehouse.

  • Number of queries that succeeded/failed.

  • Number of compiling/executing queries.

  • Number of submitted queries.

  • Number of queries waiting for compilation.

Figure 1 : The list of tests associated with the Hive Service layer