How to create a table containing a LONG VARCHAR column using Pentaho Spoon?

157 views Asked by At

I need to use a simple Pentaho Spoon transformation to copy a table from MySQL database to OpenLink Virtuoso RDB (Virtuoso Open Source).

The table on MySQL database contains a column typed LONG VARCHAR.

This data type exists in OpenLinkVirtuoso.

The problem is that Pentaho Spoon seems not understand this data type.

I tried this SQL script directly on Openlink Virtuoso RDB:

CREATE TABLE DBTEST.GSDRB_SUB_CSN
(
  SUBCOUNTER INTEGER
, REF_CATALOGO INTEGER
, CSNC VARCHAR(5)
, CSNL VARCHAR(10)
, CSNS VARCHAR(255)
, CSNO VARCHAR(10)
, CSNN LONG VARCHAR
 )

And it works fine. So the LONG VARCHAR data type actually exists and is understood.

The same is run on Pentaho Kettle (inside Create Table action), but raises this error:

2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - ERROR (version 9.3.0.0-428, build 9.3.0.0-428 from 2022-04-12 04.56.25 by buildguy) : An error occurred executing this job entry : 
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - Couldn't execute SQL: CREATE TABLE GSDRB_SUB_CSN
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - (
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] -   SUBCOUNTER INTEGER
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - , REF_CATALOGO INTEGER
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - , CSNC VARCHAR(5)
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - , CSNL VARCHAR(10)
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - , CSNS VARCHAR(255)
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - , CSNO VARCHAR(10)
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - , CSNN LONG VARCHAR
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - )
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - 
2023/01/18 11:33:35 - Create table [GSDRB_SUB_CSN] - SQ074: Line 9: syntax error

I tried also with BLOB but i have the same issue.

Do you have any suggestions?

0

There are 0 answers