logo
ksqlDB Documentation
Joins
Initializing search
    ksqlDB home
    confluentinc/ksql
    • Getting started
    • Concepts
    • How-to guides
    • Tutorials
    • Operate and Deploy
    • Reference
    confluentinc/ksql
      • Synopsis
      • Troubleshooting
      • Frequently asked questions
      • Synopsis
      • Events
      • Stream Processing
      • Materialized Views
      • Streams
      • Tables
      • Queries
        • Join Index
        • Joining collections
        • Partitioning requirements
        • Synthetic key columns
      • Time and Windows
      • User-defined functions
      • Connectors
      • Lambda Functions
      • Apache Kafka primer
      • Synopsis
      • Query structured data
      • Convert a changelog to a table
      • Update a running persistent query
      • Use connector management
      • Create a user-defined function
      • Control the case of identifiers
      • Use a custom timestamp column
      • Test an application
      • Substitute variables
      • Transforming columns with structured data
      • Synopsis
      • Materialized cache
      • Streaming ETL pipeline
      • Event-driven microservice
      • Operations Index
      • How it works
        • Install ksqlDB
        • Configure ksqlDB CLI
        • Configure ksqlDB with Docker
        • Install ksqlDB by using Docker
        • Check the Health of a ksqlDB Server
          • Configure ksqlDB Server
          • Configure ksqlDB for Avro, Protobuf, and JSON schemas
          • Configure Security for ksqlDB
        • Upgrade ksqlDB
      • Manage metadata schemas
      • Logging
      • Monitoring
      • Exactly once semantics
      • Schema Registry integration
      • High availability for pull queries
      • Plan Capacity
      • Performance Guidelines
      • KSQL and ksqlDB
      • Changelog
      • Synopsis
          • Lexical structure
        • Data definition
        • Data types
        • Time operations
        • Appendix
        • SQL quick reference
        • Statement Index
        • CREATE CONNECTOR
        • CREATE STREAM
        • CREATE TABLE
        • CREATE STREAM AS SELECT
        • CREATE TABLE AS SELECT
        • CREATE TYPE
        • DEFINE
        • DESCRIBE
        • DESCRIBE CONNECTOR
        • DESCRIBE FUNCTION
        • DROP CONNECTOR
        • DROP STREAM
        • DROP TABLE
        • DROP TYPE
        • EXPLAIN
        • INSERT INTO
        • INSERT VALUES
        • PRINT
        • RUN SCRIPT
        • SELECT (Push Query)
        • SELECT (Pull Query)
        • SHOW CONNECTORS
        • SHOW FUNCTIONS
        • SHOW PROPERTIES
        • SHOW QUERIES
        • SHOW TOPICS
        • SHOW STREAMS
        • SHOW TABLES
        • SHOW TYPES
        • SHOW VARIABLES
        • SPOOL
        • TERMINATE
        • Type Coercion
        • UNDEFINE
      • Operators
        • Functions Index
        • Scalar functions
        • Aggregation functions
        • Table Functions
      • Server configuration
      • Metrics
        • REST API Index
        • Execute a statement
        • Run a query
        • Run push and pull queries
        • Introspect query status
        • Introspect server status
        • Introspect cluster status
        • Terminate a cluster
        • Get the validity of a property
        • Synopsis
        • Java Client
        • Contribute a new client
      • Processing log
      • Serialization
      • User-defined functions
      • Migrations tool configuration

    Join Index

    • Join Event Streams
    • Partition Data to Enable Joins
    • Synthetic key columns
    Last update: 2021-12-05
    Previous Queries
    Next Joining collections

    Copyright © 2022 Confluent, Inc.

    Please report any inaccuracies on this page or suggest an edit.