Known Issues and Limitations
Following are known issues, limitations, and changes to default behavior in the OmniSci Platform.
Because OmniSciDB supports Web Mercator projection only, applications that use coordinates other than Web Mercator may not render data accurately on their maps.
Whenever the result of a query is going to be used for another query (for example, CREATE TABLE AS SELECT, any multi-step query, and so on), OmniSci performs columnar conversion to change the intermediate results into proper columnar format that all OmniSci queries expect as input. Variable length types, including all geometry targets, are not supported when performing columnar conversion.
OmniSci uses a compression library called BLOSC that reads operating system environment variables and changes behavior according to those variables. Do not set any of the environment variables listed below.
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 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].
This issue was fixed in MapD version 4.1.1.
MapD 4.0 includes several major changes that can affect compatibility with 3.x releases.
MapD recommends you make a backup of your 3.x installations before proceeding with the upgrade to MapD 4.0 so that you can revert if the upgrade is unsuccessful or problematic.
There is a known issue with automatic migration if the source database was migrated through any of the following releases: 3.2.1, 3.2.2 or 3.2.3. Contact OmniSci support before you update to v4.0.0 if you think this is the case with your database.
If you are using MapD 3.x, setting up MapD 4.0 over an existing 3.x installation data directory migrates existing users and databases to use the new model automatically.
If you encounter issues during upgrade, you must restore your 3.x installation data from backup. Back up your 3.x installations before upgrading to MapD 4.0. You cannot downgrade MapD 4.0 data directories to use them in MapD 3.x installations.
To prevent return of negative counts, set
bigint-count = truein
If you are using a server with an NVIDIA Tesla K80 card, you must turn off Error-correcting Code Memory (ecc) before you install OmniSci.
To disable Error-correcting Code Memory
- 1.Open a terminal window on your host machine.
- 2.Run the following command:
sudo nvidia-smi --ecc-config=0
- 3.Reboot your host machine
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.
NOTE: To remove all rows from a table, use
TRUNCATE TABLEinstead of
DELETE * FROM
- OmniSci does not currently support
UPDATEfrom a subquery. For example, the following will not work:UPDATE tempDataView SET marks = ( SELECT marks FROM tempData b WHERE tempDataView.Name = b.Name )
UPDATEis not currently supported on variable-length data types.
On NVIDIA DGX systems, you might get the following error:
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
This error occurs if no fabric manager is installed on the system. To resolve the issue, install the fabric manager on the system.
In OmniSci 5.1.2, a deadlock can result if a
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.
This is scheduled to be fixed in a future release. Until that time, OmniSci recommends that you avoid executing a table modification request at the same time as a
render_vegarequest against the same table.
When evaluating the new
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.
The resulting point/symbol sized by meters is just an approximate. It does not represent the exact area on the globe. There is more error in the approximate as you get closer to the poles in a mercator-projected view: a circle defined in meters should become egg-shaped, whereas the current symbol remains elliptical.
Workaround: If your clients are going to use these extension functions, OmniSci recommends you use the
legacysymbolvega mark type if the size in meters is large and zooming in close is useful for your analysis.
If you imported shapefiles into MapD 3.x, you must reimport this data in MapD 4.0 to use the new storage model for geospatial data types. Identify the tables you need to reimport and do so before using MapD 4.0.
If you imported polygon data into MapD 3.x for a custom application and are rendering or performing hit-testing on that data, upgrading to OmniSci 4.0+ will break your client-side polygon code because the storage model is different. For guidelines on migrating your code for OmniSci 4.0, see Migrating Polygon Rendering and Hit-testing for Custom Clients Upgrading to OmniSci 4.0+.
In Release 5.6.0, parameters do not work with geo joins.
You can import higher-precision timestamps (3, 6, 9, milli, micro, nano, rather than the default of seconds) via the data manager, but you cannot use them as a part of the actual queries or filters for a chart (as opposed to displaying them as results). For example, you cannot use a high-precision timestamp as the time dimension for a combo chart.
- In MapD 4.0, dashboards can be shared only as 'read-only'. Users with whom a dashboard has been shared cannot currently make edits to the dashboard.
- For security reasons, dashboard sharing does not automatically provide permissions on underlying tables/views. For now, this requires a one-time setup by a superuser/administrative to configure a group of users or a role with permissions on the underlying objects.
- Dashboard sharing does not currently work in OmniSci Cloud because each OmniSci Cloud user currently has a dedicated OmniSci instance. This limitation will be addressed in a future release.
If your OmniSci instance is set up to autoload specific dashboards on login by specifying the name in servers.json, you need to update the entry to use the dashboard ID instead. If you do not, your dashboards will not autoload. Find the dashboard ID by running `\dash` from omnisql, and then update the servers.json entry accordingly:
MapD Immerse versions 3.4.0 and higher work only with MapD Core versions 3.4.0 and higher.
Any update on Line or Histogram charts also starts an update query for range chart that is not required.
Binned columns and date extracts appear as JSON strings when exported to CSV format.
Old share links (for example, https://www.mapd.com/demos/ships/#/link/mapd/228ae04e\ no longer load and render all charts immediately. You must resize the browser or otherwise cause the page to re-render to see all charts.