I created a star tree index for a realtime table, ...
# general
a
I created a star tree index for a realtime table, how can I verify if it works or not? and there is any tool to view this index data?
m
if you call:
Copy code
<http://localhost:9000/segments/><YOURTABLENAME>/metadata
Copy code
{
  "baseballStats_OFFLINE_0": {
    "segmentName": "baseballStats_OFFLINE_0",
    "schemaName": null,
    "crc": 3449875305,
    "creationTimeMillis": 1648546440888,
    "creationTimeReadable": "2022-03-29T09:34:00:888 UTC",
    "timeGranularitySec": null,
    "startTimeMillis": null,
    "startTimeReadable": null,
    "endTimeMillis": null,
    "endTimeReadable": null,
    "segmentVersion": "v3",
    "creatorName": null,
    "custom": {
      "input.data.file.uri": "file:/opt/pinot/examples/batch/baseballStats/rawdata/baseballStats_data.csv"
    },
    "columns": [],
    "indexes": {},
    "star-tree-index": null
  }
}
it will tell you if a star tree index has been defined
on that last property
a
I checked metadata using this way and I found star-tree-index is null. I modified my table config to add a star tree index.
It seems the index didn’t work. Any idea how can I make it work?
I just tried “enableDynamicStarTreeCreation”: true, then it worked. Thanks @User
👍 1