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

GitHub | nezihyigitbasi | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Exception inserting a record of type row(integer)

    GitHub | 8 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 | 12 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