HJK181 edited a comment on issue #7262:
URL: https://github.com/apache/pinot/issues/7262#issuecomment-895762497
@npawar Same result, `cardinality: 1`. I don't understand why it should be
'$.mapping' the avro field is called `mappingTime` and in my schema definition
I have configured
```
"dateTimeFieldSpecs": [
{
"name": "timestamp",
"dataType": "LONG",
"format": "1:SECONDS:EPOCH",
"granularity": "15:MINUTES"
},
{
"name": "query.mappingTime",
"dataType": "LONG",
"format": "1:SECONDS:EPOCH",
"granularity": "15:MINUTES"
}
]
```
So `JSONPATHLONG(query, '$.mappingTime', 31536000)` should be correct,
shouldn't it? But this also results in `cardinality: 1`
Btw. if I remove
```
,
"complexTypeConfig": {
"fieldsToUnnest": [
"query",
"kpis"
]
}
```
from my table configuration I get
`Created dictionary for LONG column: timestamp with cardinality: 28202,
range: -1 to 1623628697` Looks like JSONPATHLONG is working here, but no
default value is used, as I guess it will be used in case the column is `null`
but in my case I want the default value to be set if the column's value is
equal to `-1`.
--
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: commits-unsubscr...@pinot.apache.org
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
