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:

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

Example

1. Display all resources that the current user has permissions to

   SHOW RESOURCES;

2. Display the specified Resource, the name contains the string "20140102", and display 10 attributes

   SHOW RESOURCES WHERE NAME LIKE "2014_01_02" LIMIT 10;

3. 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;

4. Using LIKE to match the resource

   SHOW RESOURCES LIKE "jdbc%";

Keywords

SHOW, RESOURCES

Best Practice