meaning i want the output in a local directory without it scanning through the whole table
On Fri, Feb 14, 2014 at 4:27 PM, Nitin Pawar <nitinpawar...@gmail.com>wrote: > what do you mean workaround for this ? its not a problem > > > On Fri, Feb 14, 2014 at 4:26 PM, Sreenath <sreenaths1...@gmail.com> wrote: > >> hi all, >> really appreciate the responses do you have any means as a work around >> for this ? >> >> >> On Fri, Feb 14, 2014 at 4:22 PM, shashwat shriparv < >> dwivedishash...@gmail.com> wrote: >> >>> Because when you do select * the query just has to read and return the >>> resultl but when you give query under query suffle sort and comparison >>> happens thats why mapreduce... >>> >>> >>> *Warm Regards_**∞_* >>> * Shashwat Shriparv* >>> [image: >>> http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9]<http://www.linkedin.com/pub/shashwat-shriparv/19/214/2a9>[image: >>> https://twitter.com/shriparv] <https://twitter.com/shriparv>[image: >>> https://www.facebook.com/shriparv] >>> <https://www.facebook.com/shriparv>[image: >>> http://google.com/+ShashwatShriparv]<http://google.com/+ShashwatShriparv>[image: >>> http://www.youtube.com/user/sShriparv/videos]<http://www.youtube.com/user/sShriparv/videos>[image: >>> http://profile.yahoo.com/SWXSTW3DVSDTF2HHSRM47AV6DI/]<shrip...@yahoo.com> >>> >>> >>> >>> On Fri, Feb 14, 2014 at 4:15 PM, Nitin Pawar <nitinpawar...@gmail.com>wrote: >>> >>>> when you are writing a file, it will need an application to create and >>>> write the file. >>>> Thats why the mapreduce job to create the file. >>>> >>>> Where as for other way when its displayed on console, its just hdfs cat >>>> operation >>>> >>>> >>>> On Fri, Feb 14, 2014 at 4:13 PM, Sreenath <sreenaths1...@gmail.com>wrote: >>>> >>>>> i have two queries >>>>> 1. select * from tab1 limit 3; >>>>> this returns the 3 rows quickly withoput launcing any map reduce jobs; >>>>> >>>>> 2. INSERT OVERWRITE LOCAL DIRECTORY "/tmp/query1/" select * from tab1 >>>>> limit 3; >>>>> but the same above query to write to a local directory launches a map >>>>> reduce job and scans through all the rows launching map-reduce jobs >>>>> >>>>> why the differenceinexecution of both queries? >>>>> >>>>> -- >>>>> Sreenath S Kamath >>>>> Bangalore >>>>> Ph No:+91-9590989106 >>>>> >>>> >>>> >>>> >>>> -- >>>> Nitin Pawar >>>> >>> >>> >> >> >> -- >> Sreenath S Kamath >> Bangalore >> Ph No:+91-9590989106 >> > > > > -- > Nitin Pawar > -- Sreenath S Kamath Bangalore Ph No:+91-9590989106
