Activating Query Optimizer Manager
To enable Query Optimizer in IBM® watsonx.data, you must activate Query Optimizer Manager through the web console.
Before you begin
To enable Query Optimizer, make sure at least one Presto (C++) engine is provisioned and active within your watsonx.data instance.
Procedure
-
Log in to watsonx.data console.
-
From the navigation menu, select Configurations and click Query Optimizer Manager tile.
-
Click Activate and confirm the activation and restarting of the engines in the Activate query optimizer window.
Query Optimizer takes approximately 20 minutes to deploy and sync over metadata for all Hive catalogs and schemas. This time may vary based on the metadata size to be synced.
Verify that all expected tables have been synced. If tables are found missing during the automatic syncing process, you can manually sync the tables. See Manually syncing Query Optimizer.
You can click Cancel activation to cancel the deployment of Query Optimizer Manager during the deployment.