Re: Join tables from different databases returns empty result

2018-11-13 Thread Prisdha Dharma
...@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/

Re: Join tables from different databases returns empty result

2018-11-06 Thread Arjun kr
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

Re: Join tables from different databases returns empty result

2018-11-06 Thread Khurram Faraaz
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 c

Join tables from different databases returns empty result

2018-11-06 Thread Prisdha Dharma
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, e