Hello there, I am trying to use Apache Drill in order to query several databases. I have some troubles using it with SQL Server:
- I am able to establish a connection between Drill and SQL Server using SQL Authentification but not using Windows Authentification which would be more convenient to me. In order for Windows Authentification to work, I have to specify in some way to Java that it has to use some DLL (namely sqljdbc_auth.dll). For instance, under Eclipse, I have to specify the following VM arguments to Java : -Djava.library.path="<path_to_the_dll>". Is it possible to do so in a similar way for Apache Drill, and which conf file should I modify? - A second question: I am able to launch queries from Apache Drill to SQL Server using SQL Auth. Now, I want to query tables of SQL Server which contain columns of datetimeoffset which is a SQL Server type. Querying such tables via Apache Drill leads to "Error: VALIDATION ERROR: Unknown SQL type -155" After running some tests, I know for sure it comes from the datetimeoffset column. I tried to cast this in several ways to date Apache Drill compatible objects but nothing worked for me. Could you please give me some advices? Thank you very much in advance, Cheers, Simon
