gchq / stroom

Stroom is a highly scalable data storage, processing and analysis platform.
https://gchq.github.io/stroom-docs/
Apache License 2.0
424 stars 56 forks source link

Invalid SQL with Meta Store datasource #4274

Open at055612 opened 1 month ago

at055612 commented 1 month ago
from "Meta Store"
select Pipeline, ${Create Time}, ${Effective Time}, ${Status Time}

gives error

SQL [select distinct `p`.`pipeline_uuid`, `m`.`create_time`, `m`.`effective_time`, `m`.`status_time`
from `meta` as `m`
left outer join `meta_processor` as `p` on `m`.`processor_id` = `p`.`id`
order by `m`.`id`];
Expression #1 of ORDER BY clause is not in SELECT list,
references column 'stroom.m.id' which is not in SELECT list;
this is incompatible with DISTINCT