java.lang.IllegalArgumentException: Invalid node. Expression dependencies ([field]) not in source plan output ([filter, $hashvalue])

GitHub | martint | 3 months ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  1. 0

    Planning failure when lambda appears in select and group by clause

    GitHub | 3 months ago | martint
    java.lang.IllegalArgumentException: Invalid node. Expression dependencies ([field]) not in source plan output ([filter, $hashvalue])
  2. 0

    Planning failure for correlated subquery

    GitHub | 3 months ago | martint
    java.lang.IllegalArgumentException: Invalid node. Expression dependencies ([custkey_1]) not in source plan output ([orderkey, unique, $hashvalue_45, avg])
  3. 0

    Unable to create plan for query with duplicated IN predicates

    GitHub | 5 months ago | kokosing
    java.lang.IllegalArgumentException: Invalid node. Expression dependencies ([semijoin_result]) not in source plan output ([expr_4, $hashvalue_22, semijoin_result_17])
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Planning error when same subquery appears in SELECT and WHERE clause

    GitHub | 11 months ago | martint
    java.lang.IllegalArgumentException: Invalid node. Expression dependencies ([field, field_1]) not in source plan output ([field, semijoin_result])
  6. 0

    Some queries with varchar(n) fail

    GitHub | 9 months ago | cberner
    java.lang.IllegalArgumentException: type of symbol 'expr_249' is expected to be varchar, but the actual type is varchar(3)
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.lang.IllegalArgumentException

    Invalid node. Expression dependencies ([field]) not in source plan output ([filter, $hashvalue])

    at com.google.common.base.Preconditions.checkArgument()
  2. Guava
    Preconditions.checkArgument
    1. com.google.common.base.Preconditions.checkArgument(Preconditions.java:145)
    1 frame
  3. com.facebook.presto
    ValidateDependenciesChecker$Visitor.visitProject
    1. com.facebook.presto.sql.planner.sanity.ValidateDependenciesChecker.checkDependencies(ValidateDependenciesChecker.java:645)
    2. com.facebook.presto.sql.planner.sanity.ValidateDependenciesChecker.access$100(ValidateDependenciesChecker.java:80)
    3. com.facebook.presto.sql.planner.sanity.ValidateDependenciesChecker$Visitor.visitProject(ValidateDependenciesChecker.java:260)
    4. com.facebook.presto.sql.planner.sanity.ValidateDependenciesChecker$Visitor.visitProject(ValidateDependenciesChecker.java:94)
    4 frames
  4. presto-main
    ProjectNode.accept
    1. com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:92)
    1 frame
  5. com.facebook.presto
    ValidateDependenciesChecker$Visitor.visitOutput
    1. com.facebook.presto.sql.planner.sanity.ValidateDependenciesChecker$Visitor.visitOutput(ValidateDependenciesChecker.java:303)
    2. com.facebook.presto.sql.planner.sanity.ValidateDependenciesChecker$Visitor.visitOutput(ValidateDependenciesChecker.java:94)
    2 frames
  6. presto-main
    OutputNode.accept
    1. com.facebook.presto.sql.planner.plan.OutputNode.accept(OutputNode.java:82)
    1 frame
  7. com.facebook.presto
    PlanSanityChecker.lambda$validate$0
    1. com.facebook.presto.sql.planner.sanity.ValidateDependenciesChecker.validate(ValidateDependenciesChecker.java:91)
    2. com.facebook.presto.sql.planner.sanity.ValidateDependenciesChecker.validate(ValidateDependenciesChecker.java:86)
    3. com.facebook.presto.sql.planner.sanity.PlanSanityChecker.lambda$validate$0(PlanSanityChecker.java:44)
    3 frames
  8. Java RT
    Iterable.forEach
    1. java.lang.Iterable.forEach(Iterable.java:75)
    1 frame
  9. com.facebook.presto
    PlanSanityChecker.validate
    1. com.facebook.presto.sql.planner.sanity.PlanSanityChecker.validate(PlanSanityChecker.java:44)
    1 frame
  10. presto-main
    QueuedExecution.lambda$start$1
    1. com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:127)
    2. com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:111)
    3. com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:297)
    4. com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:276)
    5. com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:234)
    6. com.facebook.presto.execution.QueuedExecution.lambda$start$1(QueuedExecution.java:63)
    6 frames
  11. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames