Re: Issue with join query having same storage plugin name and same datatype

Please look at the plan generated by Drill: explain plan with implementation for SELECT… (An idea is to test the generated SQL in the plan in the DB to see what it does) One idea is to try to put one of the tables in a sub select table where you actively rename the column. WITH s0 as ( SELECT

Issue with join query having same storage plugin name and same datatype

I want to join two table using same storage plugin. But One Of the Column showing null value.I am using drill in window 8 system with latest version of drill(i.e;1.6) . I am using this query:- SELECT T2.ID AS T_ID,T1.ID AS T1_ID ,T1.ProviderID AS ProviderID,

Re: Issue with join query having same storage plugin name and same datatype

Sanjiv, This is very likely a bug in the JDBC storage plugin. I would suggest you open a Jira with the information necessary to reproduce the problem. -- Zelaine On Tue, Jun 21, 2016 at 12:56 AM, Sanjiv Kumar wrote: > I want to join two table using same storage plugin. But One Of the Column >

Issue with join query having same storage plugin name and same datatype

I want to join two table using same storage plugin. But One Of the Column showing null value.I am using drill in window 8 system with latest version of drill(i.e;1.6) . I am using this query:- SELECT T2.ID AS T_ID,T1.ID AS T1_ID ,T1.ProviderID AS ProviderID, T1.Name AS Name, T2.Code AS Code