Looks like a bug. What is the svn revision of Hive? Did you verify that single insert into '/tmp/out/1' produces non-empty files?
Zheng On Tue, Jan 5, 2010 at 12:51 AM, wd <w...@wdicc.com> wrote: > In hive wiki: > > Hive extension (multiple inserts): > FROM from_statement > INSERT OVERWRITE [LOCAL] DIRECTORY directory1 select_statement1 > > [INSERT OVERWRITE [LOCAL] DIRECTORY directory2 select_statement2] ... > > I'm try to use hive multi inserts to extract data from hive to local disk. > Follows is the hql > > from test_tbl > INSERT OVERWRITE LOCAL DIRECTORY '/tmp/out/0' select select * where id%10=0 > INSERT OVERWRITE LOCAL DIRECTORY '/tmp/out/1' select select * where id%10=1 > INSERT OVERWRITE LOCAL DIRECTORY '/tmp/out/2' select select * where id%10=2 > > This hql can execute, but only /tmp/out/0 have datafile in it, other > directories are empty. why this happen? bug? > > > > > -- Yours, Zheng