hive用源生函数实现根据身份证计算年龄

SELECT 
floor(
( UNIX_TIMESTAMP(current_date) - 
UNIX_TIMESTAMP(substr(sfz,7,8),'yyyyMMdd') 
)/(365*24*60*60) 
) as age
from test_age;

如果hive不支持UNIX_TIMESTAMP(current_date)这种写法，就将它改成UNIX_TIMESTAMP(current_date,'yyyy-MM-dd')