mysql 列式数据库

-- 创建一个示例表
CREATE TABLE sales (
    id INT PRIMARY KEY,
    product_id INT,
    sale_date DATE,
    quantity INT,
    price DECIMAL(10, 2)
);

-- 插入大量数据（省略插入数据的代码）

-- 查询某个产品的总销售额
SELECT product_id, SUM(quantity * price) AS total_sales
FROM sales
WHERE sale_date BETWEEN '2022-01-01' AND '2022-12-31'
GROUP BY product_id;

-- 创建一个ClickHouse表
CREATE TABLE sales (
    id UInt32,
    product_id UInt32,
    sale_date Date,
    quantity UInt32,
    price Decimal(10, 2)
) ENGINE = MergeTree()
ORDER BY (product_id, sale_date);

-- 插入数据（省略插入数据的代码）

-- 查询某个产品的总销售额
SELECT product_id, SUM(quantity * price) AS total_sales
FROM sales
WHERE sale_date BETWEEN '2022-01-01' AND '2022-12-31'
GROUP BY product_id;