rusackas commented on issue #36304: URL: https://github.com/apache/superset/issues/36304#issuecomment-4774494300
Digging in a bit more, I don't think the empty/partial joins are a one-filter-per-column thing like the bot suggested. It's `SUPERSET_META_DB_LIMIT` (default 1000) getting applied to each underlying table *before* the in-memory join runs, so if either side of the join has more rows than the limit, matching rows get silently truncated and the join comes back incomplete or empty. As a workaround you can raise `SUPERSET_META_DB_LIMIT` above your largest joined table, or set it to `None` if your tables are small. I opened #41302 to document the caveat, and we can leave this open for the deeper discussion on whether the truncation behavior itself should change. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
