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

["Sanjiv Kumar (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sanjiv Kumar updated DRILL-4522:
--------------------------------
    Description: 
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.6) 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 works 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?

  was:
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?


> 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
>             Fix For: 1.5.0
>
>
> 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.6) 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 works 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)