HJK181 commented on issue #7262:
URL: https://github.com/apache/pinot/issues/7262#issuecomment-895766305
What is working for the mappingTime default value is the following table
configuration:
```
{
"OFFLINE": {
"tableName": "kpis_OFFLINE",
"tableType": "OFFLINE",
"segmentsConfig": {
"timeType": "MILLISECONDS",
"schemaName": "kpis",
"timeColumnName": "timestamp",
"replication": "1"
},
"tenants": {
"broker": "DefaultTenant",
"server": "DefaultTenant"
},
"tableIndexConfig": {
"invertedIndexColumns": [],
"autoGeneratedInvertedIndex": false,
"createInvertedIndexDuringSegmentGeneration": false,
"loadMode": "MMAP",
"enableDefaultStarTree": false,
"enableDynamicStarTreeCreation": false,
"aggregateMetrics": false,
"nullHandlingEnabled": false
},
"metadata": {},
"ingestionConfig": {
"transformConfigs": [
{
"columnName": "timestamp",
"transformFunction": "Groovy({query.mappingTime == -1 ? 31536000:
query.mappingTime}, query)"
}
]
},
"isDimTable": false
}
}
```
I removed the `complexTypeConfig` but with this configuration, I get a
cardinality: 0 for all other columns:
```
Using fixed length dictionary for column: query.userQuery, size: 4
Created dictionary for STRING column: query.userQuery with cardinality: 1,
max length in bytes: 4, range: null to null
Created dictionary for LONG column: query.mappingTime with cardinality: 1,
range: -9223372036854775808 to -9223372036854775808
Using fixed length dictionary for column: query.masterQuery, size: 4
Created dictionary for STRING column: query.masterQuery with cardinality: 1,
max length in bytes: 4, range: null to null
Created dictionary for INT column: kpis.clicks with cardinality: 1, range: 0
to 0
Created dictionary for INT column: kpis.checkout with cardinality: 1, range:
0 to 0
Created dictionary for INT column: kpis.cart with cardinality: 1, range: 0
to 0
Created dictionary for LONG column: timestamp with cardinality: 28202,
range: 31536000 to 1623628697
```
--
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
