drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sanjiv Kumar (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-4522) Apache Drill Schema Support for SQL Server
Date Tue, 03 May 2016 07:30:12 GMT

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

Sanjiv Kumar updated DRILL-4522:
--------------------------------
    Fix Version/s:     (was: 1.5.0)

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

Mime
View raw message