You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "yanhw (Jira)" <ji...@apache.org> on 2021/01/27 09:43:00 UTC

[jira] [Created] (HIVE-24689) Changing file format (from ORC) is not supported for table xxx

yanhw created HIVE-24689:
----------------------------

             Summary: 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


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



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