[
https://issues.apache.org/jira/browse/DRILL-5068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15769388#comment-15769388
]
ASF GitHub Bot commented on DRILL-5068:
---------------------------------------
GitHub user zbdzzg reopened a pull request:
https://github.com/apache/drill/pull/668
DRILL-5068: Add a new system table for completed profiles
Add table "sys.profiles" for completed queries.
Following fields added:
1. queryID (String)
2. time (Timestamp)
3. latency (long)
4. user (String)
5. query (String)
6. state (String)
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/zbdzzg/drill profile_query
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/drill/pull/668.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 #668
----
commit e05a999dc8ace315966cbbdb72b3e52d3d956bbd
Author: hongze.zhz <[email protected]>
Date: 2016-12-22T07:47:42Z
DRILL-5068: Add a new system table for completed profiles
----
> Add a new system table for completed profiles
> ---------------------------------------------
>
> Key: DRILL-5068
> URL: https://issues.apache.org/jira/browse/DRILL-5068
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - Information Schema
> Affects Versions: 1.8.0
> Environment: Fedora 25
> OpenJDK 8
> Firefox 50.0
> Reporter: Hongze Zhang
> Assignee: Hongze Zhang
> Fix For: Future
>
>
> Hi,
> Currently the profile page on UI is still not detailed enough for some
> complicated uses (eg. show all failed queries during these three days), we
> can only access latest 100 query profiles on this page.
> We may sometimes need a specific system table for querying completed profiles.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
