The SHOW SQL_FEDERATION RULE syntax is used to query the federated query configuration.
ShowSQLFederationRule ::=
'SHOW' 'SQL_FEDERATION' 'RULE'
| Column | Description |
|---|---|
| sql_federation_enabled | Whether the selected provider enables SQL federation |
| all_query_use_sql_federation | all query use SQL federation configuration |
| execution_plan_cache | execution plan cache configuration |
| provider_type | Selected SQL federation provider type |
SHOW SQL_FEDERATION RULE;
mysql> show sql_federation rule;
+------------------------+------------------------------+-------------------------------------------+---------------+
| sql_federation_enabled | all_query_use_sql_federation | execution_plan_cache | provider_type |
+------------------------+------------------------------+-------------------------------------------+---------------+
| true | false | initialCapacity: 2000, maximumSize: 65535 | CALCITE |
+------------------------+------------------------------+-------------------------------------------+---------------+
1 row in set (0.31 sec)
SHOW、SQL_FEDERATION、RULE