Sclera Platform Administration Tool

Sclera is a stand-alone SQL processor with native support for machine learning, data virtualization and streaming data.

This tool installs Sclera as an independent application with an interactive command-line shell.

Prerequisite: Sclera requires Java 13 or higher.

We recommend against installing Sclera with root/admin permissions. Sclera does not need root access for installation or at runtime.

Usage

       scleradmin [-h] [--install] [--add plugin [plugin ...]]
                  [--remove plugin [plugin ...]] [--update] [--root rootdir]
                  [--overwrite]

Sclera Platform Administration

optional arguments:
  -h, --help            show this help message and exit
  --install             install Sclera in the root directory
  --add plugin [plugin ...]
                        add plugins
  --remove plugin [plugin ...]
                        remove plugins
  --update              update Sclera and installed plugins to the latest version
  --root rootdir        root directory location (if not specified, will use
                        $SCLERA_ROOT if present, otherwise ~/sclera)
  --overwrite           overwrite root directory if present

In --add and --remove above, 'plugin' has the format 'org:name:version', where
'org:' and ':version' are optional. When not specified, 'org' defaults to
'com.scleradb' and 'version' defaults to the latest installable version.

Sclera requires Java 13 or higher.

Installing Sclera Core Packages and Shell

The following command installs Sclera:

> scleradmin --install --root <sclera-root>

In the above, <sclera-root> is the directory where you want Sclera to be installed. This directory must not exist before installation, it is created by the command (this is a safeguard againt accidental overwrites). The contents of the directory after installation are described later in this document.

The installation involves downloading core sclera components and associated libraries. This might take a few minutes; you can monitor the progress by viewing the generated logs in <sclera-root>/install/log/install.log.

Using the Shell

The shell can be started using the following command:

> <sclera-root>/bin/sclera

This starts the shell, wherein you can interactively run queries. When done, you can terminate the session by typing Control-D.

Welcome to Sclera 4.0

> select "Hello, world!" as greeting;
---------------
 GREETING
---------------
 Hello, world!
---------------
(1 row)

> ^D
Goodbye!

For details on using the shell, please refer to the Command Line Shell Reference.

Root Directory Structure

After installation, the root directory has the following structure:

[<sclera-root>]
  bin/
    sclera.cmd         # executable command file (generated for Windows systems)
    sclera             # executable bash script (generated for Linux, macOS, and other Unix-based systems)
  config/
    sclera.conf        # configuration file
  extlib/              # directory for additional libraries, plugins (initially empty)
  home/
    assets/
      data/            # data stored by the embedded temporary database (H2), etc.
    history            # shell command history
    log/
      sclera.log       # execution log, contains details of runtime progress
  install/
    boot/              # specification files for sclera components (core or plugin)
    launcher*.jar      # SBT launcher, used for installing sclera components
    log/
      install.log      # installation log, contains details of installation progress
  lib/                 # installation artifacts (jars, etc.) of installed components and their dependencies

Plugin Management

Sclera provides a variety of plugins that can be added using scleradmin. The command syntax is:

> scleradmin --add <plugins> --root <sclera-root>

In the above, <plugins> is a space-separated list of plugins to be added, and <sclera-root>, as earlier, is the root directory. For instance, to add the Sclera - CSV File Connector and Sclera - Text File Connector plugins to the Sclera instance installed at /path/to/sclera, the command is:

> scleradmin --add sclera-csv-plugin sclera-textfiles-plugin --root /path/to/sclera

To remove installed plugins, the syntax is similar. The following command removes the plugins installed above:

> scleradmin --remove sclera-csv-plugin sclera-textfiles-plugin --root /path/to/sclera

You can specify a list of plugins to add and another list of plugins to remove in the same command.

For a list of available plugins and other components, please refer to the Sclera Documentation.

Updating Installed Packages and Plugins

The following command updates Sclera's core packages as well as the plugins to the latest version:

> scleradmin --update --root <sclera-root>

where <sclera-root>, as mentioned earlier, is the root directory.