Quickstart StarRocks on Mac laptop

Quickstart StarRocks on Mac laptop

Contents

Docker pull Centos

Prepare StarRocks tar bales

Initiate a docker container

Fix Java JDK

Deploy StarRocks-CE-2.0.1

TEST

---

Docker pull Centos

Install Docker on mac, refer to https://www.docker.com/get-startedPull Centos images as below:

(Zsh)simon@MBp16:~ %>docker pull centos:centos7                                                                                                                                                                                  
centos7: Pulling from library/centos
Digest: sha256:9d4bcbbb213dfd745b58be38b13b996ebb5ac315fe75711bd618426a630e0987
Status: Image is up to date for centos:centos7
docker.io/library/centos:centos7

Prepare StarRocks tar bales

(Zsh)simon@MBp16:~/private/repo/SR %>wget -SO StarRocks-2.0.1.tar.gz https://starrocks.com/en-US/download/request-download/12

(Zsh)simon@MBp16:~/private/repo/SR %>mkdir deploy                                                                                                                                                                              
(Zsh)simon@MBp16:~/private/repo/SR %>tar zxf StarRocks-2.0.1.tar.gz -C deploy

(Zsh)simon@MBp16:~/private/repo/SR %>pwd                                                                                                                                                                                          
/Users/simon/private/repo/SR

Initiate a docker container

(Zsh)simon@MBp16:~/private/repo/SR %>docker run -p 9030:9030 -p 8030:8030 -p 8040:8040  -v /Users/simon/private/repo/SR:/data --privileged=true   -itd --name centos-test centos:centos7                                          
b806e54486b0f76619d5b01e314d3ef59da05fb1980431adfffa4b4ff6407194
(Zsh)simon@MBp16:~/private/repo/SR %>docker ps                                                                                                                                                                                    
ConTAINER ID   IMAGE            COMMAND       CREATED          STATUS          PORTS                                                                                                                             NAMES
b806e54486b0   centos:centos7   "/bin/bash"   11 seconds ago   Up 10 seconds   0.0.0.0:8030->8030/tcp, :::8030->8030/tcp, 0.0.0.0:8040->8040/tcp, :::8040->8040/tcp, 0.0.0.0:9030->9030/tcp, :::9030->9030/tcp   centos-test
(Zsh)simon@MBp16:~/private/repo/SR %>


(Zsh)simon@MBp16:~/private/repo/SR %>docker exec -ti b8 bash 
[root@b806e54486b0 /]# cd /data/deploy/StarRocks-2.0.1/
[root@b806e54486b0 StarRocks-2.0.1]# ls
LICENSE.txt  NOTICE.txt  apache_hdfs_broker  be  fe  udf

Fix Java JDK

Note: yum installation is not necessary, you can also prepare jdk dist under your native Storage Volume and manually provision jdk environment.

[root@b806e54486b0 bin]# ./start_fe.sh --daemon
Error: JAVA_HOME is not set.


[root@b806e54486b0 bin]# yum -y install java-1.8.0-openjdk-devel.x86_64

[root@b806e54486b0 bin]# rpm -ql  java-1.8.0-openjdk-devel.x86_64 | grep bin$
/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64/bin

[root@b806e54486b0 bin]# /usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64/bin/java -version
openjdk version "1.8.0_312"
OpenJDK Runtime Environment (build 1.8.0_312-b07)
OpenJDK 64-Bit Server VM (build 25.312-b07, mixed mode)

[root@b806e54486b0 bin]# export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.312.b07-1.el7_9.x86_64

Deploy StarRocks-CE-2.0.1

[root@b806e54486b0 log]# cd /data/deploy/StarRocks-2.0.1/fe/
[root@b806e54486b0 fe]# mkdir -p meta
[root@b806e54486b0 fe]# cd bin/
[root@b806e54486b0 bin]# ./start_fe.sh --daemon
[root@b806e54486b0 bin]# jps
3713 Jps
3690 StarRocksFE

[root@b806e54486b0 be]# pwd
/data/deploy/StarRocks-2.0.1/be
[root@b806e54486b0 be]# mkdir -p storage
[root@b806e54486b0 be]# cd bin/
[root@b806e54486b0 bin]# ./start_be.sh --daemon
[root@b806e54486b0 bin]#

[root@b806e54486b0 bin]# ps aux |grep be |grep starrocks -i
root      2874  1.2  0.5 2865524 77336 pts/1   Sl   11:22   0:00 /data/deploy/StarRocks-2.0.1/be/lib/starrocks_be

NOTE: Connect to your StarRocks using a mysql-client or alternative tools like DBever, Navicat, Zepplin etc.

(Zsh)simon@MBp16:~ %>mysql -uroot -h127.0.0.1 -P 9030

mysql> show frontendsG
*************************** 1. row ***************************
             Name: 172.17.0.2_9010_1643196291015
               IP: 172.17.0.2
      EditLogPort: 9010
         HttpPort: 8030
        QueryPort: 9030
          RpcPort: 9020
             Role: FOLLOWER
         IsMaster: true
        ClusterId: 1909402098
             Join: true
            Alive: true
ReplayedJournalId: 13
    LastHeartbeat: 2022-01-26 11:25:32
         IsHelper: true
           ErrMsg:
        StartTime: 2022-01-26 11:25:03
          Version: 2.0.1-f0de9ec
1 row in set (0.01 sec)

mysql> alter system add backend '172.17.0.2:9050';
Query OK, 0 rows affected (0.02 sec)

mysql> show backendsG
*************************** 1. row ***************************
            BackendId: 10002
              Cluster: default_cluster
                   IP: 172.17.0.2
        HeartbeatPort: 9050
               BePort: 9060
             HttpPort: 8040
             BrpcPort: 8060
        LastStartTime: 2022-01-26 11:27:02
        LastHeartbeat: 2022-01-26 11:27:02
                Alive: true
 SystemDecommissioned: false
ClusterDecommissioned: false
            TabletNum: 0
     DataUsedCapacity: .000
        AvailCapacity: 16.960 GB
        TotalCapacity: 465.725 GB
              UsedPct: 96.36 %
       MaxDiskUsedPct: 96.36 %
               ErrMsg:
              Version: 2.0.1-f0de9ec
               Status: {"lastSuccessReportTabletsTime":"2022-01-26 11:27:02"}
    DataTotalCapacity: 16.960 GB
          DataUsedPct: 0.00 %
1 row in set (0.01 sec)

TEST

Note: replication =1 since we only play around single node

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.35 sec)