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 commented on issue #10754: Explore PostgreSQL Datasource with JSONB array ERROR
Date Mon, 07 Sep 2020 07:24:17 GMT

GiannisDimitriou commented on issue #10754:
URL: https://github.com/apache/incubator-superset/issues/10754#issuecomment-688097787


   @villebro  thanks for trying to reproduce this. 
   I don't use any additional filters on the JSONB column. 
   Also the end query is a bit more complicated so exposing the `transaction_id` on a different
column will make things a lot more complicated.
   
   Can you try running the below query in SQL Lab and then press EXPLORE in order to visualise
it.
   This is what I see following the above steps:
   
   `SELECT 
   *
   FROM (
   SELECT 
   *
   FROM (
   VALUES 
   (1::int,'[{"transaction_status":"SUCCESS","transaction_id":1},{"transaction_status":"SUCCESS","transaction_id":2}]'::jsonb),
   (2::int,'[{"transaction_status":"PENDING","transaction_id":3},{"transaction_status":"CANCEL","transaction_id":4}]'::jsonb)
   ) s(id, transaction_details)
   ) t
   WHERE transaction_details @> '[{"transaction_status":"SUCCESS","transaction_id":1}]'`
   
   ![image](https://user-images.githubusercontent.com/47314887/92359393-d89b5880-f0f3-11ea-83fe-ffda82404e38.png)
   ![image](https://user-images.githubusercontent.com/47314887/92359493-02ed1600-f0f4-11ea-9935-d3d728884283.png)
   


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