I don't think we have tests covering this case so it may have issues. Can you file a JIRA?
thanks, Jacques -- Jacques Nadeau CTO and Co-Founder, Dremio On Thu, Mar 17, 2016 at 11:11 PM, Sanjiv Kumar <[email protected]> wrote: > *I want to know whether Apache Drill supports only dbo schema?? or it will > support all type of schema (user create 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: > > *{* > * "type" : "jdbc",* > * "driver" : "com.microsoft.sqlserver.jdbc.SQLServerDriver",* > * "url" : "jdbc:sqlserver://<servername>;databaseName=<dbname>",* > * "username" : "<username>",* > * "password" : "<password>",* > * "enabled" : true* > *}* > > This DB has dbo and other user created schemas like (core, P21, output, > etc). All the schemas have same type of permission. Its work for dbo > schema where core and other user created schema are not working while > querying from drill. > > *My DBO Query:* > > * select * from SqlServer.dbo.Attribute; (Its working).* > > *My CORE Query:* > > *select * from SqlServer.core.Users;(Its not working).* > > *NOTE: SqlServer is Storage Plugin Name.* > > *My Question is whether Drill Supports only dbo schema or all schemas in > DB ?* > > because, while firing show databases; query. User created schema is no > showing(e.g: core, P21, output, etc schemas). > > > > ---------------------- > Thanks & Regards. > Sanjiv Kumar >
