AWScala icon indicating copy to clipboard operation
AWScala copied to clipboard

limit in select not working as expected

Open mericano1 opened this issue 10 years ago • 0 comments

I am having some problems using a limit in a select with AWScala. It seem to fetch the records in batches of the limit size up until the last one. In my query

select * from logs where liveFrom < '1421192471363' and liveTo > '1421192471363' and rank > '0' order by rank limit 10

I get back 320 records out of a total of 323 matching records without the limit.

I have a feeling this might be related to the Stream based next token implementation but didn't have a chance to investigate.

The Java API seems to work correctly and I switched to Java just for this.

Thanks

mericano1 avatar Jan 14 '15 00:01 mericano1