HiveQL where value not empty

[Arthur Boender <ar...@avanade.com>]

Hi there,

Im new here, but I have a short question I could very much use a quick answer, I am trying to find out how I could
Filter empty value's. Is there a command similar to where (text is not Empty)

With regards,

Arthur

From: nagarjuna kanamarlapudi [mailto:nagarjuna.kanamarlapudi@gmail.com]
Sent: vrijdag 18 januari 2013 15:57
To: user@hive.apache.org
Cc: user@hadoop.apache.org
Subject: Re: Execution of udf

No but the query execution shows a reducer running .. And infant I feel that reduce phase can be there

On Friday, January 18, 2013, Dean Wampler wrote:
There is no reduce phase needed in this query.
On Fri, Jan 18, 2013 at 6:59 AM, nagarjuna kanamarlapudi <nagarjuna.kanamarlapudi@gmail.com<javascript:_e(%7b%7d,%20'cvml',%20'nagarjuna.kanamarlapudi@gmail.com');>> wrote:
Hi,

Select col1,myudf(col2,col3) from table1;


In what phase if map reduce an udf is executed.

In the very beginning, I assumed that hive will be joining two tables., getting the required columns and then applies udf on columns specified I.e., essentially on reducer phase . But later on I realised that I was wrong.

Is there any specific parameter which suggests hive to call udf at reducer phase rather than at Mapper phase.


Regards,
Nagarjuna


--
Sent from iPhone



--
Dean Wampler, Ph.D.
thinkbiganalytics.com<http://thinkbiganalytics.com>
+1-312-339-1330



--
Sent from iPhone