Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I would like to use a the data stored in a tHashOutput from a job parent in to a job child.
How can I do this?
Regards
Alessandro
Change your tHash components to be tHSQLDbOutput and tHSQDbInput components (using a "Running Mode" of "HSQLDb in Memory"). These will do what your Hash components will, but will keep the data in a temporary in-memory HyperSQL DB. This will make the data available throughout your jobs (that are currently running) and the DB will disappear when the job finishes running.
You can also use SQL queries with these components, which means you can do a lot more than you can with the tHash components.
Take a look at the documentation here: https://help.talend.com/r/en-US/8.0/hsqldb/thsqldboutput
Hi rhall
Thanks for the reply, I did not know this component.
Now the job is:
the values of the component tHSQLDbOutput can be as desired, imaginative (I invented DbName, UserName and Password) but then they must be the same in tHSQLDbInput.
Thanks and regards
Alessandro
Glad it worked for you. These components share all of the qualities of the tHash components......with MANY more. You can update, filter in queries, delete, etc, etc. I much prefer these.
hi @Richard Hall , i tried your method using a simple test ,
tfixedflowinput -> thsqldboutput with (mode execution as HSQLDb in Memory) -> tlogRow
I got this error ,
Exception in component tHSQLDbOutput_1 (talnb)
java.sql.SQLSyntaxErrorException: precision or scale out of range
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
at org.hsqldb.jdbc.JDBCUtil.sqlException(Unknown Source)
Learning how to work with this component is intersting
How could i solve this
This is because you have not set the length or precision for each column in the your schema going to your tHSQLDBOutput. I briefly talk about this here....
https://community.talend.com/s/feed/0D75b000005yRDCCA2