java.lang.IllegalArgumentException

type of symbol 'expr_249' is expected to be varchar, but the actual type is varchar(3)

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web728

  • Stack trace

    • java.lang.IllegalArgumentException: type of symbol 'expr_249' is expected to be varchar, but the actual type is varchar(3) at com.google.common.base.Preconditions.checkArgument(Preconditions.java:145) at com.facebook.presto.sql.planner.sanity.TypeValidator$Visitor.verifyTypeSignature(TypeValidator.java:161) at com.facebook.presto.sql.planner.sanity.TypeValidator$Visitor.visitProject(TypeValidator.java:116) at com.facebook.presto.sql.planner.sanity.TypeValidator$Visitor.visitProject(TypeValidator.java:56) at com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:81) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26) at com.facebook.presto.sql.planner.sanity.TypeValidator$Visitor.visitProject(TypeValidator.java:106) at com.facebook.presto.sql.planner.sanity.TypeValidator$Visitor.visitProject(TypeValidator.java:56) at com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:81) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19) at com.facebook.presto.sql.planner.plan.PlanVisitor.visitExchange(PlanVisitor.java:170) at com.facebook.presto.sql.planner.plan.ExchangeNode.accept(ExchangeNode.java:208) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19) at com.facebook.presto.sql.planner.plan.PlanVisitor.visitJoin(PlanVisitor.java:90) at com.facebook.presto.sql.planner.plan.JoinNode.accept(JoinNode.java:170) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26) at com.facebook.presto.sql.planner.sanity.TypeValidator$Visitor.visitProject(TypeValidator.java:106) at com.facebook.presto.sql.planner.sanity.TypeValidator$Visitor.visitProject(TypeValidator.java:56) at com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:81) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19) at com.facebook.presto.sql.planner.plan.PlanVisitor.visitExchange(PlanVisitor.java:170) at com.facebook.presto.sql.planner.plan.ExchangeNode.accept(ExchangeNode.java:208) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19) at com.facebook.presto.sql.planner.plan.PlanVisitor.visitTableWriter(PlanVisitor.java:115) at com.facebook.presto.sql.planner.plan.TableWriterNode.accept(TableWriterNode.java:127) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19) at com.facebook.presto.sql.planner.plan.PlanVisitor.visitExchange(PlanVisitor.java:170) at com.facebook.presto.sql.planner.plan.ExchangeNode.accept(ExchangeNode.java:208) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19) at com.facebook.presto.sql.planner.plan.PlanVisitor.visitTableFinish(PlanVisitor.java:130) at com.facebook.presto.sql.planner.plan.TableFinishNode.accept(TableFinishNode.java:80) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:26) at com.facebook.presto.sql.planner.SimplePlanVisitor.visitPlan(SimplePlanVisitor.java:19) at com.facebook.presto.sql.planner.plan.PlanVisitor.visitOutput(PlanVisitor.java:50) at com.facebook.presto.sql.planner.plan.OutputNode.accept(OutputNode.java:81) at com.facebook.presto.sql.planner.sanity.TypeValidator.validate(TypeValidator.java:53) at com.facebook.presto.sql.planner.sanity.PlanSanityChecker.lambda$validate$0(PlanSanityChecker.java:42) at java.lang.Iterable.forEach(Iterable.java:75) at com.facebook.presto.sql.planner.sanity.PlanSanityChecker.validate(PlanSanityChecker.java:42) at com.facebook.presto.sql.planner.LogicalPlanner.plan(LogicalPlanner.java:109) at com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:280) at com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:259) at com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:223) at com.facebook.presto.execution.QueuedExecution.lambda$start$1(QueuedExecution.java:62) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    bpbhat77bpbhat77
    2 times, last one
    Михайло ТітовМихайло Тітов
    10 times, last one
    arturgajowyarturgajowy
    Once,
    LukaLuka
    Once,
    batwalrus76batwalrus76
    3 times, last one
    32 more bugmates