superset-notifications mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From GitBox <...@apache.org>
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:
URL: https://github.com/apache/incubator-superset/issues/10754


   Error in Explore view when the underlining query filters a JSONB array in PostgreSQL that
contains integer values.
   
   Workaround
   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
   ![image](https://user-images.githubusercontent.com/47314887/91852086-fb97b980-ec68-11ea-9a1e-c95f71cb69bd.png)
   
   
   #### 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
   
   `select 
   *
   from jsonb_datasource
   WHERE jsonb_datasource.transactions @> '[{"transaction_status":"SUCCESS",**"transaction_id":
1**}]'`
   
   ### 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:
users@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org


Mime
View raw message