[
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)
