superset-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <>
Subject [GitHub] [incubator-superset] GiannisDimitriou opened a new issue #10754: Explore PostgreSQL Datasource with JSONB array ERROR
Date Tue, 01 Sep 2020 12:42:36 GMT

GiannisDimitriou opened a new issue #10754:

   Error in Explore view when the underlining query filters a JSONB array in PostgreSQL that
contains integer values.
   Convert the integer value inside the JSONB array to string
   what you expected to happen.
   Since the query is working as expected in SQL Lab, we should be able to create a chart
utilizing it.
   what actually happens.
   #### Screenshots
   #### How to reproduce the bug
   1) Create a query in SQL Lab that filters a JSONB array in PostgreSQL, where the value
is integer (example below)
   2) Create a datasource out of this query
   3) Error in Explore view when trying to create a chart
   from jsonb_datasource
   WHERE jsonb_datasource.transactions @> '[{"transaction_status":"SUCCESS",**"transaction_id":
   ### Environment
   - superset version: 0.37.0rc1

This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message