Skip to content
ksqlDB Documentation
ksqlDB Functions Index
Initializing search
confluentinc/ksql
ksqlDB home
ksqlDB Documentation
confluentinc/ksql
Getting started
Apache Kafka primer
Concepts
Concepts
Concepts
Events
Collections
Collections
Collections Overview
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
Evolving Production Queries
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
Test an application
Substitute variables
Reference
Reference
Syntax Reference
The SQL language
The SQL language
SQL syntax
SQL syntax
Lexical structure
Data definition
Appendix
Statements
Statements
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
UNDEFINE
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
Synopsis
Java Client
Contribute a new client
Processing log
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
Synopsis
Materialized cache
Streaming ETL pipeline
Event-driven microservice
Troubleshooting
Frequently asked questions
Functions
¶
Aggregate Functions
Scalar Functions
Table Functions
Last update: 2020-10-19