mirror of
https://github.com/GreptimeTeam/greptimedb.git
synced 2026-01-03 20:02:54 +00:00
10ecc30817
* check partition for aggr plan Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * handle empty partition rule Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * remove CheckPartition option Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * add test Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * update some valid sqlness result Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * opt-out promql plan and update sqlness Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix limit Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix insert select subquery Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * update unit test result Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * fix typo Signed-off-by: Ruihang Xia <waynestxia@gmail.com> * Update src/query/src/dist_plan/analyzer.rs Co-authored-by: Yingwen <realevenyag@gmail.com> --------- Signed-off-by: Ruihang Xia <waynestxia@gmail.com> Co-authored-by: Yingwen <realevenyag@gmail.com>
96 lines
5.5 KiB
Plaintext
96 lines
5.5 KiB
Plaintext
create table completion(
|
|
ts timestamp time index,
|
|
model string primary key,
|
|
val double
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
insert into completion values
|
|
(0, 'model-a', 10),
|
|
(5000, 'model-b', 20),
|
|
(10000, 'model-a', 30);
|
|
|
|
Affected Rows: 3
|
|
|
|
create table prompt(
|
|
ts timestamp time index,
|
|
model string primary key,
|
|
val double
|
|
);
|
|
|
|
Affected Rows: 0
|
|
|
|
insert into prompt values
|
|
(0, 'model-a', 100),
|
|
(5000, 'model-b', 200),
|
|
(10000, 'model-a', 300);
|
|
|
|
Affected Rows: 3
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval(0, 10, '5s') sum(completion * 0.0015 / 1000) + sum(prompt / 1000 * 0.0015);
|
|
|
|
+---------------------+-----------------------------------------------------------------------------------------------------------+
|
|
| ts | completion.SUM(val * Float64(0.0015) / Float64(1000)) + prompt.SUM(val / Float64(1000) * Float64(0.0015)) |
|
|
+---------------------+-----------------------------------------------------------------------------------------------------------+
|
|
| 1970-01-01T00:00:00 | 0.000165 |
|
|
| 1970-01-01T00:00:05 | 0.000495 |
|
|
| 1970-01-01T00:00:10 | 0.000825 |
|
|
+---------------------+-----------------------------------------------------------------------------------------------------------+
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval(0, 10, '5s') sum(completion * 0.0015 / 1000) + sum(prompt * 0.0015 / 1000);
|
|
|
|
+---------------------+-----------------------------------------------------------------------------------------------------------+
|
|
| ts | completion.SUM(val * Float64(0.0015) / Float64(1000)) + prompt.SUM(val * Float64(0.0015) / Float64(1000)) |
|
|
+---------------------+-----------------------------------------------------------------------------------------------------------+
|
|
| 1970-01-01T00:00:00 | 0.000165 |
|
|
| 1970-01-01T00:00:05 | 0.000495 |
|
|
| 1970-01-01T00:00:10 | 0.000825 |
|
|
+---------------------+-----------------------------------------------------------------------------------------------------------+
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval(0, 10, '5s') sum(completion * 0.0015 / 1000) by (model) + sum(prompt * 0.0015 / 1000) by (model);
|
|
|
|
+---------+---------------------+-----------------------------------------------------------------------------------------------------------+
|
|
| model | ts | completion.SUM(val * Float64(0.0015) / Float64(1000)) + prompt.SUM(val * Float64(0.0015) / Float64(1000)) |
|
|
+---------+---------------------+-----------------------------------------------------------------------------------------------------------+
|
|
| model-a | 1970-01-01T00:00:00 | 0.000165 |
|
|
| model-a | 1970-01-01T00:00:05 | 0.000165 |
|
|
| model-a | 1970-01-01T00:00:10 | 0.000495 |
|
|
| model-b | 1970-01-01T00:00:05 | 0.00033 |
|
|
| model-b | 1970-01-01T00:00:10 | 0.00033 |
|
|
+---------+---------------------+-----------------------------------------------------------------------------------------------------------+
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval(0, 10, '5s') sum(completion / 1000) + max(completion / 1000);
|
|
|
|
+---------------------+---------------------------------------------------------------------------+
|
|
| ts | completion.SUM(val / Float64(1000)) + completion.MAX(val / Float64(1000)) |
|
|
+---------------------+---------------------------------------------------------------------------+
|
|
| 1970-01-01T00:00:00 | 0.02 |
|
|
| 1970-01-01T00:00:05 | 0.05 |
|
|
| 1970-01-01T00:00:10 | 0.08 |
|
|
+---------------------+---------------------------------------------------------------------------+
|
|
|
|
-- SQLNESS SORT_RESULT 3 1
|
|
tql eval(0, 10, '5s') sum(completion / 1000) + sum(completion / 1000);
|
|
|
|
+---------------------+---------------------------------------------------------------------------+
|
|
| ts | completion.SUM(val / Float64(1000)) + completion.SUM(val / Float64(1000)) |
|
|
+---------------------+---------------------------------------------------------------------------+
|
|
| 1970-01-01T00:00:00 | 0.02 |
|
|
| 1970-01-01T00:00:05 | 0.06 |
|
|
| 1970-01-01T00:00:10 | 0.1 |
|
|
+---------------------+---------------------------------------------------------------------------+
|
|
|
|
drop table completion;
|
|
|
|
Affected Rows: 0
|
|
|
|
drop table prompt;
|
|
|
|
Affected Rows: 0
|
|
|