Hive has a whole lot of functionality that is built-in into it. You should look at length(string) function for what you want to achieve. Also I would suggest reading the hive language manual at https://cwiki.apache.org/confluence/display/Hive/LanguageManual. You can also read https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF, it lists a lot of functions that are possible in hive.
On Fri, Jul 27, 2012 at 4:19 PM, Techy Teck <comptechge...@gmail.com> wrote: > 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? >
