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
