Hi, I'm using Apache Drill to join 2 tables from different databases on MySql server When running this query: SELECT a.name, b.url FROM pg_authservice.partner a INNER JOIN pg-edge.graph_apis b N a.id = b.pid WHEN a.status = 1 && b.job_status = “COMPLETED”;
I see that Drill returns empty result, even though the join using MySQL returns non-empty data. Could you please advise. Prisdha Dharma