Hi Robert, Could you share the version of Drill you are using as well as the configuration for your Firebird plugin? (Obviously don’t include hostnames or creds) Thx, — C
> On Jun 21, 2021, at 2:58 PM, Lehrbass, Robert > <[email protected]> wrote: > > Hi there, > > I have an Apache Drill installation, with two storage plug-ins: > > 1. First one, called "storage", enables me to create parquet files using a > CTAS command. > 2. Second one, called "rdbms", is a connection to a Firebird database > > My main problem is that I cannot get the CTAS command (shown below) working. > I'm trying to read from Firebird and create parquet files from within a Java > program. > > Note that I am able to do most things separately using each storage plug-in, > from the Drill UI, from the Drill shell, and from my Java program, yet this > CTAS command is eluding me: > > SQL: [CREATE TABLE storage.analytics.`Timeline/1011/19720420` AS SELECT > CAST(COU_ID AS VARCHAR(12)) FROM rdbms.`COUNTRY`] > SQLEXCEPTION: java.sql.SQLException: DATA_READ ERROR: The JDBC storage plugin > failed while trying setup the SQL query. > > Sql: SELECT CAST("COU_ID" AS VARCHAR(12) CHARACTER SET "UTF-16LE") > FROM "COUNTRY" > Plugin: rdbms > Fragment: 0:0 > > [Error Id: 5345dfba-8e11-425b-88cf-2df11dc5d03a on bvsdev-cvm3:31010] > > (java.sql.SQLException) Dynamic SQL Error; SQL error code = -204; Data type > unknown; CHARACTER SET UTF-16LE is not defined [SQLState:HY004, ISC error > code:335544573] > org.firebirdsql.gds.ng.FbExceptionBuilder$Type$1.createSQLException():539 > > > ...I don't know where this CHARACTER SET "UTF-16LE" comes from... I've tried > setting UTF8 everywhere I possible can, but to no avail. I've also tried > every combination of SQL for the rdbms connection that I can think of, but > nothing works. > > Any suggestions would be very much appreciated. > Thanks in advance
