UI generates invalid ClickHouse queries when filtering on parsed JSON strings

[garysassano]

HyperDX UI automatically parses JSON strings in the StatusMessage column but fails to generate proper ClickHouse queries when users attempt to filter on nested JSON fields through the Search for this value only feature.

Steps to Reproduce

1. Have a span with a StatusMessage field (stored as a String in ClickHouse) containing JSON data.

2. In the HyperDX UI, the string is automatically parsed as JSON and displayed in a tree structure:

   

3. Navigate to the nested field (e.g., failures.0.index with value "identities")

4. Click Search for this value only:

   

Expected Behavior

The UI should generate a valid ClickHouse query using proper JSON Functions such as:

• simpleJSONExtractString(StatusMessage, 'index') = 'identities' for field matching

  

Actual Behavior

HyperDX generates an invalid query that fails with a ClickHouse syntax error. The UI knows how to parse and display the JSON structure correctly but cannot translate user filtering actions into proper ClickHouse queries.

Suggested Fix

The UI should:

1. Detect when a field is a JSON string that has been automatically parsed
2. Prefer simpleJSONExtractString for basic field matching as it's more reliable for nested JSON
3. Fall back to JSONExtractString only when precise path specification is required

Impact

This significantly impacts usability as users cannot effectively filter on JSON data through the UI, forcing them to write raw ClickHouse queries manually.

[teeohhem]

Thanks for the report! I've logged an issue with the team. Reference: HDX-2017