NOT_SUPPORTED: ORDER BY LIMIT 2147483647 is not supported

Question

SELECT count(*) as count ,accountname,deviceaction,ipaddress from "zinble"."zinble_2_enriched" where (rg_id IN ( 41 )) and ((resourcegroupidpq = '41' AND yearpq = '2022' AND dayofyearpq = '203') )  and eventtime >= 1657093590000 and eventtime < 1659685590000 and '785a9f0c-6187-4f50-8e7f-742a3ed0feda'='785a9f0c-6187-4f50-8e7f-742a3ed0feda' group by accountname,deviceaction,ipaddress ORDER BY count DESC LIMIT 62500000000;

When i run the above query i get this error ->. NOT_SUPPORTED: ORDER BY LIMIT > 2147483647 is not supported
This query ran against the "zinble" database, unless qualified by the query.

Can we increase the limit's value from Integer.MaxValue to Long.Maxvalue. If yes, can you please tell me how.

Answer

Currently there is no option to change the upper limit to be able to support numbers bigger than 2147483647

NOT_SUPPORTED: ORDER BY LIMIT > 2147483647 is not supported

Relevant questions

OpenSearch Cluster max clause count not updating

Cloudwatch count and graph ERROR count in cloudwatch - only getting '1'

Does Athena support ORDER BY in ARRAY_AGG ?

How can I track down RedShift throwing errors when aggregating on an otherwise functioning query involving CTEs and UNIONS?

AWS WorkDocs - File Count

Feature Request Increase DynamoDB transaction limit count from 25

DynamoDB PartiQL Unsupported clause: LIMIT in console

How to see the rows of table in order by their ID with SELECT command in QLDB?