tsort and psort

qt_ky · Post by **qt_ky** » Fri Apr 06, 2012 11:47 am

This is a bit of a trivia question, and I only know the answer to #2:

1. What does the T stand for in the tsort operator, and how do you know?

2. What does the P stand for in the psort operator?

nagarjuna · Post by **nagarjuna** » Fri Apr 06, 2012 3:10 pm

What is a psort ?

ray.wurlod · Post by **ray.wurlod** » Fri Apr 06, 2012 4:02 pm

A psort is a sort with a silent p, as in swimming.

chulett · Post by **chulett** » Fri Apr 06, 2012 6:02 pm

Don't you mean pswimming?

Sorry. Me, I have no idea what either letter stands for... waiting to be educated.

jwiles · Post by **jwiles** » Fri Apr 06, 2012 7:17 pm

Well, pshah...

p for partition sort

t: (a hint) if you know about the parallel engine's history, this should come pretty easy

ray.wurlod · Post by **ray.wurlod** » Fri Apr 06, 2012 7:26 pm

Tsort is a place on Terry Pratchett's Discworld.

jwiles · Post by **jwiles** » Fri Apr 06, 2012 7:46 pm

tsort is also a *nix utility

qt_ky · Post by **qt_ky** » Fri Apr 06, 2012 9:22 pm

Total sort...

Topological sort...

http://en.wikipedia.org/wiki/Torrent_Systems

http://en.wikipedia.org/wiki/Timsort

Either tsort or psort can be used to sort a partition, so I was wondering how the T and P designators actually came about. The docs confuse the matter further by associating psort with the UNIX sort program. Maybe it should have been called usort; it seems the P is meaningless. Older docs mention psort with the Syncsort utility also.

priyadarshikunal · Post by **priyadarshikunal** » Mon Apr 09, 2012 6:52 am

May be the psort (partition sort) was developed earlier and since it could sort partitioned data it was called psort. Then tsort operator came in which had capability of performing total sort in addition to partition sort and hence it was called tsort.

This is just based on my assumption as in documentaion it is written as "Because of the additional capabilities in tsort, it is recommended that you use this operator rather than psort." Also it uses the sort engine of its own.

qt_ky · Post by **qt_ky** » Mon Apr 09, 2012 9:42 pm

According to the product guides:

psort
Yes, "p" for partition sort.

tsort
And, "t" does not appear to be documented what it stands for. We can speculate until the cows come home... Anyone know if it's documented?

nikhil_bhasin · Post by **nikhil_bhasin** » Wed Apr 10, 2013 12:30 am

Hi, can anyone please describe the differences between tsort and psort operators. What i am looking for is exactly what conditions lead to insertion of psort operator and how it works.

BI-RMA · Post by **BI-RMA** » Wed Apr 10, 2013 2:36 am

psort will never be inserted by DataStage because tsort is the preferred option for sorting.

No clue to the naming, either. Suggest "true"-sort, as in "the-one-and-only-true-sorting-utility".

chulett · Post by **chulett** » Wed Apr 10, 2013 7:27 am

Tony has inferred above that the "t" stands for "Torrent".

BI-RMA · Post by **BI-RMA** » Wed Apr 10, 2013 7:54 am

Is Tony the guy who calls himself Eric?

And did you say "Torrent" or "Torment"???

chulett · Post by **chulett** » Wed Apr 10, 2013 8:08 am

James, Eric, Tony... somebody inferred it up there somewhere.