You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "ASF GitHub Bot (Jira)" <ji...@apache.org> on 2022/10/21 19:37:00 UTC
[jira] [Commented] (DRILL-8341) Add Scanned Plugin List to Sys Profiles Table
[ https://issues.apache.org/jira/browse/DRILL-8341?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17622445#comment-17622445 ]
ASF GitHub Bot commented on DRILL-8341:
---------------------------------------
cgivre opened a new pull request, #2690:
URL: https://github.com/apache/drill/pull/2690
# [DRILL-8341](https://issues.apache.org/jira/browse/DRILL-8341): Add Scanned Plugin List to Sys Profiles Table
## Description
In [DRILL-8322](https://issues.apache.org/jira/browse/DRILL-8322), @jnturton added the list of scanned plugins to the query profiles. This information is extremely useful in query analysis. This minor PR adds this same information to the sys.profiles table.
## Documentation
Adds two fields to the `sys.profiles` table:
* `pluginCount`: Returns the number of plugins scanned in the query
* `pluginList`: Returns the actual plugins. Note this is a JSON String, not an actual list.
## Testing
Tested manually.
```
apache drill> select pluginCount, pluginList, query from sys.profiles limit 2;
+-------------+------------+------------------------------------+
| pluginCount | pluginList | query |
+-------------+------------+------------------------------------+
| 1 | [sys] | select * from sys.profiles limit 2 |
| 0 | [] | show files in dfs.test |
+-------------+------------+------------------------------------+
```
> Add Scanned Plugin List to Sys Profiles Table
> ---------------------------------------------
>
> Key: DRILL-8341
> URL: https://issues.apache.org/jira/browse/DRILL-8341
> Project: Apache Drill
> Issue Type: Improvement
> Components: Execution - Monitoring
> Affects Versions: 1.20.2
> Reporter: Charles Givre
> Assignee: Charles Givre
> Priority: Minor
> Fix For: 2.0.0
>
>
> In DRILL-8322, [~dzamo] added the list of scanned plugins to the query profiles. This information is extremely useful in query analysis. This minor PR adds this same information to the sys.profiles table.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)