count the characters in a string

[Techy Teck]

I have a column in Table1 named as -

*character *with String datatype.


I want to find all the records from the tables if total words in
*character*column is less than 32 characters.

Something like below.

select * from Table1 where *count_characters_in_character_column* < 32;


Is it possible to do in HiveQL?