SHOW-RESOURCES

Name

SHOW RESOURCES

Description

This statement is used to display resources that the user has the privilege to view. Only root or admin users can display all resources.

Syntax:

SHOW RESOURCES
[
  WHERE
  [NAME [ = "your_resource_name" | LIKE "name_matcher"]]
  [RESOURCETYPE = ["SPARK"]]
]
[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, it will match the corresponding Resrouce type
4. You can use ORDER BY to reorder 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 starting from the offset will be displayed. The default offset is 0.

Example

1. Display all resources that the current user has privileges to view

   SHOW RESOURCES;

2. Display the specified resources, of which the name contains the string "20140102", and display 10 properties of it

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

3. Display the specified resources, of which the name contains the string "20140102", and sort them by KEY in descending order

   SHOW RESOURCES WHERE NAME = "20140102" ORDER BY `KEY` DESC;

Keywords

SHOW, RESOURCES

Best Practice