lgo opened a new issue #6143:
URL: https://github.com/apache/incubator-pinot/issues/6143
While testing some results, I accidentally used the wrong name to refer to a
column. When querying, rather than raising an error the query actually returned
but with `0` results, such as the following
**Query**
_Note: `amount` does not exist on the table. This was meant to be `balance`!_
```sql
select count(*), sum(amount) from adjustments where type = 'foobar'
```
**Result**
```json
{
"resultTable": {
"dataSchema": {
"columnNames": [
"count(*)",
"sum(amount)"
],
"columnDataTypes": [
"LONG",
"DOUBLE"
]
},
"rows": [
[
0,
0
]
]
},
"exceptions": [],
"numServersQueried": ...,
"numServersResponded": ...,
"numSegmentsQueried": ...,
"numSegmentsProcessed": 0,
"numSegmentsMatched": 0,
"numConsumingSegmentsQueried": 0,
"numDocsScanned": 0,
"numEntriesScannedInFilter": 0,
"numEntriesScannedPostFilter": 0,
"numGroupsLimitReached": false,
"totalDocs": ...,
"timeUsedMs": 10,
"segmentStatistics": [],
"traceInfo": {},
"minConsumingFreshnessTimeMs": 0
}
```
Here is a simplified example configuration we were using, in case this ends
up being particular about the table config. (irrelevant columns were prunted
from the example).
## Schema
```json
{
"schemaName": "adjustment",
"dimensionFieldSpecs": [
{
"name": "type",
"dataType": "STRING"
},
],
"metricFieldSpecs": [
{
"name": "balance",
"dataType": "DOUBLE"
},
],
"dateTimeFieldSpecs": [
{
"name": "created_at",
"dataType": "LONG",
"format": "1:SECONDS:EPOCH",
"granularity": "1:HOURS"
}
]
}
```
## Table config
```json
{
"OFFLINE": {
"tableName": "adjustment_OFFLINE",
"tableType": "OFFLINE",
"segmentsConfig": {
"timeType": "SECONDS",
"schemaName": "adjustment",
"segmentPushFrequency": "HOURLY",
"segmentPushType": "APPEND",
"timeColumnName": "created_at",
"replication": "1"
},
"tenants": {
"broker": "DefaultTenant",
"server": "DefaultTenant"
},
"tableIndexConfig": {
"bloomFilterColumns": [
"type"
],
"loadMode": "MMAP",
"noDictionaryColumns": [],
"enableDefaultStarTree": false,
"starTreeIndexConfigs": [
{
"dimensionsSplitOrder": [
"type",
],
"functionColumnPairs": [
"SUM__balance",
"COUNT"
],
"maxLeafRecords": 1
}
],
"enableDynamicStarTreeCreation": false,
"segmentPartitionConfig": {
"columnPartitionMap": {
"type": {
"functionName": "Murmur",
"numPartitions": 100
}
}
},
"aggregateMetrics": false,
"nullHandlingEnabled": false,
"invertedIndexColumns": [
"type"
],
},
"metadata": {},
"routing": {
"segmentPrunerTypes": [
"partition"
]
}
}
}
```
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org
