Getting error in vertica:Function catalog.btrim(int) dose not exist, or permission is denied for catalog.btrim(int)

Question

I am trying to execute below query in vertica:

select 
case when count(*) = 0 then #{aaa} || #{bbb}
else
 trim(cast(max(ccc)+1 as intger))
end
 as ccc
from apple where aaa = #{aaa}

Query is getting expected results in tera but in Vertica Getting error. How can I do this?

Answer 1

Check the Vertica docu: https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/SQLReferenceManual/Functions/String/BTRIM.htm

BTRIM() removes the blank characters (by default, if not specified as the second parameter) from a passed string. You can't BTRIM() a number.

Why would you want to trim an integer, in trim(cast(max(ccc)+1 as int**e**ger)) ? It makes no sense at all!. Teradata should complain, too.