SHOW-RESOURCES
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
SHOW, RESOURCES