Skip to content
ksqlDB Documentation
ksqlDB Functions Index
Initializing search
ksqlDB home
confluentinc/ksql
Getting started
Concepts
How-to guides
Tutorials
Operate and Deploy
Reference
ksqlDB Documentation
confluentinc/ksql
Getting started
Getting started
Synopsis
Troubleshooting
Frequently asked questions
Concepts
Concepts
Synopsis
Events
Stream Processing
Materialized Views
Streams
Tables
Queries
Joins
Joins
Join Index
Joining collections
Partitioning requirements
Synthetic key columns
Time and Windows
User-defined functions
Connectors
Lambda Functions
Apache Kafka primer
How-to guides
How-to guides
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
Tutorials
Tutorials
Synopsis
Materialized cache
Streaming ETL pipeline
Event-driven microservice
Operate and Deploy
Operate and Deploy
Operations Index
How it works
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
Configure Security for ksqlDB
Upgrade ksqlDB
Manage metadata schemas
Logging
Monitoring
Exactly once semantics
High availability
Schema Registry integration
Schema Inference With ID
High availability for pull queries
Plan Capacity
Performance Guidelines
KSQL and ksqlDB
Changelog
Reference
Reference
Synopsis
The SQL language
The SQL language
SQL syntax
SQL syntax
Lexical structure
Data definition
Data types
Time operations
Appendix
Statements
Statements
SQL quick reference
Statement Index
ALTER SYSTEM
ASSERT SCHEMA
ASSERT TOPIC
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
PAUSE
PRINT
RESUME
RUN SCRIPT
SELECT (Push Query)
SELECT (Pull Query)
SHOW CONNECTORS
SHOW FUNCTIONS
SHOW PROPERTIES
SHOW QUERIES
SHOW STREAMS
SHOW TABLES
SHOW TOPICS
SHOW TYPES
SHOW VARIABLES
SPOOL
TERMINATE
Type Coercion
UNDEFINE
Operators
Functions
Functions
Functions Index
Scalar functions
Aggregation functions
Table Functions
Server configuration
Metrics
REST API
REST API
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
Clients
Clients
Synopsis
Java Client
Contribute a new client
Processing log
Serialization
User-defined functions
Migrations tool configuration
Functions
¶
Aggregate Functions
Scalar Functions
Table Functions
Last update: 2024-10-28