StarRocks Free SQL Client

StarRocks is an Open source, unified analytics platform for batch and real-time analytics. QStudio is a free SQL Client, it allows running SQL scripts, easy browsing of tables, charting and exporting of results. It works on every operating system, with every database including StarRocks.

Start StarRocks
Connecting to StarRocks
Querying StarRocks

Setting up a StarRocks connection in QStudio

Start StarRocks

StarRocks can either be ran locally or you can use CelerData StarRocks Cloud. To keep this tutorial simple we opted for cloud. Simply start a small cluster in your chosen region, including settings the username (admin) and password:

You can take the cloudformation URL that CelerData provides and paste it into AWS to generate your cluster:

Finally, find the EC2 instance for the starrocks frontend and note down the IP Address.

Connecting to a Server

StarRocks is mysql wire compatible.

When you first open QStudio or on the add server button on the toolbar.
Then set the details:

click on the menu options Server->Add Server
Server Type: mySQL
Host: is the IP address listed in AWS EC2
Port: 9030
Username: admin
Password: XXXXXXXXXXX (You set this when you created the cluster)
Click Add

Sending Queries

CREATE DATABASE IF NOT EXISTS load_test;
USE load_test;

CREATE TABLE IF NOT EXISTS source_wiki_edit
(
    event_time      DATETIME,
    channel         VARCHAR(32)      DEFAULT '',
    user            VARCHAR(128)     DEFAULT '',
    is_anonymous    TINYINT          DEFAULT '0',
    is_minor        TINYINT          DEFAULT '0',
    is_new          TINYINT          DEFAULT '0',
    is_robot        TINYINT          DEFAULT '0',
    is_unpatrolled  TINYINT          DEFAULT '0',
    delta           INT              DEFAULT '0',
    added           INT              DEFAULT '0',
    deleted         INT              DEFAULT '0'
)
DUPLICATE KEY(
    event_time,
    channel,user,
    is_anonymous,
    is_minor,
    is_new,
    is_robot,
    is_unpatrolled
)
PARTITION BY RANGE(event_time)(
    PARTITION p06 VALUES LESS THAN ('2015-09-12 06:00:00'),
    PARTITION p12 VALUES LESS THAN ('2015-09-12 12:00:00'),
    PARTITION p18 VALUES LESS THAN ('2015-09-12 18:00:00'),
    PARTITION p24 VALUES LESS THAN ('2015-09-13 00:00:00')
)
DISTRIBUTED BY HASH(user);

INSERT INTO source_wiki_edit
WITH LABEL insert_load_wikipedia
VALUES
    ("2015-09-12 00:00:00","#en.wikipedia","AustinFF",0,0,0,0,0,21,5,0),
    ("2015-09-12 00:00:00","#ca.wikipedia","helloSR",0,1,0,1,0,3,23,0);
    
SELECT * FROM source_wiki_edit LIMIT 100;

You can run queries by highlighting selected code and pressing Ctrl + q to run the current statement. See Keyboard Shortcuts.

Command	Shortcut
Run current statement	Ctrl + q
Run highlighted text	Ctrl + e
Run Line	Ctrl + Enter

This will update your various results panels, result contains your table (excel export etc. supported), charts are generated based on your data and the console summarizes your recent commands

SELECT * FROM source_wiki_edit LIMIT 100;

Well Done!

You have now got QStudio querying your database successfully.

We want to make QStudio the best SQL analysis tool. If you have any problems or want additional features, please post on our github repo.