How to convert a date format YYYY-MM-DD into integer YYYYMMDD in Presto/Hive?
If you just need to transform your date YYYY-MM-DD into an integer YYYYMMDD why don't you try to first remove all the occurrences of "-"
from the string representation of your date before casting the result to int by using something like this?
cast(regexp_replace(str_column,'-','') as int)