NUMBER_OF_ARGUMENTS_DOESNT_MATCH ClickHouse error¶

The NUMBER_OF_ARGUMENTS_DOESNT_MATCH error in ClickHouse (and Tinybird) happens when you call a function with an incorrect number of arguments. Functions in ClickHouse have specific signatures that define how many parameters they expect and what types those parameters should be.

What causes this error¶

You'll typically see it when:

• Calling a function with too few arguments
• Calling a function with too many arguments
• Using the wrong syntax for function calls
• Missing required parameters
• Using optional parameters incorrectly

Example errors¶

SELECT replace('hello world')

SELECT toDate('2023-01-01', 'UTC', 'extra')

SELECT formatDateTime(now())

SELECT if(user_id > 10, 'high', 'low', 'unknown')

How to fix it¶

Check function documentation¶

Always verify the function signature before using it:

SELECT replace('hello world', 'world', 'clickhouse')

SELECT toDate('2023-01-01', 'UTC')

Use proper function syntax¶

Make sure you're using the correct syntax for each function:

SELECT formatDateTime(now(), '%Y-%m-%d %H:%M:%S')

SELECT if(user_id > 10, 'high', 'low')

Common patterns and solutions¶

String functions¶

Common string functions and their argument counts:

SELECT substring('hello world', 1, 5)  -- 3 arguments: string, start, length (indexing starts at 1)

SELECT replace('hello world', 'world', 'clickhouse')  -- 3 arguments: string, old, new

SELECT concat('hello', ' ', 'world')  -- variable number of arguments

Date and time functions¶

Date functions often require specific formats:

SELECT parseDateTimeBestEffort('2023/01/01', 'UTC')  -- 2 arguments: date string, timezone

SELECT toDateTime('2023-01-01 12:00:00')  -- 1 argument: datetime string

SELECT formatDateTime(now(), '%Y-%m-%d')  -- 2 arguments: datetime, format

Conditional functions¶

Conditional functions have specific argument requirements:

SELECT if(condition, true_value, false_value)  -- 3 arguments

SELECT multiIf(
    condition1, value1,
    condition2, value2,
    default_value
)  -- odd number of arguments

SELECT greatest(1, 2, 3, 4, 5)  -- variable number of arguments

SELECT least(10, 5, 8, 2)  -- variable number of arguments

Aggregate functions¶

Aggregate functions can have different argument patterns:

SELECT count(*)  -- 1 argument: expression or *

SELECT sum(value)  -- 1 argument: numeric expression

SELECT avg(value)  -- 1 argument: numeric expression

Advanced solutions¶

Using optional parameters¶

Some functions have optional parameters:

SELECT toDate('2023-01-01')  -- without timezone
SELECT toDate('2023-01-01', 'UTC')  -- with timezone

Variable argument functions¶

Some functions accept variable numbers of arguments:

SELECT concat('a', 'b', 'c', 'd')  -- any number of arguments

SELECT greatest(1, 2, 3, 4, 5)  -- any number of arguments

Function parameter ordering¶

SELECT substring('hello world', 1, 5)  -- string, start, length

SELECT substring(1, 'hello world', 5)  -- This will fail

Window functions¶

Window functions have specific syntax requirements:

SELECT user_id,
       ROW_NUMBER() OVER (PARTITION BY user_id ORDER BY timestamp) as row_num
FROM events

Function categories and common signatures¶

String manipulation¶

• substring(string, start, length) - Extract substring
• replace(string, old, new) - Replace substring
• concat(string1, string2, ...) - Concatenate strings
• trim(string) - Remove whitespace

Date and time¶

• toDate(string) - Convert to date
• toDateTime(string) - Convert to datetime
• formatDateTime(datetime, format) - Format datetime
• now() - Current timestamp

Mathematical¶

• abs(number) - Absolute value
• round(number, decimals) - Round number
• power(base, exponent) - Raise to power
• sqrt(number) - Square root

Conditional¶

• if(condition, true_value, false_value) - Simple conditional
• multiIf(condition1, value1, condition2, value2, ...) - Multiple conditions
• case when ... then ... else ... end - CASE statement

Tinybird-specific notes¶

In Tinybird, this error often occurs when:

• Using ClickHouse functions in Pipes with wrong argument counts
• Calling custom functions with incorrect parameters
• Using Materialized View functions incorrectly
• Working with JSON extraction functions

To debug in Tinybird:

1. Check the ClickHouse function documentation
2. Use the Query Builder to test function calls
3. Verify function signatures in Pipe nodes
4. Test functions with simple examples first

See also¶

• ClickHouse Functions
• String Functions
• Date and Time Functions
• Common function errors