Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is it possible to increment the maximum row size in AWS Athena?

I'm running this query with AWS Athena:

SELECT
  t1.*
FROM "db"."tbl1" t1
INNER JOIN "tbl1"."ema" ea ON
  ea.id = concat(t1.numc,t1.nummt)
WHERE
  ea.cod1 = '23' and
  ea.cod2 = '776'

And getting this error:

Size of a single row or its columns cannot exceed 32 MB

The table is saved in AWS S3 in jsonl format.

It's possible to increase the maximun row size?

like image 387
Shadowtrooper Avatar asked Sep 05 '25 03:09

Shadowtrooper


1 Answers

Unfortunately not. Athena does not currently let you configure any Presto details.

like image 82
Theo Avatar answered Sep 07 '25 23:09

Theo