Fwd: Hive 0.14 schema evolution for orc table

[Joanne Chan <jo...@gmail.com>]

How does schema evolution work for orc table in hive 0.14?

Does it support add column at the end of the row only?

What else is supported?

Re: Hive 0.14 schema evolution for orc table

[Mich Talebzadeh <mi...@gmail.com>]

With regard to adding column to Hive table you can add a column that will
be created as NULL but you cannot set its value to non null

hive> alter table dummy2  add columns (new_col varchar(30));
OK
Time taken: 1.171 seconds

hive> desc dummy2;
OK
id                      int
clustered               int
scattered               int
randomised              int
random_string           varchar(50)
small_vc                varchar(10)
padding                 varchar(10)

*new_col                 varchar(30)*Time taken: 0.046 seconds, Fetched: 8
row(s)
hive> update dummy2 set new_col  = 'abc';
FAILED: SemanticException [Error 10122]: Bucketized tables do not support
INSERT INTO: Table: test.dummy2

Check the discussion in Hive user mailing list here
<http://mail-archives.apache.org/mod_mbox/hive-user/201512.mbox/%3CD290A400.39823%25ekoifman@hortonworks.com%3E>




Dr Mich Talebzadeh



LinkedIn * https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*



http://talebzadehmich.wordpress.com



On 8 April 2016 at 20:49, Joanne Chan <jo...@gmail.com> wrote:

>
> How does schema evolution work for orc table in hive 0.14?
>
> Does it support add column at the end of the row only?
>
> What else is supported?
>
>