OO, I thought the adding an ORDER BY suggestion was going to work, but alas, no dice. And I reversed the LIMIT and OFFSET. Updated query below. Still the same error. SELECT COALESCE(COUNT(main.v0), 0) AS CollapsingFunction0 FROM (SELECT p.ID AS v0, p.RatingAvgApproved AS v1, p.ReviewCountApproved AS...

I'm connecting to Vertica thru JDBC, and I'm getting the below error while calling Connection.prepareStatement on the below SQL. Does anyone know what the error means and how to fix it? java.sql.Connection Error calling Connection.prepareStatement: java.sql.SQLException: [Vertica][VJDBC](2013) ERROR...