[jira] [Reopened] (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 reopened DRILL-4522:
---------------------------------

But This not the good solution. Because every time we have check for schema (default or user created schema). If it has dbo (default schema) then database name is not required in query. And If it has core (user created schema) schema then we have to give database name after Storage Plugin.
 
FOR USER CREATED SCHEMA
Ex:- select * from <storagePluginName>.<datbaseName>.<schemaName>.<tableName>;

FOR DBO (DEFAULT SCHEMA)
Ex:- select * from .<storagePluginName>.<dbo>.<tableName>;

> 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.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)