The Regatta Command-Line Interface (CLI) provides a quick and convenient way to manage and query your Regatta database. You’ll need:

  1. Valid user credentials
  2. Network access to an active Regatta cluster

Installation

Copy the Regatta Connect RPM package to your target Linux machine and install it:

yum install ./regatta-connect-<version>.el7.x86_64.rpm

Verify the CLI binary is installed:

ls /opt/regatta/1.0/connect/cli/bin/client_cli

You should see:

/opt/regatta/<version>/connect/cli/bin/client_cli

Launch the CLI

Start the client:

/opt/regatta/1.0/connect/cli/bin/client_cli

You’ll see the prompt:

rdb>

Connect to Your Cluster

Authenticate with your credentials and cluster address:

rdb>\connect user=admin pass=RegattaDefault1234! url=aaa.bbb.ccc.ddd:ppp

On success, you’ll see:

Successfully connected to cluster 

NOTE: From this point forward the rdb> prompt will be omitted.

Table Management

Create a Table

Let’s create an employees table:

CREATE TABLE employees (
  employee_key INT PRIMARY KEY INDEX,
  employee_name VARCHAR(40) NOT NULL,
  employee_salary INT,
  employee_department VARCHAR(50) NOT NULL);

If successful:

statement executed successfully 

Verify with:

SHOW TABLES;
| TABLE_NAME    | IS_READY | PRIMARY_KEY_COLUMN | DEVICES |
-----------------------------------------------------------
| employees     | true     | employee_key       | m10d1   |

Insert Data

Insert multiple rows:

INSERT INTO employees (
  employee_key,
  employee_name,
  employee_salary,
  employee_department)
VALUES 
  (1,'John Doe', 10932, 'DevOps'),    
  (2,'Richard Roe', 18324, 'Legal'),
  (3,'Jane Roe', 20411, 'SoftwareDev'),
  (4,'Rachel Roe', 19555, 'Support');
statement executed successfully  

Query Data

Select all records:

SELECT * from employees;
statement executed successfully
| employee_key | employee_name | employee_salary | employee_department |
------------------------------------------------------------------------
|            1 | John Doe      |           10932 | DevOps              |
|            2 | Richard Roe   |           18324 | Legal               |
|            3 | Jane Roe      |           20411 | SoftwareDev         |
|            4 | Rachel Roe    |           19555 | Support             |

Filter with a WHERE clause:

SELECT employee_name, employee_salary
FROM employees
WHERE employee_salary > 18324;
statement executed successfully
| employee_name | employee_salary |
-----------------------------------
| Jane Roe      |           20411 |
| Rachel Roe    |           19555 |

Update Records

Give Richard Roe a raise:

UPDATE employees SET employee_salary=20202 WHERE employee_name='Richard Roe';

Re-run the previous SELECT to confirm:

statement executed successfully
| employee_name | employee_salary |
-----------------------------------
| Richard Roe   |           20202 |
| Jane Roe      |           20411 |
| Rachel Roe    |           19555 |

Delete Records

Remove the employee with the highest salary:

DELETE FROM employees
WHERE employee_salary = (
  SELECT MAX(employee_salary)
  FROM employees
);

Verify deletion:

statement executed successfully
| employee_name | employee_salary |
-----------------------------------
| Richard Roe   |           20202 |
| Rachel Roe    |           19555 |

Drop the Table

List tables:

SHOW TABLES;

This will present all the tables in the database:

| TABLE_NAME    | IS_READY | PRIMARY_KEY_COLUMN | DEVICES |
-----------------------------------------------------------
| employees     | true     | employee_key       | m10d1   |

Drop employees:

DROP TABLE employees;

Confirm it’s gone:

SHOW TABLES
statement executed successfully
| TABLE_NAME | IS_READY | PRIMARY_KEY_COLUMN | DEVICES | TABLE_METADATA |
-------------------------------------------------------------------------

Next Steps