Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> hive multiple inserts


Copy link to this message
-
Re: hive multiple inserts
hi,

Single insert can extract data into '/tmp/out/1'.I even can see "xxx rows
loaded to '/tmp/out/0', xxx rows loaded to '/tmp/out/1'...etc in multi
inserts, but there is no data in fact.

Havn't try svn revision, will try it today.thx.

2010/1/5 Zheng Shao <[EMAIL PROTECTED]>

> 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 <[EMAIL PROTECTED]> 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
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB