Apologies if this has been raised before and answered, as I couldn't find it in the search in this group.
java.sql.SQLException: [Amazon](500310) Invalid operation: syntax error at or near "limit";
at com.amazon.redshift.client.messages.inbound.ErrorResponse.toErrorException(ErrorResponse.java:1830)
at com.amazon.redshift.client.PGMessagingContext.handleErrorResponse(PGMessagingContext.java:804)
at com.amazon.redshift.client.PGMessagingContext.handleMessage(PGMessagingContext.java:642)
at com.amazon.jdbc.communications.InboundMessagesPipeline.getNextMessageOfClass(InboundMessagesPipeline.java:312)
at com.amazon.redshift.client.PGMessagingContext.doMoveToNextClass(PGMessagingContext.java:1062)
at com.amazon.redshift.client.PGMessagingContext.getParameterDescription(PGMessagingContext.java:978)
at com.amazon.redshift.client.PGClient.prepareStatement(PGClient.java:1844)
at com.amazon.redshift.dataengine.PGQueryExecutor.(PGQueryExecutor.java:106)
at com.amazon.redshift.dataengine.PGDataEngine.prepare(PGDataEngine.java:211)
at com.amazon.jdbc.common.SPreparedStatement.(Unknown Source)
at com.amazon.jdbc.jdbc41.S41PreparedStatement.(Unknown Source)
at com.amazon.redshift.core.jdbc41.PGJDBC41PreparedStatement.(PGJDBC41PreparedStatement.java:49)
at com.amazon.redshift.core.jdbc41.PGJDBC41ObjectFactory.createPreparedStatement(PGJDBC41ObjectFactory.java:119)
at com.amazon.jdbc.common.SConnection.prepareStatement(Unknown Source)
at dbfit.api.AbstractDbEnvironment.createStatementWithBoundFixtureSymbols(AbstractDbEnvironment.java:108)
at dbfit.fixture.Inspect.inspectQuery(Inspect.java:79)
at dbfit.fixture.Inspect.doTable(Inspect.java:47)
at fitlibrary.traverse.AlienTraverseHandler.doTable(AlienTraverseHandler.java:21)
at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable(DoTraverseInterpreter.java:104)
at fitlibrary.traverse.workflow.DoTraverseInterpreter.interpretWholeTable(DoTraverseInterpreter.java:89)
at fitlibrary.DoFixture.interpretWholeTable(DoFixture.java:73)
at fitlibrary.suite.InFlowPageRunner.run(InFlowPageRunner.java:27)
at fitlibrary.DoFixture.interpretTables(DoFixture.java:42)
at dbfit.DatabaseTest.interpretTables(DatabaseTest.java:26)
at fit.Fixture.doTables(Fixture.java:81)
at fit.FitServer.process(FitServer.java:81)
at fit.FitServer.run(FitServer.java:56)
Caused by: com.amazon.support.exceptions.ErrorException: [Amazon](500310) Invalid operation: syntax error at or near "limit";
... 27 more