Wrong arguments '"yyyy-MM-dd HH:mm:ss"': No matching method for class org.apache.hadoop.hive.ql.udf.UDFFromUnixTime with (double, string). Possible choices: _FUNC_(bigint) _FUNC_(bigint, string) _FUNC_(int) _FUNC_(int, string) (state=42000,code=10014)

刘超 4天前 ⋅ 24 阅读   编辑
0: jdbc:hive2://n17-06-02:2181,n17-07-04:2181> select sessionid,hashedoperaid,materialid,timems,from_unixtime(round(timems/1000),"yyyy-MM-dd HH:mm:ss") from log_adx_install where day=20200611 and hashedoperaid in ('70b28e51bf0b7074','f93edcec212a057c','43735d38ed2de170','ddca97f7871eac46') order by sessionid,materialid,timems limit 10;
Error: Error while compiling statement: FAILED: SemanticException [Error 10014]: Line 1:49 Wrong arguments '"yyyy-MM-dd HH:mm:ss"': No matching method for class org.apache.hadoop.hive.ql.udf.UDFFromUnixTime with (double, string). Possible choices: _FUNC_(bigint)  _FUNC_(bigint, string)  _FUNC_(int)  _FUNC_(int, string) (state=42000,code=10014)


select sessionid,hashedoperaid,materialid,timems,from_unixtime(CAST(timems/1000 as BIGINT),"yyyy-MM-dd HH:mm:ss") from log_adx_install where day=20200611 and hashedoperaid in ('70b28e51bf0b7074','f93edcec212a057c','43735d38ed2de170','ddca97f7871eac46') order by sessionid,materialid,timems limit 10;

注意:本文归作者所有,未经作者允许,不得转载

全部评论: 0

    我有话说: