Hi, You will have to create a new storage plugin from Drill's Web UI, you can find the details on the below documentation link, to query MySQL tables from Apache Drill. https://drill.apache.org/docs/rdbms-storage-plugin/
Also please share the query plan if you can generate one using EXPLAIN FOR command, for that join query from Drill. Thanks, Khurram On Tue, Nov 6, 2018 at 3:58 PM Prisdha Dharma <[email protected]> wrote: > 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 > > >
