I am using Drill 1.18.0 and here is my Firebird plugin:
{
"type": "jdbc",
"driver": "org.firebirdsql.jdbc.FBDriver",
"url": "jdbc:firebirdsql://XXX.XXX.XXX.XXX/E:/BVSBAM.FDB?encoding=UTF8",
"username": "SYSDBA",
"password": "XXXXXXXXXXXXX",
"caseInsensitiveTableNames": true,
"sourceParameters": {
"autoCommit": false
},
"enabled": true
}
Thanks Charles!
Rob
-----Original Message-----
From: Charles Givre <[email protected]>
Sent: June 21, 2021 7:09 PM
To: [email protected]
Subject: Re: Drill and Firebird database
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
