[
https://issues.apache.org/jira/browse/HIVE-24689?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yanhw updated HIVE-24689:
-------------------------
Description:
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
was:
use test;
drop table if exists test_lzo_partition;
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
> 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)
