I want to know the maximum length a particular string column is taking.
I tried taking the approached mentioned here :
how to get the max size used by a field in table but did not work in Hive
but that did not work in Hive.
In that example they use
select max(length(mycolumn)) from mytable;
This works fine in hive QL.