RE: Optimization on bucketized/sorted tables

2012-03-23 Thread mdefoinplatel.ext
:mgro...@oanda.com] Envoyé : jeudi 22 mars 2012 17:58 À : user@hive.apache.org Objet : Re: Optimization on bucketized/sorted tables Hi Michael, This JIRA is along the lines of your questions: https://issues.apache.org/jira/browse/HIVE-2846 The following is based on my understanding so take it with a gra

Re: Optimization on bucketized/sorted tables

2012-03-22 Thread Mark Grover
Hi Michael, This JIRA is along the lines of your questions: https://issues.apache.org/jira/browse/HIVE-2846 The following is based on my understanding so take it with a grain of salt:-) You're right. The 4 kinds of queries you pointed out can be potentially be optimized if the source table(s) are