目录
-
- `to_char`运行报错:`function TO_CHAR cannot match any overloaded functions with (DATETIME), candidates are STRING TO_CHAR(BIGINT arg0)......`
- SQL使用了系统参数`${bizdate}`,但是运行报错:`FAILED: ODPS-0130161:[20,12] Parse exception - invalid token '$'`
- 执行插入报错:`FAILED: ODPS-0130071:[73,24] Semantic analysis exception - the number of input partition columns (1) doesn't equal to table's partition columns (2)`
- ODPS-0420081: Method not allowed
to_char
运行报错:function TO_CHAR cannot match any overloaded functions with (DATETIME), candidates are STRING TO_CHAR(BIGINT arg0)......
看字面意思是说无重载,也就是说传入了错误的参数导致误判为重载。
实际检查后,确实是参数个数不对或写法有问题:
错误代码:TO_CHAR(DATEADD(GETDATE(), -1, 'dd')), 'yyyyddmm')
,'dd’后多了一个括号
正确代码:TO_CHAR(DATEADD(GETDATE(), -1, 'dd'), 'yyyyddmm')
函数说明如下: