Impala Public Jenkins has submitted this change and it was merged. ( http://gerrit.cloudera.org:8080/24284 )
Change subject: IMPALA-14963: Query Profile AI Analysis Tool ...................................................................... IMPALA-14963: Query Profile AI Analysis Tool The query profile AI analysis component provides an end-to-end workflow for generating bottleneck analysis directly from the query details page, so users can inspect root-cause hypotheses without leaving the Impala UI. Implementation adds a new /query_ai_analysis tab and template, a /query_ai_analysis_generate endpoint, and a backend pipeline that loads the query profile JSON, redacts sensitive identifiers, runs an iterative tool-calling analysis loop through ai_generate_text, and unredacts the final response for display. It also extends OpenAI response parsing to handle native tool_calls payloads and increases AI connection timeout to better support longer analysis runs. Tests added: Unit tests verify that the AI-analysis helper logic can reliably parse noisy model responses and extract assistant content across expected and malformed payload shapes. They also validate the concurrency guard by confirming multithreaded slot acquisition never exceeds the configured max. Manual Tests: Manually verified the full end-to-end AI analysis flow on a local Impala setup using a TPC-DS query profile to validate LLM interaction and output correctness. Code Generated-by: Cursor AI Change-Id: Ia9376b8c56df75032f51abbb76b3ac6927f9107e Reviewed-on: http://gerrit.cloudera.org:8080/24284 Reviewed-by: Jason Fehr <[email protected]> Reviewed-by: Yida Wu <[email protected]> Tested-by: Impala Public Jenkins <[email protected]> --- M be/src/exprs/ai-functions-ir.cc M be/src/exprs/ai-functions.cc M be/src/exprs/expr-test.cc M be/src/service/CMakeLists.txt M be/src/service/impala-http-handler.cc M be/src/service/impala-http-handler.h A be/src/service/query-profile-ai-analysis-test.cc A be/src/service/query-profile-ai-analysis.cc A be/src/service/query-profile-ai-analysis.h M be/src/service/query-profile-parsing-tools-test.cc M be/src/service/query-profile-parsing-tools.cc M be/src/service/query-profile-parsing-tools.h M be/src/service/query-profile-redaction-test.cc M be/src/service/query-profile-redaction.cc M be/src/service/query-profile-redaction.h M be/src/util/json-util.h A www/query_ai_analysis.tmpl M www/query_detail_tabs.tmpl 18 files changed, 1,693 insertions(+), 164 deletions(-) Approvals: Jason Fehr: Looks good to me, but someone else must approve Yida Wu: Looks good to me, approved Impala Public Jenkins: Verified -- To view, visit http://gerrit.cloudera.org:8080/24284 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-MessageType: merged Gerrit-Change-Id: Ia9376b8c56df75032f51abbb76b3ac6927f9107e Gerrit-Change-Number: 24284 Gerrit-PatchSet: 27 Gerrit-Owner: Gokul Kolady <[email protected]> Gerrit-Reviewer: Abhishek Rawat <[email protected]> Gerrit-Reviewer: Csaba Ringhofer <[email protected]> Gerrit-Reviewer: Gokul Kolady <[email protected]> Gerrit-Reviewer: Impala Public Jenkins <[email protected]> Gerrit-Reviewer: Jason Fehr <[email protected]> Gerrit-Reviewer: Kurt Deschler <[email protected]> Gerrit-Reviewer: Yida Wu <[email protected]>
