apache doris sql 语法

apache doris sql 语法
Apache Doris（即Palo）是一个基于MPP架构的实时数据分析型数据库系统，其SQL语法兼容MySQL的基本语句，并在此基础上扩展了适应于大数据分析的功能。

以下是一些基本的Apache Doris SQL语法示例：
1、创建表：
sql
CREATE TABLE employees (
id INT PRIMARY KEY,
name STRING,
age INT,
department STRING,
join_date DATE,
salary DOUBLE
) DUPLICATE KEY(id) DISTRIBUTED BY HASH(`department`) BUCKETS 32;
2、插入数据：
sql
INSERT INTO employees (id, name, age, department, join_date, salary)
VALUES (1, 'Alice', 30, 'Sales', '2022-01-01', 50000),
(2, 'Bob', 35, 'HR', '2021-05-15', 60000);
3、查询数据：
sql
SELECT * FROM employees;
SELECT name, salary FROM employees WHERE department = 'Sales';
4、聚合操作：
sql
SELECT department, AVG(salary) as avg_salary FROM employees GROUP BY department;
5、连接查询：
sql
假设有另一个departments表
SELECT , d.department_name FROM employees e JOIN departments d ON
e.department = d.department_code;
6、窗口函数：
sql
SELECT id, name, salary,
RANK() OVER (ORDER BY salary DESC) as salary_rank
FROM employees;
7、分区表：
sql
CREATE TABLE sales_data (
order_id BIGINT,
product STRING,
sale_date DATE,
amount DOUBLE
) PARTITION BY RANGE(sale_date) (
PARTITION p2021 VALUES LESS THAN ('2022-01-01'),
PARTITION p2022 VALUES LESS THAN ('2023-01-01')
);
请注意，上述语法只是Doris SQL支持的部分功能。