Circular joins among tables

Can Athena respond accurately even if there are any circular joins among tables ?

hi @kousalya.jayasankar Athena will bring wrong data if circular join formed. Mostly Circular joins formed based on the Relationship configured in the SME screen. We have to configure proper relationship among tables.Thanks.

1 Like