[jira] [Created] (DRILL-4522) Apache Drill Schema Support for SQL Server

[Sanjiv Kumar (JIRA)]

Sanjiv Kumar created DRILL-4522:
-----------------------------------

             Summary: Apache Drill Schema Support for SQL Server
                 Key: DRILL-4522
                 URL: https://issues.apache.org/jira/browse/DRILL-4522
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.5.0
         Environment: Sql Server, Window 8.1 
            Reporter: Sanjiv Kumar


I want to know whether Apache Drill supports only dbo schema?? or will it 
support all type of schema?

I am running my system in window 8 and with latest version of Drill(1.5) with 
embedded mode.

I am trying to search with same storage plugin.

My Storage Plugin(for SQLServer):

{
  "type" : "jdbc",
  "driver" : "com.microsoft.sqlserver.jdbc.SQLServerDriver",
  "url" : "jdbc:sqlserver://<servername>;databaseName=<databasename>",
  "username" : "<username>",
  "password" : "<****>",
  "enabled" : true
}
This Plugin has dbo & core schema (both have same type, no special 
permission).Its work for dbo schema where core schema is not working.

DBO Query:

select * from SqlServer.dbo.Attribute; //Its working.
Core Query:

select * from SqlServer.core.Users //Its not working
My question is whether Drill Supports only dbo schemna or all type of schema?



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)