You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Sanjiv Kumar (JIRA)" <ji...@apache.org> on 2016/04/22 16:22:13 UTC
[jira] [Created] (DRILL-4625) Join Query Problem using Same Storage
Plugin
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)