Search code examples
google-bigqueryudf

Google BigQuery UDF Error


I am invoking a UDF from a select Query , however I see the following error at query time , does anyone know what the issue is ? I have checked Accounting_Date it has valid date values of type 06/28/2015.

Error: Bad number for Accounting_Date
Error Location: User-defined function
Job ID: xxx-us-n-xxxx:bquijob_3c11b2e1_1538669f9fe

Solution

  • Usually this error tells you that data type of output field (see emit portion) is not as it is declared in output schema section