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
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