hive中field如果是string,比如id,那么使用10000000000+id结果是科学计数法显示,转换为正常显示方法:
select (10000000000+cast(id as int)) as id from tb1 limit 10;
hive 调用java的函数,必须是静态类函数
select reflect ("java.lang.String","valueOf",id) from tb1 limit 1;
select reflect ("java.lang.Long","valueOf",(10000000000+cast(id as int))) as id from tb1 limit 10;