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