What about this : create view foo_copy_partition AS select * from foo where id in (1,2,3); export table foo_copy_partition to ‘path’; drop view foo_copy_partition ;
Regards Sanjiv Singh Mob : +091 9990-447-339 On Fri, Jun 26, 2015 at 7:40 AM, Xuefu Zhang <xzh...@cloudera.com> wrote: > Hi Brian, > > If you think that is useful, please feel free to create a JIRA requesting > for it. > > Thanks, > Xuefu > > On Thu, Jun 25, 2015 at 10:36 AM, Brian Jeltema < > brian.jelt...@digitalenvoy.net> wrote: > >> Answering my own question: >> >> create table foo_copy like foo; >> insert into foo_copy partition (id) select * from foo where id in >> (1,2,3); >> export table foo_copy to ‘path’; >> drop table foo_copy; >> >> It would be nice if export could do this automatically, though. >> >> Brian >> >> On Jun 25, 2015, at 11:34 AM, Brian Jeltema < >> brian.jelt...@digitalenvoy.net> wrote: >> >> > Using Hive .13, I would like to export multiple partitions of a table, >> something conceptually like: >> > >> > EXPORT TABLE foo PARTITION (id=1,2,3) to ‘path’ >> > >> > Is there any way to accomplish this? >> > >> > Brian >> >> >
