Zhiyong Liu created DRILL-2275:
----------------------------------
Summary: need implementations of sys tables for drill memory and
threads profiles
Key: DRILL-2275
URL: https://issues.apache.org/jira/browse/DRILL-2275
Project: Apache Drill
Issue Type: Task
Components: Functions - Drill
Reporter: Zhiyong Liu
Assignee: Chris Westin
Priority: Critical
In order to check drill state information, the following tables are to be
implemented:
1. Memory: a query such as
select * from sys.drillmemory;
should return a result set like the following:
+------------+------------+--------------+------------+------------+
| drillbit | total_sys_memory |heap_size | direct_alloc_memory |
+------------+------------+--------------+------------+------------+
| node1:port1 | 24596676k | 15200420k | 1012372k |
+------------+------------+--------------+------------+------------+
| node2:port2 | 24596676k | 15200420k | 2012372k |
+------------+------------+--------------+------------+------------+
2. Threads:
For each node in a cluster, we need counts of threads of the drillbits. A
query like this:
select * from sys.drillbitthreads;
should return a result set like the following:
+------------+------------+--------------+------------+------------+
| drillbit | pool_name | total_threads | busy_threads |
+------------+------------+--------------+------------+------------+
| node1:port1 | pool1 | 8 | 2 |
+------------+------------+--------------+------------+------------+
| node2:port2 | pool2 | 10 | 5 |
+------------+------------+--------------+------------+------------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
