[
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)
