| { |
| "distinct": false, |
| "targets": [ |
| { |
| "child": { |
| "name": "dt", |
| "type": "Column" |
| }, |
| "type": "Target" |
| }, |
| { |
| "child": { |
| "name": "dt2", |
| "type": "Column" |
| }, |
| "type": "Target" |
| }, |
| { |
| "child": { |
| "function": { |
| "distinct": false, |
| "signature": "row_number", |
| "params": [], |
| "type": "GeneralSetFunction" |
| }, |
| "windowSpec": { |
| "partitionKeys": [ |
| { |
| "signature": "round", |
| "params": [ |
| { |
| "name": "dt", |
| "type": "Column" |
| } |
| ], |
| "type": "Function" |
| }, |
| { |
| "name": "dt2", |
| "type": "Column" |
| } |
| ], |
| "sortSpecs": [ |
| { |
| "key": { |
| "signature": "ceil", |
| "params": [ |
| { |
| "name": "dt", |
| "type": "Column" |
| } |
| ], |
| "type": "Function" |
| }, |
| "asc": true, |
| "nullFirst": false |
| } |
| ], |
| "windowFrame": { |
| "unit": "ROW", |
| "startBound": { |
| "boundType": "PRECEDING", |
| "number": { |
| "valueType": "Unsigned_Integer", |
| "value": "1", |
| "type": "Literal" |
| } |
| }, |
| "endBound": { |
| "boundType": "CURRENT_ROW" |
| } |
| }, |
| "type": "WindowSpec" |
| }, |
| "type": "WindowFunction" |
| }, |
| "type": "Target" |
| } |
| ], |
| "child": { |
| "relations": [ |
| { |
| "tableName": "sum_example", |
| "type": "Relation" |
| } |
| ], |
| "type": "RelationList" |
| }, |
| "type": "Projection" |
| } |