How to create spark and presto engines

Login to zetaris

click on compute engine tab

 

compute engine side screen will open. click on plus button.

Screen will open where details need to be filled. In that select presto or spark as engine. fill the driver cores and memory cores

 

Once all the details are filled. click on create

This will create a spark engine.

 

In order to run the query on this spark engine. you can either:

1. click on three dots and select “set as default” now all the query will run on this compute engine.

    

2. you can also select default from sql workplace screen. then any query you will run will be directed to newly created spark engine

    

3. also you can run query by execute by explicitly mentioning the new spark engine name

   1. SELECT * FROM TPCDS_DBA.call_center using spark mspark

To update engine configs you can click on three dots on right of spark engine and select “details”.

 

Then further select deatils tab where you can update the configs of engine.

 

“presto” engine can be created same as spark engine. all you have to do different is while creating select “presto engine”