Hi, I am trying to run the following query using UNNEST
SELECT keywords FROM "query-annotation"."query_annotation" CROSS JOIN UNNEST(browse_nodes) AS single_browse_node WHERE marketplace_id=3 AND single_browse_node='x' LIMIT 50;
The above query is failing with the following error - SYNTAX_ERROR: line 3:28: Column 'single_browse_node' cannot be resolved
Although I am creating the unnest column with the given name but still it is failing. How do I fix this ? Any help would be really appreciated.
EDIT: If I try the following SELECT * FROM "query-annotation"."query_annotation" CROSS JOIN UNNEST(browse_nodes) AS single_browse_node WHERE marketplace_id=3 LIMIT 50;
, this prints a column at the last with the heading _col21 having single_browse_node value in it and is not picking up the assigned name.
Thanks !!