Home
Maintenance
Database maintenance and system management
Error Code Reference
S02-SQL
S02049

Deployment
Deploy and upgrade DolphinDB on premise or in the cloud
Database
Design and configure DolphinDB databases
Streaming
Publish, subscribe to, and process streaming data
Migration
Import and migrate data from various data sources to DolphinDB databases
Maintenance
Database maintenance and system management
Programming Guide
DolphinDB scripting language and SQL reference
Function References
Reference for all built-in functions
API & Connector
API in different languages for users to call DolphinDB from their programs
Plugins
Guidance on the use of plugins and plugin development for multiple application scenarios
Tutorials
Tutorials on database concepts and application scenarios
Release Notes
Release notes and compatibility changes for DolphinDB server, plugins and APIs

S02049

Error Code

S02049

Error Message

Analytic function does not support function '%s'. RefId: S02049

Probable Causes

Analytic functions specifies a series of supported functions. This error occurs when an unsupported function is used within an analytic function. For example:

id = `XOM`GS`AAPL
val = 102.1 33.4 73.6
date = 2020.01.01 2020.01.02 2020.01.01
t = table(id, val, date);

select database("123456", VALUE, 2024.02.01..2024.02.02) over () from t => Analytic function does not support function 'database'.

Solutions

If the outcome of the unsupported function specified in the analytic function can be achieved by a supported functions, replace it. Otherwise, use other SQL statements to achieve the outcome.