📃
v5.3.2
  • Welcome to OmniSci Documentation
  • Overview
    • OmniSci Overview
    • Release Notes
  • Installation and Configuration
    • System Requirements
      • Hardware Reference
      • Software Requirements
    • Installation
      • Installing on CentOS
        • CentOS/RHEL Enterprise Edition CPU with Yum
        • CentOS/RHEL Enterprise Edition GPU with Yum
        • CentOS/RHEL Open Source CPU with Yum
        • CentOS/RHEL Open Source GPU with Yum
        • CentOS/RHEL Enterprise Edition CPU with Tarball
        • CentOS/RHEL Enterprise Edition GPU with Tarball
        • CentOS/RHEL Open Source CPU with Tarball
        • CentOS/RHEL Open Source GPU with Tarball
      • Installing on Ubuntu
        • Ubuntu Enterprise Edition CPU with Apt
        • Ubuntu Enterprise Edition GPU with Apt
        • Ubuntu Open Source CPU with Apt
        • Ubuntu Open Source GPU with Apt
        • Ubuntu Enterprise Edition CPU with Tarball
        • Ubuntu Enterprise Edition GPU with Tarball
        • Ubuntu Open Source CPU with Tarball
        • Ubuntu Open Source GPU with Tarball
      • Installing on Docker
        • Docker Enterprise Edition CPU
        • Docker Open Source CPU
        • Docker Enterprise Edition GPU
        • Docker Open Source GPU
      • Installing on AWS
      • Installing on GCP
      • Installing on Azure
      • Upgrading OmniSci
      • Uninstalling OmniSci
    • Services and Utilities
      • Using OmniSci Services
      • Using OmniSci Utilities
    • Configuration Parameters
    • Security
      • Roles and Privileges
      • Connecting to OmniSci Using SAML
      • Implementing a Secure Binary Interface
      • LDAP Integration
    • OmniSci Distributed Configuration
  • Loading and Exporting Data
    • Supported Data Sources
      • Kafka
      • Using Immerse Data Manager
      • Importing Geospatial Data
    • Command Line
      • Loading Data with SQL
      • Exporting Data
  • SQL
    • Data Definition (DDL)
      • Datatypes
      • Users and Databases
      • Tables
      • Views
    • Data Manipulation (DML)
      • SQL Capabilities
      • Geospatial Capabilities
      • Functions and Operators
      • OmniSci Reserved Words
      • OmniSci SQL Extensions
  • Immerse
    • Introduction to Immerse
    • Working with Dashboards
      • Dashboard List
      • Creating a Dashboard
      • Configuring a Dashboard
      • Duplicating and Sharing Dashboards
    • Measures and Dimensions
    • Using Filters
    • Multilayer Charts
    • SQL Editor
    • Customization
    • Immerse Chart Types
      • Overview
      • New Combo
      • Bar
      • Bubble
      • Choropleth
      • Combo
      • Geo Heatmap
      • Heatmap
      • Histogram
      • Line
      • Linemap
      • Number
      • Pie
      • Pointmap
      • Scatter Plot
      • Stacked Bar
      • Table
      • Text Widget
  • Data Science
    • OmniSci Data Science Foundation
    • Installation and Configuration
    • Using OmniSci with JupyterLab
    • Introduction to Ibis
    • Examples
      • Interactive Data Exploration with Altair
      • Forecasting with Prophet
      • Machine Learning with RAPIDs
      • Scheduled workflows with Prefect
      • Quick ML Applications with Streamlit
  • APIs and Interfaces
    • omnisql
    • Thrift
    • JDBC
    • ODBC
    • Vega
      • Vega Tutorials
        • Vega at a Glance
        • Getting Started with Vega
        • Getting More from Your Data
        • Creating More Advanced Charts
        • Using Polys Marks Type
        • Vega Accumulator
        • Using Transform Aggregation
        • Improving Rendering with SQL Extensions
      • Vega Reference Overview
        • data Property
        • projections Property
        • scales Property
        • marks Property
      • Migration
        • Migrating Vega Code to Dynamic Poly Rendering
        • Migrating Polygon Rendering for Custom Clients Upgrading to OmniSci 4.0
      • Try Vega
    • RJDBC
    • pymapd
    • mapd-connector
  • Tutorials
    • Loading Data
    • Using OmniSci Immerse
    • Hello OmniSci
    • Creating a Kafka Streaming Application
    • Getting Started with Open Source
    • Architecture Overviews
  • Troubleshooting
    • FAQ
    • Optimizing OmniSci
    • Known Issues and Limitations
    • Logs and Monitoring
Powered by GitBook
On this page

Was this helpful?

Data Manipulation (DML)

PreviousViewsNextSQL Capabilities

Last updated 4 years ago

SQL Capabilities
Geospatial Capabilities
Functions and Operators
OmniSci Reserved Words
OmniSci SQL Extensions