drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sanjiv Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-4625) Join Query Problem using Same Storage Plugin
Date Fri, 22 Apr 2016 14:22:13 GMT
Sanjiv Kumar created DRILL-4625:
-----------------------------------

             Summary: Join Query Problem using Same Storage Plugin
                 Key: DRILL-4625
                 URL: https://issues.apache.org/jira/browse/DRILL-4625
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types, Execution - Flow, SQL Parser
    Affects Versions: 1.6.0
            Reporter: Sanjiv Kumar


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, StudentDetails 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?*



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message