[jira] [Updated] (DRILL-4625) Join Query Problem using Same Storage Plugin
[ 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)
[jira] [Updated] (DRILL-4625) Join Query Problem using Same Storage Plugin
[ 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 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 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)
[jira] [Updated] (DRILL-4625) Join Query Problem using Same Storage Plugin
[ 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 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 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 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 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 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 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)
[jira] [Updated] (DRILL-4625) Join Query Problem using Same Storage Plugin
[ 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 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 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 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 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 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 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)
[jira] [Updated] (DRILL-4625) Join Query Problem using Same Storage Plugin
[ 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 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 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 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?* > 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 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 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)
