SHOW PLUGINS OF SPI

Description

The SHOW PLUGINS OF interfaceClass syntax is used to query all the implementations of an interface.

Syntax

Grammar Railroad diagram

  1. showPluginImplementations ::=
  2.   'SHOW' 'PLUGINS' 'OF' interfaceClass
  4. interfaceClass ::=
  5.   string

Return Value Description

ColumnsDescription
typetype
type_aliasestype aliases
descriptiondescription

Example

  • Query all the implementations for org.apache.shardingsphere.sharding.spi.ShardingAlgorithm interface
  1. SHOW PLUGINS OF 'org.apache.shardingsphere.sharding.spi.ShardingAlgorithm'
  1. SHOW PLUGINS OF 'org.apache.shardingsphere.sharding.spi.ShardingAlgorithm';
  2. +----------------+--------------+-------------+
  3. | type           | type_aliases | description |
  4. +----------------+--------------+-------------+
  5. | MOD            |              |             |
  6. | HASH_MOD       |              |             |
  7. | VOLUME_RANGE   |              |             |
  8. | BOUNDARY_RANGE |              |             |
  9. | AUTO_INTERVAL  |              |             |
  10. | INTERVAL       |              |             |
  11. | CLASS_BASED    |              |             |
  12. | INLINE         |              |             |
  13. | COMPLEX_INLINE |              |             |
  14. | HINT_INLINE    |              |             |
  15. +----------------+--------------+-------------+
  16. 10 rows in set (0.52 sec)

Supplement

For some commonly used interface implementations, ShardingSphere provides syntax sugar functions to simplify operations.

The currently provided syntax sugar are as follows:

Reserved word

SHOW, PLUGINS, OF