Re: count the characters in a string

2012-07-27 Thread Techy Teck
Yup, got it. Thanks.. On Fri, Jul 27, 2012 at 5:10 PM, Viral Bajaria 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.apa

Re: count the characters in a string

2012-07-27 Thread Viral Bajaria
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.o

count the characters in a string

2012-07-27 Thread 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 t