Superset v1.3.0 incompatibility with JSON Column

opensrp / opensrp-reveal-datawarehouse

Scripts that build the Reveal data warehouse

0 stars 1 forks source link

Open HusnaHariz opened 3 years ago

HusnaHariz commented 3 years ago

When fetching data via the api using the slice_json endpoint, the following error is thrown

PG::UndefinedFunction: ERROR: could not identify an equality operator for type json

HusnaHariz commented 3 years ago

The column task_business_status_map is set as a JSON type. After converting the type to JSONB, the slice_json returns recofrds with no error