watchdog-none-encoded-string-translation-limit
to set the upper cardinality allowed for such operations (1,000,000 by default). COPY TO
to a CSV/TSV file has been changed from 'false'
to 'true'
.geo
and parquet
WITH
options of COPY FROM
have been deprecated and replaced by source_type
. Using the deprecated syntax generates the following:
Deprecation Warning: COPY FROM WITH (geo='true') is deprecated. Use WITH (source_type='geo_file') instead.
Update any scripts you have to replace the deprecated syntax with the new syntax. For more information, see CSV/TSV Import.renderer-use-vulkan-driver
program option has been removed. Remove any references to that program option from your configuration files. For more on the move to the Vulkan driver, see Vulkan Renderer.“Cannot find column in hit-test cache for query …”
Cannot find column <column name> in hit-test cache for query <sql query>.
Most errors of that form should be resolved in single-node.columnar-large-projections
is enabled. columnar-large-projections-threshold
flag (and turned off with columnar-large-projections=false
). WITH
option threads=1
to force single-threaded operation and avoid a server crash. This restriction does not apply to any other raster formats.renderer-use-vulkan-driver=false
error while loading shared libraries: libvulkan.so.1: cannot open shared object file: No such file or directory
sudo yum install vulkan
sudo apt install libvulkan1
--num-executors=2
)--num-executors
flag). In future versions of OmniSci, the number of executors will be set to 2 by default. allow-s3-server-privileges
server configuration.renderer-use-vulkan-driver
configuration parameter to true
.error while loading shared libraries: libvulkan.so.1: cannot open shared object file: No such file or directory
sudo yum install vulkan
sudo apt install libvulkan1
ST_Contains
filter expression for drawn polygons instead of expensive inside-triangle expressions.ST_Contains
filter exactly for map charts.-udf
flag were not generating code for the GPU.--noPolyRenderGroups/-nprg
to disable render group assignment, to match the available WITH option on other import workflows.allowed-export-paths
and allowed-import-paths
.mapd-1.0-SNAPSHOT-jar-with-dependencies.jar
is renamed. Scripts using SQLimporter need to reference the new .jar omnisci-utility-5.6.0.jar
.approx_median aggregate
function. Currently works only in nondistributed deployments and executes on CPU.enable-non-kernel-time-query-interrupt
.enable-runtime-query-interrupt
flag should have little to no impact on query performance; actual impact depends on the query pattern. max_rollback_epochs
option with a default value of 3. This reduces the number of epochs/data versions that are stored. When combined with new space reclamation on delete, optimizes space utilization. Setting the option with a high value stores more epochs and reduces data compaction and space reclamation. To update older tables, use the ALTER TABLE <table> SET MAX_ROLLBACK_EPOCHS=<value>
command.enable-auto-metadata-update
in Configuration Parameters. Automatic vacuuming on delete occurs when deletes or updates on variable length columns exceed the vacuum threshold. For more information, see vacuum-min-selectivity
in Configuration Parameters.ALTER TABLE <table> SET MAX_ROLLBACK_EPOCHS=3
to cap the space usage, and OPTIMIZE TABLE [<table>] WITH (VACUUM='true');
to reclaim space. This primes the system for efficient space management.{data directory}/map_import
and {data directory}/map_export
respectively) are allowed by default, so no change is required when doing an import/export from Immerse or for sample data import on server startup. However, when using other commands with user-provided paths (such as COPY FROM) provided paths must be under an allowed root path. See the Configuration Parameters for more information.%m/%d/%y
with 2-digit year on data import.