Bucketing float and double affects join?

2012-12-29 Thread Nguyễn Thi Dương
Hi, I understand that we can join float and double and they will be automatically cast to the same types. However I want to use bucketing to speed up the joins. If one of the joined columns is float and the other is double, and the number of buckets are the same, will I be able to use the hint "ma

Re: HIVE left semi join multiple tables with columns from multiple table

2012-12-29 Thread Mark Grover
Souvik, I am not sure I understand, you may want to play around with distinct keyword if you want to join on unique values. In any case, it looks like you've got it figured out already, so it's all good:-) Happy trails! Mark On Sat, Dec 29, 2012 at 2:19 PM, Souvik Banerjee wrote: > Thanks Mark f

Re: HIVE left semi join multiple tables with columns from multiple table

2012-12-29 Thread Souvik Banerjee
Thanks Mark for writing back to me. I did the same thing and still not getting the desired result. I was looking for the cause. I managed to get the desired result. Sharing my thought process and how I did it. Let me know your thoughts on this, that would be really nice to have. Also please share a

Re: Does Hue (Hadoop User Experience) works with Apache HIVE/HADOOP

2012-12-29 Thread Dean Wampler
If you're willing to consider a commercial option, Karmasphere is already supported on EMR. http://aws.amazon.com/elasticmapreduce/karmasphere/ On Sat, Dec 29, 2012 at 1:29 AM, Chunky Gupta wrote: > Hi, > > I have Apache Hive and Apache Hadoop on Amazon EC2 machines. If anyone can > tell me that