Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[AMBIGUOUS_REFERENCE] Reference accountId is ambiguous, could be: [accountId, accountId] #1310

Open
arodriguezf opened this issue Dec 2, 2024 · 1 comment
Labels
user_question Questions coming from users

Comments

@arodriguezf
Copy link

Hello team!
I´m updating overwatch from version 0.7.2.2.1 to version 0.8.0.0 (and I will continue updating to the last version). The update was fine (executing the notebook to update config), but after that, running the overwatch pipeline, I got a problem during the process:

Beginning: 2010-Silver_JobsStatus --> Workspace ID: 6720070993575571
TIME RANGE: 2024-11-19 16:10:27 -> 2024-12-02 07:40:46

Beginning: 2008-Silver_SPARK_Tasks --> Workspace ID: 5769108933149883
TIME RANGE: 2024-11-29 09:50:41 -> 2024-12-02 07:40:49

Silver_JobsStatus: Validating Input Schemas
Silver_SPARK_Tasks: Validating Input Schemas
FAILED: 2010-Silver_JobsStatus Module: Failed

[AMBIGUOUS_REFERENCE] Reference `accountId` is ambiguous, could be: [`accountId`, `accountId`]. SQLSTATE: 42704
org.apache.spark.sql.AnalysisException: [AMBIGUOUS_REFERENCE] Reference `accountId` is ambiguous, could be: [`accountId`, `accountId`]. SQLSTATE: 42704
	at org.apache.spark.sql.errors.QueryCompilationErrors$.ambiguousReferenceError(QueryCompilationErrors.scala:2525)
	at org.apache.spark.sql.catalyst.expressions.package$AttributeSeq.resolve(package.scala:407)
	at org.apache.spark.sql.catalyst.plans.logical.LogicalPlan.resolveChildren(LogicalPlan.scala:183)

Do you know if there is some bug on the version or what can I do with that? Since I can´t modify the queries to put some aliases on them, I don´t know what to do there.
Thanks!

@arodriguezf arodriguezf added the user_question Questions coming from users label Dec 2, 2024
@arodriguezf
Copy link
Author

arodriguezf commented Dec 3, 2024

Btw, I´m using DBR: 15.4 LTS (includes Apache Spark 3.5.0, Scala 2.12), also I tested with DBR 13.3LTS, 12.2LTS and 11.3LTS and had the same issue

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
user_question Questions coming from users
Projects
None yet
Development

No branches or pull requests

1 participant