HappenLee opened a new issue #4501:
URL: https://github.com/apache/incubator-doris/issues/4501
**Is your feature request related to a problem? Please describe.**
Now，we can use ```show resources``` to show all resource in doris
```
| Name | ResourceType | Key
| Value
|
+-----------------+--------------+-----------------------------------------------------+------------------------------------------------------------------------------------------+
| yarnbaidu2 | spark | spark.master
| yarn
|
| yarnbaidu2 | spark | spark.yarn.stage.dir
| /xuyang |
| yarnbaidu2 | spark | spark.yarn.dist.archives
| archives/spark-opensource-2.4.5.zip |
| yarnbaidu2 | spark | spark.hadoop.yarn.resourcemanager.address
| |
| yarnbaidu2 | spark | spark.submit.deployMode
| cluster
|
| yarnbaidu2 | spark | spark.hadoop.fs.defaultFS
| |
| yarnbaidu2 | spark | working_dir
| /user/xuyang/etl |
| yarnbaidu2 | spark | broker
| apache_doris
|
```
if there are many resource, it is difficult to find useful infomation of
resource, so we need support `where clause` in `show
resource`
the grammer like this:
```
Grammar
SHOW RESOURCES
[
WHERE
[NAME [ = "your_resource_name" | LIKE "name_matcher"]]
[RESOURCETYPE = ["SPARK"]]
]
[ORDER BY ...]
[LIMIT limit][OFFSET offset];
Explain：
1) If use NAME LIKE, the name of resource is matched to show.
2) If use NAME =, the specified name is exactly matched.
3) RESOURCETYPE is specified, the corresponding rerouce type is matched.
4) Use ORDER BY to sort any combination of columns.
5) If LIMIT is specified, limit matching records are displayed.
Otherwise, it is all displayed.
6) If OFFSET is specified, the query results are displayed starting with
the offset offset. The offset is 0 by default.
```
**Describe the solution you'd like**
change the `showresourcestmt` to support where, limit, order by clause.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
