You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
Add to Filters on a value inside an array in a native JSON column silently returns no rows #3640
"Add to Filters" on a value inside an array in a native JSON column returns no rows and shows no error. I expected the filter to match the rows that contain that value.
The row panel writes the array positions as quoted JSON keys, so the generated filter is:
toString(message.`events`.`0`.`detail`.`parameters`.`1`.`value`) IN ('EMAIL_SERVICE')
ClickHouse finds no key named 0 or 1 and returns nothing. Array elements are addressed with 1-based subscripts:
toString(message.`events`[1].`detail`.`parameters`[2].`value`) IN ('EMAIL_SERVICE')
On a table of 1,500 rows, the first form matched 0 rows and the second matched all 1,500.
Steps to reproduce
Reproduces on play.hyperdx.io? didn't try (needs a source whose attributes column is a native JSON type)
Open the source, set the range to the last hour, click Run.
Expand a row and open Column Values. Expand message → events → 0 → detail → parameters → 1.
Hover value and click the filter icon (Add to Filters).
The table shows no rows and no error. In </>, the filter uses `events`.`0` and `parameters`.`1`.
How are you running HyperDX?
The all-in-one image docker.clickhouse.com/clickhouse/clickstack-local, version 2.44.0 (from /health).
Where does it show up?
The UI: the row side panel, Column Values tab, "Add to Filters" icon.
Debug info
Not included. Version above.
Logs
None. There is no error; the query succeeds and returns zero rows.
Notes
mergePath in packages/app/src/utils.ts quotes every segment under a JSON column, so a numeric segment that is an array index comes out as a key. Numeric segments can also be real object keys, and facet keys built from the JSON schema rely on that, so the row viewer (which has the row data) is the place that can tell the two apart.
I have a fix with tests and a changeset and plan to open a PR from ralaruri:fix/json-array-paths.
Activity
pulpdrew commentedon Nov 18, 2026
/vouch @ralaruri
Update VOUCHED list (#3718)
fix(app): address JSON array elements by index in row-panel filters (C…