[jira] [Created] (DRILL-2275) need implementations of sys tables for drill memory and threads profiles

["Zhiyong Liu (JIRA)" <ji...@apache.org>]

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)