Inserted Sorts
By default, tsort operators are inserted into the score as necessary
– Before any stage that requires matched key values (Join, Merge, RemDups)
Only inserted if the user has NOT explicitly defined a sort
Check the job score for inserted tsort operators
Changing Inserted Sorting Behavior
------
Set $APT_SORT_INSERTION_CHECK_ONLY or $APT_NO_SORT_INSERTION to change
behavior of automatically inserted sorts
Set $APT_SORT_INSERTION_CHECK_ONLY
– The inserted sort operators only VERIFY that the data is sorted
• If data is not sorted properly at runtime, the job aborts
• Recommended only on a per-job basis during performance tuning
Set $APT_NO_SORT_INSERTION to stop
inserted sorts entirely
By default, tsort operators are inserted into the score as necessary
– Before any stage that requires matched key values (Join, Merge, RemDups)
Only inserted if the user has NOT explicitly defined a sort
Check the job score for inserted tsort operators
Changing Inserted Sorting Behavior
------
Set $APT_SORT_INSERTION_CHECK_ONLY or $APT_NO_SORT_INSERTION to change
behavior of automatically inserted sorts
Set $APT_SORT_INSERTION_CHECK_ONLY
– The inserted sort operators only VERIFY that the data is sorted
• If data is not sorted properly at runtime, the job aborts
• Recommended only on a per-job basis during performance tuning
Set $APT_NO_SORT_INSERTION to stop
inserted sorts entirely
No comments:
Post a Comment