Skip to content

Partitioned Postgis - can't query JSON-type columns using json path #10742

Description

@elahrvivaz

Partitioned Postgis - can't query JSON-type columns using json path

Both of the following filters throw errors:

jsonPath('$.metadata.foo') = 'bar'

metadata ILIKE '%bar%'

Potential work-around:
jsonPointer(metadata, '/foo') = 'bar'


Original JIRA Issue: https://geomesa.atlassian.net/browse/GEOMESA-3568

Key: GEOMESA-3568
Type: Bug
Priority: Major
Status: To Do
Resolution: Unresolved
Reporter: Emilio Lahr-Vivaz
Created: Thu, 16 Apr 2026 15:19:55 -0400
Updated: Thu, 16 Apr 2026 15:22:56 -0400

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions