当前位置: 动力学知识库 > 问答 > 编程问答 >

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?

网友答案:

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

分享给朋友:
您可能感兴趣的文章:
随机阅读: