I am required to be able to connect to an instance of SQL Server Using Apache Drill. I followed the steps that illustrates how its done using "RDBMS Storage Plugin - Apache Drill " and used the following configuration settings:
The SQL SERVER storage plugin "myplugin" has successfully been established and i could connect to an SQL instance.
So the problem is :-
Question 1 : I am seeing other schema and system databases even though i am establishing connection to only "ersDummy" database. Is this meant to be this way ?
Please refer to the image below : -
Question 2 : I am unable to see tables in the database "myplugin.ersDummy" when '+' sign is expanded. However, i can run "SHOW TABLE" and it provides me the list of tables that exists in the database but doesn't allow me to run a select query on the tables. I get the following error:
ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query:
Select * from myplugin.ersDummy.tablename
Query execution error. Details:[
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.
sql SELECT *
[Error Id: 3904f335-723b-4fec-afb7-bf791967e5f1 on maprdemo:31010]
Any Help will be appreciated,