gistfile1.md

explain

explain select * from user limit 10;

explain select * from (select * from user) u sort by user_id limit 10 ;

local mode

select count(*) from user;

set mapred.job.tracker = local; set mapred.tmp.dir =/tmp/masashi/sada; select count(*) from user;

virtual columns

et hive.exec.rowoffset=true;
select INPUT__FILE__NAME , BLOCK__OFFSET__INSIDE__FILE, ROW__OFFSET__INSIDE__BLOCK from user limit 10;