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.

1. Log in to watsonx.data console.

2. From the navigation menu, select Infrastructure manager.

3. Click Add component, select IBM Presto, and click Next.

4. 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.

5. Click Create.