hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Techy Teck <comptechge...@gmail.com>
Subject Re: count the characters in a string
Date Sat, 28 Jul 2012 00:28:53 GMT
Yup, got it. Thanks..



On Fri, Jul 27, 2012 at 5:10 PM, Viral Bajaria <viral.bajaria@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 <comptechgeeky@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?
>>
>
>

Mime
View raw message