Concepts

An introductory guide to understanding the core concepts of Kinetica.

• Types
  • Type Label
  • Type Schema
  • Primitive Types
  • Column Properties
• Tables
  • Distribution
  • Primary Keys
  • Shard Keys
  • Foreign Keys
• Views
  • Aggregate Group-By Views
  • Query Chaining
  • Limitations and Cautions
• Collections
• Indexes
  • Primary Key Index
  • Relational Index
  • Column Index
• Expressions
  • Constants
  • Operators
  • Functions
  • Column expressions
  • Filter Expressions
  • Aggregate Expressions
• Dynamic Schemas
  • Dynamic Schemas in Python
  • Dynamic Schemas in Java
• Joins
  • Creating a Join View
  • Operating on a Join View
  • SQL Conversion Example
  • Performance Optimization
  • Limitations & Cautions
• Projections
  • Creating a Projection
  • Operating on a Projection
  • Limitations and Cautions
• Unions
  • Performing a Union
  • Operating on a Union
  • Limitations and Cautions
• Intersect
  • Performing an Intersect
  • Operating on an Intersect
  • Limitations
• Except
  • Performing an Except
  • Operating on an Except
  • Limitations
• Materialized Views
  • Manual Mode
  • On Query Mode
  • On Insert Mode
  • Manual Refresh
  • Materialized View vs. Filtered View
  • SQL View
  • Examples
• Full Text Search
• Nulls
  • Setting Nullability
  • Using Nulls
  • Aggregates and Nulls