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 <[email protected]> wrote: > 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 > FROM SqlServer.StuentDetails.P21.Class1 AS T1 > right outer JOIN SqlServer.StuentDetails.P21.Class2 > AS T2 ON T1.ProviderID = T2.ID > > Here SqlServer is Storage Plugin Name, > > StuentDetails is Database Name, > > P21 is a Schema Name, Class1, > > Class2 are Table Names. > > While executing this query T_ID showing Null. > > But If I am using two different storage plugin name with same > credential it works properly. > > Note:- NOT ONLY IN SQL SERVER, I TRIED IN MYSQL, ORACLE DB ALSO.. SAME > PROBLEM CAME. I THINK PROBLEM WITH THE SAME STORAGE PLUGIN NAME HAVING > SAME DATATYPE, BECAUSE WHEN I TRIED TO GIVE DIFFERENT DATATYPE TO BOTH > THE TABLE, OUTPUT COMING FINE. > > *Is it possible to join two table using same storage plugin name? If > yes,then What am I doing wrong in this query?* > > > > > > > > > > > > > > > > > > > > > > ...................... > Thanks & Regards > *Sanjiv Kumar* >
