If I've already created a table and batch ingested...
# generala
Aaron Wishnick
04/13/2021, 7:13 PMIf I've already created a table and batch ingested data, can I add a star-tree index after the fact or do I need to start from scratch?
k
Kishore G
04/13/2021, 7:19 PM
You can add Star tree index later.. all indexes can be added dynamically
a
Aaron Wishnick
04/13/2021, 7:28 PMThanks -- do I do that by updating the table config?
k
Kishore G
04/13/2021, 7:50 PM
right
Kishore G
04/13/2021, 7:50 PM
update table config and invoke reloadsegments api
j
Jackie
04/13/2021, 8:10 PMYou can refer to this doc: https://docs.pinot.apache.org/configuration-reference/table#table-index-config
Jackie
04/13/2021, 8:10 PMRemember to set
enableDynamicStarTreeCreationa
Aaron Wishnick
04/13/2021, 8:57 PMThanks!
Aaron Wishnick
04/13/2021, 8:59 PMIn this case what does it mean to compute the star-tree on the fly?
Aaron Wishnick
04/13/2021, 8:59 PMDo I need to set
enableDynamicStarTreeCreationj
Jackie
04/13/2021, 9:02 PMYes, you need to set
enableDynamicStarTreeCreationa
Aaron Wishnick
04/13/2021, 9:06 PMThanks!
Aaron Wishnick
04/13/2021, 9:32 PMIt looks like the reloadsegments API finished instantly -- should I expect it to take a while to reindex?
k
Kishore G
04/13/2021, 9:37 PM
Yes.. there is a status api you can invoke to check the status
a
Aaron Wishnick
04/13/2021, 9:37 PMThe table state API?
Aaron Wishnick
04/13/2021, 9:38 PMI see
Copy code
{
"state": "enabled"
}Aaron Wishnick
04/13/2021, 9:44 PMOk I think I got this working. At first I used the "reload" API which didn't seem to do anything. Then I tried the "reset" API and it did