-
Type:
Bug
-
Status: Open
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 1.10.0
-
Fix Version/s: None
-
Component/s: Server
-
Labels:None
-
Environment:
Drill 1.10
ORACLE 12C2
plugin to ORACLE via JDBC defined
Following statement sent to Drill
select TDT.RNUM, cast(TDT.CDT as varchar(10)) from certora.DBCERT.TDT
DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.
sql SELECT "RNUM", CAST("CDT" AS VARCHAR(10) CHARACTER SET "ISO-8859-1") "EXPR$1" FROM "DBCERT"."TDT"
ORACLE DDL
CREATE TABLE "DBCERT"."TDT"
( "RNUM" NUMBER,
"CDT" DATE
) ;