Yup, got it. Thanks..
On Fri, Jul 27, 2012 at 5:10 PM, Viral Bajaria <viral.baja...@gmail.com>wrote: > 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? >> > >
