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