PRODUCT DOWNLOAD USER GUIDE CONTACT US

Raijin Documentation

    • Quick Start Guide
    • User Guide
      • Introduction
      • Installation
        • Supported platforms
        • Installing from DEB packages
        • Installing from RPM packages
        • Running Raijin server
        • Installing and running Raijin as a Docker application
      • Delimited identifiers
      • Table partitioning
      • Purging data
      • Backup and archiving
      • User management
    • Reference Manual
      • Data types
        • INT
        • UNSIGNED INT
        • BIGINT
        • UNSIGNED BIGINT
        • DOUBLE
        • FLOAT
        • BOOL
        • STRING
        • TIMESTAMP
        • VARIANT
        • BINARY
        • INTERVAL
      • SQL commands
        • ALTER DATABASE
        • ALTER TABLE
        • ALTER USER
        • ALTER VIEW
        • COPY
        • CREATE DATABASE
        • CREATE TABLE
        • CREATE USER
        • CREATE VIEW
        • DESCRIBE
        • DROP DATABASE
        • DROP TABLE
        • DROP USER
        • DROP VIEW
        • EXPLAIN
        • FLUSH TABLE
        • GRANT
        • INSERT
        • SELECT
        • SELECT FIELDS
        • SET
        • SHOW
        • SHOW DATABASES
        • SHOW PARTITIONS
        • SHOW TABLES
        • SHOW USERS
        • SHOW VERSION
        • SHOW VIEWS
        • UNLOCK TABLES
        • USE
      • Subqueries
      • Functions
        • Aggregate functions
          • AVG
          • COUNT
          • FIRST
          • GROUP_CONCAT
          • LAST
          • MAX
          • MIN
          • SUM
        • Control functions
          • IF
          • IFNULL
          • CASE
          • COALESCE
          • TYPE
        • Datetime functions
          • CURRENT_DATE
          • CURRENT_TIME
          • DATE
          • DATE_TRUNC
          • DAY
          • DAYOFWEEK
          • DAYOFYEAR
          • HOUR
          • LOCALTIME
          • LOCALTIMESTAMP
          • MICROSECOND
          • MINUTE
          • MONTH
          • MSEC_TO_TIMESTAMP
          • NOW
          • PARSE_UTC_USEC
          • QUARTER
          • SEC_TO_TIMESTAMP
          • SECOND
          • TIME
          • TIMESTAMP
          • TIMESTAMP_TO_MSEC
          • TIMESTAMP_TO_SEC
          • TIMESTAMP_TO_USEC
          • USEC_TO_TIMESTAMP
          • YEAR
          • FORMAT_UTC_USEC
        • Math functions
          • ABS
          • ACOS
          • ACOSH
          • ASIN
          • ASINH
          • ATAN
          • ATAN2
          • ATANH
          • CEIL
          • CEIL_TO_INT
          • COS
          • COSH
          • DEGREES
          • EXP
          • FLOOR
          • FLOOR_TO_INT
          • GREATEST
          • IS_EVEN
          • IS_FINITE
          • IS_INF
          • IS_NAN
          • IS_NORMAL
          • IS_ODD
          • LEAST
          • LN
          • LOG
          • LOG10
          • LOG2
          • MOD
          • PI
          • POWER
          • RADIANS
          • ROUND
          • ROUND_TO_INT
          • SIN
          • SINH
          • SQRT
          • TAN
          • TANH
          • TRUNC
        • String functions
          • CONCAT
          • LEFT
          • LENGTH
          • LOWER
          • LTRIM
          • OVERLAY
          • POSITION
          • REGEXP_EXTRACT
          • REGEXP_MATCH
          • REGEXP_MATCH_PARTIAL
          • REGEXP_REPLACE
          • REPLACE
          • RIGHT
          • RTRIM
          • SUBSTRING
          • TO_STRING
          • TO_CHAR
          • TRIM
          • UPPER
        • Miscellaneous functions
          • CAST
      • Operators
        • Arithmetic operators
        • Bitwise operators
        • Comparison operators
        • Logical operators
          • LIKE
          • ILIKE
          • IN
        • Set operators
          • UNION
          • UNION ALL
        • String operators
          • MATCH AGAINST
          • IMATCH AGAINST
      • Public APIs
      • Configuration parameters
        • raijin.conf
          • Logging settings
          • Audit logging settings
          • Networking settings
          • Authentication settings
          • SSL settings
          • Storage settings
          • Data encryption
          • Sorting and grouping settings
          • Conversion settings
          • Floating point representation settings
          • Execution settings
          • Operators policy settings
          • Optimizer cost constants
          • Other optimizer options
          • Parser settings
        • Settable configuration settings
        • Configuring via command line
      • Cluster configuration
        • cluster.json
          • Node list
      • Monitor Raijin
    • Integrations
      • Raijin plugin for Grafana
      • Raijin plugin for Apache Superset
    • Release notes
    • Changelog
Raijin Documentation v2.1
  • Raijin Documentation
    • v2.1
  • Raijin Documentation
  • Reference Manual

Reference Manual

  • Data types

  • SQL commands

  • Functions

  • Operators

  • Public APIs

  • Configuration parameters

  • Cluster configuration

User management Data types

Raijin Database © Copyright 2022 Raijin Ltd.     Privacy Policy