| plan { |
| type: UNIVPLAN_CONNECTOR |
| connector { |
| super { |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 1 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 3 |
| typeId: 250 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| leftPlan { |
| type: UNIVPLAN_AGG |
| agg { |
| super { |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_AGGREF |
| aggref { |
| transFuncId: 494 |
| retType: 103 |
| transInitVal: true |
| finalFuncId: 38324 |
| args { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 65001 |
| varAttNo: 1 |
| typeId: 103 |
| typeMod: -1 |
| } |
| } |
| funcId: 492 |
| } |
| } |
| resJunk: false |
| } |
| } |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 2 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 3 |
| typeId: 250 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| leftPlan { |
| type: UNIVPLAN_CONNECTOR |
| connector { |
| super { |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 1 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 3 |
| typeId: 250 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| leftPlan { |
| type: UNIVPLAN_AGG |
| agg { |
| super { |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_AGGREF |
| aggref { |
| transFuncId: 493 |
| retType: 103 |
| transInitVal: true |
| args { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 65001 |
| varAttNo: 1 |
| typeId: 103 |
| typeMod: -1 |
| } |
| } |
| funcId: 492 |
| } |
| } |
| resJunk: false |
| } |
| } |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 2 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 3 |
| typeId: 250 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| leftPlan { |
| type: UNIVPLAN_SCAN_SEQ |
| scanSeq { |
| super { |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 1 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| targetList { |
| type: UNIVPLAN_EXPR_TARGETENTRY |
| targetentry { |
| expression { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 3 |
| typeId: 250 |
| typeMod: -1 |
| } |
| } |
| resJunk: false |
| } |
| } |
| } |
| relId: 1 |
| tasks { |
| serializedSplits: "\000\000\001\000\000\000\005\000\000\000\000\000\000\000\370\372\000\000\000\377\377\377\377\377\377\377\377\001\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000/a\010\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000g\000\000\000\377\377\377\377\377\377\377\377\001\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\010\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000g\000\000\000\377\377\377\377\377\377\377\377\001\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\010\000\000\000\000\000\000\000\310\000\000\000\000\000\000\000g\000\000\000\377\377\377\377\377\377\377\377\001\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\010\000\000\000\000\000\000\000\377\377\377\377\377\377\377\377f\000\000\000\377\377\377\377\377\377\377\377\001\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\004\000\000\000\000\000\000\000\377\377\377\377" |
| } |
| tasks { |
| serializedSplits: "\000\000\002\000\000\000\005\000\000\000\000\000\000\000\370\372\000\000\000\377\377\377\377\377\377\377\377\002\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\004\000\000\000\000\000\000\000/a/b\020\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000g\000\000\000\377\377\377\377\377\377\377\377\002\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\001\000\000\000\000\000\000\000\002\000\000\000\000\000\000\000g\000\000\000\377\377\377\377\377\377\377\377\002\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\310\000\000\000\000\000\000\000d\000\000\000\000\000\000\000g\000\000\000\377\377\377\377\377\377\377\377\002\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\020\000\000\000\000\000\000\000\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377\377f\000\000\000\377\377\377\377\377\377\377\377\002\000\000\000\000\000\000\000\001\001\000\000\000\000\000\000\000\000\010\000\000\000\000\000\000\000\377\377\377\377\377\377\377\377" |
| } |
| columnsToRead: 0 |
| columnsToRead: 1 |
| } |
| } |
| } |
| numGroups: 1000 |
| groupColIndexes: 1 |
| groupColIndexes: 3 |
| } |
| } |
| } |
| type: CONNECTORTYPE_SHUFFLE |
| hashExpr { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 0 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| } |
| } |
| } |
| numGroups: 1000 |
| groupColIndexes: 1 |
| groupColIndexes: 3 |
| } |
| } |
| } |
| type: CONNECTORTYPE_CONVERGE |
| } |
| } |