Page 1 of 1

User inserted tsort missing in job score

Posted: Wed Nov 30, 2016 6:11 am
by zulfi123786
Hi,

I have inserted link sort over field "ENROLLEE_ID" in a job and I can find it in Generated OSH code but the tsort operator does not exist in the job score why appears confusing to me. Operator combination is disable still cant find the sort operator, should it not exist in the score ?

OSH CODE -

Code: Select all

#### STAGE: jn_MbrCov.ToJoinMemCovKey_Sort
## Operator
tsort -key ENROLLEE_ID -cs -asc -key UPDATE_DATE -desc -nulls last -nonStable
## General options
[ident('jn_MbrCov.ToJoinMemCovKey_Sort')]
## Inputs
0< [] 'Xfrm_mbrcov:ToJoinMemCovKey_Part.v'
## Outputs
0> [] 'Xfrm_mbrcov:ToJoinMemCovKey_Part_Sort.v' ; 
From Job Score that have the field mentioned

Code: Select all

ds13: {op9[4p] (parallel APT_TransformOperatorImplV114S1_NHI00_IHCISIPConfinementDetail_Ext_Xfrm_mbrcov in Xfrm_mbrcov)
      eOther(APT_HashPartitioner { key={ value=ENROLLEE_ID, 
        subArgs={ cs }
      }

ds29: {op22[4p] (parallel APT_TransformOperatorImplV0S61_NHI00_IHCISIPConfinementDetail_Ext_lkp_DRG_KEY in lkp_DRG_KEY)
      eOther(APT_HashPartitioner { key={ value=ENROLLEE_ID, 
        subArgs={ cs }
      }
The field is used in both sorting and partitioning, as I can see it in the Partitioner, is the sort operator fused with the partitioner ?

Posted: Fri Dec 02, 2016 9:13 pm
by ray.wurlod
How about you show us that part of the score that relates to the jn_MbrCov.ToJoinMemCovKey_Sort stage?