Hi Team, Regarding indexes, in Realtime Table con...
# troubleshooting
a
Hi Team, Regarding indexes, in Realtime Table config we have provided the following:
Copy code
"tableIndexConfig": {
      "invertedIndexColumns": [
        "advertiser_id",
        "partner_id",
        "market_place_id"
      ],
"rangeIndexVersion": 1,
"autoGeneratedInvertedIndex": false,
"createInvertedIndexDuringSegmentGeneration": false,
"loadMode": "MMAP",
"enableDefaultStarTree": false,
"enableDynamicStarTreeCreation": false,
"aggregateMetrics": false,
"nullHandlingEnabled": true
When i check the table metadata, i get : http://serve1:9000/segments/reporting_aggregations/metadata?type=REALTIME
Copy code
{
  "reporting_aggregations__0__0__20220111T0608Z": {
    "segmentName": "reporting_aggregations__0__0__20220111T0608Z",
    "schemaName": null,
    "crc": 1605865976,
    "creationTimeMillis": 1641883074848,
    "creationTimeReadable": "2022-01-11T06:37:54:848 UTC",
    "timeGranularitySec": 0,
    "startTimeMillis": 1641790800000,
    "startTimeReadable": "2022-01-10T05:00:00.000Z",
    "endTimeMillis": 1641859200000,
    "endTimeReadable": "2022-01-11T00:00:00.000Z",
    "segmentVersion": "v3",
    "creatorName": null,
    "custom": {},
    "columns": [],
    "indexes": {},
    "star-tree-index": null
  }
}
and also when checked /pinot/data/server/index/reporting_aggregations_REALTIME/reporting_aggregations__0__0__20220111T0608Z/v3/metadata.properties , following is visible for each and every column in table
Copy code
column.postal_code.hasDictionary = true
column.postal_code.hasInvertedIndex = true
How to check which is correct? am i missing something in config?
m
The first one is from ZK and the second one is from the segment.
IIRC, there’s an api that gives you the indexing status cc: @Mark Needham
m