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] [Resolved] (DRILL-4522) Apache Drill Schema Support for SQL Server
Date Mon, 21 Mar 2016 12:54:25 GMT

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

Sanjiv Kumar resolved DRILL-4522.
---------------------------------
       Resolution: Fixed
    Fix Version/s: 1.5.0

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

Mime
View raw message