I think that you can do it with Hive 0.14 isn't it ? I don't have any feedback about this command but, in our case, we do an INSER OVERWRITE in a partitioned table (by date)
-- Laurent HATIER - Consultant Big Data & Business Intelligence chez CapGemini fr.linkedin.com/pub/laurent-hatier/25/36b/a86/ <http://fr.linkedin.com/pub/laurent-h/25/36b/a86/> 2015-07-31 8:42 GMT+02:00 Nitin Pawar <[email protected]>: > it does not work > alter table on orc also sometimes ends in problem > > On Fri, Jul 31, 2015 at 11:04 AM, Du Lam <[email protected]> wrote: > >> Hi all >> >> not sure if this is discussed before, but does the merging for ORC works: >> >> alter table ... partition() concatenate for ORC >> >> , tried several times never been successful and some google search show >> some failure encountered by others as well. is this best way to merge small >> ORC files?? >> >> many thanks! >> > > > > -- > Nitin Pawar >
