kdb q Limit Error

The limit error is either caused by trying to create too large a list (2 billion items usually) or trying to transfer an object to/from a kdb process that is over 2GB in size. e.g.: q) / list is too large q)0W#2 'limit q)-22!til 280100200 / size in bytes 2240801614 q)til 280100200 / can generate ok 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20.. q)h:hopen 5000 q)h "til 280100200" / cant retrieve from remote process 'limit

'limit error Fix

The 2GB limit is because internally integers are used for storage and addressing and 2^31 is 2,147,483,648. You will sometimes see this error when retrieving a large of results with many columns. The only workaround is to transfer the table in multiple requests.