Apache-doris-2.1.7-安装体验

软件下载：https://apache-doris-releases.oss-accelerate.aliyuncs.com/apache-doris-2.1.7-bin-x64.tar.gz

安装配置jdk环境：

tar -zxvf jdk-8u202-linux-x64.tar.gz -C /usr/local/
tee -a /etc/profile <<EOF
export JAVA_HOME=/usr/local/jdk1.8.0_202
export PATH=\$PATH:\$JAVA_HOME/bin
EOF
source /etc/profile
java -version

解压doris软件：

tar -zxvf apache-doris-2.1.7-bin-x64.tar.gz -C /usr/local/

关闭swap和修改limits.conf

 tee -a /etc/security/limits.conf <<EOF
* soft nofile 65536
* hard nofile 65536
EOF
sysctl -p
swapoff -a
sudo sed -i '/swap/s/^/#/' /etc/fstab

启动FE

[root@node1 fe]# ./bin/start_fe.sh --daemon
[root@node1 fe]# ps -ef | grep fe
root         66      2  0 Nov14 ?        00:00:00 [deferwq]
root       6659      1 99 01:05 pts/0    00:00:10 /usr/local/jdk1.8.0_202/bin/java -Dfile.encoding=UTF-8 -Djavax.security.auth.useSubjectCredsOnly=false -Xss4m -Xmx8192m -XX:+UnlockExperimentalVMOptions -XX:+UseG1GC -XX:MaxGCPauseMillis=200 -XX:+PrintGCDateStamps -XX:+PrintGCDetails -Xloggc:/usr/local/apache-doris-2.1.7-bin-x64/fe/log/fe.gc.log.20241115-010527 -Dlog4j2.formatMsgNoLookups=true -XX:-OmitStackTraceInFastThrow -XX:OnOutOfMemoryError=kill -9 %p org.apache.doris.DorisFE
root       6867   2388  0 01:05 pts/0    00:00:00 grep --color=auto fe
[root@node1 fe]#　　　　

启动BE

[root@node1 be]# ./bin/start_be.sh --daemon
Set max number of open file descriptors to a value greater than 60000.
Ask your system manager to modify /etc/security/limits.conf and append content like
  * soft nofile 655350
  * hard nofile 655350
and then run 'ulimit -n 655350' to take effect on current session.
[root@node1 be]# ulimit -n 655350
[root@node1 be]#
[root@node1 be]# ./bin/start_be.sh --daemon
[root@node1 be]#

连接FE需要使用mysql5.7客户端，只需要mysql客户端命令。

[root@node1 be]# mysql -uroot -P9030 -h127.0.0.1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 0
Server version: 5.7.99

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

['root'@127.0.0.1][(none)]>

注册BE到FE中

['root'@127.0.0.1][(none)]> ALTER SYSTEM ADD BACKEND "10.43.20.102:9050";
Query OK, 0 rows affected (0.09 sec)

['root'@127.0.0.1][(none)]>

查看BE，FE状态

['root'@127.0.0.1][(none)]> show proc '/frontends';
+-----------------------------------------+--------------+-------------+----------+-----------+---------+--------------------+----------+----------+------------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
| Name                                    | Host         | EditLogPort | HttpPort | QueryPort | RpcPort | ArrowFlightSqlPort | Role     | IsMaster | ClusterId  | Join | Alive | ReplayedJournalId | LastStartTime       | LastHeartbeat       | IsHelper | ErrMsg | Version                     | CurrentConnected |
+-----------------------------------------+--------------+-------------+----------+-----------+---------+--------------------+----------+----------+------------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
| fe_7dde06d2_96d7_4bcc_8c23_1d47da963ec1 | 10.43.20.102 | 9010        | 8030     | 9030      | 9020    | -1                 | FOLLOWER | true     | 1292288095 | true | true  | 129               | 2024-11-15 01:05:34 | 2024-11-15 01:13:15 | true     |        | doris-2.1.7-rc03-443e87e203 | Yes              |
+-----------------------------------------+--------------+-------------+----------+-----------+---------+--------------------+----------+----------+------------+------+-------+-------------------+---------------------+---------------------+----------+--------+-----------------------------+------------------+
1 row in set (0.14 sec)

['root'@127.0.0.1][(none)]> show proc '/backends';
+-----------+--------------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+
| BackendId | Host         | HeartbeatPort | BePort | HttpPort | BrpcPort | ArrowFlightSqlPort | LastStartTime       | LastHeartbeat       | Alive | SystemDecommissioned | TabletNum | DataUsedCapacity | TrashUsedCapacity | AvailCapacity | TotalCapacity | UsedPct | MaxDiskUsedPct | RemoteUsedCapacity | Tag                      | ErrMsg | Version                     | Status                                                                                                                        | HeartbeatFailureCounter | NodeRole |
+-----------+--------------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+
| 11072     | 10.43.20.102 | 9050          | 9060   | 8040     | 8060     | -1                 | 2024-11-15 01:07:15 | 2024-11-15 01:13:35 | true  | false                | 22        | 0.000            | 0.000             | 29.980 GB     | 45.775 GB     | 34.51 % | 34.51 %        | 0.000              | {"location" : "default"} |        | doris-2.1.7-rc03-443e87e203 | {"lastSuccessReportTabletsTime":"2024-11-15 01:12:52","lastStreamLoadTime":-1,"isQueryDisabled":false,"isLoadDisabled":false} | 0                       | mix      |
+-----------+--------------+---------------+--------+----------+----------+--------------------+---------------------+---------------------+-------+----------------------+-----------+------------------+-------------------+---------------+---------------+---------+----------------+--------------------+--------------------------+--------+-----------------------------+-------------------------------------------------------------------------------------------------------------------------------+-------------------------+----------+
1 row in set (0.00 sec)

搭建完成，修改连接密码：

['root'@127.0.0.1][(none)]> SET PASSWORD FOR 'root' = PASSWORD('doris-root-password');
Query OK, 0 rows affected (0.03 sec)

['root'@127.0.0.1][(none)]> SET PASSWORD FOR 'admin' = PASSWORD('doris-admin-password');
Query OK, 0 rows affected (0.00 sec)

创建数据库和表信息：

使用admin用户连接

[root@node1 be]# mysql -uadmin -P9030 -h127.0.0.1
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.7.99 Doris version doris-2.1.7-rc03-443e87e203

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

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

['admin'@127.0.0.1][(none)]> create database demo;
    k3 CHAR(10) COMMENT "string column",
    k4 INT NOT NULL DEFAULT "1" COMMENT "int column"
)
COMMENT "my first table"
DISTRIBUTED BY HASH(k1) BUCKETS 1
PROPERTIES ('replication_num' = '1');Query OK, 0 rows affected (0.01 sec)

['admin'@127.0.0.1][(none)]>
['admin'@127.0.0.1][(none)]> use demo;
Database changed
['admin'@127.0.0.1][demo]> create table mytable
    -> (
    ->     k1 TINYINT,
    ->     k2 DECIMAL(10, 2) DEFAULT "10.05",
    ->     k3 CHAR(10) COMMENT "string column",
    ->     k4 INT NOT NULL DEFAULT "1" COMMENT "int column"
    -> )
    -> COMMENT "my first table"
    -> DISTRIBUTED BY HASH(k1) BUCKETS 1
    -> PROPERTIES ('replication_num' = '1');
Query OK, 0 rows affected (0.02 sec)

创建语句：

create database demo;

use demo;

create table mytable
    (
         k1 TINYINT,
         k2 DECIMAL(10, 2) DEFAULT "10.05",
         k3 CHAR(10) COMMENT "string column",
         k4 INT NOT NULL DEFAULT "1" COMMENT "int column"
     )
     COMMENT "my first table"
     DISTRIBUTED BY HASH(k1) BUCKETS 1
     PROPERTIES ('replication_num' = '1');

构造导入数据

tee -a data.csv <<EOF
1,0.14,a1,20
2,1.04,b2,21
3,3.14,c3,22
4,4.35,d4,23
EOF

导入数据成功：

[root@node1 be]# curl  --location-trusted -u admin:doris-admin-password -T data.csv -H "column_separator:," http://127.0.0.1:8030/api/demo/mytable/_stream_load
{
    "TxnId": 3,
    "Label": "508a19a6-d202-468e-a24e-8cc63a6e4891",
    "Comment": "",
    "TwoPhaseCommit": "false",
    "Status": "Success",
    "Message": "OK",
    "NumberTotalRows": 4,
    "NumberLoadedRows": 4,
    "NumberFilteredRows": 0,
    "NumberUnselectedRows": 0,
    "LoadBytes": 52,
    "LoadTimeMs": 463,
    "BeginTxnTimeMs": 37,
    "StreamLoadPutTimeMs": 302,
    "ReadDataTimeMs": 0,
    "WriteDataTimeMs": 74,
    "ReceiveDataTimeMs": 344,
    "CommitAndPublishTimeMs": 46
}
[root@node1 be]#

　参考连接：https://doris.apache.org/docs/gettingStarted/quick-start/