Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Aukema
Creator
Creator

Exasol and dynamic Schema

I am trying to send information to Exasol using the "Dynamic Schema" function. But the job is throwing some strange error. See screenshots for details

 

Is the dbtype of the tExaOut causing this issue? and how to solve this?

 

According the documentation the tExaOut component should be able to handle Dynamic schema

"This component offers the advantage of the dynamic schema feature. This allows you to retrieve unknown columns from source files or to copy batches of columns from a source without mapping each column individually. For further information about dynamic schemas, see Talend Studio User Guide."

 

When putting another output (for example tOutputDelimited), everything works fine.

 

I am using Talend 6.5 subscribed version of Talend.

Labels (3)
2 Replies
fdenis
Master
Master

Does tExaOut allow Table Creation with dynamic data?
I do not think.
Your dynamic data does not have any name nor sql type so it's difficult to generate create Table.
Try to create your table previously to insert data.

Aukema
Creator
Creator
Author

That will probably work, but I didnt continue this as the source table contained an object which contained a lot of data and required to find another solution.