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)

Reply via email to