Is there any way to get a query plan from Pinot, such as indexes used to pull data, or is this something that you can only really interpret from the query response stats on the Controller's query console?
Couldn't find anything searching by key words like "query plan" or "explain" on the docs, so I'm assuming no?
08/19/2020, 6:26 PM
we removed explain, it was not very useful
stats were more useful
there is a trace feature
that will be dump a lot of details but its more for dev's
08/19/2020, 7:39 PM
I'm working on a blog post that explains how to debug a query using the execution statistics. @Joey Pereira, are you wanting to optimize query performance (segments, indexes, etc)?
08/19/2020, 7:48 PM
08/19/2020, 8:47 PM
I’ll expedite work on that. We can help you for the meantime if you are looking to optimize a query. LMK
08/21/2020, 4:19 PM
OOC, @Kenny Bastani were you going to touch on the details of specific execution statistics?
Was just trying to understand them a bit when comparing two different table setups and found the public docs are pretty sparse on specifics.
08/21/2020, 4:23 PM
My goal is to start with the high level interpretation of each stat and how it relates to the trade offs for indexing.