saketbairoliya2 opened a new issue, #13851:
URL: https://github.com/apache/druid/issues/13851
Please provide a detailed title (e.g. "Broker crashes when using TopN query
with Bound filter" instead of just "Broker crashes").
### Affected Version
24.0.1
### Description
Please include as much detailed information about the problem as possible.
- Cluster size
Not sure if this information will be so relevant for this bug so skipping
the details.
- Configurations in use
```
{
"millisToWaitBeforeDeleting": 900000,
"mergeBytesLimit": 524288000,
"mergeSegmentsLimit": 100,
"maxSegmentsToMove": 5,
"percentOfSegmentsToConsiderPerMove": 100,
"useBatchedSegmentSampler": false,
"replicantLifetime": 15,
"replicationThrottleLimit": 10,
"balancerComputeThreads": 1,
"emitBalancingStats": false,
"killDataSourceWhitelist": [],
"killPendingSegmentsSkipList": [],
"maxSegmentsInNodeLoadingQueue": 100,
"decommissioningNodes": [],
"decommissioningMaxPercentOfMaxSegmentsToMove": 70,
"pauseCoordination": false,
"replicateAfterLoadTimeout": false,
"maxNonPrimaryReplicantsToLoad": 2147483647
}
```
- Steps to reproduce the problem
We were trying out a Join query - with left being queried at `granularity`
of `day` and right side of query is set to `all` `granularity`. On the `Join`
datasource, we wanted to add a virtualColumn and access one of the column.
Below is the sample query:
```
{
"queryType": "scan",
"dataSource": {
"type": "join",
"left": {
"type": "query",
"query": {
"queryType": "timeseries",
"dataSource": "multi_tenant_validated_output",
"granularity": "day",
"aggregations": [
{
"type": "doubleSum",
"fieldName": "double_sum",
"name": "sum_actual"
},
{
"type": "doubleSum",
"fieldName": "count",
"name": "count_actual"
}
],
"postAggregations": [
{
"type": "arithmetic",
"name": "mean_actual",
"fn": "/",
"fields": [
{
"type": "fieldAccess",
"fieldName": "sum_actual"
},
{
"type": "fieldAccess",
"fieldName": "count_actual"
}
]
}
],
"intervals": "2015-08-28/2025-10-20"
}
},
"right": {
"type": "query",
"query": {
"queryType": "timeseries",
"dataSource": "multi_tenant_validated_output",
"granularity": "all",
"aggregations": [
{
"type": "doubleSum",
"fieldName": "double_sum",
"name": "sum_expected"
},
{
"type": "doubleSum",
"fieldName": "count",
"name": "count_expected"
}
],
"postAggregations": [
{
"type": "arithmetic",
"name": "mean_expected",
"fn": "/",
"fields": [
{
"type": "fieldAccess",
"fieldName": "sum_expected"
},
{
"type": "fieldAccess",
"fieldName": "count_expected"
}
]
}
],
"intervals": "2015-08-28/2025-10-20"
}
},
"rightPrefix": "basesplit.",
"condition": "1",
"joinType": "INNER"
},
"intervals": {
"type": "intervals",
"intervals": [
"2015-08-28/2025-10-20"
]
},
"filter": {
"type": "and",
"fields": [
{
"type": "bound",
"dimension": "count_actual",
"lower": "1",
"ordering": "numeric"
}
]
},
"virtualColumns": [
{
"type": "expression",
"name": "mean_expected",
"expression": "basesplit.mean_expected",
"outputType": "DOUBLE"
}
]
}
```
- The error message or stack traces encountered. Providing more context,
such as nearby log messages or even entire logs, can be helpful.
<img width="1454" alt="Screenshot 2023-02-26 at 11 01 07 PM"
src="https://user-images.githubusercontent.com/5949441/221426474-96e494ee-3817-4050-a4eb-b5b3300759d6.png";>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
![https://user-images.githubusercontent.com/5949441/221426474-96e494ee-3817-4050-a4eb-b5b3300759d6.png"](https://user-images.githubusercontent.com/5949441/221426474-96e494ee-3817-4050-a4eb-b5b3300759d6.png"){kind=link}