Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
1.10.0
-
None
-
None
-
Drill 1.10
SQL Server 2016
Description
plugin defined to access SQL Server via JDBC
following statement is sent to Drill which fails due to invalid SQL sent to SQL Server
select trim(TJOIN1.C2) from certsqlserver.dbo.TJOIN1
Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.
SELECT TRIM(BOTH ' ' FROM "C2") AS "EXPR$0"
FROM "dbo"."TJOIN1"
plugin certsqlserver
https://docs.microsoft.com/en-us/sql/t-sql/functions/trim-transact-sql