[DRILL-4625] Join Query Problem using Same Storage Plugin

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.6.0
• Component/s: Execution - Data Types, Execution - Flow, SQL Parser
• Assignee: Unassigned
• Reporter: Sanjiv Kumar
• Created: 22/Apr/16 14:21
• Updated: 26/Apr/16 15:08

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