java.sql.SQLException: [Amazon](500310) Invalid operation: syntax error at or near "create";

GitHub | chanansh | 4 months ago
  1. 0

    CREATE statement

    GitHub | 4 months ago | chanansh
    java.sql.SQLException: [Amazon](500310) Invalid operation: syntax error at or near "create";
  2. 0

    Overwrite using staging table fails when table has dependencies

    GitHub | 6 months ago | khaledh
    java.sql.SQLException: [Amazon](500310) Invalid operation: current transaction is aborted, commands ignored until end of transaction block;
  3. 0

    S3 Bucket does not exist error

    GitHub | 10 months ago | ghost
    java.sql.SQLException: [Amazon](500310) Invalid operation: Specified types or functions (one per INFO message) not supported on Redshift tables.;
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    GitHub comment 97#143125178

    GitHub | 1 year ago | cfeduke
    java.sql.SQLException: [Amazon](500310) Invalid operation: syntax error at or near ".";
  6. 0

    "Invalid operation: Mandatory url is not present in manifest file" error when writing data to Redshift while using an old version of spark-avro

    GitHub | 1 year ago | JoshRosen
    java.sql.SQLException: [Amazon](500310) Invalid operation: Mandatory url is not present in manifest file. ----------------------------------------------- error: Mandatory url is not present in manifest file. code: 8001 context: Manifest file location=s3://spark-redshift-testing/temp/fc8db7a7-97fa-4dcd-b694-cbc44f8dbbe8/manifest.json url=s3://spark-redshift-testing/temp/fc8db7a7-97fa-4dcd-b694-cbc44f8dbbe8/part-r-00000-ro.avro query: 403423 location: s3_utility.cpp:328 process: padbmaster [pid=27093] -----------------------------------------------;

    2 unregistered visitors
    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.amazon.support.exceptions.ErrorException

      [Amazon](500310) Invalid operation: syntax error at or near "create";

      at com.amazon.redshift.client.messages.inbound.ErrorResponse.toErrorException()
    2. com.amazon.redshift
      PGMessagingContext.handleMessage
      1. com.amazon.redshift.client.messages.inbound.ErrorResponse.toErrorException(ErrorResponse.java:1830)
      2. com.amazon.redshift.client.PGMessagingContext.handleErrorResponse(PGMessagingContext.java:822)
      3. com.amazon.redshift.client.PGMessagingContext.handleMessage(PGMessagingContext.java:647)
      3 frames
    3. com.amazon.jdbc
      InboundMessagesPipeline.getNextMessageOfClass
      1. com.amazon.jdbc.communications.InboundMessagesPipeline.getNextMessageOfClass(InboundMessagesPipeline.java:312)
      1 frame
    4. com.amazon.redshift
      PGDataEngine.prepare
      1. com.amazon.redshift.client.PGMessagingContext.doMoveToNextClass(PGMessagingContext.java:1080)
      2. com.amazon.redshift.client.PGMessagingContext.getParameterDescription(PGMessagingContext.java:996)
      3. com.amazon.redshift.client.PGClient.prepareStatement(PGClient.java:1857)
      4. com.amazon.redshift.dataengine.PGBatchQueryExecutor.<init>(PGBatchQueryExecutor.java:135)
      5. com.amazon.redshift.dataengine.PGDataEngine.prepare(PGDataEngine.java:228)
      5 frames
    5. com.amazon.jdbc
      S4PreparedStatement.<init>
      1. com.amazon.jdbc.common.SPreparedStatement.<init>(Unknown Source)
      2. com.amazon.jdbc.jdbc4.S4PreparedStatement.<init>(Unknown Source)
      2 frames
    6. com.amazon.redshift
      PGJDBC4ObjectFactory.createPreparedStatement
      1. com.amazon.redshift.core.jdbc4.PGJDBC4PreparedStatement.<init>(PGJDBC4PreparedStatement.java:49)
      2. com.amazon.redshift.core.jdbc4.PGJDBC4ObjectFactory.createPreparedStatement(PGJDBC4ObjectFactory.java:119)
      2 frames
    7. com.amazon.jdbc
      SConnection.prepareStatement
      1. com.amazon.jdbc.common.SConnection.prepareStatement(Unknown Source)
      2. com.amazon.jdbc.common.SConnection.prepareStatement(Unknown Source)
      2 frames
    8. com.databricks.spark
      RedshiftRelation$$anonfun$schema$1.apply
      1. com.databricks.spark.redshift.JDBCWrapper.resolveTable(RedshiftJDBCWrapper.scala:168)
      2. com.databricks.spark.redshift.RedshiftRelation$$anonfun$schema$1.apply(RedshiftRelation.scala:65)
      3. com.databricks.spark.redshift.RedshiftRelation$$anonfun$schema$1.apply(RedshiftRelation.scala:60)
      3 frames
    9. Scala
      Option.getOrElse
      1. scala.Option.getOrElse(Option.scala:120)
      1 frame
    10. com.databricks.spark
      RedshiftRelation.schema
      1. com.databricks.spark.redshift.RedshiftRelation.schema$lzycompute(RedshiftRelation.scala:60)
      2. com.databricks.spark.redshift.RedshiftRelation.schema(RedshiftRelation.scala:59)
      2 frames
    11. org.apache.spark
      LogicalRelation.<init>
      1. org.apache.spark.sql.execution.datasources.LogicalRelation.<init>(LogicalRelation.scala:37)
      1 frame
    12. Spark Project SQL
      DataFrameReader.load
      1. org.apache.spark.sql.DataFrameReader.load(DataFrameReader.scala:125)
      1 frame
    13. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
      4. java.lang.reflect.Method.invoke(Method.java:606)
      4 frames
    14. Py4J
      GatewayConnection.run
      1. py4j.reflection.MethodInvoker.invoke(MethodInvoker.java:231)
      2. py4j.reflection.ReflectionEngine.invoke(ReflectionEngine.java:381)
      3. py4j.Gateway.invoke(Gateway.java:259)
      4. py4j.commands.AbstractCommand.invokeMethod(AbstractCommand.java:133)
      5. py4j.commands.CallCommand.execute(CallCommand.java:79)
      6. py4j.GatewayConnection.run(GatewayConnection.java:209)
      6 frames