[druid-user] 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’.

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

Or through the API! SQL-based ingestion and multi-stage query task API · 2022.11

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: