Abhishek,

He was referring to an older message, I have copied it here below.
Unfortunately I haven't worked much with the JDBC plugin, but it definitely
looks like a bug. Can you file a JIRA report for this issue? If you file it
you will automatically be subscribed to updates on it's progress and record
your involvement in finding the bug.

Previous message:

I want to join two table using same storage plugin. But One Of the Column
showing null value. 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.

*Is it possible to join two table using same storage plugin name? If
yes,then What am I doing wrong in this query?*

Jason Altekruse
Software Engineer at Dremio
Apache Drill Committer

On Thu, Apr 21, 2016 at 8:15 AM, Abhishek Girish <[email protected]>
wrote:

> Hello Sanjeev,
>
> Welcome to the Drill community. Please share a clear and concise
> description of the problem, including the sample dataset, query, error,
> relevant log snippets and your environment including the version of Drill.
>
> Also request you to maintain a single conversation for an issue. With
> separate individual threads, it is hard to keep track of information you
> shared and any responses you received.
>
> Regards,
> Abhishek
>
> On Thursday, April 21, 2016, Sanjiv Kumar <[email protected]> wrote:
>
> > Hello
> >        I have posted my problem, but didn't get any reply from Drill. I
> > have also posted my problem with example as asked. Please tell me its a
> bug
> > or i am doing anything wrong in it. If its a bug when drill community
> going
> > to solve this problem.
> >
> >
> >  ......................
> >   Thanks & Regards
> >   *Sanjiv Swaraj*
> >
>

Reply via email to