Databend 产品月报（2024 年 9 月）

CREATE DICTIONARY order_dict(    order_id INT,    customer_name STRING,    order_total INT)PRIMARY KEY order_idSOURCE(MYSQL(    host='mysql'    port='3306'    username='root'    password='admin'    db='dict'    table='orders'));

-- Set a variable to use as a filter valueSET VARIABLE threshold = 100;
-- Use the variable in a query with $SELECT * FROM sales WHERE amount > $threshold;
-- Alternatively, use the getvariable() functionSELECT * FROM sales WHERE amount > getvariable('threshold');

-- Create a table with sales dataCREATE TABLE sales_data (region TEXT, sales_amount INT, month TEXT) AS SELECT 'North', 5000, 'January' UNION ALLSELECT 'South', 3000, 'January';
select * from sales_data;
-- Set variables for the table name and column nameSET VARIABLE table_name = 'sales_data';SET VARIABLE column_name = 'sales_amount';
-- Use IDENTIFIER to dynamically reference the table and column in the querySELECT region, IDENTIFIER($column_name) FROM IDENTIFIER($table_name) WHERE IDENTIFIER($column_name) > 4000;

CALL SYSTEM$FUSE_AMEND('<database_name>', '<table_name>');

SELECT ...FROM <stream_name> WITH (<hint1> = <value1>[, <hint2> = <value2>, ...])

-- Retrieve all task history recordsSELECT *FROM TASK_HISTORY() order by scheduled_time;
-- Retrieve the task history records where the scheduled time range starts at '2022-01-02T01:12:00-07:00' and ends at '2022-01-02T01:12:30-07:00'.SELECT *  FROM TASK_HISTORY(    SCHEDULED_TIME_RANGE_START=>TO_TIMESTAMP('2022-01-02T01:12:00-07:00'),    SCHEDULED_TIME_RANGE_END=>TO_TIMESTAMP('2022-01-02T01:12:30-07:00'));

CREATE ROLE billing;