Google-Bigquery: conflicting field names in JOIN?

Question

I am 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 simple to me, but despite the prefixes a.and b., I get the following error message:

Error: Name conflict in JOIN output: field identifier is present on both sides of the JOIN.

Is this behavior known?

Answer 1

I had the same problem and resolved it by checking the "smooth the results" checkbox in hidden options when writing to the table.