This page was moved to https://api-docs.treasuredata.com/en/tools/presto/presto_troubleshooting/#presto-error---unexpected-parameters-for-function-yyyy
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;