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.

Sign up for GitHub

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

Jump to bottom

I'm unable to view a late binding view's columns in the Redash schema explorer #3536

Closed
paulgraff opened this issue Mar 5, 2019 · 0 comments · Fixed by #3537
Closed

I'm unable to view a late binding view's columns in the Redash schema explorer #3536

paulgraff opened this issue Mar 5, 2019 · 0 comments · Fixed by #3537

Comments

@paulgraff
Copy link
Contributor

paulgraff commented Mar 5, 2019 •
edited
Loading

Issue Summary

Since #2174 was merged in 2017, the svv_columns system view has been updated to include late-binding views. This results in duplicate columns being returned by Redash's column aggregation query, which is creating front-end errors when I go to view a table's columns using the schema browser:

Error: "[ngRepeat:dupes] Duplicates in a repeater are not allowed. Use 'track by' expression to specify unique keys. Repeater: column in table.columns track by column, Duplicate key: teamid, Duplicate value: teamid
http://errors.angularjs.org/1.5.11/ngRepeat/dupes?p0=column%20in%20table.columns%20track%20by%20column&p1=teamid&p2=teamid"

Steps to Reproduce

  1. Create a late-binding view in Redshift
  2. Try to view its columns using the schema explorer in Redash
  3. Note the JS errors in the browser console

Technical details:

  • Redash Version: 5.0.0
  • Browser/OS: Firefox (Quantum) 65.0.1/MacOS 10.14
  • How did you install Redash: Setup script
@paulgraff paulgraff mentioned this issue Mar 5, 2019
Merged
3 tasks
@ghost ghost added the in progress label Mar 5, 2019
@paulgraff paulgraff changed the title Revert https://github.com/getredash/redash/pull/2174 to fix column rendering bug for late-binding views I'm unable to view a late binding view's columns in the Redash schema explorer Mar 5, 2019
@ghost ghost removed the in progress label Mar 6, 2019
@weekly-digest weekly-digest bot mentioned this issue Mar 10, 2019
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

Remove duplicate column information for late-binding views paulgraff/redash
1 participant
@paulgraff