esilver opened a new issue #9836: URL: https://github.com/apache/incubator-superset/issues/9836
When using a chart filter on a nested Big Query field, for example, field.field_name with the `like` operator %name%, superset will generate an alias in the `WHERE` clause of the query, which will lead to a syntax error: `bigquery error: 400 Unrecognized name: field_field_name_0b211 ` ### Expected results Superset chart returns filtered result ### Actual results Error: `bigquery error: 400 Unrecognized name: field_field_name_0b211 ` #### How to reproduce the bug 1. Go to a chart 2. Click on query filter at the bottom of a chart 3. Select the like operator on a nested Bigquery field 4. run the query 5. See error ### Environment - superset version: `0.36.0` - python version: `3.6` - node.js version: `12` - npm version: `6.12` ### Checklist Make sure these boxes are checked before submitting your issue - thank you! - [x] I have checked the superset logs for python stacktraces and included it here as text if there are any. - [x] I have reproduced the issue with at least the latest released version of superset. - [x] I have checked the issue tracker for the same issue and I haven't found one similar. ### Additional context Using the community docker image (https://hub.docker.com/r/amancevice/superset/tags ) ---------------------------------------------------------------- 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: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
