topic Re: java tExternalSortOutput error in Talend Studio

java tExternalSortOutput error

Anonymous — Sat, 16 Nov 2024 14:36:11 GMT

Hi
I am trying to use the tExternalSortOutput java component. The scenario is the following
tFileInputDelimited ---- > tExternalSortOutput
I have created a file schema that it is used by both components. When I run the job I get the following error.
Starting job ExternalSort at 11:03 05/06/2007.
32 milliseconds
/usr/bin/sort: open failed: "/tmp/tExternalSortOutput_143063.tmp": No such file or directory
Job ExternalSort ended at 11:03 05/06/2007.
Where is set up the tmp file?

Re: java tExternalSortOutput error

Anonymous — Tue, 05 Jun 2007 15:21:28 GMT

At the end of the parameters, you have a tmp directory parameter.

Re: java tExternalSortOutput error

Anonymous — Tue, 05 Jun 2007 16:05:00 GMT

thx
but I get this now
Starting job ExternalSort at 17:03 05/06/2007.
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Syntax error on token "/", delete this token
usr cannot be resolved
bin cannot be resolved
Syntax error on token "+", ++ expected
tmp cannot be resolved
at bbdd_download.externalsort.ExternalSort.tFileInputDelimited_1Process(ExternalSort.java:392)
at bbdd_download.externalsort.ExternalSort.main(ExternalSort.java:523)
Job ExternalSort ended at 17:03 05/06/2007.
the input file is the following
1249971|25-ABR-07 12.06.25.000000 PM|1|CUENTANUM:1249971|25/04/2007|1249971
1249969|25-ABR-07 12.06.42.000000 PM|3|CUENTANUM:1249969|25/04/2007|1249969
1249969|25-ABR-07 12.06.59.000000 PM|5|CUENTANUM:1249969|25/04/2007|1249969
1249970|25-ABR-07 12.06.25.000000 PM|1|CUENTANUM:1249970|25/04/2007|1249970
1249970|25-ABR-07 12.06.33.000000 PM|2|CUENTANUM:1249970|25/04/2007|1249970
1249970|25-ABR-07 12.06.51.000000 PM|4|CUENTANUM:1249970|25/04/2007|1249970
1249970|25-ABR-07 12.06.59.000000 PM|5|CUENTANUM:1249970|25/04/2007|1249970
1249969|25-ABR-07 12.06.51.000000 PM|4|CUENTANUM:1249969|25/04/2007|1249969
1249970|25-ABR-07 12.06.42.000000 PM|3|CUENTANUM:1249970|25/04/2007|1249970
1249969|25-ABR-07 12.06.33.000000 PM|2|CUENTANUM:1249969|25/04/2007|1249969

Re: java tExternalSortOutput error

Anonymous — Tue, 05 Jun 2007 16:14:24 GMT

If I leave empty the external sort command path I get this
Starting job ExternalSort at 17:05 05/06/2007.
Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Syntax error on token "+", ++ expected
tmp cannot be resolved
at bbdd_download.externalsort.ExternalSort.tFileInputDelimited_1Process(ExternalSort.java:394)
at bbdd_download.externalsort.ExternalSort.main(ExternalSort.java:523)
Job ExternalSort ended at 17:05 05/06/2007.
If I go to that line
sb_tExternalSortOutput_1.append(" -S " + "200M"); sb_tExternalSortOutput_1.append(" -T \"" + /tmp + "\"")
What it means I cannot put /tmp in the Temporary directory property. If I remove the '/' another error appears

even if I write it with "" such "/tmp" I get this
Starting job ExternalSort at 17:11 05/06/2007.
/usr/bin/sort: open failed: "/tmp/tExternalSortOutput_17699.tmp": No such file or directory
Job ExternalSort ended at 17:11 05/06/2007.
and thaolias@aolias-laptop:/tmp$ pwd
/tmp
aolias@aolias-laptop:/tmp$
at directory exists

Re: java tExternalSortOutput error

_AnonymousUser — Wed, 11 Apr 2012 17:34:48 GMT

Hey, I tried similar example. I Have a input as employee file. I need the output as Sorted one based on deptno.
When i run the job i get error like
Starting job job2 at 22:01 11/04/2012.
connecting to socket on port 3607
connected
Input file specified two times.
disconnected
Job job2 ended at 22:01 11/04/2012.

Thanks,
Gunaranjan