*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
