com.facebook.presto.sql.analyzer.SemanticException: Insert query has mismatched column types: Table: [row(A integer)], Query: [integer]

GitHub | nezihyigitbasi | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    Exception inserting a record of type row(integer)

    GitHub | 7 months ago | nezihyigitbasi
    com.facebook.presto.sql.analyzer.SemanticException: Insert query has mismatched column types: Table: [row(A integer)], Query: [integer]
  2. 0

    Cannot insert null into table without explicit cast

    GitHub | 11 months ago | martint
    com.facebook.presto.sql.analyzer.SemanticException: Insert query has mismatched column types: Table: [bigint], Query: [unknown]
  3. 0

    Inserting into a view fails with wrong error message

    GitHub | 2 years ago | electrum
    com.facebook.presto.sql.analyzer.SemanticException: Table 'raptor.test.tmp_view' does not exist
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. com.facebook.presto.sql.analyzer.SemanticException

      Insert query has mismatched column types: Table: [row(A integer)], Query: [integer]

      at com.facebook.presto.sql.analyzer.StatementAnalyzer.visitInsert()
    2. presto-main
      StatementAnalyzer.visitInsert
      1. com.facebook.presto.sql.analyzer.StatementAnalyzer.visitInsert(StatementAnalyzer.java:249)
      2. com.facebook.presto.sql.analyzer.StatementAnalyzer.visitInsert(StatementAnalyzer.java:161)
      2 frames
    3. presto-parser
      AstVisitor.process
      1. com.facebook.presto.sql.tree.Insert.accept(Insert.java:61)
      2. com.facebook.presto.sql.tree.AstVisitor.process(AstVisitor.java:22)
      2 frames
    4. presto-main
      QueuedExecution.lambda$start$1
      1. com.facebook.presto.sql.analyzer.Analyzer.analyze(Analyzer.java:62)
      2. com.facebook.presto.execution.SqlQueryExecution.doAnalyzeQuery(SqlQueryExecution.java:273)
      3. com.facebook.presto.execution.SqlQueryExecution.analyzeQuery(SqlQueryExecution.java:259)
      4. com.facebook.presto.execution.SqlQueryExecution.start(SqlQueryExecution.java:223)
      5. com.facebook.presto.execution.QueuedExecution.lambda$start$1(QueuedExecution.java:62)
      5 frames
    5. 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