I believe:
alter table _tablename_ set fileformat orcfile;
will do what you want. All future partitions that are added will be in orcfile
format (assuming you use insert to create the partitions) or assumed to be in
orcfile format if you do alter table add partition.
As to whether orcfile wil
More specifically, we have a table that is currently defined as RCFile, to
do this, I'd like to define all new partitions as ORC. With the advent of
ORC, these types of problems are going to come up for many folks, any
guidance would be appreciated ...
Also, based on the strategic goals of ORC fi
Can you give some examples of how to alter partitions for different input
types? I'd appreciate it :)
On Fri, Jul 26, 2013 at 3:29 PM, Alan Gates wrote:
> A table can definitely have partitions with different input
> formats/serdes. We test this all the time.
>
> Assuming your old data doesn't
A table can definitely have partitions with different input formats/serdes. We
test this all the time.
Assuming your old data doesn't stay for ever and most of your queries are on
more recent data (which is usually the case) I'd advise you to not reprocess
any data, just alter the table to s
