GitHub user prakhar2003 edited a discussion: Error: column reference "session_id" is ambiguous while filtering bar chart
i created a dataset over superset using the SQLlabs. I joined the tables as follows. ``` SELECT * FROM table1 as t1 INNER JOIN table1 as t2 ON t1.session_id = t2.session_id ``` now when I want to filter values (which are present over both session and perf table) over a bar chart, like **Where session_id is '3204701'**, I get error calling **Error: column reference "session_id" is ambiguous**. I tried to look at the columns available to filter columns, I see session_id and session_pk_id__1. 1. when I use session_id, then, Error: column reference "session_id" is ambiguous, (both if i use the dropdown filters and if I use custom SQL) 2. when I use session_id, then error Error: column "session_id" does not exist in virtual_table is thrown. 3. I further looked at a way to call the column with reference to its parent table, like t1.session_id like '3832864' and s1.table1 like '2938523', this gives Error: relation "t1" does not exist. GitHub link: https://github.com/apache/superset/discussions/34010 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
