在Docker中快速体验StarRocks 3.0.0环境

docker rm -f starrocks300
docker run -itd --name starrocks300 -h starrocks300 \
  -p 9031:9030 -p 8031:8030  \
  -v /sys/fs/cgroup:/sys/fs/cgroup \
  --privileged=true lhrbest/starrocks:3.0.0 \
  /usr/sbin/init

docker exec -it starrocks300 bash

/usr/local/starrocks/fe/bin/start_fe.sh --daemon
/usr/local/starrocks/be/bin/start_be.sh --daemon
/usr/local/starrocks/apache_hdfs_broker/bin/start_broker.sh --daemon

mysql -h 127.0.0.1 -P9030 -uroot

SHOW frontends \G

show  backends \G

show broker;

[root@starrocks300 /]# mysql -h 127.0.0.1 -P9030 -uroot
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.0 StarRocks version 2.5.3

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> SHOW frontends ;
+------------------------------+-----------+-------------+----------+-----------+---------+--------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+
| Name                         | IP        | EditLogPort | HttpPort | QueryPort | RpcPort | Role   | ClusterId  | Join | Alive | ReplayedJournalId | LastHeartbeat       | IsHelper | ErrMsg | StartTime           | Version       |
+------------------------------+-----------+-------------+----------+-----------+---------+--------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+
| 127.0.0.1_9010_1680064832570 | 127.0.0.1 | 9010        | 8030     | 9030      | 9020    | LEADER | 1723834094 | true | true  | 2536              | 2023-03-29 15:15:47 | true     |        | 2023-03-29 15:13:57 | 2.5.3-46bf084 |
+------------------------------+-----------+-------------+----------+-----------+---------+--------+------------+------+-------+-------------------+---------------------+----------+--------+---------------------+---------------+
1 row in set (0.02 sec)

MySQL [(none)]> show  backends;
+-----------+-----------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+
| BackendId | IP        | HeartbeatPort | BePort | HttpPort | BrpcPort | LastStartTime       | LastHeartbeat       | Alive | SystemDecommissioned | ClusterDecommissioned | TabletNum | DataUsedCapacity | AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | ErrMsg | Version       | Status                                                 | DataTotalCapacity | DataUsedPct | CpuCores | NumRunningQueries | MemUsedPct | CpuUsedPct |
+-----------+-----------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+
| 11001     | 127.0.0.1 | 9050          | 9060   | 8040     | 8060     | 2023-03-29 15:13:57 | 2023-03-29 15:15:52 | true  | false                | false                 | 79        | 27.525 KB        | 519.123 GB    | 1019.104 GB   | 49.06 % | 49.06 %        |        | 2.5.3-46bf084 | {"lastSuccessReportTabletsTime":"2023-03-29 15:14:58"} | 519.123 GB        | 0.00 %      | 16       | 0                 | 0.34 %     | 0.0 %      |
+-----------+-----------+---------------+--------+----------+----------+---------------------+---------------------+-------+----------------------+-----------------------+-----------+------------------+---------------+---------------+---------+----------------+--------+---------------+--------------------------------------------------------+-------------------+-------------+----------+-------------------+------------+------------+
1 row in set (0.01 sec)

MySQL [(none)]> show broker;
+-------------+-----------+------+-------+---------------------+---------------------+--------+
| Name        | IP        | Port | Alive | LastStartTime       | LastUpdateTime      | ErrMsg |
+-------------+-----------+------+-------+---------------------+---------------------+--------+
| broker_name | 127.0.0.1 | 8000 | true  | 2023-06-14 15:28:20 | 2023-06-14 15:40:31 |        |
+-------------+-----------+------+-------+---------------------+---------------------+--------+
1 row in set (0.01 sec)

MySQL [(none)]> 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| _statistics_       |
| example_db         |
| information_schema |
| lhrdb              |
| sbtest             |
+--------------------+
5 rows in set (0.08 sec)

CREATE DATABASE db1;

USE db1;

CREATE TABLE `sr_on_mac` (
 `c0` int(11) NULL COMMENT "",
 `c1` date NULL COMMENT "",
 `c2` datetime NULL COMMENT "",
 `c3` varchar(65533) NULL COMMENT ""
) ENGINE=OLAP 
DUPLICATE KEY(`c0`)
PARTITION BY RANGE (c1) (
  START ("2022-02-01") END ("2022-02-10") EVERY (INTERVAL 1 DAY)
)
DISTRIBUTED BY HASH(`c0`) BUCKETS 1 
PROPERTIES (
"replication_num" = "1",
"in_memory" = "false",
"storage_format" = "DEFAULT"
);


insert into sr_on_mac values (1, '2022-02-01', '2022-02-01 10:47:57', '111');
insert into sr_on_mac values (2, '2022-02-02', '2022-02-02 10:47:57', '222');
insert into sr_on_mac values (3, '2022-02-03', '2022-02-03 10:47:57', '333');


select * from sr_on_mac where c1 >= '2022-02-02';

mysql> select * from sr_on_mac where c1 >= '2022-02-02';
+------+------------+---------------------+------+
| c0   | c1         | c2                  | c3   |
+------+------------+---------------------+------+
|    3 | 2022-02-03 | 2022-02-03 10:47:57 | 333  |
|    2 | 2022-02-02 | 2022-02-02 10:47:57 | 222  |
+------+------------+---------------------+------+
2 rows in set (0.16 sec)