BigQuery - cannot UNION String and NULL

Question

I have two tables that I am trying to UNION. Column id in table1 is of type STRING. I do not have that column in table2 so I am writing SELECT NULL AS id FROM table2 but BigQuery thinks that column id in table2 is of type INT64.

I get this error - Column 2 in UNION ALL has incompatible types: STRING, INT64.

Query works if I write SELECT "" AS id FROM table2 instead.

In your upper query select cast(null as string)

HoneyBadger
– HoneyBadger

2018-02-01 09:01:43 +00:00
Commented Feb 1, 2018 at 9:01 — HoneyBadger
– HoneyBadger, Commented Feb 1, 2018 at 9:01
..or STRING(NULL) should work as well

Graham Polley
– Graham Polley

2018-02-01 10:21:38 +00:00
Commented Feb 1, 2018 at 10:21 — Graham Polley
– Graham Polley, Commented Feb 1, 2018 at 10:21

Melissa Guo · Accepted Answer · 2019-08-06 17:30:23Z

7

SELECT id FROM table1 UNION ALL SELECT CAST(NULL AS STRING) FROM table2

answered Aug 6, 2019 at 17:30

Melissa Guo

1,09812 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

BigQuery - cannot UNION String and NULL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related