Data Definition

Table of Contents

• Creating Tables
  • Introduction
  • Schemas
  • Naming Restrictions
• Data Types
  • Classification
  • boolean
  • string
  • Numeric Types
  • ip
  • timestamp
  • geo_point
  • geo_shape
  • object
  • array
  • Type Conversion
  • Type aliases
• System Columns
• Generated Columns
• Constraints
  • Primary Key
  • Not Null
• Storage
  • Column Store
• Partitioned Tables
  • Introduction
  • Creation
  • Information Schema
  • Insert
  • Update
  • Delete
  • Querying
  • Alter
  • Limitations
  • Consistency Notes Related to Concurrent DML Statement
• Sharding
  • Introduction
  • Number of Shards
  • Routing
• Replication
  • Configuration
• Shard Allocation Filtering
  • Settings
  • Special Attributes
• Column Policy
  • strict
  • dynamic
• Fulltext Indices
  • Index Definition
  • Disable indexing
  • Plain index (Default)
  • Create a Custom Analyzer
  • Extending a Bultin Analyzer
• Fulltext Analyzers
  • Overview
  • Built-in Analyzers
  • Built-in Tokenizers
  • Built-in Token Filters
  • Builtin Char Filter
• Show Create Table
• Views
  • Introduction: Creating Views
  • Querying Views
  • Dropping Views
• Altering Tables
  • Updating Parameters
  • Adding Columns
  • Closing and Opening Tables
  • Renaming Tables
  • Reroute Shards