[
https://issues.apache.org/jira/browse/DRILL-4522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sanjiv Kumar updated DRILL-4522:
--------------------------------
Component/s: (was: Server)
> 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
> Affects Versions: 1.6.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.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)
