[
https://issues.apache.org/jira/browse/DRILL-2275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Parth Chandra updated DRILL-2275:
---------------------------------
Component/s: (was: Functions - Drill)
Metadata
> 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: Metadata
> Reporter: Zhiyong Liu
> Assignee: Sudheesh Katkam
> Priority: Critical
> Fix For: 0.9.0
>
>
> 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)
