-Re: count the characters in a string
Viral Bajaria 2012-07-28, 00:10
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
lists a lot of functions that are possible in hive.
On Fri, Jul 27, 2012 at 4:19 PM, Techy Teck <[EMAIL PROTECTED]> 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?