| plan { |
| type: UNIVPLAN_LIMIT |
| limit { |
| 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: 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: 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_LIMIT |
| limit { |
| 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: 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_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: 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_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 |
| } |
| } |
| qualList { |
| type: UNIVPLAN_EXPR_OPEXPR |
| opexpr { |
| funcId: 158 |
| retType: 300 |
| args { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 2 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| args { |
| type: UNIVPLAN_EXPR_CONST |
| val { |
| type: 102 |
| isNull: false |
| value: "1" |
| typeMod: -1 |
| } |
| } |
| } |
| } |
| qualList { |
| type: UNIVPLAN_EXPR_OPEXPR |
| opexpr { |
| funcId: 92 |
| retType: 300 |
| args { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 1 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| args { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 2 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| } |
| } |
| qualList { |
| type: UNIVPLAN_EXPR_OPEXPR |
| opexpr { |
| funcId: 35 |
| retType: 300 |
| args { |
| type: UNIVPLAN_EXPR_FUNCEXPR |
| funcexpr { |
| funcId: 0 |
| retType: 300 |
| } |
| } |
| args { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 1 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| } |
| } |
| qualList { |
| type: UNIVPLAN_EXPR_BOOLEXPR |
| boolexpr { |
| args { |
| type: UNIVPLAN_EXPR_OPEXPR |
| opexpr { |
| funcId: 164 |
| retType: 300 |
| args { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 1 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| args { |
| type: UNIVPLAN_EXPR_CONST |
| val { |
| type: 102 |
| isNull: false |
| value: "1" |
| typeMod: -1 |
| } |
| } |
| } |
| } |
| args { |
| type: UNIVPLAN_EXPR_OPEXPR |
| opexpr { |
| funcId: 14 |
| retType: 300 |
| args { |
| type: UNIVPLAN_EXPR_VAR |
| var { |
| varNo: 1 |
| varAttNo: 2 |
| typeId: 102 |
| typeMod: -1 |
| } |
| } |
| args { |
| type: UNIVPLAN_EXPR_CONST |
| val { |
| type: 102 |
| isNull: false |
| value: "10" |
| typeMod: -1 |
| } |
| } |
| } |
| } |
| type: BOOLEXPRTYPE_OR_EXPR |
| } |
| } |
| } |
| 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 |
| } |
| } |
| planRows: 110 |
| planRowWidth: 0 |
| operatorMemKB: 0 |
| } |
| limitOffset { |
| type: UNIVPLAN_EXPR_CONST |
| val { |
| type: 103 |
| isNull: false |
| value: "0" |
| typeMod: -1 |
| } |
| } |
| limitCount { |
| type: UNIVPLAN_EXPR_OPEXPR |
| opexpr { |
| funcId: 339 |
| retType: 103 |
| args { |
| type: UNIVPLAN_EXPR_CONST |
| val { |
| type: 103 |
| isNull: false |
| value: "10" |
| typeMod: -1 |
| } |
| } |
| args { |
| type: UNIVPLAN_EXPR_CONST |
| val { |
| type: 103 |
| isNull: false |
| value: "100" |
| typeMod: -1 |
| } |
| } |
| } |
| } |
| } |
| } |
| } |
| type: CONNECTORTYPE_CONVERGE |
| } |
| } |
| planRows: 110 |
| planRowWidth: 0 |
| operatorMemKB: 0 |
| } |
| limitOffset { |
| type: UNIVPLAN_EXPR_CONST |
| val { |
| type: 103 |
| isNull: false |
| value: "100" |
| typeMod: -1 |
| } |
| } |
| limitCount { |
| type: UNIVPLAN_EXPR_CONST |
| val { |
| type: 103 |
| isNull: false |
| value: "10" |
| typeMod: -1 |
| } |
| } |
| } |
| } |
| rangeTables { |
| table { |
| tableId: 0 |
| format: INVALID_FORMAT |
| location: "" |
| tableOptionsInJson: "" |
| } |
| } |
| rangeTables { |
| table { |
| tableId: 2 |
| format: ORC_FORMAT |
| location: "/tmp" |
| tableOptionsInJson: "TableOptionsInJson_20" |
| columns { |
| columnName: "p1" |
| typeId: 102 |
| typeMod: -1 |
| } |
| columns { |
| columnName: "p2" |
| typeId: 250 |
| typeMod: -1 |
| } |
| } |
| } |
| receivers { |
| listener { |
| address: "mdw" |
| port: 101 |
| } |
| } |
| receivers { |
| listener { |
| address: "smdw" |
| port: 201 |
| } |
| listener { |
| address: "smdw" |
| port: 203 |
| } |
| } |
| doInstrument: true |
| commonValue { |
| key: "TableOptionsInJson_20" |
| value: "option1 string in json" |
| } |
