Provisioning a Presto (Java) engine
An engine in watsonx.data runs SQL queries on your data source and fetches the queried data. Presto (Java) is one of the engines supported in watsonx.data.
The versions of Presto (Java) supported depends on the watsonx.data versions. The following is the list of supported versions:
-
watsonx.data v1.0.0, v1.0.1 and v1.0.2: Presto (Java) version 0.279
-
watsonx.data v1.0.3, v1.1.1 and v1.1.3: Presto (Java) version 0.282
-
watsonx.data v1.1.4, v1.1.5: Presto (Java) version 0.285.1
-
watsonx.data v2.0.0: Presto (Java) version 0.286
To provision a Presto (Java) engine, complete the following steps.
-
Log in to watsonx.data console.
-
From the navigation menu, select Infrastructure manager.
-
Click Add component, select IBM Presto, and click Next.
-
In the Add component - IBM Presto window, provide the following details to sign up new compute to work with your data:
Provision engine Field Description Type Select the Presto (Java) (version) engine from the list. Display name Enter your compute engine name. Configuration mode Standard: Select Standard for predefined engine sizes: Starter: Includes 1 coordinator node and 1 worker node, both starter. Small: Includes 1 coordinator node and 3 worker nodes, all cache-optimized. Medium: Includes 1 coordinator node and 6 worker nodes, all cache-optimized. Large: Includes 1 coordinator node and 12 worker nodes, all cache-optimized. Custom: Select Custom for customized engine configuration: Coordinator nodes (max. 1): Select the run rate for coordinator node (you can have a maximum of 1 node). Worker nodes (max. 18): Select the number of worker nodes and run rate (you can have a maximum of 18 nodes). Associated catalogs (optional) Associate the available catalogs with the engine if necessary. HANA and MySQL catalogs do not display due to the Bring Your Own JAR (BYOJ) process. -
Click Create.
Related API
For information on related API, see