I also asked Devin a question: Can I use a star-tree index with upserts? I was pleasantly surprised by the answer: https://deepwiki.com/search/can-i-use-a-st

I also asked Devin a question: Can I use a star-tree index with upserts? I was pleasantly surprised by the answer: https://deepwiki.com/search/can-i-use-a-startree-index-wit_ac7b3d92-a465-4139-be58-4137d9e31929#1 https://deepwiki.com/search/can-i-use-a-startree-index-wit_a... Briefly: "No, you cannot use a star-tree index with upserts in Apache Pinot. This is a built-in restriction that is explicitly enforced in the system." Why This Restriction Exists When upserts are enabled for a table in Pinot, the system explicitly checks and prevents the use of star-tree indexes. This validation happens during table configuration validation. The code in TableConfigUtils.java explicitly enforces this restriction: [snip] At cursory glance, I did not detect a hallucination. The answer was true (AFAIK), clear, and objective. I also see that you can peek into other resources to get some additional contextual information. Very impressive work.