BLOSC_*
environment variablesOPTIMIZE TABLE with VACUUM
increases metadatawith (vacuum = 'true')
option has the suboptimal effect of increasing the size of your metadata in HEAVY.AI Core version 4.5.0. Do not use the vacuum option.ALTER TABLE ADD COLUMN
does not work with geo column typeALTER TABLE ADD COLUMN
for 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 HEAVY.AI support at [email protected].bigint-count = true
in heavyai.conf
.DELETE
functionality does not work on tables created using MapD 3.x. For DELETE
to function correctly, create a new table in MapD 4.0 with the same schema, and then copy the data.TRUNCATE TABLE
instead of DELETE * FROM
UPDATE
from a subquery. For example, the following will not work:UPDATE
is not currently supported on variable-length data types.2021-05-14T15:56:16.571249 E 40446 0 DBHandler.cpp:403 Unable to instantiate CudaMgr, falling back to CPU-only mode. CUDA Error (999): unknown error
render_vega
request 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_vega
request against the same table.convert_meters_to_pixel_width
and convert_meters_to_pixel_height
extension 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.legacysymbol
vega mark type if the size in meters is large and zooming in close is useful for your analysis.