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] [Updated] (DRILL-4625) Join Query Problem using Same Storage Plugin
Date Tue, 26 Apr 2016 15:09:12 GMT

     [ https://issues.apache.org/jira/browse/DRILL-4625?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Sanjiv Kumar updated DRILL-4625:
--------------------------------
    Description: 
I am using Apache Drill in Window 8.1 & having 1.6 version of Apache Drill.

`I want to join two table using same storage plugin. But When i am using same storage plugin
name for query,in output 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.StudentDetails.P21.Class1 AS T1
 right outer JOIN SqlServer.StudentDetails.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 Value.

But If I am using two different storage plugin name with same credential it
works Fine.

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

  was:
I am using Apache Drill in Window 8.1 & having 1.6 version of Apache Drill.

`I want to join two table using same storage plugin. But When i am using same storage plugin
name for query,in output 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.StudentDetails.P21.Class1 AS T1
 right outer JOIN SqlServer.StudentDetails.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 Value.

But If I am using two different storage plugin name with same credential it
works Fine.

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


> 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 am using Apache Drill in Window 8.1 & having 1.6 version of Apache Drill.
> `I want to join two table using same storage plugin. But When i am using same storage
plugin name for query,in output 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.StudentDetails.P21.Class1 AS T1
>  right outer JOIN SqlServer.StudentDetails.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 Value.
> But If I am using two different storage plugin name with same credential it
> works Fine.
> *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