topic Re: When and Why To Use tExternalSortRow? in Talend Studio

When and Why To Use tExternalSortRow?

Anonymous — Mon, 20 Feb 2017 05:24:02 GMT

Hi,
We already have sorting option using tSortRow. And if I have to perform sorting on aggregated values then I would go for tAggregateSortRow. I was just wondering where this tExternalSortRow could be useful? Also, what should I mention External command "sort" path field when using this component.
I can see in the advanced settings, it asks for the Temporary directory. Does it perform faster than tSortRow?

Re: When and Why To Use tExternalSortRow?

Anonymous — Mon, 20 Feb 2017 07:17:15 GMT

Hi,
Usually, tExternalSortRow uses an external sort application to sort input data based on one or several columns, by sort type and order.
Here is the online document about:TalendHelpCenter:tExternalSortRow

Best regards
Sabrina

Re: When and Why To Use tExternalSortRow?

Anonymous — Mon, 20 Feb 2017 09:40:21 GMT

Can you please let me know what could be the example of external sort application ? I have already checked the document but it doesn't have any scenario mentioned. It's just pointing to tSortRow scenarios.

Re: When and Why To Use tExternalSortRow?

Viswa560 — Tue, 21 Feb 2017 06:00:05 GMT

It will sort the data based on a custom sort... like u can sort data how you want other than the options available in the talend regular tsortRow

Re: When and Why To Use tExternalSortRow?

Anonymous — Fri, 30 Aug 2019 08:58:35 GMT

Hey, Can anyone let me know what will be the format of the external sort code that needs to be attached?
As there is only a single option to give the External command "sort" path for the sorting code I am not sure how Talend is going to use it.

Re: When and Why To Use tExternalSortRow?

Anonymous — Fri, 30 Aug 2019 09:07:29 GMT

Hello,

We created a workitem jira issue about your issue:https://jira.talendforge.org/browse/TDI-39125 and will keep you posted.

Thanks for your time.

Best regards

Sabrina

Re: When and Why To Use tExternalSortRow?

Anonymous — Fri, 30 Aug 2019 09:14:32 GMT

Hey, Thanks for replying, but I see that the issue is closed already and it does not look like it is related to tExternalSort. Can you please elaborate and help me with its usage?
I have gone through the documentation here but it does not mention anything about the format of the sorting code that needs to be added externally.
Thanks for help

Re: When and Why To Use tExternalSortRow?

Anonymous — Fri, 30 Aug 2019 09:31:36 GMT

Hello,

It is still in ''New" status.

Best regards

Sabrina

Re: When and Why To Use tExternalSortRow?

Anonymous — Fri, 30 Aug 2019 09:34:06 GMT

Hello,

The tExternalSortRow is a very old component. We need our component developers to clarify the function of its properties.

Best regards

Sabrina