docs/sql-manual/sql-statements/Show-Statements/SHOW-RESOURCES.md

{ “title”: “SHOW-RESOURCES”, “language”: “en” }

SHOW-RESOURCES

Name

SHOW RESOURCES

Description

This statement is used to display resources that the user has permission to use. Ordinary users can only display resources with permission, and root or admin users will display all resources.

grammar:

SHOW RESOURCES
[
  WHERE
  [NAME [ = "your_resource_name" | LIKE "name_matcher"]]
  [RESOURCETYPE = ["SPARK"]]
] | [LIKE "pattern"]
[ORDER BY...]
[LIMIT limit][OFFSET offset];

illustrate:

If NAME LIKE is used, it will match Resource whose Name contains name_matcher in RESOURCES
If NAME = is used, it will match the specified Name exactly
If RESOURCETYPE is specified, match the corresponding Resrouce type
You can use ORDER BY to sort on any combination of columns
If LIMIT is specified, limit matching records are displayed. Otherwise show all
If OFFSET is specified, the query results are displayed starting at offset offset. By default the offset is 0.
If using LIKE, the WHERE clause will be ignored.

Example

Display all resources that the current user has permissions to
```
SHOW RESOURCES;
```
Display the specified Resource, the name contains the string “20140102”, and display 10 attributes
```
SHOW RESOURCES WHERE NAME LIKE "2014_01_02" LIMIT 10;
```
Display the specified Resource, specify the name as “20140102” and sort by KEY in descending order
```
SHOW RESOURCES WHERE NAME = "20140102" ORDER BY `KEY` DESC;
```
Using LIKE to match the resource
```
SHOW RESOURCES LIKE "jdbc%";
```

Keywords