CartoDB's SQL API: Row too large

ا

المشرف العام

Administrator
طاقم الإدارة
I am trying to run the following PostGIS query using CartoDB's SQL API:

SELECT the_geom, ST_Area(ST_Intersection(the_geom::geography, ST_Buffer(ST_SetSRID(ST_MakePoint(-52.4379, -12.6235), 4326)::geography, 25000))) / 1000000 AS polyarea

FROM dataset1

WHERE ST_Intersects(the_geom::geography, ST_Buffer(ST_SetSRID(ST_MakePoint(-52.4379, -12.6235), 4326)::geography, 25000))

​
The same query works with two other datasets (one of which has 735,000 rows), but returns a "row too large error" for this particular dataset (which "only" has 160,400 rows).



أكثر...
 
يجب تسجيل الدخول أو التسجيل كي تتمكن من الرد هنا.
أعلى