BigQuery Union Error: Syntax error: Expected keyword ALL or keyword DISTINCT but got keyword SELECT at 
Error: Syntax error: Expected keyword ALL or keyword DISTINCT but got keyword SELECT at [16:3]
- For Big Query, you will have to use "
UNION ALL"instead of
- Datatypes for all union columns should be the same
Read great educational content like this and a lot more !
Members get free exclusive access to content, new courses, and discounts. Signup for a free account to write a post / comment / upvote posts. Creating an account takes less than 5 seconds and you can start earning badges & points too