Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[0.24.0] Explore / Visualise - Javascript error when using JSONB column #4885

Closed
Maxwell2022 opened this issue Apr 26, 2018 · 3 comments
Closed
Labels
#bug:cant-reproduce Bugs that cannot be reproduced !deprecated-label:bug Deprecated label - Use #bug instead

Comments

@Maxwell2022
Copy link

I'm getting an error when creating a table from a SQL editor (visualise).

When clicking on visualise, it's redirecting me to /superset/explore/ and loading forever with the following javascript error:

image

It's doing this with a specific table, I just have a SELECT * FROM "table_name" LIMIT 10 and it's crashing the visualiser. If I try with another table, then it's working. I thing it depends of the columns / data that is returned.

Superset version

0.24.0

Expected results

Display the visualisation

Actual results

Javascript error

Steps to reproduce

  1. Add a PostgreSQL source
  2. Go to the SQL Editor
  3. Perform a simple SQL query (not sure which one, some of them are working)
  4. Click on visualise (leave the default checkbox)
  5. Click on visualise again
@Maxwell2022
Copy link
Author

Just an update on this, issue. It looks like it's happening with JSONB column from my table.
If I omit this columns from the request, the visualiser is working as excepted

@Maxwell2022 Maxwell2022 changed the title [0.24.0] Explore / Visualise - Cannot read property 'match' of null [0.24.0] Explore / Visualise - Javascript error when using JSONB column Apr 27, 2018
@mistercrunch mistercrunch added !deprecated-label:bug Deprecated label - Use #bug instead help wanted labels Apr 27, 2018
@zhaoyongjie
Copy link
Member

I created an include JSONB column table in postgres, it seems ok, could you post you table DDL?
@Maxwell2022

@jazib
Copy link

jazib commented May 4, 2018

@Maxwell2022 i created a jsonb column and tried to replicate, but it seems to be working. can you show the table?

@kristw kristw added the #bug:cant-reproduce Bugs that cannot be reproduced label Feb 13, 2019
@kristw kristw closed this as completed Feb 13, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
#bug:cant-reproduce Bugs that cannot be reproduced !deprecated-label:bug Deprecated label - Use #bug instead
Projects
None yet
Development

No branches or pull requests

5 participants