Skip to content
ksqlDB
ksqlDB Functions Index
Initializing search
confluentinc/ksql
ksqlDB
confluentinc/ksql
Overview
Getting started
Concepts
Concepts
Concepts
Events
Collections
Collections
Collections Overview
Streams
Tables
Inserting events
Stream Processing
Materialized Views
Queries
Queries
Queries Overview
Push Queries
Pull Queries
Schemas
Connectors
Functions
Joins
Joins
Join Index
Joining collections
Partitioning requirements
Synthetic key columns
Architecture
Time and Windows
Serialization
Processing Guarantees
Relationship to Kafka Streams
Developer Guide
Developer Guide
Develop ksqlDB Applications
Develop with ksqlDB clients
Create a Stream
Create a Table
Aggregate Streaming Events
Transform a Stream
Example Queries
Test and Debug
Test and Debug
Test and Debug Index
Test harness
Generate test data
Processing log
How-to guides
How-to guides
Synopsis
Query structured data
Convert a changelog to a table
Use a custom timestamp column
Use connector management
Create a user-defined function
Control the case of identifiers
Reference
Reference
Syntax Reference
Statements
Statements
SQL quick reference
Statement Index
CREATE CONNECTOR
CREATE STREAM
CREATE TABLE
CREATE STREAM AS SELECT
CREATE TABLE AS SELECT
CREATE TYPE
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
SPOOL
TERMINATE
Operators
Functions
Functions
Functions Index
Scalar functions
Aggregation functions
Table Functions
Metrics
REST API
REST API
REST API Index
Introspect query status
Introspect server status
Execute a statement
Run a query
Run push and pull queries
Terminate a cluster
Clients
Clients
Java Client
Operate and Deploy
Operate and Deploy
Operations Index
Deploy
Deploy
Install ksqlDB
Configure ksqlDB CLI
Configure ksqlDB with Docker
Install ksqlDB by using Docker
Check the Health of a ksqlDB Server
Server Configuration
Server Configuration
Configure ksqlDB Server
Configure ksqlDB for Avro, Protobuf, and JSON schemas
Configuration Parameter Reference
Configure Security for ksqlDB
Upgrade ksqlDB
Monitoring
Plan Capacity
KSQL and ksqlDB
Changelog
Tutorials
Tutorials
Tutorials and Examples
Materialized view/cache
Streaming ETL pipeline
Event-driven microservice
Examples
ksqlDB with Embedded Connect
Integrate with PostgreSQL
Troubleshooting
Frequently asked questions
Functions
¶
Aggregate Functions
Scalar Functions
Table Functions
Last update: 2020-07-30