com.facebook.presto.spi.PrestoException: array_constructor(varchar,varchar(1)):array(varchar) not found

GitHub | haozhun | 5 months ago
  1. 0

    VARCHAR(n) and var-args functions

    GitHub | 5 months ago | haozhun
    com.facebook.presto.spi.PrestoException: array_constructor(varchar,varchar(1)):array(varchar) not found
  2. 0

    DISTINCT fails for JSON type when optimizeHashGeneration=true

    GitHub | 2 years ago | martint
    com.facebook.presto.spi.PrestoException: Unexpected parameters (json) for function $operator$hash_code. Expected: $operator$hash_code(boolean), $operator$hash_code(bigint), $operator$hash_code(double), $operator$hash_code(varchar), $operator$hash_code(varbinary), $operator$hash_code(date), $operator$hash_code(time), $operator$hash_code(timestamp), $operator$hash_code(interval day to second), $operator$hash_code(interval year to month), $operator$hash_code(time with time zone), $operator$hash_code(timestamp with time zone)
  3. 0

    Implicit coercions not added for expressions involving scalar subquery

    GitHub | 9 months ago | martint
    com.facebook.presto.spi.PrestoException: $operator$DIVIDE(double,bigint):double not found
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can't concat an Array with an empty Array.

    GitHub | 1 year ago | yaoxin226
    com.facebook.presto.spi.PrestoException: Can not cast array<unknown> to array<bigint>
  6. 0

    presto kafka create view error: This connector does not support creating views

    Google Groups | 2 months ago | lurenx
    com.facebook.presto.spi.PrestoException: This connector does not support creating views

    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. com.facebook.presto.spi.PrestoException

      array_constructor(varchar,varchar(1)):array(varchar) not found

      at com.facebook.presto.metadata.FunctionRegistry.getScalarFunctionImplementation()
    2. presto-main
      ExpressionOptimizer$Visitor.lambda$visitCall$3
      1. com.facebook.presto.metadata.FunctionRegistry.getScalarFunctionImplementation(FunctionRegistry.java:852)
      2. com.facebook.presto.sql.relational.optimizer.ExpressionOptimizer$Visitor.visitCall(ExpressionOptimizer.java:145)
      3. com.facebook.presto.sql.relational.optimizer.ExpressionOptimizer$Visitor.visitCall(ExpressionOptimizer.java:70)
      4. com.facebook.presto.sql.relational.CallExpression.accept(CallExpression.java:88)
      5. com.facebook.presto.sql.relational.optimizer.ExpressionOptimizer$Visitor.lambda$visitCall$3(ExpressionOptimizer.java:150)
      5 frames
    3. Java RT
      ReferencePipeline.collect
      1. java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
      2. java.util.Iterator.forEachRemaining(Iterator.java:116)
      3. java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
      4. java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
      5. java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
      6. java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
      7. java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
      8. java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
      8 frames
    4. presto-main
      ExpressionOptimizer$Visitor.lambda$visitCall$2
      1. com.facebook.presto.sql.relational.optimizer.ExpressionOptimizer$Visitor.visitCall(ExpressionOptimizer.java:151)
      2. com.facebook.presto.sql.relational.optimizer.ExpressionOptimizer$Visitor.visitCall(ExpressionOptimizer.java:70)
      3. com.facebook.presto.sql.relational.CallExpression.accept(CallExpression.java:88)
      4. com.facebook.presto.sql.relational.optimizer.ExpressionOptimizer$Visitor.lambda$visitCall$2(ExpressionOptimizer.java:140)
      4 frames
    5. Java RT
      ReferencePipeline.collect
      1. java.util.stream.ReferencePipeline$3$1.accept(ReferencePipeline.java:193)
      2. java.util.Iterator.forEachRemaining(Iterator.java:116)
      3. java.util.Spliterators$IteratorSpliterator.forEachRemaining(Spliterators.java:1801)
      4. java.util.stream.AbstractPipeline.copyInto(AbstractPipeline.java:481)
      5. java.util.stream.AbstractPipeline.wrapAndCopyInto(AbstractPipeline.java:471)
      6. java.util.stream.ReduceOps$ReduceOp.evaluateSequential(ReduceOps.java:708)
      7. java.util.stream.AbstractPipeline.evaluate(AbstractPipeline.java:234)
      8. java.util.stream.ReferencePipeline.collect(ReferencePipeline.java:499)
      8 frames
    6. presto-main
      TaskResource.createOrUpdateTask
      1. com.facebook.presto.sql.relational.optimizer.ExpressionOptimizer$Visitor.visitCall(ExpressionOptimizer.java:141)
      2. com.facebook.presto.sql.relational.optimizer.ExpressionOptimizer$Visitor.visitCall(ExpressionOptimizer.java:70)
      3. com.facebook.presto.sql.relational.CallExpression.accept(CallExpression.java:88)
      4. com.facebook.presto.sql.relational.optimizer.ExpressionOptimizer.optimize(ExpressionOptimizer.java:67)
      5. com.facebook.presto.sql.relational.SqlToRowExpressionTranslator.translate(SqlToRowExpressionTranslator.java:141)
      6. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.toRowExpression(LocalExecutionPlanner.java:1100)
      7. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitScanFilterAndProject(LocalExecutionPlanner.java:1002)
      8. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitProject(LocalExecutionPlanner.java:933)
      9. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitProject(LocalExecutionPlanner.java:525)
      10. com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:81)
      11. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.createNestedLoopJoin(LocalExecutionPlanner.java:1418)
      12. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitJoin(LocalExecutionPlanner.java:1399)
      13. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitJoin(LocalExecutionPlanner.java:525)
      14. com.facebook.presto.sql.planner.plan.JoinNode.accept(JoinNode.java:170)
      15. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitScanFilterAndProject(LocalExecutionPlanner.java:973)
      16. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitProject(LocalExecutionPlanner.java:933)
      17. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitProject(LocalExecutionPlanner.java:525)
      18. com.facebook.presto.sql.planner.plan.ProjectNode.accept(ProjectNode.java:81)
      19. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitOutput(LocalExecutionPlanner.java:564)
      20. com.facebook.presto.sql.planner.LocalExecutionPlanner$Visitor.visitOutput(LocalExecutionPlanner.java:525)
      21. com.facebook.presto.sql.planner.plan.OutputNode.accept(OutputNode.java:81)
      22. com.facebook.presto.sql.planner.LocalExecutionPlanner.plan(LocalExecutionPlanner.java:340)
      23. com.facebook.presto.sql.planner.LocalExecutionPlanner.plan(LocalExecutionPlanner.java:279)
      24. com.facebook.presto.execution.SqlTaskExecution.<init>(SqlTaskExecution.java:161)
      25. com.facebook.presto.execution.SqlTaskExecution.createSqlTaskExecution(SqlTaskExecution.java:120)
      26. com.facebook.presto.execution.SqlTaskExecutionFactory.create(SqlTaskExecutionFactory.java:74)
      27. com.facebook.presto.execution.SqlTask.updateTask(SqlTask.java:313)
      28. com.facebook.presto.execution.SqlTaskManager.updateTask(SqlTaskManager.java:323)
      29. com.facebook.presto.server.TaskResource.createOrUpdateTask(TaskResource.java:125)
      29 frames
    7. Java RT
      Method.invoke
      1. sun.reflect.GeneratedMethodAccessor779.invoke(Unknown Source)
      2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      3. java.lang.reflect.Method.invoke(Method.java:498)
      3 frames
    8. jersey-core-server
      ServerRuntime$2.run
      1. org.glassfish.jersey.server.model.internal.ResourceMethodInvocationHandlerFactory$1.invoke(ResourceMethodInvocationHandlerFactory.java:81)
      2. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher$1.run(AbstractJavaResourceMethodDispatcher.java:144)
      3. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.invoke(AbstractJavaResourceMethodDispatcher.java:161)
      4. org.glassfish.jersey.server.model.internal.JavaResourceMethodDispatcherProvider$ResponseOutInvoker.doDispatch(JavaResourceMethodDispatcherProvider.java:160)
      5. org.glassfish.jersey.server.model.internal.AbstractJavaResourceMethodDispatcher.dispatch(AbstractJavaResourceMethodDispatcher.java:99)
      6. org.glassfish.jersey.server.model.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:389)
      7. org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:347)
      8. org.glassfish.jersey.server.model.ResourceMethodInvoker.apply(ResourceMethodInvoker.java:102)
      9. org.glassfish.jersey.server.ServerRuntime$2.run(ServerRuntime.java:326)
      9 frames
    9. Jersey Core
      RequestScope.runInScope
      1. org.glassfish.jersey.internal.Errors$1.call(Errors.java:271)
      2. org.glassfish.jersey.internal.Errors$1.call(Errors.java:267)
      3. org.glassfish.jersey.internal.Errors.process(Errors.java:315)
      4. org.glassfish.jersey.internal.Errors.process(Errors.java:297)
      5. org.glassfish.jersey.internal.Errors.process(Errors.java:267)
      6. org.glassfish.jersey.process.internal.RequestScope.runInScope(RequestScope.java:317)
      6 frames
    10. jersey-core-server
      ApplicationHandler.handle
      1. org.glassfish.jersey.server.ServerRuntime.process(ServerRuntime.java:305)
      2. org.glassfish.jersey.server.ApplicationHandler.handle(ApplicationHandler.java:1154)
      2 frames
    11. jersey-container-servlet-core
      ServletContainer.service
      1. org.glassfish.jersey.servlet.WebComponent.serviceImpl(WebComponent.java:473)
      2. org.glassfish.jersey.servlet.WebComponent.service(WebComponent.java:427)
      3. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:388)
      4. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:341)
      5. org.glassfish.jersey.servlet.ServletContainer.service(ServletContainer.java:228)
      5 frames
    12. Jetty
      ServletHandler$CachedChain.doFilter
      1. org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:845)
      2. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1689)
      2 frames
    13. http-server
      TraceTokenFilter.doFilter
      1. io.airlift.http.server.TraceTokenFilter.doFilter(TraceTokenFilter.java:63)
      1 frame
    14. Jetty
      ServletHandler$CachedChain.doFilter
      1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
      1 frame
    15. http-server
      TimingFilter.doFilter
      1. io.airlift.http.server.TimingFilter.doFilter(TimingFilter.java:52)
      1 frame
    16. Jetty
      ScopedHandler.handle
      1. org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1676)
      2. org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:581)
      3. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
      3 frames
    17. org.eclipse.jetty
      GzipHandler.handle
      1. org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:397)
      1 frame
    18. Jetty
      SelectChannelEndPoint$2.run
      1. org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1182)
      2. org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:511)
      3. org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1112)
      4. org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
      5. org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:119)
      6. org.eclipse.jetty.server.handler.StatisticsHandler.handle(StatisticsHandler.java:169)
      7. org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
      8. org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:134)
      9. org.eclipse.jetty.server.Server.handle(Server.java:524)
      10. org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:319)
      11. org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:253)
      12. org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:273)
      13. org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:95)
      14. org.eclipse.jetty.io.SelectChannelEndPoint$2.run(SelectChannelEndPoint.java:93)
      14 frames
    19. org.eclipse.jetty
      ExecuteProduceConsume.run
      1. org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.executeProduceConsume(ExecuteProduceConsume.java:303)
      2. org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.produceConsume(ExecuteProduceConsume.java:148)
      3. org.eclipse.jetty.util.thread.strategy.ExecuteProduceConsume.run(ExecuteProduceConsume.java:136)
      3 frames
    20. Jetty
      QueuedThreadPool$2.run
      1. org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:671)
      2. org.eclipse.jetty.util.thread.QueuedThreadPool$2.run(QueuedThreadPool.java:589)
      2 frames
    21. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame