CODEWITHSUNDEEP
google-bigquery
Kris
Kris

Reputation: 23569

Google-Bigquery: Conflicting field names on JOIN?

I'm having a problem with the following JOIN:

SELECT a.id as a_id, b.id as b_id
  FROM tables.table_a as a
  JOIN tables.table_b as b
    ON a.id = b.id

This seems pretty basic to me, but despite the a. and b. prefixes I'm getting the following error message:

Error: Conflicting names in JOIN output: field id is present in both side of the JOIN.

Is this behavior known?

Upvotes: 4

Views: 1287

Answers (1)

Gwazilla
Gwazilla

Reputation: 41

I had this same issue and resolved it by checking the "flatten results" box in the hidden options when writing to a table.

Upvotes: 2

Related Questions