AnsweredAssumed Answered

Drill connecting to SQL Server

Question asked by kannu.kumar on Nov 1, 2016
Latest reply on Apr 6, 2017 by David_Lee

Heyya,

 

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:

{
"type": "jdbc",
"driver": "com.microsoft.sqlserver.jdbc.SQLServerDriver",
"url": "jdbc:sqlserver://192.168.1.1:1433;databaseName=ersDummy",
"username": "username",
"password": "password",
"enabled": true
}

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
[30027]Query execution error. Details:[
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.

sql SELECT *
FROM "ersDummy"."tablename"
plugin myplugin
Fragment 0:0

[Error Id: 3904f335-723b-4fec-afb7-bf791967e5f1 on maprdemo:31010]
]

 

Any Help will be appreciated,

 

Thanks,

 

Kannu

Outcomes