Kent Yao created SPARK-56140:
--------------------------------
Summary: Add server-side pagination for SQL tab query listing
Key: SPARK-56140
URL: https://issues.apache.org/jira/browse/SPARK-56140
Project: Spark
Issue Type: Sub-task
Components: SQL
Affects Versions: 4.2.0
Reporter: Kent Yao
Follow-up to SPARK-55875: add server-side DataTables pagination for the SQL tab
query listing, following the same pattern as stagepage.js uses for tasks.
Current state: the SQL tab fetches all executions from the REST API in one
request. This works for typical workloads (<10K executions) but won't scale for
long-running applications like ThriftServer or Spark Connect Server with 50K+
SQL executions.
Implementation:
1. Add a new REST endpoint (e.g., /sql/sqlTable) that accepts DataTables
server-side parameters (offset, length, sort column, sort direction, search)
2. Switch allexecutionspage.js from client-side DataTables to serverSide: true
with ajax config
3. Server returns paginated results with recordsTotal and recordsFiltered counts
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
