I need a join union with elasticsearch and I am testing dremio.
The above function works very well. Thank you
However, there is one problem.
Simple queries are too slow.
Attach a query profile.
Can you confirm the cause and give it?
By the way, execution of query with elasticsearch excluding union takes less than 3 seconds.