[D] Table output array type (hop)

["mocoxk (via GitHub)" <gi...@apache.org>]

GitHub user mocoxk created a discussion: Table output array type

I'm loading data into ClickHouse using a simple pipeline with a Table Input and a Table Output. The issue arises when inserting data into an Array-type field in ClickHouse. Apache Hop treats it as a string, which I assume causes the Table Output step to wrap it in quotes upon insertion.

I tested using an "Execute SQL Script" step to insert the data correctly as an Array, avoiding the automatic quoting, and it worked as expected.

Is there a way to configure the Table Output step to insert the value as an Array instead of a string?

GitHub link: https://github.com/apache/hop/discussions/4917

----
This is an automatically sent email for users@hop.apache.org.
To unsubscribe, please send an email to: users-unsubscribe@hop.apache.org