Mailing-List: contact dev-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
From: StevenMPhillips <git@git.apache.org>
To: dev@drill.apache.org
Reply-To: dev@drill.apache.org
Message-ID: <git-pr-479-drill@git.apache.org>
Subject: [GitHub] drill pull request: DRILL-4258: Add threads, fragments,
 and querie...
Content-Type: text/plain
Date: Thu, 14 Apr 2016 18:37:22 +0000 (UTC)

GitHub user StevenMPhillips opened a pull request:

    https://github.com/apache/drill/pull/479

    DRILL-4258: Add threads, fragments, and queries system tables

    Here are the pojos that represent the data for the new system tables:
    
    ```java
      public static class FragmentInfo {
        public String hostname;
        public String queryId;
        public int majorFragmentId;
        public int minorFragmentId;
        public Long memoryUsage;
        /**
         * The maximum number of input records across all Operators in fragment
         */
        public Long rowsProcessed;
        public Timestamp startTime;
      }
    ```
    
    ```java
      public static class ThreadSummary {
        /**
         * The Drillbit hostname
         */
        public String hostname;
    
        /**
         * The Drillbit user port
         */
        public long user_port;
        public String threadName;
        public long threadId;
        public boolean inNative;
        public boolean suspended;
        public String threadState;
        /**
         * Thread cpu time during last second. Between 0 and 100
         */
        public Integer cpuTime;
        /**
         * Thread user cpu time during last second. Between 0 and 100
         */
        public Integer userTime;
        public String stackTrace;
      }
    ```
    
    ```java
      public static class QueryInfo {
        /**
         * The host where foreman is running
         */
        public String foreman;
        /**
         * User who submitted query
         */
        public String user;
        public String queryId;
        /**
         * Query sql string
         */
        public String query;
        public Timestamp startTime;
      }
    ```
    
    I did not include data in the query table which can be obtained from the fragments table and doing a join on the queryId.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/StevenMPhillips/drill drill-4258

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/drill/pull/479.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #479
    
----
commit c99fffd5f091bcea17d8a0248c22094ed90ca86d
Author: Steven Phillips <steven@dremio.com>
Date:   2016-04-14T18:27:46Z

    DRILL-4258: Add threads, fragments, and queries system tables

----


---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---