hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sreenath <sreenaths1...@gmail.com>
Subject INSERT OVERWRITE LOCAL DIRECTORY
Date Fri, 14 Feb 2014 10:43:01 GMT
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

Mime
View raw message