Segments tab in Druid's web console no longer works

[weishiuntsai]

The Segments tab in Druid's web console no longer works

Affected Version

0.20.0

Description

The Segments tab in Druid's web console no longer works. Its query references a column "payload" which doesn't exist anymore. "payload" was removed by the PR #9883.

The error message from the broker log:

2020-07-09T17:50:30,729 WARN [sql[1b1bd460-5f7b-49f1-9603-2c7a7b6618b5]] org.apache.druid.sql.http.SqlResource - Failed to handle query: SqlQuery{query='SELECT "segment_id", "datasource", "start", "end", "size", "version", "partition_num", "num_replicas", "num_rows", "is_published", "is_available", "is_realtime", "is_overshadowed", "payload"
FROM sys.segments
ORDER BY "start" DESC
LIMIT 25', resultFormat=OBJECT, header=false, context={}, parameters=[]}
org.apache.calcite.tools.ValidationException: org.apache.calcite.runtime.CalciteContextException: From line 1, column 182 to line 1, column 190: Column 'payload' not found in any table

[weishiuntsai]

The browser needs to be refreshed if it had accessed an older version of Druid.