Note
This view is available starting with V4.3.5 BP1.
Overview
Displays the list of plugins and their detailed information.
Columns
Nullable |
Type |
Nullable |
Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | Node address of the replica |
| SVR_PORT | bigint(20) | NO | Replica Port Number |
| NAME | varchar(64) | YES | Plugin name |
| STATUS | varchar(64) | YES | Plugin status:
|
| TYPE | varchar(80) | YES | Plugin type: FTPARSER (tokenization plugin) |
| LIBRARY | varchar(128) | YES | Plugin dynamic link library name (built-in plugins do not have a corresponding link library) |
| LIBRARY_VERSION | varchar(80) | YES | Version of the basic plugin library on which this plugin depends |
| LIBRARY_REVISION | varchar(80) | YES | Plugin Library Revision |
| INTERFACE_VERSION | varchar(80) | YES | The specific interface API version implemented by this plugin |
| AUTHOR | varchar(64) | YES | Plugin Author Information |
| LICENSE | varchar(64) | YES | Plugin License |
| DESCRIPTION | varchar(65535) | YES | Plugin Description |
Sample query
In the sys tenant, view the list of all plugins and their detailed information.
obclient [oceanbase]> SELECT * FROM oceanbase.GV$OB_PLUGINS;
The query result is as follows:
+-----------------+----------+--------+--------+----------+---------+-----------------+------------------+-------------------+-----------------------+------------+---------------------------------------------------------------------------------------------+
| SVR_IP | SVR_PORT | NAME | STATUS | TYPE | LIBRARY | LIBRARY_VERSION | LIBRARY_REVISION | INTERFACE_VERSION | AUTHOR | LICENSE | DESCRIPTION |
+-----------------+----------+--------+--------+----------+---------+-----------------+------------------+-------------------+-----------------------+------------+---------------------------------------------------------------------------------------------+
| xxx.xxx.xxx.128 | 2882 | ngram | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is a ngram fulltext parser plugin. |
| xxx.xxx.xxx.128 | 2882 | beng | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is a basic english parser plugin. |
| xxx.xxx.xxx.128 | 2882 | space | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is a default whitespace parser plugin. |
| xxx.xxx.xxx.128 | 2882 | ngram2 | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is a range ngram fulltext parser plugin.It is used to parse fulltext with range ngram. |
| xxx.xxx.xxx.128 | 2882 | ik | READY | FTPARSER | NULL | 0.0.1 | NULL | 0.2.0 | OceanBase Corporation | Apache 2.0 | This is an ik parser plugin. |
+-----------------+----------+--------+--------+----------+---------+-----------------+------------------+-------------------+-----------------------+------------+---------------------------------------------------------------------------------------------+
5 rows in set