[jira] [Commented] (DRILL-5068) Create a system table for completed profiles - sys.profiles

[ASF GitHub Bot (JIRA)]

    [ 
https://issues.apache.org/jira/browse/DRILL-5068?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16306452#comment-16306452
 ] 

ASF GitHub Bot commented on DRILL-5068:
---------------------------------------

Github user kkhatua commented on the issue:

    https://github.com/apache/drill/pull/1077
  
    @sohami 
    Applied the checks for security to deny unauthorized access.
    This is a screenshot with an admin user (`mapr`) querying the table.
    <img width="1440" alt="adminuser" 
src="https://user-images.githubusercontent.com/4335237/34444695-cbe7efd4-ec84-11e7-9bf1-e4b007c8a062.png";>
    
    This is a screenshot with a non-admin user (`kuser1`) querying the table.
    <img width="1440" alt="nonadminuser" 
src="https://user-images.githubusercontent.com/4335237/34444715-f7f0b85e-ec84-11e7-8fe1-bbed71e2d5ea.png";>



> Create a system table for completed profiles - sys.profiles
> -----------------------------------------------------------
>
>                 Key: DRILL-5068
>                 URL: https://issues.apache.org/jira/browse/DRILL-5068
>             Project: Apache Drill
>          Issue Type: Sub-task
>          Components: Storage - Information Schema
>    Affects Versions: 1.8.0
>         Environment: Fedora 25
> OpenJDK 8
> Firefox 50.0
>            Reporter: Hongze Zhang
>            Assignee: Kunal Khatua
>             Fix For: 1.13.0
>
>
> 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.4.14#64029)