OPTIMIZE TABLE with VACUUMincreases metadata
with (vacuum = 'true')option has the suboptimal effect of increasing the size of your metadata in OmniSci Core version 4.5.0. Do not use the vacuum option.
ALTER TABLE ADD COLUMNdoes not work with geo column type
ALTER TABLE ADD COLUMNfor a geo column type in MapD 4.1 only partially adds the column. Any queries on that column will result in a system failure. If you encounter this issue, contact OmniSci support at [email protected].
bigint-count = truein
sudo nvidia-smi --ecc-config=0
DELETEfunctionality does not work on tables created using MapD 3.x. For
DELETEto function correctly, create a new table in MapD 4.0 with the same schema, and then copy the data.
TRUNCATE TABLEinstead of
DELETE * FROM
UPDATEfrom a subquery. For example, the following will not work:
UPDATEis not currently supported on variable-length data types.
render_vegarequest is executed at the same time as a table modification request (DROP/TRUNCATE/RENAME/APPEND TABLE) and the same table is referenced in both requests.
render_vegarequest against the same table.
convert_meters_to_pixel_heightextension functions for accuracy against circular polygons created with ST_Buffer in other packages, some errors are introduced by the extension functions somewhere at large zoom levels.
legacysymbolvega mark type if the size in meters is large and zooming in close is useful for your analysis.