Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> count the characters in a string


Copy link to this message
-
Re: count the characters in a string
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 <[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?
>