How to get maximum size used by a string in Hive?

Question

I want to know the maximum length a particular string column is taking. I tried taking the approach mentioned here: how to get the max size used by a field in table, but that did not work in Hive.

Answer 1

In that example they use len, use length instead:

select max(length(mycolumn)) from mytable;

This works fine in hive QL.