Trying Starburst Enterprise on any Linux #
You can install Starburst Enterprise platform (SEP) on any 64-bit Linux distribution with the following steps:
- Obtain the most recent SEP
tar.gz
archive - Unpack the archive as root
- Add configuration files
- Start the SEP server
- Obtain the Presto CLI client and run tests
Prerequisites #
Starburst Enterprise requires a Linux distribution that:
- Is no more than a few years old
- Runs on 64-bit Intel hardware
- Has Python 2.7 or later (only needed to run the
launcher
utility) - Has Java 11.0.7 or a later Java 11 LTS release from OpenJDK, Oracle, or Azul Java distributions. (Newer Java releases may work but are not tested.)
(SEP also installs for evaluation purposes only on a macOS release with the same prerequisites.)
Download an SEP archive #
To gain access to SEP archives, visit the Starburst website and click either the Get Started or Start Free buttons.
This opens a dialog that prompts for your name, email address, and location. Fill out the form using a valid email address, then click Free Download.
A few moments later, you receive email from Starburst with a link to the downloads page.
The Downloads page is organized into Long-Term and Short-Term Support sections. Choose an LTS edition.
Download the tar.gz
file from the All Platforms LTS link.
Download the Presto CLI JAR file #
While you’re on the download page described above, download the
Presto CLI client JAR file that matches the version of the server
you downloaded. That is, download the file whose name ends with
executable.jar
. We will take advantage of this file later.
Unpack the archive #
The contents of the tar.gz
archive are by default owned by root. Select an
appropriate location and unpack the files as usual. (This page uses /usr/local
as the location.) For example:
cd /usr/local
sudo tar xvzf ~/Downloads/presto-server-nnn.tar.gz
where nnn is the version number you downloaded.
This creates a directory named the same as the basename of the tar.gz
file in
the current directory, such as starburst-server-nnn
. We refer to this as the
sep-root
directory.
Your site may have standards for running servers that includes not running as
root. If you do not want the SEP server to run as root, create a
user named sep
and change ownership to sep
of all files and directories in
the new sep-root
directory. Then log in as sep
to run the upcoming commands.
Inspect the new directory to find that it contains three directories:
bin
lib
plugin
Add configuration files #
Even the simplest Starburst Enterprise server must have a minimum set of
configuration files before it can start. Create a directory named etc
parallel
to bin
and lib
. Populate etc
with the following configuration files, using
contents suggested on Deploying Presto.
- node.properties
- Follow the sample in Node properties. For the node.properties line, the suggested value production has no special meaning; use any value, such as test.
- jvm.config
- Follow the sample in JVM config. Use the suggested text verbatim, except reduce
the
-XmX
value as appropriate for your test environment. - config.properties
- Follow the sample in Config properties. Use the third suggestion for a combined coordinator and worker machine.
- catalog.properties
- Follow the sample in
Catalog properties. Create a subdirectory
catalog
underetc
. In there, create at least one file for each data source. To start with, create a file namedtpch.properties
with the following s contents is the single line:connector.name=tpch
Alternate configuration files #
Another way to get started quickly is to use the set of configuration files provided as examples for the O’Reilly book Presto: The Definitive Guide.
To use these ready-to-use configuration files, download the samples from their
GitHub location
either as a zip file or a git clone. Let’s say you place your clone or unzip
directory in ~/bookfiles
.
From bookfiles
, copy the entire etc
directory from the single-installation
sample folder to your sep-root
directory. For example:
cd ~/bookfiles/single-installation
sudo rsync -av etc /usr/local/starburst-server-nnn/
Start the server #
Once configuration files are in place, start the server. From the sep-root
directory, run the following command:
sudo bin/launcher start
For a successful server start, the launcher script returns a process ID.
For a sep-root
directory in which you changed file and subdirectory ownership,
you can drop the sudo
or use sudo -U sep
to run bin/launcher
.
Verify the server #
To verify that your locally-run server is operating as expected, invoke the Presto UI as described in Verify the server.
Run queries #
To run queries against your server, use the Presto CLI as described in CLI.