Hi, You could try adding columnLabelForName=true as one of the options to the connection.
Kr, Hans On 15 May 2025 at 15:14 +0200, Bart Maertens <[email protected]>, wrote: > This sounds like a "feature" of your JDBC driver. I don't have any experience > with Firebird, you'll have to check their JDBC driver documentation, but > there is or used to be a similar issue with DB2. > > Regards, > Bart > > > On Thu, May 15, 2025 at 3:11 PM Irio Andre Moesch <[email protected]> wrote: > > Hello everyone, > > > > I'm new here, I searched here about my problem and couldn't solve it and > > would like the help of the "masters". My problem is: I'm using Apache HOP > > version 2.12 and when connecting to the Firebird database version 3.0.12 > > the output of the "table input" transformation where the queries that use > > the "coalesce()" or "cast()" functions the column names do not return the > > name that was defined in the "alias" but rather the name of the function > > that was used "CAST, CAST_1, CAST_2...". How can I solve this problem? > > > > Thank you very much > > Irio
