sure that will do what is required thanks nitin
On Fri, Feb 14, 2014 at 4:38 PM, Nitin Pawar <nitinpawar...@gmail.com>wrote: > hive -e " select * from table limit 3" > localfile > > will above do for what you want to do? > > > On Fri, Feb 14, 2014 at 4:36 PM, Sreenath <sreenaths1...@gmail.com> wrote: > >> 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 >> > > > > -- > Nitin Pawar > -- Sreenath S Kamath Bangalore Ph No:+91-9590989106
