Re: Re: how to join like a "In A but not in B" operation?

Thinking out loud here and may be worth a shot. Please perform an explain to see if the where takes place after the join but this may work, Select a.* from a left join b on a.key=b.key where b.key is null Thanks, Ranjith From: Richard [mailto:codemon...@163.com] Sent: Monday, March 12, 2012 12

Re:Re: how to join like a "In A but not in B" operation?

Hi Sachin I have tried LEFT SEMI JOIN, but the results are the same to a JOIN operation. Richard At 2012-03-12 12:03:39,sac.khur...@gmail.com wrote: Hi richard, You can use left semi join. SELECT a.key. FROM a LEFT SEMI JOIN b on (a.key = b.key) Thanks, Sachin Sent from BlackBerry® on A

how to compute histogram on non-numeric data set?

I have noticed histogram_numeric(col, n), but it seems to require numeric column. I have a string column, they are numeric like string but are category label, e.g, 11, 200034 two different strings are two different category but the numeric value does not mean anything, so it is not prope

Re: how to join like a "In A but not in B" operation?

Hi richard, You can use left semi join. SELECT a.key. FROM a LEFT SEMI JOIN b on (a.key <> b.key) Thanks, Sachin Sent from BlackBerry® on Airtel -Original Message- From: sac.khur...@gmail.com Date: Mon, 12 Mar 2012 04:03:39 To: Reply-To: sac.khur...@gmail.com Subject: Re: how to joi

Re: how to join like a "In A but not in B" operation?

Hi richard, You can use left semi join. SELECT a.key. FROM a LEFT SEMI JOIN b on (a.key = b.key) Thanks, Sachin Sent from BlackBerry® on Airtel -Original Message- From: Richard Date: Mon, 12 Mar 2012 11:52:11 To: Reply-To: user@hive.apache.org Subject: how to join like a "In A but

Re: how to join like a "In A but not in B" operation?

I used a left outer join with a constraint on a joined row column value being null -- logically equivalent to a "not in" clause. Looks funny, but it works. On Mar 11, 2012, at 10:52 PM, "Richard" mailto:codemon...@163.com>> wrote: hi, how can I join two tables A and B so that the result is "I

how to join like a "In A but not in B" operation?

hi, how can I join two tables A and B so that the result is "In A but not in B"? let's take an example, say, the column to identify record is id. e.g. select A.* from A join B on (A.id = B.id) thanks. Richard

RE: Hive-645 is slow to insert query results to mysql

Hi Viral and Bejoy.K.S I can see that both of you are suggesting Sqoop, and I will have a try ☺. Thanks, Wei From: Bejoy Ks [mailto:bejoy...@yahoo.com] Sent: Saturday, March 10, 2012 2:11 AM To: user@hive.apache.org; Lu, Wei Subject: Re: Hive-645 is slow to insert query results to mysql Hi Wei