Hive Query with UDF

2012-10-17 Thread Sam Mohamed
I have some encrypted data in an HDFS csv, that I've created a Hive table for, and I want to run a Hive query that first encrypts the query param, then does the lookup. I have a UDF that does encryption as follows: public class ParamEncrypt extends UDF { public Text evaluate(String name) thr

Re: Hive Query with UDF

2012-10-17 Thread Michael Segel
You don't need an UDF... You encrypt the string 'Ann' first then use that encrypted value in the Select statement. That should make things a bit simpler. On Oct 17, 2012, at 8:04 PM, Sam Mohamed wrote: > I have some encrypted data in an HDFS csv, that I've created a Hive table > for, an

RE: Hive Query with UDF

2012-10-17 Thread Sam Mohamed
, 2012 6:10 PM To: user@hadoop.apache.org Subject: Re: Hive Query with UDF You don't need an UDF... You encrypt the string 'Ann' first then use that encrypted value in the Select statement. That should make things a bit simpler. On Oct 17, 2012, at 8:04 PM, Sam Mohamed wrote:

Re: Hive Query with UDF

2012-10-17 Thread lohit
Segel [michael_se...@hotmail.com] > Sent: Wednesday, October 17, 2012 6:10 PM > To: user@hadoop.apache.org > Subject: Re: Hive Query with UDF > > You don't need an UDF... > > You encrypt the string 'Ann' first then use that encrypted value in the > Select stateme

Re: Hive Query with UDF

2012-10-17 Thread Michael Segel
ck response. > > The idea is that we are selling the encryption product for customers who use > HDFS. Hence, encryption is a requirement. > > Any other suggestions. > > Sam > > From: Michael Segel [michael_se...@hotmail.com] >

Re: Hive Query with UDF

2012-10-17 Thread Sam Mohamed
_se...@hotmail.com>] Sent: Wednesday, October 17, 2012 6:10 PM To: user@hadoop.apache.org<mailto:user@hadoop.apache.org> Subject: Re: Hive Query with UDF You don't need an UDF... You encrypt the string 'Ann' first then use that encrypted value in the Select statement. That