Does it return any result if you query on individual tables with the corresponding filter applied in Drill?
Thanks, Arjun ________________________________ From: Khurram Faraaz <kfar...@mapr.com> Sent: Wednesday, November 7, 2018 5:34 AM To: user@drill.apache.org Cc: om...@intertrust.com Subject: Re: Join tables from different databases returns empty result 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 <pris...@intertrust.com> 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 > > >