select cast(date as char) as date from table1; 结果如下: date 2015-11-03 15:31:26 select cast(date as datetime) as date from table1; 结果如下: date 2015-11-03 15:31:26 select cast(date as date) as date from table1; 结果如下: date 2015-11-03 select cast(date as time) as...
cast(split(jsonp(json),',')[3] as int) from t_rating_json; 注:临时函数只在一次hive会话中有效,重启会话后就无效 如果需要经常使用该自定义函数,可以考虑创建永久函数: 拷贝jar包到hive的类路径中: cp wc.jar apps/hive-1.2.1/lib/ 创建了: create function pfuncx as 'com.doit.hive.udf.UserInf...
select cast(date as signed) as date from table1; -- 结果如下: date 20151103153126 select cast(date as char) as date from table1; -- 结果如下: date 2015-11-03 15:31:26 select cast(date as datetime) as date from table1; -- 结果如下: date 2015-11-03 15:31:26 select cast(date...