KNOWLEDGE BASE

Error "array size exceeds the maximum allowed" When Using PostgreSQL Spatial


Published: 22 May 2019
Last Modified Date: 22 May 2019

Issue

When using a PostgreSQL Spatial data source that contains geometry objects, the following error might occur: 

Error: "ERROR: array size exceeds the maximum allowed (1073741823); Error while executing the query" ​SELECT ST_Collect(geom) FROM public.my_geom_table ​

Environment

  • Tableau Desktop 2019.2
  • PostgreSQL Spatial

Resolution

As a workaround, use filters to isolate geometry by type.​

Additional Information

For more information about PosgreSQL, see PosgreSQL in Tableau Help. 
Did this article resolve the issue?