[ 
https://issues.apache.org/jira/browse/HIVE-24689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

yanhw resolved HIVE-24689.
--------------------------
    Resolution: Not A Problem

use "set hive.exec.schema.evolution = false;" can fix it;

> Changing file format (from ORC) is not supported for table xxx
> --------------------------------------------------------------
>
>                 Key: HIVE-24689
>                 URL: https://issues.apache.org/jira/browse/HIVE-24689
>             Project: Hive
>          Issue Type: Bug
>    Affects Versions: 3.1.2
>            Reporter: yanhw
>            Priority: Major
>
> use test;
>  drop table if exists test_lzo_partition;
> create table test_lzo_partition (a string) partitioned by (t string) stored 
> as orc;
> alter table test_lzo_partition
>  set FILEFORMAT INPUTFORMAT 'com.hadoop.mapred.DeprecatedLzoTextInputFormat'
>  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
>  SERDE 'org.openx.data.jsonserde.JsonSerDe' ;
> alter table test_lzo_partition add if not exists partition (t=2);
>  alter table test_lzo_partition PARTITION (t=2)
>  set FILEFORMAT INPUTFORMAT 'com.hadoop.mapred.DeprecatedLzoTextInputFormat'
>  OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'
>  SERDE 'org.openx.data.jsonserde.JsonSerDe' ;
> It will return:
> FAILED: Execution Error, return code 1 from 
> org.apache.hadoop.hive.ql.exec.DDLTask. Changing file format (from ORC) is 
> not supported for table test.test_lzo_partition



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to