multi-stage query for DBeaver

[АМИР З]

Hi all.
How can I use multi-stage query in DBeaver?
On the project where I work, there is a requirement to create some kind of materialized views from datasources.
I have Druid 24.0 installed on my machine, I checked the multi-stage query on the web interface of Druid itself, it works, but when I try to repeat the same "insert into new_table ***" operation in dbeaver, I get the following error: Remote driver error: SqlPlanningException: Cannot execute INSERT with SQL engine 'native'.

[Senthil Valli]

Hi, 

At this stage MSQ (SQL ingest) is not supported with DBWeaver or other db tools. It is only possible through Druid Console. 

[Vadim Ogievetsky]

Or through the API! https://docs.imply.io/latest/druid/multi-stage-query/api/

[АМИР З]

Thank you.
Will this feature be available for db tools in future versions?

четверг, 24 ноября 2022 г. в 03:11:36 UTC+5, senthil.va...@imply.io:

[АМИР З]

Thank you.
Yeah, I'll have to find a way to call this api from dbeaver

четверг, 24 ноября 2022 г. в 04:08:03 UTC+5, Vadim Ogievetsky:

[АМИР З]

Hello. Hope you're doing well.
I guess MSQ feature is still not available on dbeaver, even on the version 25.0 Right?

четверг, 24 ноября 2022 г. в 03:11:36 UTC+5, senthil.va...@imply.io:

Hi,