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

GitHub | nezihyigitbasi | 4 months ago
  1. 0

    Exception inserting a record of type row(integer)

    GitHub | 4 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 | 8 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 | 1 year 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

  5. 0

    Support for column aliases in WITH clause

    GitHub | 9 months ago | martint
    com.facebook.presto.sql.analyzer.SemanticException: line 1:6: Column alias not supported in WITH queries
  6. 0

    Support implicit coercions in VALUES

    GitHub | 2 years ago | martint
    com.facebook.presto.sql.analyzer.SemanticException: Values rows have mismatched types: Expected: (bigint, bigint), Actual: (double, double)

    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.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