query topN with join the result not rollup

[wengwh]

i use topN query with join，result not rollup，only i use groupBy the result will correct. how can i use top with join?
{
"queryType": "topN",
"dataSource": {
"type": "join",
"left": "xxx",
"right": {
"type": "query",
"query": {
"queryType": "scan",
"dataSource":{
"type":"table",
"name":"yyy"
},
"context": {
"timeout": 180000
},
"intervals": "2020-07-02T00Z/2020-07-03T00Z",
"granularity": "all",
"columns": [
"uid",
"channel"
],
"limit": 100000,
"lenientAggregatorMerge": false,
"descending": false
}
},
"rightPrefix": "r.",
"condition": "uid== "r.uid"",
"joinType": "INNER"
},
"context": {
"timeout": 180000,
"priority": 2147483647,
"queryId": "wwh-test",
"skipJwoodCache": false,
"weight": 0
},
"intervals": "2020-07-02T00Z/2020-07-03T00Z",
"filter": {
"type": "in",
"dimension": "r.channel",
"values": [
"googleplay",
"appstore"
],
"lowerStrict": false,
"upperStrict": false,
"alphaNumeric": false
},
"aggregations": [
{
"type": "thetaSketch",
"name": "!Theta_counted_uid",
"fieldName": "counted_uid",
"byRow": false,
"inputThetaSketch": false
},
{
"type": "doubleSum",
"name": "item_golds",
"fieldName": "item_golds",
"byRow": false,
"inputThetaSketch": false
}
],
"postAggregations": [
{
"type": "thetaSketchEstimate",
"name": "counted_uid",
"field": {
"type": "fieldAccess",
"fieldName": "!Theta_counted_uid"
}
}
],
"granularity": "all",
"lenientAggregatorMerge": false,
"merge": true,
"dimension": {
"type": "default",
"dimension": "r.channel",
"outputName": "channel"
},
"threshold": 500,
"metric": {
"type": "lexicographic"
},
"descending": false,
"virtualColumns": []
}

[clintropolis]

Hi @wengwh, based on the description in your issue, it seems possible this will be resolved by #10053, which fixed a bug I ran into when using top-n queries as a part of a join query caused by a flaw in the query engine algorithm selection. This fix will be part of 0.19, which should be released soon.

[wengwh]

@clintropolis thanks i will wait for the new version,.