GET_DATA_COLLECTOR_NOTIFY_POLICY
列出在 数据收集器组件上设置的所有通知策略。
这是元函数。您必须在顶级 SELECT 语句中调用元函数。
行为类型
易变语法
GET_DATA_COLLECTOR_NOTIFY_POLICY('component')
- component
- 要检查其通知策略的数据收集器组件的名称。
查询系统表 DATA_COLLECTOR 的组件名称。例如：
=> SELECT DISTINCT component, description FROM data_collector WHERE component ilike '%Depot%' ORDER BY component; component | description ----------------+------------------------------- DepotEvictions | Files evicted from the Depot DepotFetches | Files fetched to the Depot DepotUploads | Files Uploaded from the Depot (3 rows)
示例
=> SELECT GET_DATA_COLLECTOR_NOTIFY_POLICY('LoginFailures');
GET_DATA_COLLECTOR_NOTIFY_POLICY
----------------------------------------------------------------------
Notifiable; Notifier: vertica_stats; Channel: vertica_notifications
(1 row)
以下示例显示了当组件未设置通知策略时函数的输出：
=> SELECT GET_DATA_COLLECTOR_NOTIFY_POLICY('LoginFailures');
GET_DATA_COLLECTOR_NOTIFY_POLICY
----------------------------------
Not notifiable;
(1 row)