[jira] [Commented] (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:comment-tabpanel&focusedCommentId=15204124#comment-15204124 ] 

Sanjiv Kumar commented on DRILL-4522:
-------------------------------------

select * from <StoragePluginName>.<databaseName>.<schemaName>.<tableName>;
Ex:

seleect * from SqlServer.Test.core.Category;
This query will work for all type of user created schemas. But for dbo(default) schema Databases name is not required. If you write database name while query through dbo schema, it will through error.

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