Subquery fields from different view slower to populate in combined report
We have a report that consists of data from a view A generated by one data source (a MySQL db) and on top of it we create a subquery that merges A with data from another view (a PostgreSQL database). Effectively this report consists of data from a view + subquery B from another view. When running the reports, or dashboards, the columns corresponding to the subquery B take longer to appear, sometimes hours. And we're concerned that they might just not appear, ever.
On the other hand, If we individually check rows (by filtering some ids) the data corresponding to the subquery are there, but they don't however appear in the "unfiltered" report.
Is anyone aware of this problem? Does it depend on my setup? If required by support we could open a private conversation where I could share more details.
Yellowfin version 7.4.6.