This example query would cause the following error:

SELECT td_time_format(time) from pageviews;

Error:

Unexpected parameters (bigint) for function td_time_format. 
Expected: td_time_format(bigint, varchar, varchar) , td_time_format(bigint, varchar)

Cause

This error occurs when the number of arguments or the data type provided in the function is different from those specified for that function.

Resolution

Provide the correct number and type of arguments required for the function. See the notes for the correct number and type of arguments.

Fixed query:

SELECT td_time_format(time, 'yyyy-MM-dd HH:mm:ss', 'UTC') from pageviews;

Notes


  • No labels