Basic Guide for Using Apache Doris

Apache Doris, originally named Palo, is a distributed relational database based on column storage and MPP architecture. It offers a high performance, reliable, and scalable solution for data storage and analysis. Here is a basic guide to using Apache Doris.

1. To install and configure Doris, first download the installation package and unzip it. Then, in the unzipped directory, locate the “conf” folder and edit the “doris_fe.conf” and “doris_be.conf” files to configure parameters such as the listening address, port, storage directory, etc.
2. To start Doris: in the directory after decompression, run the command bin/start_fe.sh to start the frontend service. Next, run the command bin/start_be.sh on each backend node to start the backend service.
3. Create Database: Use Doris’ command line tool ‘doris’ to create a database. For example, use the command ‘doris create database test’ to create a database named test.
4. Create a table using Doris’s command line tool ‘doris’ command. For example, execute the command ‘doris -d test -e “create table t (id int, name varchar(20))”‘ to create a table named ‘t’ with two fields – id and name.
5. Load data: Use Doris’s command line tool, the doris command, to load data into a table. For example, by running the command “doris -d test -e ‘load data inpath ‘path/to/data.txt’ into table t'”, the data file data.txt will be loaded into table t.
6. Query data: Utilize Doris’s command-line tool to query data with the command “doris -d test -e “select * from t” to retrieve all data from table t.
7. Update data: Use Doris command line tool ‘doris’ to modify data. For example, running the command ‘doris -d test -e “update t set name=‘newname’ where id=1″‘ will change the name field of the data with id 1 to ‘newname’.
8. Delete data: Use the Doris command line tool “doris” to remove data. For example, run the command “doris -d test -e “delete from t where id=1″” to delete data with id 1.
9. Optimize table: Improve the storage and query performance of a table using the Doris command-line tool, doris command. For example, running the command “doris -d test -e “optimize table t”” will optimize table t.
10. Stop Doris: In the directory after decompression, run the command bin/stop_fe.sh to stop the front-end service. Then, run the command bin/stop_be.sh on each backend node to stop the backend service.

This is a basic guide for using Apache Doris, where you can perform operations and configurations according to your specific needs. However, this is just a simple introduction. If you want to delve deeper into using Doris, you can refer to the official documentation or other related materials.